Filtering on Multiple Fields by Configuring Map Tools in Operations Dashboard

3114
3
01-13-2016 01:52 PM
RobbWatson
New Contributor

Is it possible for multiple layer filters to actually recognize each other when checked "on" using the map tools?

Example:

  • I have filters for several states, such as Ohio, Indiana, etc. These work great when selecting just one or multiple states only.

  • I also have filters for months that the data was received, appearing in the same Filter list (obviously from different fields, but from the same table), such as November 2015 and December 2015. These work great when selecting just one or multiple months only.

  • But if I try to filter using one of each together, for example all of the records for Ohio from November 2015 (just checking the boxes on for each of the filters), the results give me all of the results for Ohio from each month (in the entire dataset), plus all of the results from every state for just the month of November 2015.

I would expect it to only return the records with Ohio in the state field and November 2015 in the month field.

It seems to me there should be a way for this filter to be built. Does anyone have insight into this issue, or am I going to be learning how to create a custom widget in the near future?

Thanks in advance!

- Robb

0 Kudos
3 Replies
FinbarGillen
Occasional Contributor

Robb,

I think I have the same kind of issue. I am looking to display data in the Pie Chart or Bar Chart Widget showing value and ratings of properties by Estate but it seems it only shows the full data set. If there was a widget that allowed the user to select from a drop down that would filter the data and this would automatically update the charts it would be extremely beneficial.

Finbar

0 Kudos
AliBarakat
Occasional Contributor II

Hello everyone, i have the same issue also.

did anyone find a solution?

0 Kudos
ChristopherOlsen
Regular Contributor

Ali (and all)- 

There isn't really a solution in the current Operations Dashboard but we are redesigning how filters and configurations will look in the new Dashboard. Thanks for the feedback!

Chris