topic How to add a filter in the following expression in App Development

How to add a filter in the following expression

Sid666123 — Mon, 20 Dec 2021 21:08:46 GMT

Hi,

I've managed to link a custom filter to a single chart using the following equation. However, my goal is to include a filter for yes or no.

Count({$*[Issue]},{Condition='Yes'} ID_number)/Count({1<[Issue]=>} ,{Condition ='Yes'}>} Total ID_number)

What is the correct syntax?

Cheers,

Sid

Re: How to add a filter in the following expression

Vegar — Sat, 16 Jan 2021 07:49:18 GMT

What is [Issue]? Is it a field , a state or a bookmark? I am assuming it is a field in my suggestion below.

Count({$<[Issue] , [Condition] ={'Yes'} >} ID_number)/Count({1<[Issue],[Condition] ={'Yes'}>} Total ID_number)

Or if you want both yes and no ids.

Count({$<[Issue] , [Condition] ={'Yes', 'No' } >} ID_number)/Count({1<[Issue],[Condition] ={'Yes', 'No' }>} Total ID_number)

Re: How to add a filter in the following expression

Sid666123 — Sat, 16 Jan 2021 11:24:10 GMT

Hi Vegar,

Thanks for the solution. The reason I am using Count({$*[Issue]} is because $* is a filter I've used explicitly for a particular chart since it is in an alternate state. Taking out the * disables the filter. I gotta add the Extra bit keeping the filter on.

Cheers,

Sid

Cheers

Re: How to add a filter in the following expression

Vegar — Sat, 16 Jan 2021 14:45:22 GMT

Is this a solution/help for you?

Count({$*Issue<[Condition] ={'Yes', 'No' } >} ID_number)/Count({1*[Issue]<[Condition] ={'Yes', 'No' }>} Total ID_number)

If not then please explain or rephrase your issue.

Re: How to add a filter in the following expression

Sid666123 — Sat, 16 Jan 2021 23:19:16 GMT

Hi Vegar,

The filter is working perfectly!! Thanks for that. In the second part of the equation i.e Count({1*[Issue]<[Condition] ={'Yes', 'No' }>} Total ID_number) My main goal is to calculate the percentage using the equation such that, if I pick a date with the date picker then it would use the total within the date range to spit the percentage of the dimension. My understanding is using a 1< would fix that issue? I might be wrong? Right now it does not calculate the correct percentage and yes, the issue is a dimension.

Re: How to add a filter in the following expression

Vegar — Sun, 17 Jan 2021 08:48:04 GMT

Using {1} will ignore all selections, inclusive any selections you have done on the date field. To pinpoint just to ignore selection on date you can use a date modifier cancelling your selection.

{1 * Issue<[Date] =, [Condition] ={'Yes', 'No' }>}

However if you have Date as a dimension and want to show all dates on all rows then you w will need to take a look at the count (TOTAL [...] )