Standard Deviation Formula

[jerryr125]

Hi - 

This seems pretty straight forward but it does not seem to work.

I have a numeric field and would like to calculate the standard deviation in a KPI.

Not working:

Field Name : AmountSpent

=StDev([AmountSpent])

Thoughts ? Jerryr

[lorenzoconforti]

What error is it giving you? 

In which object are you trying to calculate it?

Do you have null values?

[jerryr125]

Hi

1.  I am getting an "Invalid Dimension" error.

2. KPI

3. No null values

* Note: I am using the same field for Min, Max and Average KPI - no issues.

[lorenzoconforti]

Strange; try rebuild the aggregation in the KPI object

Something like this:

StDev(aggr(avg(AmountSpent), YourDimension))

replace avg with the aggregation you are performing (if none, just use only()) and YourDimension with the relevant dimension 

[jerryr125]

Hi - I tried this :

=StDev(aggr(avg(), [AmountSpent]))

Again - no luck.

In my data, I have a field 'AmountSpent' in which I would like the Average, Min, Max and Standard Deviation.

There is no null values - only numbers > 0.00

I would like to display this as a KPI 

Any thoughts ? Jerry

[lorenzoconforti]

In your data, do you have a dimension that identifies each observation? Like a transaction id that is unique for each row?

[jerryr125]

yes

ID

I tried this:

=StDev(aggr(avg([AmountSpent]), [ID]))

[lorenzoconforti]

Did it work?

[jerryr125]

hi - sorry - no that did not work

[lorenzoconforti]

Does it still give you invalid dimension? Any chance you can post the application?