Hello guys,
I am building a dashboard app, which is composed of graphs and tables.
On a certain table, I would like the rows to correspond to the selection that is made on my chart (which is itself based on a SQL query).
What is the easiest way to do that?
Thanks in advance ![:slight_smile: :slight_smile:](https://community.retool.com/images/emoji/apple/slight_smile.png?v=12)
Hi @Alexandre_Lorthiois, welcome to the fam ![:hugs: :hugs:](https://community.retool.com/images/emoji/apple/hugs.png?v=12)
You have a couple of options:
- use the dynamic column setting in the table to show/hide only the columns your interested in based on your chart selection
- use a tabbed container to switch views (multiple tables)
I would use the latter only if the data shown in the table differs a lot between chart point selections. I think the dynamic column setting is the cleanest approach.
Does that make sense? Share a bit more about your setup if you need more help