Jump to content
We've recently updated our Privacy Statement, available here. ×

% Difference from Mean

Andres Mitchell

Recommended Posts

How to calculate Difference % over the mean of the view I have created.

Avg([NETWT]) THEN ([Value] / First([Value]) OVER (NavigatePeriod([Axis.X],"VARIETY",-2))) - 1

Does Not work.

What I need is if the means of the data selected is 10 and the value of the one individual is 12 I would like to see only a 20% difference.

Or the other thing how can I make a graph that shows me the difference against the higher value in that graph.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...