I am trying to use Kibana Visualize to do what I normally do with DataDog’s gauges: showing the last known value of a specific variable.
My data looks like this:
What I would like it the Visualize: Metric to do is:
- Read all the available names from the role_name column.
- Display the value in the role_count column.
But I can’t figure out how I might do that. I also tried to do it with the Data Table but I don’t know how either. Specifically it seems that these tools are trying to look for occurances of rows matching those values, but I want to show the values in the fields.
I realize that I probably can build all the queries manually but that won’t work if the role_names are not known beforehand — not to mention that it would be a bit messy.
Any help would be appreciated!
Ok so I managed to get the Data Table to work now:
But I still can’t figure out:
- How to get the Metric to split all rows from the table into its own display.
- How to sort the rows neither alphabetically or by metric. What I in fact need is to sort the rows by the role_hierarchy_index seen from my first screenshot above. (number values which show hiearchy in a list)
If you want to split each row into it's own display you might want to use the "metric" visualization type, which renders each bucket as a single number.
I used it below, and setup a custom sorting aggregation for the terms agg based on the
max of the
@spalger Thanks that’s what I tried to do but I don’t have the option to aggregate Terms in my options.
I see that you have a panel for Buckets, which I don’t have…
Ah, I'm using an unreleased version of Kibana. Looks like that feature when in with https://github.com/elastic/kibana/pull/10336 which will be shipping soon in 5.5
Oh sweet — hopefully soon. This is exactly what I needed. With this new update I can kill datadog completely!
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.