Row Viewer Format

Choose a for specific columns for your numbers or dates. Row Viewer is a visual formatting option, supporting 500-plus columns, that is available on the Build, Run and Visualize tabs, from the Pipes page. With the Visualize tab, the row viewer is available when you create or edit a chart. The new format is immediately active after you choose it.

Note

The Row Viewer is available on the My Data page without formatting.

Format multiple columns at the same time. Use the Shift key to select the columns that you want to format.

You can see the total number of rows in your data without counting or opening up the data.

All data inherits the formatting, either from the data import into Symon.AI or if you choose to apply a new format. The filtering option indicates in blue that the filtering is applied. Any new tools that you add in the pipe inherit this format.

Note

Formatting does not carry over to the raw data or appear in the downloaded version (CSV, PDF, PNG) of your data.

The following tools can change the column type, but do not inherit the from other tools:

• Change Type

• DateFormat

You can use reset format to set your data or dates back to the original format.

The following tools add new columns to the data and come with default formatting.

• Moving Average Forecast

• Forecast

• Aggregate

• Binning

• Combination Matcher

• Date Aggregate

• Formula

• Quantile

• Segmentation

• Classifier

• Regressor

• Predictor

• Running Total/Average

• Weighted Average

Some tools create a new column called Probability, which is shown a percentage and has no decimal places.

Numeric Format

Apply the following formats to the rows in your data column:

Table 30. Numeric Format

Format

Description

None

Removes the applied formatting.

Dollar

Adds a dollar sign to the specific column.

Percentage

Adds a percentage sign to the specific column.

Decimal places

Increase or decrease the number of decimal places.

Note

With decimal places, the formatting skips blank rows and starts formatting at the first number in the data.

You can also toggle the 1000's separator on and off.

Important

Calculations with the following five operators generate the output format based on priority:

• +

• -

• *

• /

• %

For example, currency > regular number > percentage. If number one is currency and number two is a percentage, number one multiplied by two outputs the currency. If the two operands are set with the same decimal place, the decimal place remains. If the operands are both set with thousand separators, the separators remain. If this is not the case, the decimal places and thousand separators are ignored.

Date Format

There are five date format options to choose from:

Table 31. Date Format

Format

Example

Short Date

21-01-24

Long Date

Monday, January 24, 2001

Time

12:00 AM

Full Date and Time

21-01-24 12:00 AM

Short Month

Jan 2021