Customizing default date filter in Sisense

Follow

Kshitiz K

November 26, 2018 13:37

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.

0

• 

  David Hertzberg November 28, 2018 15:36

  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.

   

  0

  Comment actions Permalink
• 

  Kshitiz K November 28, 2018 15:51

  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!

   

  0

  Comment actions Permalink
• 

  JJ Chritton April 29, 2019 21:43

  We have a similar issue with data that is aggregated at the month level, so that allowing the user to filter more specifically than a month is confusing because the results will often include no data.

  0

  Comment actions Permalink
• 

  Roopa Raghavan June 28, 2019 14:05

  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!

  0

  Comment actions Permalink
• 

  Jessica Orlando March 23, 2020 16:09

  Curious if anyone was able to figure out the code for this? I am looking to filter to 'This Year' but exclude a specific week due to holidays.

   

  Thanks!

  0

  Comment actions Permalink
• 

  Vikas Sharma July 08, 2020 02:53

  Any Idea how to display data for last 365 days, default date filter of sisense only allow 'Last 360 days' filter. But our client need 'Last 365 days' as default data on dashboard load

  0

  Comment actions Permalink

Please sign in to leave a comment.