2 views
in BI

Using Tableau 8.1.
Daily data like this:

Date     Sales

1-1-14     \$5

1-2-14     \$2

...

6-15-14    \$15

Which can be aggregated to weeks of course

Week 1   \$15

Week 2   \$12

Week 3   \$10

Week 4   \$13

etc.

I would like to get the weekly average of each month

So like this:

Weekly Average

Month 1     (weekly average of the weekly total sales)  (\$15+\$12+\$10+13)/4 = 12.5

Month 2

Month 3

Does that make sense? If you simply put "average" in the tableau table, it gives the average daily value PER WEEK (or month) < - I don't want that. I want the average of the weekly totals per month.

by (47.2k points)
• You have to create these calculations

Unique Weeks = COUNTD(DATEPART('week',[Date])) Weekly Average = sum([Sales])/[Unique Weeks]

• And then, you can simply report Weekly Average x Month (or Quarter or Year, etc.)

(Note: Some weeks have < 7 days).

Further, enroll for an online training course to clear the Tableau Desktop Specialist Certification exam. I would recommend this Tableau Training online by Intellipaat.