How to calculate Sum of values present in Table in KPI

Hi All,

I am working on a requirement where we have calculated some values of Prod/QA/Training in different steps. We have to calculate Overall Average by adding all the values of QA and Prod .
For example in the given example 5+7+2+1+4=19

I am able to achieve this using windows function but we need this in KPI chart which is throwing Table calculation error which I use the same formula.

can anyone please help in calculating this.


Its look simple prod time + QA = new column.
finally get the total of new column. It will be 19.

5 + 0 = 5
7 + 1 = 8
0 + 4 = 4
2 + 0 = 2
total 19

Naveed Ali

Correct Naveed!
But we have to show this 19 into KPI Chart (not in table)


are you not able to use the calculated field as per @Naveed suggestion and then use that calculated field for KPI visual.

Let us know if that works for your use case.


@Naveed has just reiterated the problem statement. Unfortunately , that’s not the solution.

Take the newly created column: Prod Time + qa and put that in the KPI.

Are Prod Time & QA regular fields in your dataset (not calculated fields)?

Replace my field with the newly created field.