Hi there!
Somebody please helps me with the issue that I've been confused for days...
Here I got dimensions in both column and row: ( Here row means hour; Column means date)
What I want to do is to calculate the average and summation of each row, and show them in two new columns. (sum by the same hour from different days)
Here I used the Subtotal function to calculate, but when I add another subtotal to the sheet and change its calculation way into average, the former one will be changed, too.
Could you please help me that Is there any method to show them at the same time?
Here is the raw data from the database:
And I can't just sum them up in the database, because we need to calculate by the date interval that the user selects in Tableau.
Hi, Serral
I noticed that you are using parameter to control the date range, probalby you can use your date filter in the calculation so that you don't have to union your data.
Below is the screenshot of how it works by 3 calcualtion fields
A sample workbook based on super store data attached for your reference.
Hope this helps
ZZ
