grafana / piechart-panel

Pie Chart Panel Plugin
MIT License
151 stars 101 forks source link

Extra column with difference/subtract aggregation in Boom Table or Table panel #195

Open SwathiMuppalla opened 5 years ago

SwathiMuppalla commented 5 years ago

Grafana: 6.2.5 Elastic search @yesoreyeram @marefr @torkel @daniellee @coolshiva123 Hope you are doing good, I have been using table plugin in grafana, and lately found boom table plugin which is very helpful. Does “BoomTable” plugin support Elasticsearch? I have a situation where i have a template variable “Version” with data V1, V2, V3 …etc. for every version there is lots of data and i am querying to get total count of every versions data eg: V1 Total V2 Total A 10 A 20 B 20 B 15 C 30 C 25 Since I am having template variable “Version” If i try combining two versions i get V1,V2 | Total A | 30 B | 35 C | 55

But I am trying to create another column in boom table or table panel to subtract the values which i am not able to create. I need it like this V1,V2 | Total | Difference A | 30 | 10 B | 35 | 5 C | 55 | 5 Screenshot (46)

I need Difference column which gives value of (server1 - server3) How do i do this? Can I do this in Table panel?