Customizing default date filter in Sisense

Comments

6 comments

  • Avatar
    David Hertzberg

    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
  • Avatar
    Kshitiz K

    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
  • Avatar
    JJ Chritton

    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
  • Avatar
    Roopa Raghavan

    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
  • Avatar
    Jessica Orlando

    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
  • Avatar
    Vikas Sharma

    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.