topic Re: Compare previous year data in KPI in App Development

Compare previous year data in KPI

Darren1 — Thu, 02 Sep 2021 17:27:12 GMT

I am working to create a KPI that compares the previous years results to the current selected year. The user will be able to pick a fiscal year from a filter pane and see the results. However I am having trouble when the first available year is picked (ex 2005) does not have a previous year to compare it to (no data for 2004) . Can the KPI display a text note when a previous year comparison is not available?

Here is my current expression

Sum({$<fiscal_year={$(=max(fiscal_year))}>} Tons) - Sum({$<fiscal_year={$(=max(fiscal_year)-1)}>} Tons)

Re: Compare previous year data in KPI

rubenmarin — Sat, 04 Sep 2021 08:15:06 GMT

Hi, maybe adding a condition to check if the firts year has been selected, something like:

If(max(fiscal_year)=min({1} fiscal_year), 'text note to display', [YourCurrentExpression])

Re: Compare previous year data in KPI

Darren1 — Tue, 07 Sep 2021 16:44:37 GMT

Thank you for your response. Your expression help did the trick!