I have some sales data, and I want to calculate the average sales for a day of the week (over a month) and over a year.
For instance average sales Monday for July and Compare the average sales on Monday over a year.
I have created multiple data connections to the same sales data.
In two separate worksheets I can calculate the average sales on Monday, for July and the average sales on Monday for the whole year
As soon as I try to combine the data into a single worksheet - the date for my calculations are either monthly or yearly, when I need separate calculations for month/year.
You will need to use Table Calculations to get the desired figures on a single worksheet.
I am not too clear on the format you require for this but have attached an example table calculation in a cross tab comparing daily averages at month and year levels.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...