Ref values are missing on row selected in interactive Dashboard

AppSheet AppSheet Q&A
, , ,
1

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?

2

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?

3

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?

4

@AleksiAlkio how could I solve?