How to create stack chart in grafana

[alinizamani72]

Hi Guruz
I am newbie in Grafana Labs. Please guide me . I want to draw stack chart as shown bin attachment.

when i am using same query to draw required chart in grafana it appears as below.

Please help me to find missing settings…

[ivanahuckova]

Hello @alinizamani72, see the thread below with the answers:

Creating Stacked Bar Charts on Grafana using data from SQL Server

Hi During a particular day, I have data from multiple categories say A,B,C. I want to create a bar chart in which for every day there is a single bar with different colors for the different categories. The count of categories should be stacked in a single bar for a particular day. I am not able to figure that out in Grafana. Can someone please help me out?

[alinizamani72]

See, i dont have time column in my query . The expected result is as below

while attaching now() current date time , chart doesnt give required stack preview.

[alinizamani72]

See, i dont have time column in my query . The expected result is as below

while attaching now() current date time , chart doesnt give required stack preview.

[ivanahuckova]

Unfortunately, that is not possible. See the thread below with the external plugin that might help you. There is also a github feature request for it, so feel free to upvote it and write why would this feature be useful for you and what is your use-case.

Stacked Bar Chart from Table Values

I have some MS SQL data that looks like this (after aggregations): time metric Revenue Cost Profit 1569909600 Sub1 177.345600 159.611040 17.734560 1569909600 Sub2 187.166900 168.450210 18.716690 1569909600 Sub3 209.718500 188.746650 20.971850 and I’m trying to get a stacked bar chart that looks similar to this: [chart001] I’m having a hell of a time figuring out any way to do it. Any chance someone could help me out? So far the best I can get is all of the bars lined up …

[alinizamani72]

Very clear now , can you share any sample or support discussions which demonstrate multiple stack series with time interval at x axis (using mysql or sql server)

[ivanahuckova]

I don’t think I understand what do you mean by multiple stack series with time interval at x axis . But you can use a search functionality to try to find relevant information.