Ignition Pie Chart

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!

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:

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

My results look like this:

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

1 Like