To use this visualization, you’ll need to have a single number grouped by a Time field, like the Count of Orders by Created At.
I'm almost positive I have it set up this way, but am not able to get it to generate a comparison. All I get is the sad message "Nothing to compare for the previous ."
Here's an example of the query. Currently grouping by date_trunc but have also tried to_char and various other postgres date functions. I have also tried limiting the results by 2.
Hi @pjatx
Interesting. I was trying to reproduce your issue and forgot to order by date descending (meaning it was ASCending) and that worked, but when I sorted by date DESCending, then I’m getting Nothing to compare for the previous .
@sbelak Is that intended behavior? If so, then we should update the docs.
It’s not really intended, but rather a side-effect of how we check if you have evenly spaced data (ie. if it makes sense to do a comparison). Mind opening an issue for this.