5 Replies Latest reply: Jun 8, 2015 9:08 AM by Senthil Kumar RSS

    Sum of Distinct Records

      Hi

      Below is the sample data

        

        

      DateMAR         vTAT
      2015-04-24150424SCBLAU2SAXXX44958660321:13:41
      2015-04-24150424SCBLAU2SBXXX012300400263:41:27
      2015-04-24150424SCBLAU2SAXXX449586603365:52:23
      2015-04-24150424SCBLAU2SBXXX012300400263:41:27
      2015-04-24150424SCBLAU2SBXXX0123004002

      63:41:27

      Need to find the average of vTAT for DISTINCT MAR using Date as Dimension

       

      Average should be around 43:35:50

       

      It should be displayed as a BAR CHART

       

       

      Regards