Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Creating Trend Line charts using BIP Offline Editor for Word

Received Response
11
Views
1
Comments
MattR_HK-Oracle
MattR_HK-Oracle Rank 1 - Community Starter
in Oracle Analytics Publisher

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:

image.png image.png image.png image.png
Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.