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.
Best answer by dennis.pflug
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.