Zoomdata Version

Standard Bar Charts

Standard bar charts are based on one metric and one or two attributes, as follows:

  • Plain: Based on 1 metric and 1 attribute
  • Clustered: Based on 1 metric and 2 attributes
  • Stacked: Based on 1 metric and 2 attributes
  • 100% Stacked: Based on 1 metric and 2 attributes

Standard bar charts are supported by all Zoomdata data connectors.

To configure default standard bar chart settings for a data source configuration:

  1. Edit the appropriate data source configuration. See Editing a Data Source Configuration.

  2. Select the Charts tab in the data source configuration wizard.

  3. On the Standard subtab of the Charts tab, select Bars.

    If you want to be able to display the data collected by this data source configuration as a standard bar chart, make sure the Bars checkbox is selected.

    Default standard bar chart settings appear on the right side of the page.

  4. Configure the default settings as follows:

    Setting Description
    Group

    Select the attribute by which the data should be grouped.

    If you select a date or time attribute, a second box appears to the right for this setting. Use this second box to specify the date and time granularity used to group the data. Valid granularities are Millisecond, Second, Minute, Hour, Day, Week, Month or Year.

    If some of these granularity options do not appear, verify that the granularity specified for this field on the Fields tab is set at the correct granularity level. For each field, the available granularity options include all options starting from Year down to the granularity level specified for this field on the Fields tab.

    The refinement level of the field data in a data store defines the minimum level of granularity that should be set for the field. Specifying granularity for a field that is lower than the refinement level of the field data will not produce a chart with data grouped at the requested lower level. For example, if a field's data is stored in hours, requesting the granularity of that data lower than hours will produce the values up to the hour level, and the more detailed level information will be zeros (i.e., 0 minutes, 0 seconds, and 0 milliseconds).
    Group Limit Specify the number of attribute items to display on the chart.
    Group Sort Select a metric or attribute by which the Group attribute items should be sorted. You can also select the sorting order (ascending or descending). For metrics, you can define the default aggregation function: SUM, AVG, MAX, or MIN. See Available Metric Functions.
    Sub-Group

    Select the attribute by which the other attributes should be grouped.

    If you select a date or time attribute, a second box appears to the right for this setting. Use this second box to specify the date and time granularity used to group the data. Valid granularities are Millisecond, Second, Minute, Hour, Day, Week, Month or Year.

    If some of these granularity options do not appear, verify that the granularity specified for this field on the Fields tab is set at the correct granularity level. For each field, the available granularity options include all options starting from Year down to the granularity level specified for this field on the Fields tab.

    The refinement level of the field data in a data store defines the minimum level of granularity that should be set for the field. Specifying granularity for a field that is lower than the refinement level of the field data will not produce a chart with data grouped at the requested lower level. For example, if a field's data is stored in hours, requesting the granularity of that data lower than hours will produce the values up to the hour level, and the more detailed level information will be zeros (i.e., 0 minutes, 0 seconds, and 0 milliseconds).
    Sub-Group Limit Specify the number of attribute items to be displayed for each attribute that you have selected in the Sub-Group list. This option only appears if you have selected a subgroup.
    Sub-Group Color Palette Select the palette and enable the legend if needed. This option only appears if you have selected a subgroup.
    Sub-Group Sort Select a metric or attribute by which the Sub-Group attribute items should be sorted. You can also select the sorting order (ascending or descending). For metrics, you can define the default aggregation function: SUM, AVG, MAX, or MIN. See Available Metric Functions.This option only appears if you have selected a subgroup.
    Bar Color Select the metric that will be depicted by the bar color. You can also define the default aggregation function used for the metric values: SUM, AVG, MAX, MIN, or (for some data sources) LAST VALUE. See Available Metric Functions.
    Number of colors Specify the number of colors to use for the chart.
    Display Legend Select this checkbox if you want the legend to be displayed on the chart.
    Legend Type Select the color palette or color range that you want to use.
    Metric Select the metric by which you want to analyze the selected attribute. You can also define the default aggregation function used for the metric values: SUM, AVG, MAX, MIN, or (for some data sources) LAST VALUE. See Available Metric Functions.
  5. Click .

Was this topic helpful?