John Brand Posted April 6, 2022 Share Posted April 6, 2022 I have monthly gas/oil production data. I want to make a line chart showing average production per day by operator over each year. Haven't been able to figure out the expression for it yet. The chart would look something like this Link to comment Share on other sites More sharing options...
Jose Leviaguirre Posted April 7, 2022 Share Posted April 7, 2022 Hello jbrand, I can't see the image chart you uploaded. Please make sure you use the image button or the use the attachment upload button because pasting images is not always reliable. A data set will also help. On a table you can always calculate daily production average per per operator per year like this: Avg([production]) over ([day],[operator],[year]) year, operator, day, production 2020,a,1,10 2020,a,1,15 2020,a,2,20 2020,a,2,25 2020,a,2,30 2020,a,3,30 2020,b,1,10 2020,b,1,15 2020,b,2,20 2020,b,2,20 2020,b,3,30 2021,a,1,10 2021,a,1,20 2021,a,2,20 2021,a,2,25 2021,a,3,30 2021,a,4,40 2021,b,1,10 2021,b,2,20 2021,b,4,40 2021,b,5,50 Note: If uploading image does not work, try pasteboard.co and replace the generated code with this one: https://gcdnb.pbrd.co/images/ONjxjaDqGLyK.pngo=1 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