I created a new column which is a group by and count of each category, so if in a particular day there are 20 rows with category A , 15 with category B, and 30 with category C, then the new column looks like this:
rowNumber cat count
1 A 20
2 A 20
3 B 15
4 C 30
5 A 20
And so on. What I wanted to do is to create a Custom Metric consisting of the sum of all the respondents who finished the survey divided by whatever happens to be the count for that category that day. How do I do this last part? In the divisor I can only specify a Count, Min and Max or aggregate measures like Average. Is there any way to create this metric, be it as a custom metric or calculating it directly inside the widget?
Thanks.
Best answer by KendraR
View original