Charts group columns from one field custom filter/query

[mc2prod (John)]

I am trying to create a chart from one field that separates based on counts $lte: 2000, $gt: 4000, etc. I am unable to do this with the available tools. seems I am missing a step or two. I can do a custom query but that applies to all.

Thank you in advance for your help.

[tomhollander]

Hi @mc2prod -

If you want the group the values into evenly sized bins, you can do this very easily:

If you want custom groups, you can do this by adding several calculated fields, each which returns 1 or 0 depending on if the condition is met. For example in the chart below the calculated field runtime30To60 is defined with this expression:

{ $cond:
 [ { $and: [ 
   { $gte:[ "$runtime", 30] },
   { $lt:[ "$runtime", 60] }] },
 1, 0]}