Hello. We have tabular data formatted like this:
"CollectionName" "CollectionSize" "PercentageUsed"
"FOO" "36" "50"
"BAR" "14" "36"
(The first row is the column headers, translated into field names.)
We are trying to create a dashboard containing pie charts like this:
For each CollectionName, create a pie chart labeled with "CollectionName" that contains the value of field "CollectionSize."
Within that pie chart, we want a wedge for the "PercentageUsed" field. So if "PercentageUsed" field is "50" (%) of CollectionSize, it would split the pie chart in half. If it's "20" (%) of CollectionSize then the pie chart would have a wedge that is 20% of the chart's size. We'll eventually want to be able to click on that wedge to drill down, but we'll tackle that later.
We'd like the dashboard to show a pie chart for each CollectionName. I think I'm close. I can get it to create a single pie chart for one CollectionName.
index=foo sourcetype="foo-usage" CollectionName=FOO | stats count by CollectionSize,PercentageUsed | transpose
That will show a single pie chart for the CollectionName "FOO." How do we get a pie chart for each CollectionName on the dashboard?
Thanks!
Update: I am able to get pie charts for each CollectionName with the PercentageUsed on top:
index=vdiclinics sourcetype="vdi-usage" | stats count by PercentageUsed,CollectionName
and using Trellis (finally got that to work). That's okay, but I'd like PercentageUsed to be a wedge, not a label. Here's what I have right now for one Collection:
How can I accomplish this? Thank you!
... View more