Calculating average daily production per operator

[John Brand]

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

[Jose Leviaguirre]

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