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
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.
Any pointers much appreciated.