Waffle Chart Percentages seem to be incorrect

[debbieedwards]

I wanted to change a Pie chart into a waffle chart but the percentages are different.

In my pie chart I have Values: Hours, Category: Data Number of Employees Group

Less than 10 Employees 59.43%

No Employees 22.1%

10 to 50 Employees 14.38%

NULL 2.16%

50 to 100 employees 1.74%

But the Waffle chart shows

Less than 10 Employees 100%

No Employees 37%

10 to 50 Employees 24%

NULL 4%

50 to 100 employees 3%

Over 100 Employees 0%

Why is the percentages different between the pie and waffle chart? I know my less that 10 employees make nearly 60% of the data, not 100. Can anyone help me understand whats going on here?

Ive now tried it foe a few things and the values are different to the pie chart (Which is correct) every time

For example I created a new one for positive negative and Neutral feedback.
Positive Negative Neutral
Pie 43.38 17.39 39.13
Waffle 20 8 18
What appears to be happening is the report is showing the number of rather than the percentage of but its still showing % against the numbers when its not a percentage.

[kiewic]

The largest value is taken as 100%, use the Max Value bucket and set a 100 constant in there so the values are calculated as a percentage of 100. Or set the Max Value as the count of companies.

This is because a waffle chart can be used to represent multiple values that do not necessarily add up to 100. Think of it more like a Multi Row Card.

[xxmysteryangel5xx]

this is probably a silly question but how do I change the constraint to 100? I used to use this visual often and I am applying the same steps but it isnt working how I had hoped. if I drop a value in by using a measure(but have also tried using a field) it shows the correct value but then the category is (blank) and as soon as I put a category in, I get 100% then the other one (in this instance) is correct at 45%.

I have tried to drag and drop the count on the max values but this doesnt seem to work. Am I missing something? or has something changed? I tried changing my visual as a mutli-row just to check the explanation like you have above and that seems to work fine. I hope I am making sense.