how to make a chart of one field according to another one sort by a third one ?

[arbelron3]

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 !

[arbelron3]

it worked ! thank you very much

[ppablo]

Hi @arbelron3

Which answer worked? Click Accept below the answer that solved your question please so we know and to resolve the post!

[woodcock]

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 avg, sum, count, or one of the other number-based functions instead, like this:

... | chart avg(field1) BY field2 field3

Obviously, if field1 is not a single-valued number, you must convert it to be one first.

[diogofgm]

Have you tried to use something like

| chart field1 over field2 by field3