Filter by date, location, type

for_testing · 09-18-2021 05:56 PM

I would like to create a map of incidents, but then filter the results on a map by date (how many per month), and/or Location and/or type of incident so can I can see the results plotted on a map. For example, how many robberies took place in OurTown in July. Thank you

WillowMobileSys

Hi! Welcome to the AppSheet Community.

If you are asking if this is possible, yes, it is.

for_testing

Great! That is good to know…now to demonstrate my ignorance…how do I do that? I don’t see these functions where I would expect to see them. Any guidance and assistance is appreciated.

Aurelien

Hi @for_testing

I like your nickname “for testing”

so, you may want to have a look here:

Also, have a look here for a user-input-dashboard-filter-example !
https://www.appsheet.com/templates/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=912...

For all specific filter like you mentioned:

you will probably need to use, for your row filter condition (on the slice), a combination of these expressions:

(have a look to the “See Also” section at the very bottom)

for_testing

This is GREAT! Thank you! “for testing” is very appreciative!

Steve

Where would you expect to see them?

for_testing

I was thinking that there would be a more intuitive way that I would see them on the map. I’m sure that once I know what I am looking for/at and how to get there…it will appear to be intuitive.