Viewing Totals and Grand Totals in Custom Analytic Widgets

Users can view totals and grand totals in the tooltips of chart visualizations in custom analytic widgets.

Complete the following steps to view the new information:

  1. L og in to the ONE system.

  2. Click the Edit button (pencil) on the dashboard.

  3. Click the plus sign in one of the sections to add a widget.
    The Add a Fixed (or Flexible) Widget popup displays.

  4. Click on the Custom Analytic Widgets tab.

  5. Click on the Create button.
    The Create a Widget screen displays with the Data Sources popup displays.

  6. Select a data source.
    The Fields (Column Chart) popup displays by default.

    images/download/attachments/131827211/2022-11-03_16-01-35-version-1-modificationdate-1674660079000-api-v2.png



  7. Select from the Fields section for data display from the left section for the X-Axis (this is for a column chart) and Values sections. Please see the "Adding and Creating a Custom Analytical Widget" section in the Online Help for more information.

  8. Click the Apply button.
    The Create a Widget screen with visualizations and customizations displays.

    images/download/attachments/131827211/2022-11-03_16-11-12-version-1-modificationdate-1674660079000-api-v2.png



  9. Select the visualization (chart type), Chart Colors * , and Measure * as required. Fields with an asterisk ( * ) are required. The screenshot below shows a stacked bar chart and changes the axis to a Y-axis view.

  10. Click the Show Total dropdown arrow.
    A menu displays options for Total By X, where X is the value selected in the axis section, and Grand Total.

    images/download/attachments/131827211/2022-11-03_16-07-34-version-1-modificationdate-1674660079000-api-v2.png



  11. Check the boxes to display this data in a tooltip.

  12. Click the Confirm button.
    The chart refreshes.

  13. Hover your mouse on a data point.
    The tooltip now shows the selected values.

    images/download/attachments/131827211/2022-11-03_16-19-59-version-1-modificationdate-1674660080000-api-v2.png



    Users can save and customize further per normal steps as shown in the "Adding and Creating Custom Analytic Widgets" section.