Sum of rows on a table

[paxistas]

So i have this simple query to extract the total sum of transaction duration:

When i use the Table visualization, i get 2 fields as expected:

Now i would like to get a 3rd column with a single row that would show the total amount of all the transaction durations.

I tried to add a field called “Total” via “Transform data” thing, but it displays the same value in each row as the “Sum” field:

I know this is because of “Group By” row in the original query, but in grafana it is not possible to remove this row, so i am forced to use it.

So how do i get a single value from all the rows then?

[yosiasz]

here you go

[paxistas]

great, but how do i reference to this Total value if i want to calculate the percentage of each separate transaction’s duration?

Here is the snippet of the table and the query for reference:

Three transactions are visible under “transaction.name” column and their appropriate total transaction duration value in seconds under the “Sum” column.

In addition to “Sum” i need a 3rd column “Percentage”, which would derive its value for each individual row by using formula:

Sum * 100 / Total

Is this possible?

[yosiasz]

please open a new thread for that question.