A better way to dynamically update chart?

AppSheet AppSheet Q&A
,
1

Hi,

I’m looking for a better way of dynamically updating a chart that I have in a dashboard. I need to display the meetings per year as in the screenshot below when selecting the year from the table view in the dashboard.

I currently have multiple dashboards, charts and slices setup one per year. Whilst it gets the job done its very clunky.

Is there a better way of going about this please?

Thanks, Kerry.

KerryIBCLC_0-1646142666980.png
KerryIBCLC_0-1646142666980.png576×234 9.94 KB

KerryIBCLC_2-1646142967001.png
KerryIBCLC_2-1646142967001.png181×187 2.03 KB

KerryIBCLC_1-1646142937696.png
KerryIBCLC_1-1646142937696.png1639×939 22.4 KB

2

https://www.youtube.com/embed/nK-Aq_ak_T8

1 Like
3

Thank you. So I’m currently trying to write the expression for the row filter condition of a slice which will then display the correct filtered rows for the chart.

I’ve now got a text column [Year enum] with suggested values of the years column so the user can choose from a drop down.

I need to be able to compare the value of this drop down to the value of all rows that contain the same value for the [year] column.

I’ve tried

IN([Year enum], SELECT(LLL Stats[Year],[Year enum]=TEXT([Year])))

but that’s not working.

Cheers again :slightly_smiling_face:

4

Based my app on https://www.appsheet.com/templates/How-to-search-with-a-Slice–Dashboard?appGuidString=7e3e1bed-6576-4613-91df-5c947a87064e and got there in the end. Thanks @SkrOYC .