1 Reply Latest reply on Dec 6, 2016 5:13 AM by Maciek La

    Average across dimensions

    Koushik Racharla

      Hi Guys,

       

      I have 3 dimensions and each of them having similar values I just need the total average of all of them ( total yes % (across A,B,C) and total no %(across A,B,C)) can any one help me ?

        • 1. Re: Average across dimensions
          Maciek La

          how about

           

          Updated

          create calculated fields:

          yesCountA:

          sum(if [A] = "Yes" then 1 end)

           

          yesCountB:

          sum(if [B] = "Yes" then 1 end)

           

           

          yesCountC:

          sum(if [C] = "Yes" then 1 end)

           

          YesShare:

          (yesCountA + yesCountB + yesCountC) / (count[A] + count[B] + count[C])

           

          NoShare:

          ((count[a] - yesCountA) + (count[b] - yesCountB) + (count([c] - yesCountC) )/ (count[A] + count[B] + count[C])