Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
To ignore a selection you need to write a set analysis like this {<Field1ToIgnore=,Field2ToIgnore=>}