How to create a Cumulative Line chart in BoldBI

Published:

We can create a cumulative line chart using the Combo chart in BoldBI. Here are the steps to achieve this:

Drag and drop the Combo chart widget. Please refer the document for the Combo chart Create Combo Chart Widget and connect the data source as needed. Please refer the document to connect the datasource Create New datasource.
After setting up your data source, add an expression to calculate the running sum for the desired column using the RUNNINGSUM(). Please refer the document to create an expression Add Expression.

In Expression Designer, choose the RUNNINGSUM function from the Functions list and choose the required column. Once saved, new column will be added to the datasource.
The added expression will appear on the “Assign Data” page. Bind this expression (e.g., Cumulative Sales) to the "Value(s)" section and the Date column to the "Column(s)" section.
Go to the "Properties" tab and change the chart type for "cumulative Sales" as line.
Then you can see the cumulative sum chart displayed.