Standardize measures from model

[former_member722018]

I'm trying to standardize several measures which has been added to a model from a CSV file and which I will visualize using charts. For this, I have created a story that uses that model and, in the "Builder" section of my charts, I have created the following calculations for each measure:

1. Measure Mean: using an "Average" aggregation with a date dimension
2. Measure Standard Deviation: using a "Standard Deviation" aggregation with a date dimension
3. Measure Standardized: using the following formula (["Model":Measure]-[#Measure Mean])/[#Measure Standard Deviation]

The problem is that, has I have verified, the field ["Model":Measure] does not return the value for each data entry as I expected, and it instead returns the sum of all the data entries which are on the date granularity specified on my charts.

How can I achieve to get the standarized value of each of my data entries for one of my measures as I am trying to do?

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're new in asking questions here, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question.

Should you wish, you can revise your question now by selecting Actions, then Edit.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards

Mariah

SAP Community moderator