Skip to Content

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

 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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers