I have 2 tables:
- Main Table ---> with users (with Key Column "CODICE FISCALE")
- Events Table ----> these users could be referenced to this table in 4 ref columns
Now, when I select a row in Main Table where there is the Key Column "CODICE FISCALE",
if I insert this table in a dashboard view with Interactive mode actived with Inline Events view or charts views,
on Row Selected I see only some events an not all the events.
For example:
- If a user (with Key Column "CODICE FISCALE") has 4 events --> if I search the key value in calendar view, the events associated are 4 (and it is correct)
- but if I select the row for that row ---> I have only 1 event in Inline events view or chart views
(it is filtered only for [Ref column 3] and so not for also [Ref column 1] [Ref column 2] [Ref column 4] )
Why?
The problem is propagated to all charts connected, and so on row selected are visible only a part of referenced table and not all.
how it is possible?
I have tried changing the ref tables,
and so:
If the key column of table 1 is on [Ref column 1] [Ref column 2] of table 2
the ref events are all visible only for these 2 columns
but
If the key column of table 1 is on [Ref column 3] [Ref column 4] of table 2
the ref events are all visible only for these 2 columns
but for all ref columns [Ref column 1] [Ref column 2] [Ref column 3] [Ref column 4] together
are visible only 2 ref events.
Why?
@AleksiAlkio how could I solve?
User | Count |
---|---|
18 | |
9 | |
6 | |
5 | |
3 |