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

    Calculate Minimum of average of each day of the week

    Claude GARTISER

      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