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:





      Which should give me something like 0.055 %.


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