topic Re: If with count in KPI in App Development

If with count in KPI

sunainapawar — Tue, 24 Mar 2020 08:58:33 GMT

Hello,

I need to display the count of customer id's w.r.t Fyear in KPI. If current Financial Year is selected , then count of customer_id's should be count of all Financial Year, if previous year is selected then it should show count of customer_id's for that particluar year.

I tried to use if expression, but its not working. Please find the expression i used below,

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

Our Fyear is considered from Apr till Mar.

Please help to check.

Thanks in advance.

Re: If with count in KPI

Kashyap_R — Tue, 24 Mar 2020 11:32:22 GMT

Try this

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

Thanks

Re: If with count in KPI

sunainapawar — Tue, 24 Mar 2020 11:47:29 GMT

Hi Kashyap,

Thanks for the reply. This is working upon selection of fyear 2019. It is showing count of customer_id for 2019. But when i select 2020 it is showing only for fyear 2020, but rather it should show count of customer id's for both 2019 and 2020.

Please suggest.

Re: If with count in KPI

Kashyap_R — Tue, 24 Mar 2020 12:11:36 GMT

Try this

if($(=max(fYear))=$(=max({<fyear=>}fyear)),(count({<fYear=>}distinct customer_id)),(Count(distinct customer_id)))

Hope this works

Thanks

Re: If with count in KPI

sunainapawar — Tue, 24 Mar 2020 12:21:28 GMT

Hi Kashyap,

It is same as previous result.

For current year selection, its not summing up the count of 2019,2020. Its only showing for 2020.

Re: If with count in KPI

sunainapawar — Tue, 24 Mar 2020 13:49:46 GMT

Hello All,

I have got the solution. I just used the below expression and it worked.

Count({<fYear={"<=$(vMaxYear)"},FYear>}distinct customer_id)