Hello, I have the following problem: I have responses from a daily survey where each respondent belongs to one of several categories (more than 60), and I want to know what is the response rate for each one of this categories. For reasons I don't understand, the Distributions Table widget ignores all kinds of dashboard filters, so I only have the general response rate.

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.