I have a table like
Table1:
Rec_ID, KEY
1, A
1,B
1,C
1,D
1,E
I have another table where we have entries like
TABLE2:
KEY ,VAL(%), TYPE
A, 80, 1
B,60,1
C,20,2
D,0,0
I am able to show the result in pivot table for TYPE 1 as
KEY ,VAL(%)
A ,80
B,60
C,100
D,100
E,100
AVG: 88
Here in TABLE 2 i have value for only A and B for type 1 and since there is no data for C,D and E in table 2 we have to consider 100 as default value and then show the average of all the percentages in the bottom. so basically i have to take the average of all the KEYs in table 1 and calculate. if KEY is available then take the value otherwise consider as 100 and calculate the average
Now the same average value of percentages i need to calculate in gauge chart . So need help with expressions
