Creating Household Income and then Histogram

[bigck2]

Hello,

I'm doing a project for an apartment community. I have a table with demographics information including income. Each row is for an individual in the community and people share an apartment unit.

I'm able to create a histogram using individual income, but I want to create a histogram for household income. My table looks like this:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Unit[/TD]
[TD]Age[/TD]
[TD]Income[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]35[/TD]
[TD]65000[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]32[/TD]
[TD]28000[/TD]
[TD]Jane[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]40[/TD]
[TD]75000[/TD]
[TD]Jim[/TD]
[/TR]
</tbody>[/TABLE]


I'm able to use some calculated measures with DISTINCT and DISINCTCOUNT to get occupancy. But I can't figure out how to get Household Income.

I was thinking about using a calculated lookup column, but my brain is a little lost right now. It seems like if I did that I would end up double counting incomes.

Please let me know if you have any suggestions.

-Chris

 

[TimRodman]

What about using a regular Pivot Table and then a Pivot Chart on top of the Pivot Table like pictured below:

 

[scottsen]

Ya, a calculated column is likely where you want to go here. It really depends on how fancy you want to get... you could have a separate table of all the income ranges and assign some sort of bucket ID to it, then your calc column does a lookup to find its bucket, (60000 to 62499 = 60k, 62500-64999 = 62.5k, ...)

You could try something "easy" and see how you like that.. say, a calc column =ROUNDDOWN([Income], -4) would give you buckets based on 10,000 income marks (and you can do round/rounddown/roundup depending on what you like).

Then you just drop the new calc column as your independent variable, and COUNTROWS() as your dependent... and <boom> Histogram city!