I'm looking to create a grouped bar chart from data in the following format:
---- ID Results
1: AAA, B321
2: AAA, A918
3: AAA, C391
4: BBB, A918
5: BBB, C391
6: CCC, B321
7: CCC, A918
Essentially I would like to easily visualize which ID has the same results. My idea is to have a bar chart with the IDs listed along the 'X' and then above each ID a 1 unit stacked colour bar representing a result.
If I run a search for:
Results=* | chart Values(Result) by ID
I get the table shown below but the graph view is just axis.
ID ---------Results
AAA---------B321, A918, C391
BBB---------A918, C391
CCC---------B321, A918,
... View more