I am trying to plot a 4 column chart, say 'A, B, C, D', where each column value is actually a single value series (so that we can color code each column consistently).
I have set 4 pre-defined column labels, and can generally pass the data to them and have it plotted so that each column aligns to the label.
However, the search that generates the data may not always return any series data for some of the columns - for example:-
Col ColA ColB ColC ColD
B 0 6 0 0
D 0 0 0 3
In this example the chart columns start trying to reformat the column widths - especially, as in the example above, if there is a 'gap' between two populated columns.
I've tried every combination of "useAbsoluteSpacing" etc I can think of and cannot seem to get consistent plotting. From what I can think, I may have two options to try and get this to work:-
- Is there a way to force a column chart to plot consistently even if there is no series data for some of the expected columns
- Is there a way to create 'null\empty' column fields in my
search, and if so would passing
this populated with zeros force
the consistent format.
E.g if the following search returns the results shown above, can I 'fake' results for A and C
... | chart
count(eval(match(Metric,"A"))) AS "ColA",
count(eval(match(Metric,"B"))) AS "ColB",
count(eval(match(Metric,"C"))) AS "ColC",
count(eval(match(Metric,"D"))) AS "ColD"