How to create a date range interactive filter for dashboards?

[Dario Marquez]

I need to create an interactive filter that allows me to set in between dates in a dashboard. Similar to the date filter currently exists in standard reporting but in a widget that I can add to a dashboard. I don't need the time, just the dates. So far I've found only 1 script in the community with an update set that creates a macro and a widget, but didn't work for me. Does anyone have a different script or update set that can help me create this filter? 

[sachin_namjoshi]

You can create a custom interactive filter (there is an example here).   

Regards,

Sachin

[Dario Marquez]

I tried that update set, but didn't work. Was hoping for a different one.

[Divya118]

HI 

I am also looking for the same, can someone help 

[Dario Marquez · Accepted solution]

Hey, this worked for me. The update set is a combination of 2 contributions based on this post:

Interactive Filter "between dates"

Basically the update set creates:

• a new widget called "custom interactive filter"
• and a UI macro, which is the backend magic that works with the new widget created

the widget coding is originally from the accepted solution from the mentioned post, but the macro part doesn't work, so the macro fixed code was posted in a later reply (that for some reason I am not able to find). But the macro displayed text was in Norway language, so I had to translate it. 

So the final update set is like a hybrid solution compiled in the attached update set, which should give you something like pic below. You will only need to update the table names  in the widget coding(pic 2), everything is explained in the linked post. So at the end you will have one filter for each table needed.  Let me know any questions.

pic2