Slice row filter condition expression help

[KerryIBCLC]

Hi,

I have a chart that I need to dynamically update based on the drop down [Year filter].

[Year filter] is populated with data from the column [Year]

I understand I need to hook up the chart to a slice with a row filter condition.

I need the slice to detect the rows where the column [Year] matches the selection in [Year filter].

Thank you in advance. Kerry.

[Aurelien · Accepted solution]

Hi @KerryIBCLC 

Try that:

[Year]=ANY(yourFilterTable[Year])

[TeeSee1]

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Dashboard-view-with-filtered-records/m-p/260648

Have you read this?

There are several sample apps also available.

Just search "AppSheet filtered dashboard"

[KerryIBCLC]

Thanks @TeeSee1 and @Aurelien.

I got there by using [Year]=ANY(Filter[Year Filter]) and basing my app design on this:

https://www.appsheet.com/templates/How-to-search-with-a-Slice--Dashboard?appGuidString=7e3e1bed-6576...