Andres Mitchell Posted June 28, 2019 Share Posted June 28, 2019 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now