Grouped and stuck data by days

Grafana Time Series Panel
1

I have rather simple query (Postgresql):

select created_at, category, sum(profit) as profit
from datasource
group by created_at, category;

I want to create a chart which represents profit per category for every day. I tried to use a time series but I couldn’t stack them. Also I tried to use a bar chart (unsuccessfully). So technically I even didn’t find a way to represent categories with profit inside one date.
How could I do it in Grafana?

2

Welcome to forum @tylinka

try this

select created_at as time, 
       category as metric, 
       sum(profit) as value
  from datasource
 group by created_at, category;

and make sure your data format is time series

image
image921×690 36 KB

3

Did you set any additional settings? I used this aliases but still have the same :frowning: I tried to override and use stack option, but it doesn’t help.

image
image1434×634 24.4 KB

4

Did you set tha format?

5

Yes, it has date time format
image

6

Nope not that. See the previous picture I posted

image
image921×690 36.7 KB

Right below there is a Format option

1 Like
7

Wow, I’ve never noticed that… Thank you very much!

1 Like
8

Would be nice if it defaulted to time series when it sees a time column