19 Replies Latest reply: Jan 29, 2016 4:13 AM by Chanty 4u RSS

    RE:Overall count

    Chanty 4u

      Hi all,

       

       

      What wrng in my expression? in stright table.

       

      Metric: distinc pass&fail for exec testid

       

      and also apply modified date on  condition to view he latest record.

       

      =Count(

      if(

      Aggr

      (

      DISTINCT

      (

      max({<Exec_Status={'Passed','Failed'}>}Exec_ModifiedOn),

       

      lvl_id,Period,Exec_TestID

      )

       

      =Exec_ModifiedOn

      ,Exec_TestID

      ))

      )