Define a variable as a filter

Fri, 26 Aug 2016 14:49:39 GMT

Hi !

I have inputs/outputs table which I want to analyze.

Those inputs/outputs are distributed in Unities:

Inputs:

Unity | [Nb of inputs] | Source

U1 | 3 | Outside

U1 | 4 | Other Unity

U2 | 2 | Outside

U2 | 5 | Other Unity

As you can see it, an input can come from another Unity.

The problem is, when I analyze my inputs with the vision of all unities, I don't want the inputs from others unity to be considered.

I could use expressions like

IF(count(Unity)=count(TOTAL Unity),

Sum({<Source={'Outside'}>}[Nb of inputs]),

Sum([Nb of inputs]))

but I would have to put it in all the expressions of all my graphs, and the code would become hard to understand...

My question is: is there a way to define a variable that, when count(Unity)=count(TOTAL Unity) applies a filter on the Source ?

Thank you

topic Define a variable as a filter in App Development