Hello again! From the dashboard it seems like you're wanting to double count. Did you want these all in one sheet? Looking at the data is a bit confusing, did you just remove last name to anonymize? I'm trying to figure out why there are people who both did and didn't earn a t-shirt, but that would explain it. If you want several bar charts why not use a dashboard?
Since your incentives overlap it seems like a good way to visualize is in the 3 groups Tableau gave, just maybe not with those colors or pane dividers. I included an example of another way to look at the whole picture in the last sheet. To create these groups I combined the different incentive levels into a single dimension, control click several dimensions then right click and select combine. Once on the sheet you can right click the individual categories and edit alias to rename (note the fields are ordered alphabetically by field name).
Let me know if this helps, or if you still need help.
Thanks for the response.
That control click and combine is a nice tip!
I'm sorry the data is confusing, I did delete several rows to anonymize, and didn't de-duplicate the first names.
In this particular case, I do want to double count rows. As a participant raises more money, the incentive items accumulate as follows:
$25 - T-Shirt
$150 - VIP & T-Shirt
$500 - Jacket & VIP& T-Shirt
$1,000 - Backpack & Jacket & VIP & T-Shirt
So with the following list of people:
John - $0
Sarah - $25
Matt - $200
Steve - $300
Anna - $550
Kathleen - $1500
I would like the bar chart to look like:
T-Shirt Yes: 5
T-Shirt No: 1
VIP Yes: 4
VIP No: 2
Jacket Yes: 2
Jacket No: 4
Backpack Yes: 1
Backpack No: 5
I would like to have it all on one sheet so I can later view it by location and year next to each other.
I'm hoping to later view each bar as a percent of all participants as well.
Ok..Ok. Fine, you can do it. If this had occurred to me before I'd have posted it, but I must have been having an off night. I used a running sum along reward type (ordered by descending average donation) to get the number who got each reward, then took the total minus that number for those who didn't. Measure values lets us use those 2 side by side.
Hey Noah Salvaterra ,
Thanks for this response! I have been out of the office, and am just checking this out. This is exactly what I'm looking for, however it's going to take me a minute to figure out how exactly you did this!