hello there

i would like to create a pie chart that represent (category and count)

however, I couldnt do a count function or something similar

my table has a string column and an auto increment id, I want to show the string and how many id are for that string 

when i do grouping the chart takes the id value and add it up >> I want a count for id not sum

how can i do that??