Making bar chart with named query

Ignition
1

Hi all,
If I have a named query that query a daily total data for each location, how can I implement it into a bar chart?
Only worked if I have one row of data. If my set of data has more than 1 row data, it doesn't display the data.
Any suggestions? I have tried to transfer my date into millis but it still doesn't want to display the 2nd row data.
Thanks

image
image1503×945 86.6 KB

2

You are trying to do this with the Time Series Chart component.

Try the XY Chart instead.
I would set the xAxes.0.render : category to get evenly spaced bars.

3

Thanks for the reply Transistor.
Is there anyway I can stack 3 of them into 1 bar? I tried the xy chart but seems like separting into 3 bars is the only option

4

Use the XY Chart.
series.0.render : column
series.1.render : column
series.2.render : column
series.0.column.appearance.stacked : true
series.1.column.appearance.stacked : true
series.2.column.appearance.stacked : true

Make sure that
series.0.yAxis
series.1.yAxis
series.2.yAxis
all point to the same y-axis, otherwise they won't stack.

5

Oh man you saved me a lot of time.

Going to try this: Stacked Bar Chart in Perspective - Detailed Steps - Ignition - Inductive Automation Forum

But I guess no need anymore :smiley:

6

Wait. It has same approach.