1 Reply Latest reply on Apr 1, 2016 6:38 AM by Takaaki Koseki

    Help with Calculated field for Ratio using Dimension

    Raj Kumar

      Hello,

       

      I have three dimensions in my data source which are Date, Status and Task ID. There are thousands of Task IDs which are in one of the Closed, New or Re-Open statuses. Now I am trying to create a calculated field called Close Ratio, the formula for this is:

       

      Number of Task IDs in Closed Status/(Number of Task IDs in New Status + Number of Task IDs in Re-Open Status)

       

      I tried creating some calculated fields but nothing are fetching required results. Some of them are:

      1.

      Closed Claims:

      If ATTR([Status]) = "Closed" then COUNT([Task ID])

      END

      Created two more calculated fields for New and Re-Open statuses and created one more calculated field, which is defined as ([Closed Claims])/(([New Claims]) + ([Re-Open Claims]))

       

      2.

      Closed Claims:

      If [Status] = "Closed" then 1 else o

      END

      Created two more calculated fields for New and Re-Open statuses and created one more calculated field, which is defined as ([Closed Claims])/(([New Claims]) + ([Re-Open Claims]))

      Dragged this calculated field to columns shelf and dragged Task ID dimension to measures shelf, but of no use.

       

      Need  help with this.

       

      Best

      Raj