Customizing default date filter in Sisense

Comments

4 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

Please sign in to leave a comment.