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
Hi! Welcome to the AppSheet Community.
If you are asking if this is possible, yes, it is.
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.
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=91266cff-e843-46b8-a42b-3d85afedb37f
For all specific filter like you mentioned:
for_testing:
filter the results on a map by date (how many per month), and/or Location and/or type of incident
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:
I don’t see these functions where I would expect to see them.
Where would you expect to see them?
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.
This is GREAT! Thank you! “for testing” is very appreciative!