Slice row filter condition expression help

AppSheet AppSheet Q&A
1

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.

KerryIBCLC_0-1646216275522.png
KerryIBCLC_0-1646216275522.png632Ă—235 6.49 KB

KerryIBCLC_1-1646216305762.png
KerryIBCLC_1-1646216305762.png1662Ă—841 18 KB

2

Hi @KerryIBCLC

Try that:

[Year]=ANY(yourFilterTable[Year])
2 Likes
3

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”

2 Likes
4

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-4613-91df-5c947a87064e

2 Likes