Skip to Content

Calculating Average for Attribute Value in SAP HANA GRAPHICAL VIEW Ask Question

Feb 25 at 10:23 PM


avatar image
 ColumnA    ColunmnB   ColumnC  ColumnC
     A         10       xyz      Ab
     A         20       def      Ab
     A         5        mno      Xy
     B         10       pqr      Ab
     B         40       abc      Xy
     C         10       uvw      Xy

I need to calculate total average as well as average for each value of ColumnD

Total Average(divided by unique ColumnA):


Now I need Average for Ab=>


Average for Xy=>


I made Calculated Column in Hana:

Counter-> CA_Count on ColumnA(to get unique Count) CA_Avg ->


for Avg of Ab: CA_AVG_Ab :


but this Value is not coming correctly when we use filter in output

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers