Drilldown to subset the points that are mapped

[Fof_Webmaster]

I have a table view with “sorted by” and “grouped by” which creates a drill down on reports, all of which include GPS location. I want to create a dashboard that uses this drilldown to subset map locations as I drilldown. In other words the only locations shown on the map would be according to what is picked on the list. Right now the map in my dashboard is pretty useless. It only changes when I drill all the way down to one specific record, at which time it points to one record location.

Could I do this with a Slice and a row filter conditions that subsets the data based on the current list drilldown?

[Frederik]

Yes!

This would be very useful

I have a list of customers to visit, and being able to filter by appointment date would be an absoulte game changer for figuring out when I’ll be in an area!

[Fof_Webmaster]

Hi Frederick,

I solved this with help in this posting:
https://community.appsheet.com,/t/change-row-filter-condition-for-a-slice-based-on-user-input/11747

Part of the filter uses start time and end time, which may be what you are looking for.

Cheers,
Bob

[Fof_Webmaster]

This link should work:

Change row filter condition for a slice based on user input Questions

I think you need ANY(FilterTable[Filter_Desc]) = “Yes” (and ditto for No or just use IF with an else case). Stylistically, I would consider writing this a bit differently. I’m assuming there is only one row in the FilterTable and its key is known. Let’s say the key is “1”. So you could have a hidden virtual column FIlterRef in the table you are filtering with a Ref to the FilterTable and the app formula “1”. Then you could just do a de-reference. IF([FilterRef].[FilterDesc] = “Yes”, AND([Fil…

[Frederik]

Thanks a lot, I’ll look into that