That does not work when I have multiple discoveries, but I do not want the calculation for Browse, only the downloaded where Browse is the total by Discovery.
Type Discovery Name Users % of Total
Browse Bed 200 100
Downloaded Bed 100 50%
Browse Yoga 500 100%
Downloaded Yoga 400 80%
I think we are on the right track....
Please attach your data and your expected results.
My data comes from a blended source from Alteryx.
We expect the Browse type to the source and should always say 100%.
Downloaded should be a % of the browse total by the Discovery name (bed and Yoga).
Browse does not need a label or should be 100%.
See example data set.
Is it also better to create a calculation of the number of users who did not download to provide a better picture?
Example data set.xlsx 270.8 KB