Data set named query for time series chart not working

Ignition
,
1

Hi all,

Do you know why my time series chart not working with this data set named query? It's a SQL query.

TIA,

image
image1541×883 128 KB

2

If you didn’t tell me there was a problem, I wouldn’t know there was one from that screen shot. Aside from the component error.

You didn’t:

  1. Show the query
  2. Show expected results
  3. Explain why what you have is incorrect.
  4. Show the settings for the chart.

In other words, we’re going to need more information to even have a hope of helping with whatever your problem is.

1 Like
3

Hi Irose,

  1. here is the named query so you can have a look.
    named query.txt (6.3 KB)
  2. Expected result is a bar chart that displaying the same data of the table above it, in the pic of post.
  3. Not sure why it said component error. I haven't had any luck with time series chart whenever use named query.
  4. Here is the setting. Basically it is a default chart with named query binding.
    image
    image1304×767 85.8 KB
4

It's a Time Series chart, which means that the x value must be a timestamp. Your dataset is providing two columns - one a string and the other a numerical value. Not a timestamp in sight!

Try the XY Chart component instead and set,
xAxes.0.render : category