topic Re: Set Expression to change value in KPI using multiple Filters in App Development

Set Expression to change value in KPI using multiple Filters

yashpace — Sat, 16 Nov 2024 20:07:52 GMT

Hi, I have three filters for date, week and month and I would like to change the count of Distinct ORDNUM as user select any of the above filters

I am trying this in Current KPI (Total Orders Dispatched) -

Count({1} DISTINCT {<ORDNUM = {"=[NewOrderDate] = [NewDispatchDate] or [Week] = [WeekNewDispatchDate] or [Month] = [MonthNewDispatchdate]"}>} ORDNUM)

My filters respectively are- NewOrderDate. Week, Month (Here week and month are calendar values created by me )

This is giving me count of month if I select any date or week.

TIA!!

sugathirajkumar — Fri, 06 Sep 2019 07:32:30 GMT

can you pls try it with $ current selection?

yashpace — Fri, 06 Sep 2019 15:37:35 GMT

Hi,

I tried -

Count({$} DISTINCT {<ORDNUM = {"=[NewOrderDate] = [NewDispatchDate] or [Week] = [WeekNewDispatchDate] or [Month] = [MonthNewDispatchdate]"}>} ORDNUM)

But still getting months count.