Creating Trend Line charts using BIP Offline Editor for Word

MattR_HK-Oracle

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

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.