1 Reply Latest reply on Oct 20, 2016 10:48 AM by David Li

Calculate Minimum of average of each day of the week

Hi,

my data is composed of a DATE and a VALUE (int)

I'd like to create a graph with the following information :

The minimum of the average of each day of each week

It's something like the following : Min(Avg(Monday1), Avg(Monday2), ...)

Let me give you an example :

DATE         |   WEEKDAY(DATE) |  VALUE

Monday 1   | MONDAY |  1

Monday 1   | MONDAY |  2

Monday 1   | MONDAY |  3

Monday 2   | MONDAY |  2

Monday 2   | MONDAY |  3

Monday 2   | MONDAY |  4

Thuesday 1 | THUESDAY |  ....

I want for each day  : MinOfDailyAvg(MONDAY) =  Min(Avg(1,2,3),Avg(2,3,4)) = Min(2,3) = 2

Which is different of Min(VALUE) = 1

How can I get this information ?

Thanks

• 1. Re: Calculate Minimum of average of each day of the week

Hi Claude, you can do this easily by using a LOD calculation, as long as you're in Tableau 9 or newer.

MIN({ FIXED [Date] : AVG([Value]) })

Set up your sheet so that it has a row, column, etc for each week and then use this calculation. You'll get the minimum daily average for each week, as you wanted.