Custom number of days for trend visualisation

#1

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:
25
Gives:

46
Screenshot 2022-01-19 at 14.29.46.png726×392 11.8 KB

So all good so far.
But when I try to set the date range to just 3 days i.e.:
38
There is no comparison:
01
Screenshot 2022-01-19 at 14.31.01.png720×296 13.2 KB

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

#2

Hi @dmellor
That's currently not supported:
https://github.com/metabase/metabase/issues/9510 - upvote by clicking :+1: on the first post
By the way, there's no 0.45 (yet) - latest release is 0.41.6: https://github.com/metabase/metabase/releases/latest

#3

Hi @flamber - thank you very much for your instant reply! (woops - I did mean 0.41.5 :blush:)

Noted - much appreciated.

#4

@flamber is there a way of hiding the text "Nothing to compare" ? That way I can have a trend when possible but it doesn't look odd when not possible.

#5

@dmellor Currently no, the Trend visualization doesn't have that many configurations.

#6

Ok - many thanks!