I am using Table Panel to visualize a Prometheus metrics. How to display an aggregated row by summation for a group. I tried different available transformation but was not able to get the intended behavior. It was showing the data returned for all time intervals for that group or I was able to visualize the last data (by using instant). How do you sum up all the data returned in the selected time interval for that group and have single row for each group combination, I have hidden the time column using the Organize transformation.
It sounds like you might want the Group by transformation, which is new in Grafana 7.2.
Thank you @dianapayton, that is exactly what I needed. Looks like it was not available in 7.1.5.