Solved: Percent of total for distinct values - Page 2

sandsp · 02-24-2021 02:55 AM

Hi all,

I am aware that lot of questions have been asked about % of total but I could not find the specific question I am looking for.

Sample data & explore

Total active email addresses: 50

I have four activities with 25 email addresses undertaking each activity with some email addresses undertaking multiple activities. A simple table calc of value/sum(value) gives me % of the table total whis is 50% each. I am looking for % of total against Total active email addresses.

Is there a way to achive this without making a database change or a derived table? A merged Look could work; I am trying to see if this can be achieved in a single Look.

Much appreciated.

Regards,

Sandeep

Maddie

Hi sandsp,

The Totals available in the Data tab in the explore actually calculates distinct values across all rows, see here for how to use the totals within the explore. This help article explains this behaviour in more detail.

Using the Total + a table calculation which calculates ${count_distinct_email_addresses}/

${count_distinct_email_addresses:total} would give you what you are after.

Let me know how you get on!

Best,

View solution in original post