Skip to main content
Is there a way to add a vertical line to a chart in an analysis that signifies a "go-live" or a specific point in time? This is needed to help track KPIs before and after a specific go-live or other milestone.

Hi Jake,

 

you can do it by adding another KPI into your chart (e.g: KPI Go-Live Date) with the following logic:

 

CASE WHEN ROUND_MONTH({d '2022-10-01 }) = ROUND_MONTH(BSEG.BLDAT) THEN 1 END

 

{d '2022-10-01' } -> would be the go-live date

BSEG.BLDAT -> Is your current used KPI on x-axis

 

To make it look even better go to Component options.

Select your newly created KPI in the drop down menu -> Data series: Go-Live Date and select alternative type = Area Chart


Hi Jake,

 

you can do it by adding another KPI into your chart (e.g: KPI Go-Live Date) with the following logic:

 

CASE WHEN ROUND_MONTH({d '2022-10-01 }) = ROUND_MONTH(BSEG.BLDAT) THEN 1 END

 

{d '2022-10-01' } -> would be the go-live date

BSEG.BLDAT -> Is your current used KPI on x-axis

 

To make it look even better go to Component options.

Select your newly created KPI in the drop down menu -> Data series: Go-Live Date and select alternative type = Area Chart

Thanks Dennis, this worked great! I think the one other thing to think about is your primary axis scale--if you want the line to go all the way through the Y axis, you'll need to manually set the axis maximum to something less than 1.


Reply