Grouping values in bar chart when using inline search

[MatMeredith]

Using the search app I can run a search like this:

| chart avg(callcount) by sp_day sp

which gives me a bar chart where
- there is a bar for each combination of sp_day / sp
- bars are colored according to the value of sp

When I try to code this in my dashboard xml I have to drop the "| chart ..." from the end of the search term and then all the bars are always just drawn in the same color. How can I reproduce the behaviour from the search app on my dashboard?

[richgalloway]

I assume you have a HiddenChartFormatter stanza somewhere in your xml. If so, try adding a statement like this to it:

<param name="charting.fieldColors">{"Value1":0x00FF00,"Value2":0xFF0000,"Value3":0xFF0000}</param>