Working with Chart

• On Mouse Over Effects
• Legend Filter
• Using User Filters
• Sorting a Chart
• Changing Chart Types
• Split/Merge Axis
• View Underlying Data
• Chart Drill down
  • Switch Axis
• Exporting a Chart
• Sharing a Chart
• Publishing a Chart

On Mouse Over Effects

Zoho Advanced Analytics app provides interactive on-mouse-over effects in a chart. You can mouse-over a particular data point in the chart to highlight the corresponding point or view the corresponding data as a tooltip. You can also mouse-over a data series provided in the legend to highlight the corresponding data series in the Chart. Refer to the following screenshots which exhibit the on-mouse-over interactive option.

Legend Filter

When designing a chart, if you have enabled Show Legend Filter option in Settings -> Legend tab (Refer here), a checkbox next to each legend item will be added as shown below.

If Legend Filters are exposed then users of the chart can dynamically filter the data series in a chart by selecting/deselecting the corresponding legend item connected to the data series. For instance, in a chart that displays order fulfillment status, if you want to display only fulfilled and restocked data, hover the mouse on the legend and deselect the partial legend item. This removes the partial data and will dynamically regenerate the chart with the remaining data as shown below.

This way you can select/deselect the required legends.

Using User Filters

In the Zoho Advanced Analytics app, chart owners can add User Filters to their charts, to provide dynamic filtering capability to the users. User Filters in a chart enables users to dynamically filter the data displayed in the chart by selecting or deselecting the appropriate values in the filter columns provided.

Following is a brief description of how to use the provided user filters for various column types:

Date type columns:

In the case of a user filter on a Date type column, options to select date ranges or a multiple select box to select the required dates will be provided to allow users to select values depending on the component type chosen by the chart owner.

To filter displayed chart data using User Filter provided on a Date type column, do the following:

1. Select a date range either by typing in the date or by choosing the date with the calendar picker.
2. If a filter drop-down list has been provided, multiple dates can be selected by checking the boxes next to the required date.
3. Click OK to apply the filter.

Numeric type columns:

In the case of a user filter on a Numeric type column, a slider or a multiple select box will be provided to allow users to select values depending on the component type chosen by the chart owner.

To filter displayed chart data using User Filter provided on a Numeric type column, do the following:

1. Choose a specific numeric range by adjusting the slider bars accordingly.
2. If a filter drop-down list has been provided, multiple values can be selected by selecting the boxes next to the filter items.
3. Click OK to apply the filter.

Category(String) type columns:

In the case of a user filter on a Category(String) type column, a single or multiple select drop-down boxes will be provided to select values depending on the component type chosen by the chart owner.

To filter displayed chart data using User Filter provided on a Category/String type column, do the following:

1. Invoke the filter drop-down list containing the filter values.
2. Select the required filter values in the filter drop-down list.
3. If the filter drop-down list provides check boxes next to the filter items, multiple values can be selected simultaneously as shown below.
4. Click OK to apply the filter.

Select Others filter item, if you want to display data corresponding to all other remaining items that are not listed in the user filter drop down.

Sorting a Chart

Zoho Advanced Analytics app allows you to sort the chart metrics by Axis, and by Legend. You can sort the chart in ascending or descending order. You can also choose to apply a custom sort to meet your requirements.

You can sort the chart by invoking the Sort option in the toolbar and choosing the appropriate option in the list given.

Described below are various sorting options available in the Zoho Advanced Analytics app.

Sorting by Axis 

You can sort the axis either based on the dimensional column or based on the metric column.
The following are the options to sort the axis.

• By Dimensional column name - Ascending: Sorts the dimensional column in ascending order. i.e., the Text column will be ordered from A to Z, and the Date column will be ordered from earlier to later. 
• By Dimensional column name - Descending: Sorts the dimensional column in descending order. i.e., the Text column will be ordered from Z to A, and the Date column will be ordered from later to earlier. 
• By Y-value - Ascending: Orders the values in X-axis based on Y-values sorted from smallest to largest.
• By Y-value - Descending: Orders the values in X-axis based on Y-values sorted from largest to smallest.
• Custom Sorting - For Text-based columns, you can choose to apply a custom sort to meet your requirements. 

In case the dimension column is added in Y-Axis and the metric column is added in X-Axis, then the menu will be renamed as follows.

• By X-value - Ascending: Orders values in Y-axis based on X-values sorted from smallest to largest.
• By X-value - Descending: Orders values in Y-axis based on X-values sorted from largest to smallest.

Sorting by Legend 

Zoho Advanced Analytics app also provides an option to sort the Chart Legend. You can sort the legend values by ascending and descending order. You can also apply a custom sort order for your chart legend.

Note on Sorting: The sort option will be enabled only when a Category or Date column is plotted along either X or Y axis but not both.

Custom Sorting

When your chart contains the Category (String) column in one of the axes and the Numeric column in the other, you can sort the chart based on your own custom-defined order. This is called Custom Sort.

For example, if a chart displays the product categories. By default, this will be ordered alphabetically in ascending order. Using custom sort, you can order them irrespective of the alphabetical order.

Steps to sort the chart by your own custom defined order:

1. Open the Chart to sort.
2. Click the Sort button in the toolbar and then click Custom Sort. The Custom Sort Order dialog box will open.
   
3. Order the column values listed using the arrow keys provided or by drag and drop.
   ​
   Note: The Custom Sort Order dialog box will list all values in the column. The filter criteria applied on the chart will not be applied here. In case the value is no longer available in the underlying data, you will find an option to delete it from the Charts custom sort dialog.
4. Select the Make this Global checkbox to set this order as the default custom sort order for this column. Existing charts and new charts created with this column will be sorted by this order. In case you already have a global custom order, selecting this will override the old sort order.
5. Click Apply button, the chart will be organized as you define.