Designing a Custom Line Chart

Line charts are a simple and quick way of tracking changes over a period of time. They are a better choice for tracking changes over a short period of time. A line chart can also be used to compare changes for multiple groups over the same period of time.

To design a custom line chart:

  1. Build a report.
  2. Under the CHART CONFIGURATION section, select the LINE 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: Creation Date.
    *Group by Select a value from the dropdown on the basis of which report data will be grouped. For example: Creation Date.
    *Date format Select a valid date format from the dropdown menu. For example: Monthly.
    *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 line 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 their line chart, 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.
  7. To enable the report, turn on the toggle. Only enabled reports are visible on the dashboard to which they are pinned.
    Note: Color code mapping is not applicable to the line chart.
  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.