How do I get a % on two sets of data in bar chart

[#1]

To be honest, I may be blind to the obvious, I tend to miss the obvious, especially as I'm new.

I have spreadsheets for two periods (December and April) of the same data (RateMe) for which I need to make % comparisons:

RateMe is a series of rating scores of one to five.

((Count([RateMe]))/(Count (total [RateMe])))

When I run this expression with Dimensions of Period and RateMe it totals the count for both periods rather than totally for each.

I have also just used

Count([RateMe])

And ticked 'Relative' on the expressions tab and 'Show in Percent' on the number tab, and it has the same effect.

How do I get a % Comparison between the values for these two periods?

Thanks

[tresesco]

Yes proper combination of 'Relative' and 'Show is percent' is the key. Try expression:

=Count([RateMe]) / (Count (total [RateMe]) / 100    ,and check 'Show in Percent %' and uncheck 'Relative'

[SunilChauhan]

num(((If(Month='Apr'((Count([RateMe]))/(Count (total [RateMe]))))-If(Month='Dec'((Count([RateMe]))/(Count (total [RateMe]))))))

/If(Month='Dec'((Count([RateMe]))/(Count (total [RateMe])))),'#.##%')

hope this helps

[#4]

This gives me the same issue I had initially. Sorry.

[#5]

This gives me 'no data to display' and 'error in expression' 😕

[SunilChauhan]

try to solve error .ie somewhere ( missing or extra)

you can check for syntax error.

otherwise you can attached a sample

hope this helps

[jonathandienst]

Hi

If I understand you correctly, then

=Count([RateMe]) / Count (total <Period> [RateMe])

should work. If not, I suggest that you post your qvw document here as the problem may lie in your data structure.

HTH

Jonathan