To interactively slice a date range across multiple years, you'd essentially need separate fields representing parts of the date (month, day, or maybe a single day of year, i.e 237 for Aug 1), or else you'd need to carefully define that as an option in your Date Selector.
The latter option can be extremely tedious with many ranges, and is not adjustable for the dashboard's users. If you edit the dashboard's JSON, you can quickly create lots of defined options, but the static nature of those selectors may not be what you want.
Thanks Josh for your insight!
Yes, the latter one is not an option for me as it's not adjustable for the dashboard's users.
We do have a field "yDay" which represents a single day of the year, for example120 for Apr. 30th, 2021. With that, how to interactively slice a date range across multiple years? Any more detailed information? Or can you point me to any document?
Thanks so much!
I believe you'd need a "year" field, too, thinking about it more. Easy enough to calculate that to a new field using EXTRACT. The day and year would each have to be on their own number / category selectors.
Thanks again Josh,
You are right that the day and year would each have to be on their own number selector. For the day number selector, it will display from 1 to 365. That is not user friendly. Instead of displaying 1 to 365, is there a way to display Jan. 1 to Dec. 31 like the screenshot below?