I would like to take the results of this query, namely the values:
3683
3676
3574
3530
3706
3695
3663
3530
3586
3567
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.

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 kubernetes.pod.name

The Table Part in TSVB can be hard why don't you try the Line First...

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

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.