Designing a Custom Bar Chart

A bar chart allows you to compare data across different categories. It is especially useful for measuring changes in data over longer periods of time or measuring larger changes in data.

To design a custom bar Chart:

  1. Build a report.
  2. Under the CHART CONFIGURATION section, select the BAR chart.
  3. Enter or select the required field information.
    The following table describes the field information in this section:
    Field Description
    X-axis label Enter the criteria for the X-axis label. For example: Status.
    *Group by Select a value from the drop down menu on the basis of which data will be grouped. For example: Status. This will generate a report that shows the status of devices as managed, unmanaged and so on.
    *Aggregation Select the calculation to be done on the report data for the dropdown. The following options are available:
    • Average: Calculates the average value of a given set of data.
    • Sum: Calculates the sum of all values in a given set of data.
    • Count: Calculates the total number of items in a given numeric field.
    • Maximum: Displays the maximum value in a given set of data.
    • Minimum: Displays the minimum value in a given set of data.
    * : Mandatory fields
  4. Click Save.
    A preview of the bar chart is generated on the right side of the screen.
  5. To select the data loading pattern, in the chart's preview window, click (Settings) icon.
    The following options are displayed:
    • Instant: This option allows you to enable live data loading and see changes in data immediately. This can be used in the case of small databases.
    • Deferred: This option allows you to enable lazy data loading and is useful in the case of larger databases. The default time interval for this is set at 30 minutes.
  6. To change the style/font color of the bar chart, in the chart's preview window, click Styles.
    1. Click on the coloured value boxes to display the color palette.
    2. Choose the desired color.
    3. Similarly click the coloured boxes and choose different colors from the palette for the different values,
    4. Click Save.
    5. Enable the toggle button to view the applied changes.
  7. To enable the report, turn on the toggle. Only enabled reports are visible on the dashboard to which they are pinned.
  8. Click Next.
    The CHART DRILLDOWN section is displayed.
What to do next: To modify any chart report parameters, first disable toggle button from the preview screen. Settings and Styles can also be edited only when the report is in a disabled state.