1 of 1 people found this helpful
It would be helpful if you included a packaged workbook.
Thanks for your response.
I have created a dummy excel data and dummy Tableau sheet.
Tableau file contains 3 worksheets - one for each region UK, US and Russia. "2013 Revenues", "2014 Revenues" and "2015 Revenues" are calculated fields.
It has total revenue for 3 different years. Now, I want to calculate Average Daily Revenue for each of the three years (for each region).
Avg, Daily Revenue = Total Revenue for a period / Total Working Days in the same period.
Numerator would be dependent on the region (US/UK/Russia), but denominator would be total working days in US in a period
Hence, denominator is independent of region.
Excel has a column named "Working Day" which is computed based on "Weekday", "Price" & "Revenue" (For a non working day, both price and revenue would be 0).
Sorry, I do not have access to Tableau at the moment. Knowing how fast and awesome this community is to respond to questions, I am sure someone will jump in to assist. Just in case nobody does, then I will take a look tomorrow.
No Problem Pooja. Thought of asking you as you had helped me few days back.
I have attached updated tableau file. Created some calculated fields for trading days calculation.
As you can see Trading Days and Avg Daily Revenue for UK and Russia is blank/zero because of region filter. So I want denominator to be independent of region.
This is because as per the business rules only US working days should be used to calculated average daily revenue for all regions.
dummy2.twbx 148.4 KB