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
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.
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
GROUP BY VLAN
My results look like this:
Your example gave me some data! thank you. this was really helpful