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

Please sign in to leave a comment.