Not so easy filter with some conditions

tnunes — Wed, 24 May 2023 22:56:14 GMT

Hi,

I will try to explain my problem using an example, please fill free to ask more.

I need to count distinct users (represented as U) and I am able to do that if I select T1Col1.

Considering these 2 tables , the issues is when selected T2Col2 or T2Col3, I am filtered by my selection, but what I need is, when select one of these Col, it should ignore the selection for count, and need to look for T1Col1 associated values.

In this map, you can see what I need.

Grouping by T1Col3, count distinct T2Col1.

All groups have 5 distinct users

S1 group have 4 distinct users

S2 group have 1 distinct users

S3 group have 2 distinct users

Shared distinct users value is 1

Other option is, when I filter by T2Col2 or T2Col3, if it's possible to select automaticaly the associated values in T1Col1, it can solve almost all the issue. Is it possible?

Thanks

Re: Not so easy filter with some conditions

Sabrina_V — Thu, 25 May 2023 06:50:57 GMT

To ignore a selection you need to write a set analysis like this {<Field1ToIgnore=,Field2ToIgnore=>}

topic Not so easy filter with some conditions in App Development

Not so easy filter with some conditions

Re: Not so easy filter with some conditions