I have some monthly data, in this case oil production per well. How can I calculate a daily average production rate for the quarter from daily average rate per month? In excel I would do this by taking the sumproduct of rate and days in each of the 3 months, and then divide by total days. I haven't been able to figure out how to do this with Tableau.
1 answer
Hello @Chris Thompson Chris,
hard to tell without any data / workbook.
Any change you could upload a (mocked up) packaged workbook:
https://community.tableau.com/s/packaged-workbooks
Regards,
Rene
