Anand Kote 2 Posted June 18, 2019 Share Posted June 18, 2019 I am trying to limit data calculate average of production between 6 and 11 month of production. IDYearMonthValueDate A2014 1 7 1/1/2014 A2014 2 1 2/1/2014 A2014 3 1 3/1/2014 A2014 4 3 4/1/2014 A2014 5 1 5/1/2014 A2014 6 4 6/1/2014 A2014 7 4 7/1/2014 A2014 8 4 8/1/2014 A2014 9 1 9/1/2014 A2014 10 7 10/1/2014 A2014 11 4 11/1/2014 trying to average values between 6 and 11 month over ID and create bubble chart. What can be the expression that can do it. Thanks Link to comment Share on other sites More sharing options...
Neil Kanungo 2 Posted June 19, 2019 Share Posted June 19, 2019 Hi Anand, Try this: case when ([Month]>=6) and ([Month] Link to comment Share on other sites More sharing options...
Anand Kote 2 Posted June 19, 2019 Author Share Posted June 19, 2019 Thanks Neil!! It worked. Appreciated!! 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