4 Replies Latest reply on Sep 24, 2018 12:12 AM by Mahfooj Khan

    How to add count of the measures and create a "percentage of" field

    Subhra Sardar

      I have a data set like this:

      Capture_1.JPG

      What I am looking for is this :

      Capture_2.JPG

       

      To create this I have created three calculated fields "Bounced", "Cleared" and Total. These are the counts in each state for different segments (i.e Commercial Vehicle and Two Wheelers).

       

      In my workbook, I am not able to add those count with a 0's and how to create a "Bounce % of Total" field when both are aggregated field

       

      Formulas :

       

      Bounce = IF [Segment] = "COMMERCIAL VEHICLE" AND [Realisation Status] = "BOUNCED" THEN [Number of Records] END

      Cleared = IF [Segment] = "COMMERCIAL VEHICLE" AND [Realisation Status] = "CLEARED" THEN [Number of Records] END

      Total = (SUM([CV_Bounce]) + SUM([Realised_CV]))

      % of bounce = Bounced / Total

       

      I have also attached the .twbx file for reference.

       

      Thank you so much cheers!!