I know I can do |chart list(field1) by field2,field 3
but than I dont get what I want because some of the values are getting erased.... I want to get a graph for field 1 by field 2 for every index of field 3.. so if for example I have 8 things in field 3 I want to get 8 graphs of field 1 by field 2... I know it is possible but I dont manage to make it... does anyone know how can I do it ?
thank you all very much !
The problem is that your
Y-Axis value must be a
single-valued number or it cannot be charted. This means that you should not be using
list, which creates multi-valued fields. Try using
count, or one of the other number-based functions instead, like this:
... | chart avg(field1) BY field2 field3
field1 is not a
single-valued number, you must convert it to be one first.