Hello! I have an athena query that returns various strings denoting a service type. I am trying to display the different services with aggregate counts as a bar graph but the query only returns the strings. How do i create a bar chart with this info?
Example response: “abc”, “abc”, “xyz”, “pqr”, “abc”, “abc”, “pqr”
so ideally a bar chart that shows 4 for the value of abc and 2 for the value “pqr”.
So the data aend is comma delimited?
That is just an example but it will be a sql query that returns those values, and a table representation works fine, trying to do a bar graph or pie chart showing the count along with it
please share a query with sample data. That way we can try it on our database. otherwise it would just be guess work
Thank you ! I was able to play around with my query and got it working
where col_name = 'tag_to_display' UNION ALL
select count(col_name), 'tga_2_to_display
Thank you !