topic Re: store KPI value for later usage in App Development

store KPI value for later usage

Micki — Sat, 16 Nov 2024 01:31:16 GMT

Hi, does anybody have recipe have easily store today value in KPI chart and use tomorrow for comparing with new one?

JustinDallas — Tue, 08 Sep 2020 13:47:31 GMT

Generally, I would have a "IsYesterday" flag, and then use that in my set analysis. It can then be calculated at load time or declared in the UI

SUM({<[IsYesterday]={'Y'}>} Widgets)

You would have to create this flag using a calendar or some other date in your script i.e

If( InDay(SomeDateInYourDataModel, Today(), -1 ) , 'Y','N' )

Micki — Tue, 08 Sep 2020 14:24:52 GMT

ok, please correct me if I am wrong:

1. I need to add

If( InDay(SomeDateInYourDataModel, Today(), -1 ) , 'Y','N' )

SUM({<[IsYesterday]={'Y'}>} [Sum(Sales)])

Correct ?

Micki — Tue, 08 Sep 2020 14:45:43 GMT

@JustinDallas thank you so much for your answer, but it's not working 😞 Could please send the sample .qvf with dummy data ?

JustinDallas — Tue, 08 Sep 2020 15:46:35 GMT

If you provide the dummy data I might be able to help.