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
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