Hi,
I have been struggling with calculating the percentage of cumulative users that belong to a particular group by the total cumulative unique users available.
In addition, I need to display a time series of the cumulative percentage broken out into multiple sub groups whose numerator varies but denominator should be the same (cumulative of the total available users).
Till now I have been able to display the time series of cumulative users for the group broken out into multiple sub groups. However, I am unable to use the cumulative of total available unique users correctly (across all events) as a fixed denominator and calculate the percentage.
I have attached a workbook (v 10.2.2) with sample data highlighting the issue. The workbook has two sheets
1. Cumulative Users & Percentage
- Contains group and subgroup level cumulative user counts for group1, cumulative percentages for group1 and total cumulative unique users
- The total unique users calculation is not working correctly
2. Total Cumulative Users
- Shows the correct calculation of total cumulative unique users
I would like to be able to use the total values on "Total Cumulative Users" sheet in the "Cumulative Users & Percentage" sheet so that I can calculate the % correctly.
Am I missing something ? Anyone have any suggestions ?
Regards,
Raghav
Hello Raghav, You could duplicate the data source, connect them both on [Date] and then use the Cumulative Unique Users ID for All Users from the second data source.
I hope that helps.
Patrick
