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.