Ability to filter in Date Selector using multiple attributes

922
3
11-19-2019 02:35 PM
SamanthaGriffore
Occasional Contributor

It would be very useful for the Date Selector Widget in Operations Dashboard to filter using multiple attributes as in the other Category selectors.

For example, I am filtering projects by date and need to be able to query both the Start Date and End Date as one Category. (Started on on this date and Ended before this date). Since we have many projects that span over multiple years, we need to take into account both when it started and whether it is completed.

Filter options in List Widget                                                                     Filter options in Date Selector Widget (unable to choose field)

 

Thanks for your consideration.

3 Comments
patrickb
Status changed to: Under Consideration

@SamanthaGriffore We can consider ways we might be able to offer this. In the meantime. can what you are after be achieved using two separate selectors? (In a dashboard, multiple selectors will naturally 'AND' the filters together).  

TEMPNunoAlves

@patrickb Is there a solution or workaround for this at the moment?

PeterMacKenzie2

@patrickb I think this use case needs to 'OR' the two queries together rather than AND them. 
This is for  a time span query to return results partially within the start and end dates. 

example:

Start date is after date A AND End data is BEFORE date B
will capture data completely within that timespan

Start date is after date A OR End data is BEFORE date B
will capture data partially within that timespan

i've upvoted this as i would like to create a op dashboard for different stages of a construction project ..show me what the project looks like at time X