Date filter to select between two fields

In my table, each record has a date range denoted by two fields. I would like the user to be able to use a date filter to select any day within the range and have that record be selected.

Example:

Pointing to this four-field table, the user could choose 04/06/24 in a filter in order to see this record. I realize I could create another table such that this record repeats 25 times, once for every day in between (a record for 4/1, 4/2, ... 4/25). However, my original table is already pushing the limits of being too large; creating that alternative table would be severely impractical.

Any ideas how to accomplish this?

~ Linux/on-prem ~

danblack

Posted 2 years ago·Last reply 2 years ago

3 comments

DRay

·2 years ago

Hello danblack,

Thank you for your question. Are there counts associated with each date within that date range? If so, a different visualization may work better here. A graph would show the value for each point along the range, making it easier to get the count for each day.

danblack

OP2 years ago

Thanks for the reply, DRay! While there aren't counts associated, I believe you gave me another idea to play with. Much appreciated!

DRay

·2 years ago

Glad to help! Please keep us posted, I would love to hear how you end up resolving this.