Filtering in Expression of Count()

[nm02]

Hello there,

I want to combine 2 filter in one function, but i can't figure it how to do it.

I have a table with several coloums of which only the [Result] matters.
I have another table where I assign every [Machine] a [MachineCategory] based on some parameters.

My goal is to Count all [Result] = 'not Ok' in one specific [MachineCategory] (which you can filter via variable input with variable #vMachineCategory).

I have these two filters:

Count({<Result={'not Ok'}>}Result))*100/Count(Result)

- This gives me the percentage of [Result] = 'not Ok' out of all [Result]

Count({<MachineCategory={'$(#vMachineCategory)'}>}Result)

- This counts all items in [Result] in a [MachineCategory]

My pseudo code looks something like this:

Count({<MachineCategory={'$(#vMachineCategory)'}>}Result{<Result={'not Ok'}>})

Sadly, this doesn't work. I don't know if it's because of a syntax error on my side or because you can't filter in the expr Expression of the Count function.

I would love to get your ideas on that, thanks in advance.

[MarcoWedel · Accepted solution]

Count({<MachineCategory={'$(#vMachineCategory)'}, Result={'not Ok'}>} Result)

[nm02]

Thank you very much, it works perfectly!