1 of 1 people found this helpful
You can do this by first, importing the desired custom shapes (http://onlinehelp.tableausoftware.com/current/pro/online/en-us/buildmanual_shelves_shape_custom.html
Then, change the Mark type to shape. Place your fruit dimension on the Columns shelf and the shape shelf. Place your value on the rows shelf. Then, go to Analysis and un-check Aggregate Measures.
Hope this helps!
First of all, apologies that it has taken so long for me to get back to you.
Thank you very much for your help - this looks to me like it would work a dream.
HOWEVER. I've recently managed to get my hands on the data, and it's structured in a way that makes this solution not quite work.
The Fruit dimension is actually a concatenated string, containing text indicators for the fruit purchased in a transaction. Example:
So, I've built multiple calculated fields in order to ascertain whether or not each fruit type appears in the string.
"IF FIND([Ingredients],"apple") >0 THEN 1 ELSE 0 END"
"IF FIND([Ingredients],"orange") >0 THEN 1 ELSE 0 END"
(there's probably a cleaner way to look for a string within a string, but this jumped out at me)
Using the Measure Values on the Rows shelf, and Measure Names on the Columns Shelf (filtering out 'Number of Records', of course) leaves me with more or less what I'm after. The only issue is that, because I am now only using 1 Data Item ("Measure Values"), I am only able to assign one shape to the whole dataset.
Apologies for not posting a packaged workbook, this is sensitive data and I've not had a chance to clean it. Will do, if nobody can think of any obvious solutions.
Just realised what I was missing... Just need to bring the Measure Names pill in for the Shape parameter and bobs my uncle.
Hi Tracy -
Just to follow up on this question - is there a way to reaggregate the shape counts, so that they say if you had 1 million fruits (to go along with the OP's example) you would only have say 10 fruit shapes showing??
Must be re-calculated ? Or perhaps reformatted? I will play around with it and see.