Has anyone used custom date ranges in the ArcGIS Dashboard Date Selector?

[RachelAbernethy]

Hi everyone

I am working with a feature service that contains information on property transactions and one of the fields displays the expiration date of the lease/licenses involved in the transaction. 

I am creating a dashboard that will display various indicators and charts relating to these transactions. I would like to add a Date Selector to the top and have the following options included:

1. Select records where the expiry date is within the next 3 months

2. Select records where the expiry date is within 3-6 months

3. Select records where the expiry date is beyond 6 months.

I don't want to hard code the dates in because of course that would need to be edited all the time. The current drop down options for date ranges doesn't really fit in with what I would like to show. There is "this quarter", "next quarter" but I am not sure if that always means JAN-MAR, or if it is a rolling time frame. 

So my question for everyone is - is there a way to customize the date selector options in a dashboard? or is there something I should do in the data itself first to make it work here? 

Any thoughts welcome, or if you have done something similar it would be great to know.

Thank you!

[ctalleygreenville]

Rachel,

on the "Defined Options", if you choose something other that "is" on the dropdown, such as "Within the Last", you have options for indicating an exact number days, hours, minutes, etc.  

I have found that it works better to use a incremental size one level smaller than what you might label in the display.

For example, the Display name might say, "Within the last week" but your query will be "is within the last" and choose "7" "days".  It also depends on whether or not your data has date only or date and time.   I suppose what I am saying is that you might have to tweak this a bit to get exactly what is expected but I have had good results once I drop back and use a unit of time less than what you might display as an option.