Bar Chart want work

Ignition
1

Hi,

I am trying to put my qry in to barchart. It working with Report based on Named Qry, but want work on barchart. Not sure why? I tried same qry on table and it working fine.

Qry from SQL.

image.png676×693 19 KB

Binded to Table

image.png787×595 30.9 KB

image.png699×189 3.05 KB

Binded to BarChart

image.png788×590 30.6 KB

Results

Not sure what I am doing wrong.

Best regards
Pawel

2

You specified a database connection in the first screenshot but not in the second. Maybe try that. Also, coalesce null values to 0

3

Thanks for your advice. Once I added missing value everything start working fine.

Regards
Pawel