Filtering data using pivot chart

You can filter and view the detailed data of the selected data source in pivot chart.

1. From the left pane, click the icon to open the Discover page.
   OR

   While you are on the Widget Catalog page, click Create New to open the Discover page.

   
   
   
2. Select required dimensions and measures.
3. If required, add filters in Filters.
   The selected filters persist when you view the chart next time.
4. Click Apply.
   The data appears in different widget types in Chart.
5. To filter the pivot data and view detailed information, do the following:
   1. In Chart, select .
      The data appears in a pivot chart based on the selected dimensions and measures.
   2. Select the required dimension details.
      The options to filter data appears.

      
      
      
   3. To display data of the selected dimensions only, select .
   4. To remove data of the selected dimensions, select .
   5. To view detailed information of the dimensions, select .
   6. To export data to CSV format, select .