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”.
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