I wanted to calculate % of active user using the following beast mode, but soemhow it only gives 100%. I could not figure out what went wrong.
In this exmaple, %of active user should be 2215/(2215+3273) , but it shows 100%.
This is my beast mode:
COUNT(DISTINCT case when `useractivity_status` = 'Active User' then `usersid` end)/COUNT(DISTINCT `usersid`)
Thank you.
Olivia