5 Replies Latest reply on Aug 20, 2018 6:24 PM by Ali raza

    Calculating Percentage from Total

    Ali raza

      Hi Guys I am very new to tableau. I cannot seem to a find a solution for a problem I am currently facing. Following is a dashboard  I built:

       

      Screenshot 2018-08-19 15.54.06.png

       

       

      I am trying to calculate the clickrate of total like this:

       

      Screenshot 2018-08-19 16.02.04.png

       

      But it gives me a very strange value.

       

      All I need is to Divide the number of clicks of a certain ad for that week with the total no. of impressions for that week.

       

      For example for the first ad I would do:

       

      11/19911*100

       

       

      Which should give me something like 0.055 %.

       

      Please advise on how to achieve this. I will be very thankful.

       

      Best