cancel
Showing results for 
Search instead for 
Did you mean: 

Classifying Ordinal Data in SAP Analytics Cloud

Former Member
0 Kudos

Hi,

I am currently new and working on learning SAP Analytics Cloud for dashboarding. I am however having trouble understanding measured data and how you can classify the data as norminal, ordinal or interval.

What has happened is that my data is summing the oridnal data within a hierarchy instead of averaging it. So lets say that I have ordinal data for a variety of cities in Louisiana (state), where 1 means low risk and 5 means high risk. When I create a hierarchy and I zoom out from cities to state level, the data is summed instead of averaged. I would like to have an overall risk value of the state and not a summation of all risk values for each city.


All help would be appreciated!

Accepted Solutions (0)

Answers (1)

Answers (1)

JohnL
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Madelief,

Welcome!

You probably need to apply an Exception Aggregation to your Risk Level measure and Choose the city/state (location) dimension in the Exception Aggregation Dimension field.

See https://www.sapanalytics.cloud/resources-applying-aggregation/

HTH