1 Reply Latest reply on Mar 25, 2016 6:31 PM by Shinichiro Murakami

    Percentage Calculation withing pane

    jitan.chainani

      Hi Guys,

       

      I have  a data set of impressions, likes.... etc  by messages. I want to calculate the percentage rate within each message based on the impressions served. I was thinking to use the formulas to calculate the rate (i.e. engagement/impressions)

      Just wanted to find out if there is an alternative way using tableau functionality and not using any formula to calculate the rate within each message.

       

      Any suggestions would be helpful.

       

      Thanks,

      JC

        • 1. Re: Percentage Calculation withing pane
          Shinichiro Murakami

          Jitan,

           

          According to your data structure, to calculate % of Engagement / Impression should be

          sum([Engagements])/sum([Impressions]).

           

          All these fields are individual measure field, then each score need to be calculated as

          sum([Engagements])/sum([Impressions])

          sum([Likes])/sum([Impressions])

          sum([Retweets])/sum([Impressions])

           

          Don't use [Engagements]/[Impressions] because 10% of 20 line items becomes 200% in this case.

           

          Thanks,

          Shin