# Bar Chart want work

**URL:** <https://forum.inductiveautomation.com/t/bar-chart-want-work/19612>\
**Category:** Ignition\
**Created:** [September 10, 2018, 9:22pm UTC](https://forum.inductiveautomation.com/t/bar-chart-want-work/19612 "2018-09-10T21:22:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pawel.kondol](https://avatars.discourse-cdn.com/v4/letter/p/96bed5/32.png) [@pawel.kondol](https://forum.inductiveautomation.com/u/pawel.kondol)\
**Post date:** [September 10, 2018, 9:22pm UTC](https://forum.inductiveautomation.com/t/bar-chart-want-work/19612/1 "2018-09-10T21:22:17Z")

</div>

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.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f243b1663461a3deb18a19cba2380380f0ac5aef.png)

Binded to Table

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f8da41112af4634ba57e167d1c64f0a7edb23bf0.png)  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/43daa969f32fdc773d4129e5eeff3c6b1f5613cb.png)

Binded to BarChart

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/dbe7e2d95b7b6ee12718a706d27d9a14b0b338d5.png)

Results  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c49a3865185b85b263b00d0204369bc0a2859215.png)

Not sure what I am doing wrong.

Best regards  
Pawel

---

<div class="post-metadata">

**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\
**Post date:** [September 10, 2018, 9:37pm UTC](https://forum.inductiveautomation.com/t/bar-chart-want-work/19612/2 "2018-09-10T21:37:08Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pawel.kondol](https://avatars.discourse-cdn.com/v4/letter/p/96bed5/32.png) [@pawel.kondol](https://forum.inductiveautomation.com/u/pawel.kondol)\
**Post date:** [September 11, 2018, 11:47am UTC](https://forum.inductiveautomation.com/t/bar-chart-want-work/19612/3 "2018-09-11T11:47:39Z")

</div>

> [@ethomason](#):
>
> coalesce

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

Regards  
Pawel