- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-09-2020 09:52 AM
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?
Solved! Go to Solution.
- 63,581 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-23-2020 12:26 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-09-2020 09:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-09-2020 09:59 AM
I tried that update set, but didn't work. Was hoping for a different one.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-23-2020 04:18 AM
HI
I am also looking for the same, can someone help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-23-2020 12:26 PM
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