Workspace settings

Zoho Analytics provides several options to customize your workspaces, such as setting the beginning of your fiscal year, setting chart color or grid theme across reports and managing users, data alerts and slideshows.

  1. What are the various customization options available for workspaces? 
  2. How can I customize workspaces in Zoho Analytics?
  3. How do I rename a workspace in Zoho Analytics?
  4. Can I choose to set a default workspace?
  5. Is it possible to list a table's hidden columns in the Report Designer? 
  6. Can I modify the way the fiscal year is calculated and displayed across the workspace?
  7. Can I modify the way weeks are calculated and displayed in my workspace?
  8. What are variables in Zoho Analytics?
  9. How do I create a variable?
  10. Can I create multiple variables?
  11. How do I configure workspace-level formatting?
  12. It it possible to specify colors for all charts in a workspace?
  13. What are Color Palettes?
  14. How do I create a customized color palette?
  15. How do I apply a new color palette to existing charts in the workspace?
  16. What are grid themes in Zoho Analytics?
  17. How do I customize a grid theme?
  18. How do I apply the customized grid theme over existing pivot, summary or tabular views?
  19. How do I manage all the email schedules in the workspace?
  20. How do I manage the slideshows in my workspace?
  21. Is it possible to manage the various data alerts created across the workspace from a single place?

1. What are the various customization options available for workspaces? 

You can easily modify the settings of your workspace in Zoho Analytics, by clicking the Settings button from the side panel. From this page, you can modify the color of the various charts in your workspace, set a workspace as default, set up custom variables, customize grid themes, manage data alerts, etc. 

2. How can I customize workspaces in Zoho Analytics?

You can easily customize workspace settings by clicking the Settings button from the side panel. The Settings page allows you to configure a wide range of settings, which are detailed in the following questions. 

3. How do I rename a workspace in Zoho Analytics?

To rename a workspace in Zoho Analytics, select the Settings option from the side panel, navigate to the General tab and modify the Workspace Name and Workspace Description fields as needed. 

You can also rename workspaces from the Zoho Analytics homepage. Click here to learn more.

4. Can I choose to set a default workspace?

Setting a default workspace ensures that the workspace will be opened automatically on every login. To set a default workspace, click the Settings button from the left panel, and navigate to the General tab. Select the Yes radial button under the Make this Workspace Default? option, and click Save. You can also set a workspace as default from the Zoho Analytics homepage. Click here to learn more. 

Note: Only one workspace can be set as the default workspace.

5. Is it possible to list a table's hidden columns in the Report Designer? 

Yes, you can. This helps you create reports using those hidden columns. To list hidden columns, click the Settings button from the side panel, and navigate to the General tab. Select the Yes radial button under the Show hidden columns while creating reports? option, and click Save.

6. Can I modify the way the fiscal year is calculated and displayed across the workspace?

By default, Zoho Analytics uses the calendar year (January-December) for year-wise computations. Various options are available to customize the way the fiscal year is calculated and displayed. To modify your fiscal year format, click the Settings button from the side panel, and navigate to the General tab. 

The Fiscal year section provides the following options, which will be used to compute the financial year while generating reports. 

  • Starting Month: This option allows you to set the starting month of the financial year, which will then be used for all year wise calculations across the tables and reports in the workspace.
  • Year Display Format: This option allows you to modify the format in which the fiscal year is displayed in tables and reports. The following are the available formats:
  • Display fiscal year end: Displays the start year of the fiscal year. For example, the fiscal year of 2019-2020 will be displayed as 2019. 
  • Display fiscal year start: Displays the end year of the fiscal year. For example, the fiscal year of 2019-2020 will be displayed as 2020. 
  • Display year as range: Displays the range of the fiscal year. For example, the fiscal year of 2019-2020 will be displayed as 2019 -2020. 

7. Can I modify the way weeks are calculated and displayed across the workspace?

To do this, click the Settings button from the side panel, and navigate to the General tab. The Week Settings section provides the following options, which will be used to compute the weeks while generating reports. 

  • Week Start Day: This option allows you to specify the starting day of the week. For example, if Monday is selected as the starting day of the week, weekly reports will include data starting from Monday 00:00am to Sunday 11:59pm.
  • Week & Year Format: You can select the format in which the weeks are to be displayed in your workspace. The following options are available:
    • Long: Displays the start and end date of the week, along with the year. For example: 01 - 07 Jan 2020
    • Medium: Displays the week number along with the year. For example: Week 01 2020
    • Short: Displays the week number in a shorter format, along with the year. For example: W01 2020
    • Start date: Displays the start date of the week, along with the year. For example: 01 Jan 2020 End date: Displays the end date of the week, along with the year. For example: 07 Jan 2020
    • End date: Displays the end date of the week, along with the year. For example: 07 Jan 2020

      .

  • Week Mode: You can specify the starting week of the fiscal year in the workspace. The following are the options available:
    • ISO 8601: The first week with a minimum of four days will be considered the first week of the fiscal year.
    • Week starts on January 1: The first week of the Starting Month specified under Fiscal Year section will be considered the first week of the fiscal year. To set the starting month of the fiscal year, click here

Note: Any format change made on the Workspace Settings page is applied across all the reports of the workspace. You can also change the Week & Year format at the report level. Click here to learn more.

8. What are variables in Zoho Analytics?

Variables are placeholders that help Server Administrators and Managers assign dynamic values for individual workspace users. You can use variables in the Filter criteria section while sharing reports and dashboards. Click here to learn more about using variables while sharing reports. 

Note: These variables are specific to each workspace and cannot be used across workspaces.

9. How do I create a variable?

Follow the steps below to create variables in Zoho Analytics.

  • Click the Settings button from the side panel, and navigate to the Variables tab in the Settings page that opens. 
  • Click Create New Variable.

  • In the Create New Variable dialog that opens, provide a name for the variable.
  • Enter the value that needs to be mapped with the email addresses in the Map Values to Users field. You can either type the email addresses or click the Add Users/Groups icon to add contacts and groups.
  • To add more values, click the + Add New Value link.
  • A default value can also be set using the Default Value section, for users whose email IDs have not been mapped to a specific value. Selecting the All Values checkbox includes all possible values in your data as the default value.
  • To specify multiple default values, click + Add New Default Value link. 
  • Click Save to create the variable. 

You can use these variables in the Filter criteria section, while sharing reports and dashboards. Zoho Analytics also provides a set of predefined system variables that you can use in your filter criteria. They are listed below.

System Variable NameDescription
system.login.emailReturns the email id of the user who has logged in.
system.login.firstnameReturns the first name of the user who has logged in.
system.login.lastnameReturns the last name of the user who has logged in.
system.login.fullnameReturns the full name of the user who has logged in.

10. Can I create multiple variables?

Multiple variables can be created in a single workspace in Zoho Analytics. The Variables section of the Settings page lists the different variables present in the workspace. 
You can create and manage your variables from this page. 

11. How do I configure workspace-level formatting?

Zoho Analytics allows you to specify workspace-level formatting options for all the views in the workspace. You can configure specific formats for Date, Duration, Number, Positive Number, Decimal number, Currency, and Percentage.

To do this,

  • Open the required workspace, and click the Settings button from the side panel.
  • Navigate to the Format tab, and make the required changes.

The following table lists the various format options that can be configured for a workspace.

Date format

Format optionDescription
Actual Value FormatThis option allows you to pick the date format you want, for displaying date values. You can Choose your date format from the existing list or 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 a custom date format string.
Seasonal/Cyclic FormatYou can specify how you want the text in the date values to be displayed. It can either be a full text (Quarter 1) or a short text (Q 1).

Duration format

Format optionDescription
AlignmentThis option can be used to align the value in the cell horizontally. Possible values are Left, Right, and Center.
Choose Duration Format

This option allows you to pick the duration format in which you want to display the duration format.

In case the required format is not available as part of the default list. You can enter the custom format in this field. Refer here to know how to construct a custom duration format string.

Number, Positive Number, and Decimal Number

Format optionDescription
Units

This section enables you to format the unit values in thousands (K), millions (M), and billions (B).

  • None: No unit formatting will be applied to the data.
  • (Thousands) K: The data will be formatted in thousands (k).
  • (Lakhs) L: The data will be formatted in lakhs (L).
  • (Millions) M: The data will be formatted in millions (m).
  • (Crores) C: The data will be formatted in crores (C).
  • (Billions) B: The data will be formatted in billions (B).
  • (Thousands) K - (Lakhs) L - (Crores) C: The data will be auto formatted to the unit value as thousands (K), lakhs (L), and crores (B) based on the data in the corresponding column.
  • (Thousands) K - (Millions) M - (Billions) B: The data will be auto formatted to the unit value as thousands (K), millions (M), and billions (B) based on the data in the corresponding column.
  • Auto (User Locale Specific): The data will be auto formatted to the unit value as per the user's local standards, i.e., either as thousands (K), millions (M), and billions (B) or as thousands (K), lakhs (L), and crores (B) based on the data in the corresponding column.
Decimal PlacesThis option allows you to specify the number of decimal places to be displayed in decimal numbers.
Separator

This section allows you to pick the decimal and thousand separators to be used and where to add them.

Apply User Locale Settings - Select this option to use separators based on the locale settings of the user. For example, in the US locale, a comma will be used for a thousand separator, and in the case of German locale, a dot will be used.

The following options are used to specify the decimal and thousand separators to be used. These options will be disabled when you have selected the Apply User Locale Settings mentioned above.

  • Thousand: This option can be used to select the type of thousand separator. This option will be enabled for number and decimal type columns. 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. Available options include Dot and Comma.

Display Format:Select the format to place the thousand separators. Available options are:

  • International System: Places the thousand separator based on the International system. Eg: 123,456,789
  • Indian System: Places the thousand separator based on the Indian system. Eg: 12,34,56,789

Currency

Format optionDescription
Units

This section enables you to format the unit values in thousands (K), millions (M), and billions (B).

  • None: No unit formatting will be applied to the data.
  • (Thousands) K: The data will be formatted in thousands (k).
  • (Lakhs) L: The data will be formatted in lakhs (L).
  • (Millions) M: The data will be formatted in millions (m).
  • (Crores) C: The data will be formatted in crores (C).
  • (Billions) B: The data will be formatted in billions (B).
  • (Thousands) K - (Lakhs) L - (Crores) C: The data will be auto formatted to the unit value as thousands (K), lakhs (L), and crores (B) based on the data in the corresponding column.
  • (Thousands) K - (Millions) M - (Billions) B: The data will be auto formatted to the unit value as thousands (K), millions (M), and billions (B) based on the data in the corresponding column.
  • Auto (User Locale Specific): The data will be auto formatted to the unit value as per the user's local standards, i.e., either as thousands (K), millions (M), and billions (B) or as thousands (K), lakhs (L), and crores (B) based on the data in the corresponding column.
Decimal PlacesYou can use this option to set the number of decimal places to display for decimal numbers. This option is specific to decimal numbers.
Negative Number DisplayYou can use this option to select the display format for negative numbers. Available options include Negative sign (Eg: -$23) and Parenthesis (Eg: ($23)).
Separator

This section allows you to pick the decimal and thousand separators to be used and where to add them.

Apply User Locale Settings - Select this option to use separators based on the locale settings of the user. For example, in the US locale, a comma will be used for a thousand separator, and in the case of German locale, a dot will be used.

The following options are used to specify the decimal and thousand separators to be used. These options will be disabled when you have selected the Apply User Locale Settings mentioned above.

  • Thousand: This option can be used to select the type of thousand separator. This option will be enabled for number and decimal type columns. 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. Available options include Dot and Comma.

Display Format:Select the format to place the thousand separators. Available options are:

  • International System: Places the thousand separator based on the International system. Eg: 123,456,789
  • Indian System: Places the thousand separator based on the Indian system. Eg: 12,34,56,789

Percentage

Format optionDescription
Decimal PlacesYou can use this option to set the number of decimal places to display for decimal numbers. This option is specific to decimal numbers.
Negative Number DisplayYou can use this option to select the display format for negative numbers. Available options include Negative sign (Eg: -$23) and Parenthesis (Eg: ($23)).
Separator

This section allows you to pick the decimal and thousand separators to be used and where to add them.

Apply User Locale Settings - Select this option to use separators based on the locale settings of the user. For example, in the US locale, a comma will be used for a thousand separator, and in the case of German locale, a dot will be used.

The following options are used to specify the decimal and thousand separators to be used. These options will be disabled when you have selected the Apply User Locale Settings mentioned above.

  • Thousand: This option can be used to select the type of thousand separator. This option will be enabled for number and decimal type columns. 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. Available options include Dot and Comma.
  • Show Percentage Symbol: You can use this option to display the percentage symbol for your percentage data columns.

On configuring the required format options, select the Apply this setting to all existing Tables/Views checkbox to apply these settings to the existing tables and views in the workspace. Please note that this action is irreversible.

12. Is it possible to specify colors for all charts in a workspace?

Zoho Analytics allows you to customize the colors applied over the charts in a workspace. When you create a chart, the colors used are based on your workspace's color palette. To learn more about color palettes, refer the below question.

13.What are Color Palettes?

Color Palettes are a collection of colors that allow you to customize and beautify your charts. Zoho Analytics offers a variety of color palettes to choose from. By default, when you create a chart, the colors assigned to your chart are those that are set for the corresponding workspace. You can also add your own color palettes to suit your reporting requirements. 

To access chart palettes in Zoho Analytics, click the Settings button from the side panel, and navigate to the Chart Colors tab.

By default, Zoho Analytics offers three types of color palettes. You can also create your own palette by defining a set of colors to be applied to your charts, instead of manually assigning chart colors every time. 

The following are the default color palettes present in Zoho Analytics: 

  • Solid Color: The Solid Color palette is a collection of plain solid colors, with a maximum of 32 colors in a palette. 
  • Monochrome: This palette is differentiated by tones and tints of the same color applied for different legend items in a chart.
  • Gradient: The Gradient palette represents a list of colors that represent a gradual shift from one color to another.

Click here to learn more about the color palettes in Zoho Analytics.

14. How do I create a custom color palette?

In addition to the default color palettes, Zoho Analytics allows you to create custom color palettes and apply it to the charts in your workspace. These new palettes will be available under the Custom Palettes section of the Chart Colors tab. 

To create a new color palette, 

  • Click the Settings button from the side panel, and navigate to the Chart Colors section. 
  • Select the required color palette type, and click the Create Palette button.
  • Modify the settings as needed from the Edit Palette dialog, and click Save

To learn more about creating custom color palettes in Zoho Analytics, click here.

15. How do I apply a new color palette to existing charts in the workspace?

To apply the customized palette to all existing charts in your workspace, navigate to the required palette and click the More Actions icon that appears on mouse over. Select the Apply to All option, and click Save. This will apply the colors from the palette to all existing charts in the workspace. This is an irreversible action. 

16. What are grid themes in Zoho Analytics?

Grid themes allow you to customize the look and feel of your tabular views such as pivots, summary and tabular views. These themes can be customized easily to fit your requirements, from the Grid Themes section of the Settings page. Refer the following question to learn more. 

17. How do I customize a grid theme?

Follow the steps below to customize grid themes in Zoho Analytics. 

  • Click the Settings button from the side panel, and navigate to the Grid Themes section. Select the Pivot, Summary or Tabular tab as required. 

The following are the options available to customize grid themes in Zoho Analytics.

  • Theme Layout: You can choose the structure and appearance of your grid view from the available set of themes.
  • Theme Color: Select a color that you wish to apply.
  • Font: Select the font for the text in your pivot, summary or tabular view.
  • Zoom: Modify the focus level to make the report easily readable. This will increase or decrease the size of your pivot, summary and tabular view.
  • Row spacing: Adjust the gap between the rows using the predefined options available.
  • Apply this setting to all existing views: This option will apply the selected theme to all the pivot, summary or tabular views in your workspace.

  • To reset the grid theme to the default settings, click the Reset to System Default option.
  • Click Save.

18. How do I apply the customized grid theme over the existing pivot, summary or tabular views?

To apply the modified grid theme to the existing pivot, summary or tabular views in your workspace, select the Apply this setting to all existing views checkbox in the Grid Theme section of the workspace settings page. 

Note: This action is irreversible. 

19. How do I manage all the email schedules in the workspace?

Zoho Analytics allows you to efficiently manage all the email schedules within your workspace. To do this, click Workspace Settings from the side pane, and navigate to the Email Schedule tab. The email schedules are organized into three distinct groupings to streamline the management process as follows:

Each group provides a comprehensive overview of all email schedules created within the workspace. Each schedule includes key information, such as the schedule name, the last schedule status, the next scheduled time, and the status of the schedule.

You can also create and manage email schedules at the view level. Click here to learn more.

By Name

This section provides the list of all the email schedules created within the workspace.

  • Click any Schedule Name to view the detailed schedule information, including the list of associated users and views.

  • Toggle the Status button to activate or deactivate an email schedule.
  • Hover the mouse on the schedule name to explore options such as Send Now, Edit, and Delete.

    • Send Now: This option allows you to send the email instantly as specified in the email schedule.
    • Edit: This option allows you to edit the email schedule information.
    • Delete: This option allows you to delete the selected email schedule.

You can also select multiple schedules simultaneously and choose to Activate or Deactivate them. You can also delete multiple schedules in the same way.

By Users

This section provides a user-centric view, showcasing a list of users to whom emails are scheduled.

  • Click any user name to open the drop-down displaying all schedules associated with the selected user.
  • To remove all the email schedules associated with a user, click Remove corresponding to the user name.
  • Hover the mouse on the schedule name to explore the Edit and cloud-options.
    • Edit: This option allows you to edit the email schedule information.
    • Delete: This option allows you to remove the user from the selected email schedule.
Note: Deleting a user who is the only recipient listed in the email schedule will result in the removal of the entire email schedule.

By Views

This section provides a list of views for which emails are scheduled.

  • Click on any view to open a drop-down displaying all schedules associated with the selected view.
  • To remove all email schedules associated with a view, click Remove corresponding to the view name.
  • Hover the mouse on the schedule name to explore the Edit and Delete options.
    • Edit: This option allows you to edit the email schedule.
    • Delete: This option allows you to remove the view from the selected email schedule.
Note: Removing the sole view listed in the email schedule will lead to the deletion of the entire email schedule.

20. How do I manage the slideshows in my workspace?

Zoho Analytics allows you to manage all the slideshows in your workspace from the Slideshows page. To access this page, click the Settings button from the side panel, and navigate to the Slideshows section. 

The following are the various options that appear on mouse over the listed slideshows.

  • Get Publish/Embed URL: This option allows you to copy the slideshow's embed URL.

  • Edit Slideshow: This option allows you to edit the slideshow settings.  

  • Delete Slideshow: Click this button to delete the slideshow, and confirm your action in the popup that appears.

21. Is it possible to manage the various data alerts created across the workspace from a single place? 

The Alerts section of the workspace's Settings page lists all the data alerts created in the workspace, and allows you to perform various actions over them. 

Follow the steps below to manage the data alerts in your workspace.

  • Click the Settings button from the side panel, and navigate to the Alerts section. This page lists all the alerts created in the workspace.
  • The following options appear on mouse over the listed alerts.
    • Run Now: This option allows you to run the data alert verification.  
    • View Alert History: Click this to view the alert's trigger history.
    • Information: The information icon displays the data alert's creation and modification details. 
    • Edit: The Edit option under the More Actions icon allows you to edit the alert as needed. 
    • Delete: The Delete option under the More Actions icon allows you to delete the data alert.

To learn more about data alerts, click here