April 26, 2017
Workout Wednesday - Product Spread Treemap (Part 1)
% of total
,
challenge
,
level of detail
,
LOD
,
table calc
,
treemap
,
Workout Wednesday
5 comments
My next two Workout Wednesday challenges for you will build upon each other. WARNING: This might be tough. This challenge came from a Data School project that I helped the team with.Use this data source to build this treemap. The idea is to be able to count how many regions each product sells in. Here are the requirements:
- Dashboard needs to be 850x700
- Include a summary table at the top that shows the number and % of products that sell in each region.
- Match the color-coding and text of the table.
- Create a treemap that segments the products by the number of regions it sells in.
- Match the tooltips in the treemap.
- Clicking on a color in the summary table should highlight that segment in the treemap.
- Include the caption on the treemap
That's it! The brutal part of the challenge I'm saving for week 19. Good luck!
Subscribe to:
Post Comments
(
Atom
)
I just started looking into Workout Wednesday, and I have to admit this is the first one I could actually did without cheating by opening your workbook first! The link to my dashboard is below. The only thing I couldn't replicate was having the 4 Regions on the top left. Why not have 3 Regions (Green) since it has the highest percentage?
ReplyDeleteThanks for organizing this! I learned a lot!
https://public.tableau.com/profile/publish/WW-Treemap/WWProductSpreadTreemapPart1#!/publish-confirm
-Nurul
Hi Nurul. Yours isn't quite right. 4 regions should be top left of the treemap as you pointed out. I want the regions in this order so they are sequential from top left.
DeleteI fixed it using AVG(#Regions per Product) as the size. Thanks for the challenge, Andy!
DeleteAndy,
ReplyDeletehttps://public.tableau.com/profile/publish/WorkoutWednesday-ProductSpreadTreemap/ProductsSold#!/publish-confirm
I wasn't able to get the Summary title just right. Everything else should be perfect though.
-Josh
Nice challenge:)
ReplyDeletehttp://tabsoft.co/2oLYSAh