Customizing default date filter in Sisense
Hi!
Is there a way to customize the default date filter such as to exclude some of it's default values e.g. I wish to exclude Weeks, Days and Time from the list so users only see Years, Quarters and Months.
-
Hi,
Don't believe you can set this as a parameter, and probably not at field level.
In order to achieve what you want to do, you would need to :
- change the filter through JAvascript (though probably not documented, and quite risky in terms of a version upgrade)
- use custom fields: year, date and month and use dependent filters
Best,
David.
-
Thanks for the response David.
- Would you know how to write the javascript code for this? I'll make sure to document internally about the version upgrade impact.
- Can't use custom fields as my calculations include "Growth" formula which does not work on custom date fields.
Thanks!
-
I have a similar need where I need the 'Last 7 days' to start from now()-1. I'm trying to show data through yesterday(dont get current day data in until the next day)
Either that or just edit the wording to say 'Last 6 days' if that is easier to do.
How can I go about editing filter script? Appreciate any leads.Thanks!
Please sign in to leave a comment.
Comments
6 comments