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
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.