How to create separate Chart Views for different REF_ROWS columns related to the same table

[vitistuta]

Hello everyone,

I am working with three tables in AppSheet. Table 1 is a main database containing all the data, while Tables 2 and 3 each have a virtual column that uses the REF_ROWS formula to pull data from Table 1. The issue I’m encountering is that AppSheet seems to assign the same Chart View to both related columns, even though these columns are linked to Table 1 but refer to different columns within it.

I would like to create two separate Chart Views, one for each table, but it appears that both related columns are being treated as the same in the Chart View configuration.

How can I configure AppSheet to display the correct data in the right Chart View for each table, specifically for the columns related to Table 1?

Any help or suggestions would be greatly appreciated!

[Suvrutt_Gurjar]

In general you could create two chart views (ref type) for the two tables.

[vitistuta]

Thank you for your reply! I think I might have explained myself poorly.

The data for the two Chart Views is actually stored in Table 1, so both Chart Views are created from Table 1. Table 2 is used to filter by year, and Table 3 is used to filter by category. Essentially, the two tables (2 and 3) are serving as filters for the data in Table 1, but the actual Chart Views are based on Table 1's data.

Unfortunately, it’s a bit hard to explain clearly in words, but I hope this clarifies things.

If you have any further suggestions, I’d be happy to hear them!

[Suvrutt_Gurjar]

Thank you. Could you share how the columns that reference data from Table 1 in Table 2 and Table 3 are configured, meaning their expressions. If possible, you may wish to share relevant screenshots.

[vitistuta]

I’m sending some screenshots where I try to explain the situation. Unfortunately, I think it’s quite complicated, so if you can make sense of it, great, otherwise it’s fine and I’ll leave it as it is. In the end, everything works. I just would have liked a different type of chart view (maybe a bar chart) for the category filter. Thanks anyway for your help!table 2 viewtable 3 viewtable 3table 1table 2

[Suvrutt_Gurjar · Accepted solution]

Please try creating a slice  called say "Entrate Slice" on table 8 with slice filter condition as simply TRUE 

Then have Ref_ROWS expression as

REF_ROWS( "Entrate Slice" , "Chiave Categoria") and base your Category view on that slice.

[vitistuta]

yes!! Thank you. it works now.
I created a slice of sheet8, I corrected the REF_ROW formula by indicating the new slice, and finally I created the graph based on the data of the new slice.
Thanks again!

[Suvrutt_Gurjar]

Great to know. You are welcome.

From the screenshots shared by you it sounds that you are using "_RowNumber" as a key for the Sheet 8 table. You may want to use something like UNIQUEID() as the table key in a dedicated key column. This is so because in general "_RowNumber" is not a good key option.

What is a key? - AppSheet Help

Excerpt from the article:

Please also read the 'Random Keys' paragraph in the article. Random keys is a recommended approach in AppSheet.