1 Reply Latest reply on Mar 13, 2012 1:04 PM by Tracy Rodgers

    Calculation based on date values

      In Tableau we are applying the Min and Max function to our calculations but it is finding the Min and Max of the raw data which has more than one record per day.  We need to figure out how to group value by the datename dimension before applying the Min or Max function.

      leau we are applying the Min and Max function to our calculations but it is finding the Min and Max of the raw data which has more than one record per day.  We need to figure out how to group value by the datename dimension before applying the Min or Max function.

        • 1. Re: Calculation based on date values
          Tracy Rodgers

          Hi Brandon,

           

          I have reattached your workbook. By using the window_max and window_min functions, the desired value can be achieved. Then, changing how the calculations are computed (by Date Name) will give the desired value. On the graph, it should be computed by cell.

           

          **Note: Date Name will need to be on the level of detail shelf

           

          ***Two separate calculations will need to be created, one for Min and one for Max.

           

          Hope this helps!

           

          -Tracy