I have a custom SQL query to count "sessions" between two dates, and am trying to create a trend visualisation to show comparisons the previous periods counts i.e:
For a full week:
So all good so far.
But when I try to set the date range to just 3 days i.e.:
There is no comparison:
Why is this? Users of my dashboard must be able to choose whatever date range they desire, so I can't just stick to exact week/month etc. I'm using version 0.45