Solved: Calendar view using interactive dashboard filter - Page 2

Dan_Longley · 04-13-2020 01:49 AM

Mimicking the demo app " Slice based on user input", I have an interactive dashboard filter that should allow me to select a Client Name using table Filter-Client. That bit works ok. Then it should show on the calendar all dates that the client has (previously) attended.

With this formula

CONTAINS(Register[Attendees],ANY(Filter_Client[Client Name]))

in a slice (looking at Register table) for the calendar view, I’ve managed to get the calendar to recognise that, for example, Anton has attended before, but it shows ALL the dates, even those that he didn’t attend. In other words, it’s a yes/no response.

How do I get the formula to check which dates Anton was an attendee and then return just those dates on the calendar view.

T

Any pointers much appreciated.

WillowMobileSys

I wasn’t completely sure how you were using the original expression.

For the slice filter criteria, you simply need to wrap the expression I provided with another IN() function. I am assuming that you have access to the RegisterID value is some way such as directly in a column in the “Client Attendance Calendar” slice row or through a Ref column. If you don’t, be sure to add it.

IN([RegisterID],
   SELECT(Register[RegisterID], 
          IN(ANY(Filter_Client[Client Name]
             ), 
             [Attendees]
          )
   )
)

Note that I used RegisterID in two places. AppSheet should be able to figure out from context that the first is in the Slice dataset and the second is from the Register table.

View solution in original post