Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying calculate Standard deviation for an aggregated value, which is throwing an error saying "nested aggregation" is not possible. Does anyone have any solution regarding the same.
Thanks,
@Itsmeakshata We appreciate if you can share the expression and screenshot to work with.
you need to wrap your expression AGGR() on the chart dimensions as below
= stdev(
AGGR( YourExpression , ChartDimension1, ChartDimension1 )
)
Try this
Stdev( AGGR( Sum(Sales), Year ) )