Sum of last complete Bucket as a single metric

[smueller]

hi,
im looking for a way to display the sum of all values from the last complete bucket of a timeseries.
the idea is to display the current sum of all memory ,cores ,requests,disk space, etc. used for a server farm in a table visualisation, to get a overview for a drilldown.
.
for a tsvb graph, you set 'drop last bucket' and display the series sum of 'max used heap' per agent.hostname:

and you get the number in the legend.
how can i get this number in a 'markdown' or 'table' display? (markdown is problematic as it only allows you to gather 2 metrics )

[Marta_Bondyra]

If you know the bucket size (for example, a day, or 30m), would it be ok for you to use Lens in 8.5 (it will be released in 1-2 weeks?

You could use metric or datatable visualization and formula:

[Marta_Bondyra]

And for tsvb you can use math to calculate your value not inside markdown but before:

[smueller]

Hi Thanks for the response. But i think there are some misunderstandings here.
i don't want to add hdd space and ram.
I'm trying to get the number indicated in the screenshot in a view that allows me to display lots of these values

which is the sum of heap used by all servers from the last complete bucket. (i want to repeat that for other metrics aswell).
tsvb has the neat trick of "dropping the last bucket" so you don't see incomplete results(a otherwise the graph would always drop towards the end.)
but since i don't know the bucket size, i don't see any other solution than this one here:

and setting tsvb panel options to "last value" and 'drop last bucket'

edit: i just noticed, that in tsvb markdown you can select many metrics, not just two like in the "timeseries"or "metric" display, so i think, i got what i wanted

or is there any other way to get the 'last full bucket for all hosts and one metric' in other visualisations (maybe vega)?
best regards