Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can't figure out how to use the TOTAL function with this formula to give a 100% stacked bar chart
COUNT(DISTINCT {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)
I have a primary time-based dimension called 'Week' and a secondary dimension called 'Type'.
I tried the following formula but it didn't seem to work
COUNT(DISTINCT {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)
/
COUNT(DISTINCT TOTAL {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)
Try:
COUNT(DISTINCT {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)
/
COUNT(DISTINCT TOTAL <Type> {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)
Strange, the percentages seem to be adding up to over 100%