Ability to compare the current time period vs the same time period some time ago

[blanchonvincent]

First of all, I really like your product, very easy to deploy (a single docker image is enough), easy to automate (with seq-cli), this is a brillant project!

I got a suggestion with the dashboards and SQL queries.

It would be great to be able to make a chart of type "value" that could show the increase/decrease of the current period vs the previous one.

For instance, I got 50k event for "Last 1d" but the day before I got 40k, I would like to be able to have a chart that show me "+25%". Same thing, if my time period selected is last 7 days, then I could compare 2 weeks ago vs this week.

With prometheus we can do things like

sum(rate(my_http_counter[1m]))

and

sum(rate(my_http_counter[1m] offset 5m)) to get the same series 5 minutes ago.

Let me know if it makes sense.

[nblumhardt]

Thanks for the suggestion! This makes sense, but would rely on some back-end capabilities that I don't think Seq will have for a while - it's good for us to have this use-case in mind 👍