Line chart represents a trend over time.

A few measures with line chart
You could plot a few measures using line chart. For SQL data source you need to join tables between each other if you would like to plot measures from these different tables.

Measure and dimension
Using a measure and a dimension is also possible with the line chart. In the example below we can see the line chart for orders with a different type of status, e.g. completed, processing and shipped

Show total
In order to show total value for the selected period with a line chart, press on the Settings  and tick Show Total box. Result will be displayed at the top left corner of the chart (721 in the example below).

Show comparison
Displaying comparison has never been easier than in Statsbot. If you enable comparison a second line chart will be plotted allowing you to compare trend over a period. With Show Total option enabled in Settings, you would be able to see percentage change over the period along with the change in absolute numbers in brackets.

Let's break down different types of comparison modes in a more details.

  • Show comparison with the same length previous period (last 30 days  in the example below). Blue line chart represents the last 30 days (Aug 12 - Sep 10) and grey line chart represents 30 days before that last 30 days that had been selected (Jul 13 - Aug 12).
  • Show comparison with the same length period, but a year before. Blue line chart represents last 30 days (Aug 12, 2018 - Sep 10, 2018) and grey line chart represents same 30 days a year before (Aug 12, 2017 - Sep 10, 2017).
  • Show custom comparison with the same length period. You could choose any days for comparison with date picker, but length of the period always remains the same. In the example below we compare last 30 days (Aug 12 - Sep 10) and 30 days of June (June 1 - Jun 30).

Show Trendline
Statsbot users can easily plot trendline with line chart in order to see if measure has a growing or a falling trend as well as see a rolling average.

  • Linear Trendline
  • Rolling average

Fill in Null Values
Users in Statsbot can choose how to display charts if there's no data (NULL value) during a certain date range.

  • Fill with Zeros. Set as by default option in Statsbot. In this case chart shows 0 and indicates No Data  in tooltip.
  • Fill From Left. Instead of showing 0 chart will be showing same value as from the left, e.g. the last available value (101.900  in the example below).
  • Do Not Fill. With this option chart will not be displayed if there're any NULL values.

Show Legend
You can choose whether to display legend with chart at the bottom, right or to simply hide it.
  

Show Full Field Name
By default chart legend contains name of a cube and name of a measure. If you'd like to remove name of a cube, and leave only name of a measure, take a look at the example below.

Drill downs

With SQL as a data source, you can configure drill down. Drill down is a powerful feature to facilitate data exploration. It allows users to dive deeper into visualisations and data tables. You can define what data to show along when using drill down in data schemas. Take a look how it looks like from visualisation standpoint.

  • Drill down from total. In this case we can see data related to a measure and it's total for selected period (last 30 days  in the example below).
  • Drill down from chart. In this case user sees data that belongs to a particular selected point on the chart which can be a hour, day, week, month or year. (14th September, 2018  in the example below)

Did this answer your question?