If condition in KPI

sunainapawar — Sat, 16 Nov 2024 18:53:53 GMT

Hello,

I need to display the count of customer_id's wrt to Fyear.

For example: If we have FY17/18 , FY18/19 & FY19/20 data set
Then, if current year selected FY19/20 = it should show data of FY19/20 + FY18/19 + FY17/18
if any previous year selected let say FY18/19 then it should show data only of FY18/19 & FY17/18
ANDif year FY17/18 selected then it should show data only of FY17/18.

I tried to achieve this with below expression, but its not working. Whenever i select 2020, it shows data correctly for all years, but when i select previous year say 2019, it should show 2019 count only, but it returns count of all customer_id's. Its not evaluating the 2nd expression.

=if(
fYear=$(vMaxYear),
count({<fYear={"*"}>}distinct customer_id),
Count({<fYear={'$(vPrevYear)'}>}distinct customer_id))

Here, fyear is in 2019,2020 format. And in front end we have Financial Year selection as FY 18/19,FY 19/20..

Any help would be appreciated. Thanks in advance.

topic If condition in KPI in App Development

If condition in KPI