Simple Line Graph of a value against time

Unknown

Simple Line Graph of a value against time

Unknown

Im trying to display a currency amount against time in a line graph. Im only able to see the count" against the date. Instead

Unknown

You can do this by adding a Sub Total which performs aggregation on the currency column.

1. You can add a Sub Total through Results in the Report Settings.

[img]https://i.imgur.com/SVFYFby.png[/img]

2. In the Add Sub Total dialog, you can perform different types of aggregations like Sum, Count, Maximum, Minimum, Average, or Median. In the Field dropdown, we select the column on which we want to perform the aggregation.

[img]https://i.imgur.com/dZpQWlz.png[/img]

3. For the Lines chart, well choose the added sub-total as the Series.

   [img]https://i.imgur.com/RjVrxA5.png[/img]

4. This will display a chart which shows the sum of the currency on a particular date instead of the count.

[img]https://i.imgur.com/WRNGup8.png[/img]