Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a bar chart that shows recommendataions 1 and 2 out of a possible 1 through 5, by gender, so there are two dimensions (gender and rating). Now I need to normalize the values..
This expression gives the count: If(Recommend<=2,Count(Recommend)) and this is the normalization: If(Recommend<=2,Count({1}Recommend))
Both expressions give correct values if they are charted independently, but if I combine them on a single chart to do the normalization, they do not: If(Recommend<=2,(Count(Recommend)/Count({1}Recommend))*100)
Any suggestions? Thanks, Tom
I've figured out the problem but not the solution. Let's say you have:
10 out of 100 recommendations are 1 or 2, by males, which is 10%
15 out 100 recommendations are 1 or 2, by females, which is 15%
The formulas above calculate the total by adding 10% and 15% for 25%. I really want 25 out of 200 for a total, which is 12.5%
Hi,
can you post an example? Might be a bit easier to look at.
/Peter
Example posted, with brief description embedded.
Is the attached what you're looking for?