How to get the cumulative/total resource usage of resources say RAM or CPU over a selected duration of time

[touseefspeaks]

Hi, I want to calculate the total consumption of memory/cpu usage (with underlying kubernetes infrastructure) monotonously over a period of time(lets say 3 months).

I tried query like
sum(container_memory_usage_bytes{namespace=~“$namespace”,pod=~“$pod”})/1024/1024/1024

I also tried to use the increase() and sum_over_time() functions to get the cumulative sum of the total resource consumed.
However it doesn’t give me the cumulatively total usage over a selected duration time.It just gives me sum at that time instant.So the graph obtained goes up and down based on usage at that time instant.

Any suggestion for the alternative function/formulla to achieve a sum total usage of resource over a selected time would be appreciated.

Thanks!

[mattabrams]

Hi @touseefspeaks

Try using a different panel like the Stat panel and using the panel editor configs to return the Total calculation value: