# Ignition Pie Chart

**URL:** <https://forum.inductiveautomation.com/t/ignition-pie-chart/27157>\
**Category:** Ignition\
**Created:** [August 5, 2019, 12:42pm UTC](https://forum.inductiveautomation.com/t/ignition-pie-chart/27157 "2019-08-05T12:42:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ammermanbrittanyf](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\
**Post date:** [August 5, 2019, 12:42pm UTC](https://forum.inductiveautomation.com/t/ignition-pie-chart/27157/1 "2019-08-05T12:42:04Z")

</div>

Hello. I am looking to use a pie chart for a visual analysis, however, I can't figure out how to get it to run. I was hoping to run a simply query like below:

> SELECT COUNT(VLAN) FROM FA\_ECA\_MASTER

or

> SELECT VLAN FROM FA\_ECA\_MASTER

where VLAN is a column title from the FA\_ECA\_MASTER table.

I'd appreciate any help to get this working or take a step in the right direction.  
Thank you!

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [August 5, 2019, 1:00pm UTC](https://forum.inductiveautomation.com/t/ignition-pie-chart/27157/2 "2019-08-05T13:00:54Z")

</div>

What kind of results do you get if you run the query in the Database query browser?

Charts of this type usually require two columns, one for the category and one for the value. Your query, as written, will only return one column.

I’m guessing your query should look more like:

```auto
SELECT VLAN, COUNT(VLAN) AS vlan_count
FROM FA_ECA_MASTER
GROUP BY VLAN

```

---

<div class="post-metadata">

**Author:** ![ammermanbrittanyf](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\
**Post date:** [August 5, 2019, 1:02pm UTC](https://forum.inductiveautomation.com/t/ignition-pie-chart/27157/3 "2019-08-05T13:02:56Z")

</div>

My results look like this:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/22b26520fd0bc3d5866b6600e62de07bfbf8ee22.png)

---

<div class="post-metadata">

**Author:** ![ammermanbrittanyf](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\
**Post date:** [August 5, 2019, 1:07pm UTC](https://forum.inductiveautomation.com/t/ignition-pie-chart/27157/4 "2019-08-05T13:07:55Z")

</div>

Your example gave me some data! thank you. this was really helpful 🙂