Data Formatting
The Data Formatting options selected for the data values in your columns is applied across all visualizations in Zoho Analytics.
Let us now see an example.
In the below image the data in the ' Sales ' column are not formatted. This can be a major step back while analyzing a large amount of data.
Let us now create a report using this data. We are going to create a report to show the total sales done in each month.
In the above chart, the data labels with extended decimal values make it difficult to interpret the chart. This is where data formatting comes in handy.
Let us now see how to resolve this issue.
- Open the table.
- Right-click the Sales column and select Format Column
- In the format column dialog that appears, choose ' 2 ' from the drop-down that is available next to Decimal Places. This will limit the units after the decimal point to two. Apart from decimal places, there are various other options that you can use to customize your data. Also, please do note that the formatting options in this dialog will change based on the data type of the column. Click here to learn more .
- Click OK.
Now, this is how the report will look like.
You can also watch the below video to learn about formatting a column.
Note:
- Option to format columns will be disabled for shared users.
As mentioned earlier, formatting options provided in the dialog box changes based on the data type of the selected column. The following table gives a brief description of these options.
| Numeric Data Type | |
| Option | Description |
| Alignment |
This option can be used to horizontally align the value in the cell. Possible values are l eft , right and center . |
| Separator |
This option allows you to pick a decimal and thousand separators to be used. Apply User Locale Settings - You can select this option to use separators based on the locale settings of the user. For example, in US locale a comma will be used for a thousand separator and in case of German locale a dot will be used. Thousand - This option can be used to select the type of thousand separator. This option will be enabled for a number and decimal type columns. This option will be disabled when you have chosen. Apply User Locale Settings mentioned above. Available options include: Comma, Dot, Space and Single Quote Decimal - This option can be used to select the type of decimal separator. This option will be available only for decimal, currency and percentage columns. Also, this option will be disabled when you have chosen. Apply User Locale Settings mentioned above. Available options include Dot and Comma. |
| Currency Symbol |
This option enables you to choose the type of currency symbol displayed. You can select the currency symbol you want from the wide variety of symbols available in the drop-down list. This option will be enabled for currency type columns. |
| Negative Number Display |
This options allows you to specify how negative numbers are to be displayed Options available are:
|
| Decimal Places |
You can use this option to set the number of decimal places to display for decimal, currency and percentage columns. |
| Date Data Type | |
| Alignment | This option can be used to horizontally align date in the cell. Possible values are left, right and center. |
| Choose Date Format |
This option allows you to pick the date format you want, for displaying dates values, from the given list. Enter Your Date Format: Zoho Analytics provides this option to allow you to specify a custom date format if the required format is not available as part of the default list provided. Refer here to know how to construct custom date format string. |
| String/Category Data Type | |
| Alignment | This option can be used to horizontally align the text in the cell. Possible values are left, right and center. |
| URL Data Type | |
| Alignment | This option can be used to horizontally align the text in the cell. Possible values are left, right and center. |
| Alternate Text | This option allows you to provide a substitute reader-friendly text that will be shown instead of the actual URL. |
Points to be noted on the behavior of the Alternate text (for URL data type columns) feature in various scenarios
- Sorting - When you sort URL data type column in a table, sorting will be done based on the actual URLs in the column.
- Copy and Paste - When you copy and paste the Alternate text in a column, actual URL corresponding to it will be pasted.
-
Exporting
- When a view with alternate text is exported, the view will be exported with the actual URLs.
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Query Tables for Data Preparation
Query Table is a feature that enables you to prepare data for easy reporting and analysis. You can combine data from one or more tables in a reporting database and create specific data views using the standard SQL SELECT queries. These data views are ...Data Snapshots
The Data Snapshot feature in Zoho Analytics allows you to capture and maintain a timeline of changes to a specific metric or a set of metrics. It periodically records changes in your data, and stores it in a table to facilitate historical report ...Data Alerts
In business, keeping track of changes in your KPIs and metrics is vital to stay ahead of the curve. Data alerts in Zoho Analytics notify you of key business events that you cannot afford to miss. This helps you quickly make informed business ...Managing data sources
Zoho Analytics enables users to view and manage all data sources within the same workspace from a single location. To access this page, click the Data Sources button at the bottom of the side panel. The Data Sources page lists all the sources from ...Import data from Snowflake
If you have your data stored in Snowflake Cloud Database, you can easily import the data into Zoho Analytics or connect live with the Snowflake for advanced reporting and analysis. Data Import: Data from your database will be imported and stored in ...