Creating Trend Line charts using BIP Offline Editor for Word

Question

Have been grappling with how to generate time based trend charts to track status trends.

For example, the source data is in this general format:

* Record 1 - Opened 10/01/24 - Closed 23/01/24
* Record 2- Opened 13/01/24 - Closed 31/01/24
* Record 3 - Opened 02/02/24 - Closed 14/02/24
* ….etc

What I am looking to achieve is a running total on a period basis of Open records vs Closed records at any point in time. eg Week 3 how many records are Open and how many records are Closed. Either a single trend line or 2 overlapping trend lines

Some examples attached:

Gianni Ceresa · Answer

You need a proper "time dimension", a source of data with all the days, and then join it to your current data to generate the status of each record at any point in time.

There isn't a thing doing time based trends out of a line with start-end or open-close, you need to transform your data into a row per each record and time granularity you look for with a single status.