I have the same problem. Suppose I pass my data through stats into the bar/column chart, e.g. :
stats avg(Duration) as AvgDuration by Method
I expected colors to be applied based on each Method that gets charted out, e.g. "Method1", "Method2", but instead it applies just one color for the field (AvgDuration).
Pie charts work as expected, so it seems like a bug/feature of bar & column charts.
I suspect it's a feature (rather than a bug). Unlike pie charts, which work on a single field, bar charts can work on multiple fields. For example if my stats command was:
stats avg(Duration) as AvgDuration, min(Duration) as MinDuration by Method
My bar chart would have an AvgDuration and MinDuration bar for both "Method1" and "Method2", and it aligns the colors along the field names (AvgDuartion and MinDuration) rather than the series names ("Method1", "Method2").
Is there a way to tell the bar chart to color the series names instead of the field names? Or a way to put the bar chart in single-field mode?
... View more