Zoomdata Version

Line & Bar Trend Charts

Line and bar trend charts are based on two metrics and a time attribute. They are supported by all Zoomdata data connectors, except Cloudera Search, and by Zoomdata Apache Solr connectors for version 5.2 or later.

To configure the default settings for line & bar trend charts 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 Line & Bars Trend.

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

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

  4. Configure the default settings as follows:

    Setting Description
    Trend Attribute

    Select the time trend attribute for the chart.

    In the second (rightmost) box for this setting, 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).
    Trend Attribute Limit Specify the number of time attribute items.
    Trend Attribute Sort Shows the time parameter by which the trend attributes will be sorted. You can select the sorting order (chronological or reverse chronological).
    Y1 Axis Select a metric to use for the bars on your chart. 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.
    Y2 Axis Select a metric to use for the line on your chart. 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.
    Y2 Color Select a color for the Y2 line on your chart.
    Y1 Color Select a color for the Y1 bars on your chart.
  5. Click .

Was this topic helpful?