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:

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

thanks!!!!!

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