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
CTR is a measure or calculated column?
try with adding Calculate Function.
CTR=Calculate(divide(sum(data[Clicks],sum(data[impresions]))
Regards
Victor Velarde
Sorry you are right! Made a mistake that it should be a measure not calculated column. Thanks!