Forum Discussion
Waffle chart
Hello,
Waffle Chart author here.
The Waffle Chart works nice if all the input values are between 0 and 100, but if one of them is over 100, then, the maximum value in the input is considered the 100% value and the rest of the values are calculated using cross multiplication.
There is a nice way to fix this, and it is using the Maximum value column. For example, if the values are greater than 100, then, you can provide what value is 100% in the Maximum value like this:
Group, Value, Maximum Value Female, 3400, 6000 Male, 2600, 6000
Then Female will become 57% and Male will become 43%.
Let me know if this does not solve the problem.
Hello,
Waffle Chart author here.
The Waffle Chart works nice if all the input values are between 0 and 100, but if one of them is over 100, then, the maximum value in the input is considered the 100% value and the rest of the values are calculated using cross multiplication.
There is a nice way to fix this, and it is using the Maximum value column. For example, if the values are greater than 100, then, you can provide what value is 100% in the Maximum value like this:
Group, Value, Maximum Value Female, 3400, 6000 Male, 2600, 6000
Then Female will become 57% and Male will become 43%.
Let me know if this does not solve the problem.
Yes, after some work i figured that out a few days ago. That was exactly what i did!
Thanks! kiewic
PS: Good job with waffle chart creation :)
Hello,
I face some problems as well, all visuals seem to work following your instructions accept one, one column has only answers "Yes", the waffle chart displays 0% in that case?
Do you know what this can be. It is all in the same table...
Thank you in advance for any support on that.
