AnsweredAssumed Answered

Applying Count/Distinct Count operation on Dimension

Question asked by malav on Nov 14, 2018
Latest reply on Nov 14, 2018 by malav

Hello there,

 

I am having little trouble finding a data operation which can reflect my dimensional values in form of count or lets say numbers,

 

For example, I have two Columns like ,

 

DimensionMeasure
Bldg110
Bldg220
Bldg350
Bldg470

  

 

What i want to get is Total Sum of Measures / Total Count of Dimensions and average it out, 150/4 = 37.5

how can i do this on Board, help requested

 

Note: Dimension is in Entity, Measure is in Cube

 

Thanks & Regards,

Malav

Outcomes