Custom Filter for date

Question & Answer
, ,
1

I want to add a start date and end date filter to my dashboard. The thing is my data doesn’t contain a date column, it only contains month and year columns which are not date formatted, meaning month is a string and year is an integer like below:
image

Now whatever start date and end date I select in filter, I want the dashboard visuals to filter based on the specific month and year.
eg: If start_date = 05/11/2023 and end_date = 25/01/2024, I want the filter to show all data of November 2023 and January 2024.
Can something like this be done?

2

Hi @maitreya10
if you want to use a date filter. You need to create a date field first.

You also need to create two parameter (start and end).
After that i would create a calculated field isRelevant to check if date fieldis between first day of start month and last day of end month.
Then i would create a filter for the isRelevantfield.
BR