Skip to Content
Jan 05, 2021 at 07:44 PM

Standardize measures from model

58 Views Last edit Jun 22, 2021 at 08:40 AM 2 rev

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?