Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 10 values in Spray field as shown in the figure. I want to find the StDev total of Panel Side = Top side regardless of Axis. In Excel, I would drag the mouse from Spart1 of Axis 1 to Spray1 and then spray10.
What should I do?
It depends on your data structure, and whether you want the result as a standalone KPI or as part of a table.
You say you have 10 values in the spray field, so I assume the data structure is something like this:
In this case, if you want a KPI showing stdev for all Top side values, something like this should work:
if([Panel side]='Top side',stdev(Value))
I want to find all values of Spray 1-10 ignoring Axis.
This is a formula in Excel.