Add missing dates to a trend chart

Comments

4 comments

  • Avatar
    Linna

    This script does not work on my end. I have the current version of SiSense. What updates should I make to this script for it to work?

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Lianna,

    This is a native feature in newest version. Please see attached scrren on how to enable it.




    1.png
    0
    Comment actions Permalink
  • Avatar
    Linna

    Thank you Michal! This is incredibly helpful.

    Would it be possible to enable this feature for the Quarter, Month and Day when I drill down into those fields?

    0
    Comment actions Permalink
  • Avatar
    Chris Bridges

    Hey @...,

    This is so close to solving an issue I am facing. Some of my categories on my line chart have all of the days while a few of them are missing the days. When I have all of the categories displayed, it does not turn turn the other values into zeros and instead leaves them off of the chart. If I filter my categories however, to just include the categories that are missing dates, the script correctly adds 0's for the dates that were missing. So it is really close to working but we would not know the data was missing until we filter on each category individually. Could this script be tweaked to work for my scenario?

    -Chris

    0
    Comment actions Permalink

Please sign in to leave a comment.