I am using chart component to display certain information from GQI table results.

However, I get duplicated values and the reason is that the GQI data is not grouped by the value that I am using as a label and I get multiple labels that are same.

I wanted to group the GQI query and then aggregate the values but there is not GQI group option. How can I overcome this problem?