Row Viewer Format
Choose a row viewer for specific columns for your numbers or dates.
Choose a row viewer 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 and Charts pages, 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 row viewer from other tools:
Adapt
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 Add
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:
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:
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 |