Forum Discussion
Solved
Divide one column by another split by distinct column
This seems simple but I can't seem to get it right. 1. I have data with columns Channels, Clicks and Impressions. 2. I want to calculate the Click-Thru-Rate (CTR) by Channels i.e. CTR = Click...
CTR is a measure or calculated column?
try with adding Calculate Function.
CTR=Calculate(divide(sum(data[Clicks],sum(data[impresions]))
Regards
Victor Velarde
Looks right to me. Double check everything to make sure the formulas are right etc
- Thanks Matt. Yes which is why I couldn't quite figure this out. Double checked and all looked good. Still have a wrong output.
Sorry realise I need to provide more context.
Here is a smaller subset of the data and I will want to calculate the Click-Thru-Rate (CTR) (i.e. CTR = Clicks / Impressions)
However, I cannot get the formula of CTR at the total correct either through this method:
Or this method:
Any reason why this happens?
CTR is a measure or calculated column?
try with adding Calculate Function.
CTR=Calculate(divide(sum(data[Clicks],sum(data[impresions]))
Regards
Victor Velarde
