12 Replies Latest reply on Oct 17, 2018 4:38 AM by Tushar More

    issue min, max of date ->results are wrong

    Patrick Weber

      Hi everyone.

       

      I'm trying to create a view like in this table below.

      But I don't know how to splitt min and max to get just one row of information.

       

       

      Product
      Month
      Amount_max
      Date_max
      Amount_min
      Date_min
      ABCOctober3811.10.2018 14:574602.10.2018 11:49

       

      I'm struggling in Tableau with min and max function because e.g. if I use max(Date) and max(Amount) then these results

      doesn't match. Because on one hand the latest date is shown but the information of the amount column is wrong

      if you are using max(Amount) too.

      I only need the newest entry and the oldest one per month.

      16-10-_2018_12-12-23.png

       

      In my example workbook there is just one month and one product. In the real system there are several hundreds of products.

       

      Thanks for any advice.