0 Replies Latest reply on Aug 9, 2013 11:51 AM by Kum Tham

    excel array manipulation

    Kum Tham

      First time I am posting into this forum, hope you can bear with me.

      I am wondering if tableau has the capability to do similar type of excel calculation based on the table below.  The "latest run ID" column is calculated using the excel formula: {=MAX(($A$2:$A$11=A2)*($B$2:$B$11))}.

      The objective is to identify the latest (or largest number) "run id" for each "instance ID" that may have duplicates. (eg. in the case of test instance ID "111" there are a total of 3 records with corresponding "run id" (1,2,5).  Since 5 is the largest number, the records will be tag with 5 under the "latest Run ID" column).

       

      Instance ID

      Run IDLatest Run ID
      11115
      11125
      11337
      11444
      11155
      11768
      11377
      11788
      11899
      1191010