Hello, i am a summer intern that has an engineering background but little background in tableau. I am trying to create a production data table but i am having trouble inputting the calculation and query sent to me by our IT guy. I would work with him but hes out of the office and i need help today.

So my instructions are here

Given below query calculates Barrel, CurrentDateLastValue and LastDayLastValue, which we use in our formula to calculate Totals and Running Total, we just change the dates to get CurrentDateLastValue and LastDayLastValue

TodaysAdjustments: Calculated by sum of Volumes and we exclude Reason which is Water removed from tbladjustments Table.

Query is something like this (Dim TodaysAdjustment As Double = Select ifnull(sum(ifnull(Volume,0)),0) from tbladjustments where reason <> 'Water Removed' and date(adjdate) = 2018-06-06 and EquipmentID=?EquipmentID

I hope you were able to get the calculations started that are needed to accomplish the above. I would try to include a packaged workbook with sample data with your post. This can allow for users to better assist with questions.