5 Replies Latest reply: Jul 19, 2017 5:05 PM by Cassandra Baqir RSS

    Match and Max Date

    Cassandra Baqir

      I only want to show the row with the most recent start date per DEFECT_ID... in this case 5/3/17 with a total of 77 days.

      7-19-2017 12-35-59 PM.jpg

       

      I need to adjust this dimension to show only the MAX GPQ2_START_DATE when CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0:

       

      =date(if(match(CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0,GPQ2_START_DATE,null()) , 'MM/DD/YYYY')

       

      Can anyone help? TIA!