Growth Rate adding dates to chart

Comments

6 comments

  • Avatar
    Nathan Giusti

    Hey Greg,

    I'm not sure this is the best solution, but what I do in this case is create a widget filter on your date for this year and the previous x years (x being however many years of data you have). 

    To do this go to the widget filter, filter on date, and select timeframe. Set the timeframe filter to "This year & last year"

    Now go to the advanced tab near the bottom of the filter menu and you'll see something like this

     

    {
    "last": {
    "count": 2,
    "offset": 0
    }
    }

     

    Change the 2 to a however many years you have data for. This means sisense will only display data for the past x years. So a 2 would mean this year and last year. A 5 would be 2015-2019. This is a relative date so when 2020 comes, your data will display 2016-2020. Feel free to set the 2 to a large number like 10 or 15. Telling it to look at years that don't exist won't break it. 

     

    Let me know if this won't work for you or if I can clarify. 

     

    Cheers,

     

    Nathan

    1
    Comment actions Permalink
  • Avatar
    Greg Springer

    Thanks Nathan, I just tested that out and it works.  I think we'll be using those customizable date filters more often, the built-in functions seem to work well together with them.

    0
    Comment actions Permalink
  • Avatar
    Nick Burleigh

    Nathan, I'm encountering the same issue. However, I want the widget to respond to a time (year) filter at the dashboard level. Your solution works before filtering, but if I filter for a set of years (2010-2014, for example), it adds an extra year (2015) with values of -100%. Is there any solution that takes into account dynamic filtering? Thanks.

    0
    Comment actions Permalink
  • Avatar
    Nathan Giusti

    Hey Nick,

     

    Can you filter the dimension to not include 2015?

     

    If not, you can try to dynamically set your dashboard filters.

    Here's some reference material: https://developer.sisense.com/display/API2/Jaql+Reference#JAQLReference-Filtering

    And some examples of creating dynamic filters I've done here: https://github.com/nathangiusti/Sisense/tree/master/JS%20Scripts/Filters

     

    Hopefully something there helps. 

     

     

    0
    Comment actions Permalink
  • Avatar
    Greg Springer

    Hey Nick,

    My first thought, which is ugly, was to filter out Growths of -1 (-100%), but the value remains.  Manually filtering out 2015 doesn't work either, as that's the crux of this topic.

    To Nathan's point I think it's proving to be most flexible and easy to use Sisense dynamic filters all over.  They fit together with the built-in functions very well, and can be customized in many ways.  If you use the dynamic date filters as your dashboard filter it should work, as pictured below. 

    This is a limitation of Sisense, but one that can be worked around very easily once the designer understands how each piece fits together.

    0
    Comment actions Permalink
  • Avatar
    Nick Burleigh

    Hi Greg and Nathan,

    Thanks for the suggestions. As it turned out, I was just using the wrong measure in my dashboard filter. I had a Year (int) column and a Date column in my data. I was using the Year column in the filter, but once I switched it to the Date column, things behaved as expected. Appreciate you enlightening me on the dynamic filters, I'll keep that one in my toolbox for later use.

    Nick

    0
    Comment actions Permalink

Please sign in to leave a comment.