I am having multiple Docker compose projects of which I collect metrics. I want to see the CPU of the Projects over Time.
That means I need to add the amount of cpu ticks of every document with the same docker.container.labels.com_docker_compose_project and same time and then divide the sum per collected time intervall with the amount of timestamps in one x step.
Example: I collect every 30s metrics, I want to see the metrics of the last 30 days so one step on the x axis is 12h. Now I need to sum the cpu ticks of every compose project and then divide each by 1440 (12h / 30 s).
I could configure the dashboard to always show in 12 hour steps, then I could just divide hard by 1440.
But that would make it hard to show custom intervalls, even harder to change the intervalls in which I collect metrics.
And in case metricbeat is not able to collect all 1440 times in 12h the the result would get wrong.
TL;DR: How to aggregate (sum) in Breakdown and then aggregate the average in vertical axis in Visualization (bar graph).
Thanks for reading my question and Thanks for helping in advance .