Chart with group by and filter

Suite and Optimus Suite 5
#1

Hi,

Is it possible to filter a group by column (equivalent of having in sql)?
I have a count as a value column, and I would like to remove small quantities from the chart, because I get a lot of small slices in the pie chart :slight_smile:

I tried to set one using the filter method but doesn’t seem to work.

#2

Hi,

filter method can be applied. However, you need to call after data loading:

chart.load(url,"json",function(){ chart.filter(function(obj){ return obj.count>5; }) })