9 Replies Latest reply on Jul 6, 2017 11:33 AM by Michael Hesser

# Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

Being a Monday, I thought it might be a good day for a simple viz challenge. I'm going to confess: this one puzzled me for far, far longer than it should have: hopefully it won't be so tricky for you!

Premise: I'm a big collector of found change (you know: those pennies you see in gas station parking lots-- I'm the guy that takes time to pick them up).

Anyway, I throw them in a jar until I have enough to buy new toys for the cats (I get the ones from IKEA-- they're about \$1.06 with tax).

I want to make a Tableau viz that meets the following criteria:

• Shows total \$\$ of found change
• Shows total \$\$ by coin type
• Shows a stack of each coin type
• the height of the stack is equivalent to the total value of the coin type (in the initial display, at least)
• additionally, the stack is broken into individual segments (so if I have 4 quarters, the stack is broken into 4 segments)
• Bonus features:
• the size of each stack varies roughly by coin value (so the stack of quarters is broader than the stack of pennies).
• it would be nice to be able to switch views so the stack height doesn't represent total value but total number of coins. Maybe I'll publish a paper on the probability of people stooping to pick up dropped change...
• Since I have 2 cats, I really shouldn't make the trip to IKEA unless I can get 2 toys, so the viz should tell me if I have at least \$2.12 available.

The viz needs to utilize a very simple Excel file consisting of a single column called COIN

Each time I find a new coin, I append it to the list. Right now PENNY is listed 16 times, NICKEL is listed 11 times, QUARTER is listed 4 times. I don't have any dimes, half dollars, or doubloons for that matter.

There is no unique ID or index on the list (no fair adding it). Nor is there a value associated with the COIN type.

Final result should look something like this:

• ###### 1. Re: Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

This is a great way to start a Monday. Is there a prize for the first twbx file posted that does the job?

Good luck, everybody.

Best regards,

Dave.

• ###### 2. Re: Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

Hi Dave Jobling... indeed there is!

The person posting the first correct answer will get:

• his/her answer marked CORRECT (and all the assorted points that go with it)
• bragging rights (granted, it's not THAT difficult)
• for those with kitties, clinical evidence suggesting which IKEA stuffed animal makes the best toy*

*result may vary.

Good Luck!

• ###### 3. Re: Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

Hi Michael,

That's a nice little challenge but only found it about an hour ago

Anyway - there are probably several possible solutions - I used:

• aggregation off
• border from color effects
• reference line for labels
• custom sheet title

• ###### 4. Re: Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

Łukasz Majewski : Wonderful-- you got it!

The trick (to rephrase: the thing that took me so long) was realizing that I needed to turn the aggregations off.

• You are correct!
• You may brag about getting it right!
• And for those with cats, I've found the most popular kitty toy is the octopus. All those extra arms make it enticing for the cats, apparently.

Thanks for playing!

• ###### 5. Re: Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

Hi,

Well done Łukasz Majewski!

Michael, will you be posting another challenge?

Anyone else got a brainteazer for the community?

Best regards,

Dave.

• ###### 6. Re: Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

I'd love to post another challenge, however I've been thinking that as a future tradition, it's only fair to pass the mantle to the winner of the challenge, so it is up to him/her to post the next one?

I won't put  Łukasz Majewski up to this since I didn't warn him in advance... unless you'd like to take it on?

• ###### 7. Re: Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

I did already back in December (?)

But if I have something cool to show then I'll do it

• ###### 8. Re: Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

I just saw this challenge, and i really enjoyed. Michael you mentioned in your original post that you want to be able to switch the label between the Coin Value, and the Coin Count, and this doesn't seem to be mentioned in the correct answer.

here is my answer with the addition of the point mentioned above.

I was a little bit challenged with the Coin Count display, but it turned out to be an easy change. thanks

Rawan

1 of 1 people found this helpful
• ###### 9. Re: Viz Challenge: Graphing Pocket Change for IKEA Cat Toys

Great job, Rawan Alsiekh!

I'm glad you liked the challenge... I'll see if I can put together another one