Have tested this in Kibana with all available options.
Result is a visualization of TSVB:
Aggregation: Max of "devices_connected" Group by: Terms by "prometheus.labels.server.keyword" Sum: ... not available?
Results in:
A stacked visualization available showing 3 lines (one per server), but not the sum only.
Expectation:
One line only is visible, showing the sum of all connected deviced on the system.
(similar in case of Gauge usage to show only the sum in the Gauge, not having 3 Gauges, one per server)
//1sec
1
//2sec later
2
//3sec later
6
//4sec later
27
In Kibana there is no way to add a Sum behind the Terms aggregation. Is this right? Should I do something completely different?
Thanks for your hint 8))!, works fine with two remaining limitations:
the Sum Bucket looks not available in TSVB, cant find it 8(
there is no filter available (in my case in addition to Sum Bucket / Terms / Max and now filter for devicetype: "android", means to see the overall sum only for android devices and another visualization that filters than only for lets say devicetype: "iOS"")
You can do this by creating two separate visualizations. If you add a filter while editing the vis, it will be saved along with it and will also be applied if the visualization is put on a dashboard.
SO basically:
New vis
Configure sum bucket
Add android filter
Save and add to dashboard
Create new vis
Configure sum bucket
Add ios filter
Save and add to same dashboard to have both side by side
You can do the same in TSVB, but it's working a little different there - you need to use the "Group by" functionality to split up the series by your terms or filters, then use the "Series agg" with "Sum" on the max of your metric field:
"Series agg" is summing up all series created by "Group by" per time bucket using the specified function - doing essentially the same as the sum bucket, but in a different order
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.