Hi!
I would like to draw a chart with stacked bars , but I don't know how to add columns depend on result. for example, I first search and get the result as:
fieldA fieldB
A 1
B 2
C 3
D 4
But for drawing the chart, I need a result table like this, fields named by the result I got :
fieldA A B C D
dummy 1 2 3 4
The result might not be ABCD only. How could I do something like this? Thanks
Problem has been solved now, I've found a search command called "xyseries". I search as:
search ... | xyseries fieldA fieldB fieldB | addcoltotals labelfield=fieldA label="dummy" | where fieldA="dummy"
Problem has been solved now, I've found a search command called "xyseries". I search as:
search ... | xyseries fieldA fieldB fieldB | addcoltotals labelfield=fieldA label="dummy" | where fieldA="dummy"
Hi @millie be sure to accept your answer so other users know it's correct when searching for similar issues 🙂