Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Curve Plot with KPI Target Line


Benjamin S

Recommended Posts

Hello Community,

I have currently a self-set objective which I am struggling to achieve. Maybe someone of you could give me an advice on that.

- I want to create a plot for KPI visualisation which has a simple value on the y-axis (Maybe a cumulative function) and the date as x-axis (as shown in attached figure).

- I want to set the KPI target value as a document property (because I think that is the most convenient way as input).

 

The basic framework of the plot should look like the one in the output. A straight-line starting at 0 and moving to the defined KPI value at the end of the year. So the whole year is representing the X-Axis.

This shall be overlayed by the "real data" which looks like this:

ID Start End

1

01.03.2022

01.08.2022

2

01.02.2022

03.08.2022

3

05.08.2022

01.12.2022

4

03.09.2022

01.11.2022

 

Consequently, I want to extract the end date and plot this. The x-axis represents the end-date and the y-axis represents the sum of all IDs closed until then (over Axis.X)

Problems:

How to set the X-Axis to the full year (e.g. 01.01.2022 - 31.12.2022) Because any column only ranges between e.g. 01.02.2022 and 03.09.2022

How to cumulate the number of "finished" activities until the current X-Axis Value Sum(If(DateDiff("dd",[End],[Axis.X])

Link to comment
Share on other sites

Does nobody have any starting point on how to do this

 

In the meantime I found out that I am able to use(x*${DocProp}/365) for the drawn KPI curve, but only if the x-axis is set to date (which makes sense). This looks good on a day-chart, but does not on Quarterly level. Is there any way to this in a more clean way

Link to comment
Share on other sites

×
×
  • Create New...