I would like to take the results of this query, namely the values:
Sum them together, which would give: 36210, and display them in a table. I can't seem to figure out the table piece. I have tried just doing a straight sum of
kubernetes.pod.cpu.usage.nanocores but that gives a different result, as
kubernetes.pod.cpu.usage.nanocores is not an average, it's just a point-in-time value. I need to get a sum of a set of accumulated averages. The table I have looks like this:
I have also tried to just take the average, but then I need to multiply that by the number of pods. I can't seem to find a metric for that which works.
I am using Kibana 7.17.7
February 1, 2023, 2:56am
Which Exact VIZ is that...
You have to do what is known as a Series Agg - SUM
Under that first Average AGG and another Agg
Series Agg of type Sum of the Average above
That says Sum the Values for the Series and in this case the Series is the Value for Each Pod... for each Time Bucket i,e. add the values in each bucket to get a sum for each time bucket
Leave still the group by term
The Table Part in TSVB can be hard why don't you try the Line First...
Thanks for your reply! It's the Table of of the same visual:
I tried Overall Sum (there is no option for Sum to aggregate the previous collection). It still just shows the average:
I think because there is only now a single value to sum up. The individual buckets have been accumulated into a single value.
I can't use Series Agg:
February 2, 2023, 4:16pm
So the non-table version would look like this, Yeah done think TSVB table is going to work...
I think Lens Might, but I don't have a 7.17. to test with
And here is just a metric that could be over the whole time frame or the last bucket
February 13, 2023, 1:40pm
Thanks for your help
@stephenb That explains it. Lens will work but there is no option to do the manipulations I need using a Bucket Script.
@eeijlar that bucket script seems quite easy to be translated into a Lens formula.
February 17, 2023, 6:28pm
That one is straightforward but I have another one that I am not sure if I can do in Lens. I will look into it further. Thanks
March 17, 2023, 6:28pm
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.