I have water usage records from several months of the year broken down per day and also have a list of active residents who use water per day. I would like to present a trend-line of the data Average data usage per day over the several months.
For this, i understand would need to create a calculated field. Can someone provide help on how i can create the calculated field for display.
Also, how i can i change from Avg to using Median and Mode for display.
Do you have a Tableau Workbook that you can share with some sample data? Also, please let us know the version of Tableau that you are working with unless you don't mind getting back a v10 update of the workbook.