2 of 2 people found this helpful
is this what you wanted to see
Here is how it is calculated
first add and index to the horizontal axis and one to the vertical axis (don't worry we will hid them later)
I made the calculation discrete and gave them names so I could distinguish them
place them on the rows and columns shelf
the calculation is
then create the viz by dragging the poverty level to color and expand the size of the squares to fill the cell
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you Jim- this is helpful. I was able to follow your directions and come up with the same thing. I just had to figure out how to hide the vertical and horizontal by clicking on the carrot and unchecking show header.
I have a couple follow up questions if you don't mind.
How do I rename the Null value on the legend to read Not poverty? Would I change the calculation?
Also how does the index horizontal and vertical work- how does it know what is and isn't the poverty level?
And finally will this only work on this specific grid visualization (not sure what this one is technically called) ? Would I have to create another way to calculate poverty if I wanted to visualize in another way for example on a bar graph or map?
Thanks so much for your assistance and quick response!
1 of 1 people found this helpful
in order asked
this change will add the "Not poverty"
you can then put it on the viz and either leave the color like this
or you can change the colors by opening the color mark
Index() is a table calculation and it is positional - it is just counting the position on the table -
you created ranges (strings) that were related to the HHI and HH size from your word doc - I just took advantage of how they were placed on the chart -
your data does not have the actual HHI - only the group that the HHI falls within
It is much more complex but could still be accomplished - i would convert the string responses to numeric with a rather long case statement or if statement that placed responder into a HHI income bucket from 1 to 10 (you have 10 buckets - I would use the contains statement and focus on the upper $ level in each group)
Then the HHI size is already a number = so I would use the the same poverty level calc except use the Numeric HHI indicator and HH size in the formula -
the last point is different than the post - if you wanted to do some sort of counting above or below the poverty level I would convert the HHI buckets into numbers as above to allow numeric operations - (greater than and less than is much easier with numeric values
Thanks! This answers all my questions!
Glad to help out
if you need something else let me know