-
1. Re: Percent of total from value in Dimension
minh.nguyen.3 Jan 28, 2016 10:29 AM (in response to minh.nguyen.3)I have a table that combines a running count of total web sessions, total purchases and total active users per day. I want to create a dashboard or report that tracks what % of active users have a web session/purchase per day.
-
2. Re: Percent of total from value in Dimension
pooja.gandhi Jan 28, 2016 11:32 AM (in response to minh.nguyen.3)If it is percent of total active users by day, shouldn't web session be 50/90 and purchase be 40/90 for 1/2/2016 because there are 90 active users on that day?
If my assumption is right then you can create a LOD expression to capture the count of active users at the level of day and then divide sum(count) by this new calc:
Active Users: {fixed [Date] : sum( IF [User Attribute] = 'Active' then [Count] end) }
Percentage: sum([Count]) / sum([Active Users])
User attribute on rows, date on columns , user attribute in filter and exclude 'active' and percentage on text:
-
3. Re: Percent of total from value in Dimension
minh.nguyen.3 Jan 28, 2016 3:09 PM (in response to pooja.gandhi)Hi Pooja,
This seems to be the closest answer! I'm running into an error when I try to create the Active Users expression - Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expression.
Thanks,
Minh
-
4. Re: Percent of total from value in Dimension
pooja.gandhi Jan 28, 2016 3:21 PM (in response to minh.nguyen.3)Minh,
Are you using the expression I suggested? Is the count field already aggregated? Can you share some screenshots and/or your data? That would help me help you faster and more effectively!
Thanks,
Pooja
-
5. Re: Percent of total from value in Dimension
minh.nguyen.3 Jan 28, 2016 4:14 PM (in response to pooja.gandhi)Followed it exactly and it worked - THANK YOU!
-
6. Re: Percent of total from value in Dimension
Giacomo Vannucchi Nov 23, 2018 7:26 AM (in response to minh.nguyen.3)thanks!!!!!
-
7. Re: Percent of total from value in Dimension
Dustin Guiyab Nov 26, 2018 1:23 AM (in response to minh.nguyen.3)Hi Minh,
Could you share the Active Users Formula? I am getting the "cannot mix aggregates and non-aggregates error comparisons in IF expresssions?
Thank you!
Dustin