Just wondering if you found a solution to this as I am now facing the same challenge.
No, not yet, other than what you see above. Our clients have not clamored for this kind of presentation, so it has taken a back burner. Thanks for asking. Hopefully, someone will chime in here.
Peace and All Good!
Michael W Cristiani
Market Intelligence Group, LLC
I'm your market and I'm clamouring for it - please could we have built-in marimekko charts. Thanks.
I'd be interested in seeing this chart available too - it can be useful as two dimensions with a small number of values but displayed across many small multiplies.
The folks at Aspire really want this, too! It's so much mroe useful when the bars are touching - that way the whitespace also conveys information.
Going off of Jon Peltier's Marimekko Chart at http://peltiertech.com/WordPress/marimekko-charts/
I made http://public.tableausoftware.com/views/Marimekko/Marimekko with a few table calculations.
I adding in some additional worksheets in the workbook so you can see the data s it progressed. I also started off with numeric amounts, and then calculated their percentages.
Attached is the data source that I used, so you can see the data source structure.
segment_data.xls 17.0 KB
Excellent work by both Jon Peltier (showing it in Excel) and Joe Mako (showing this chart type in Tableau). I have added a simplified alternative dashboard to this advanced chart type on Tableau Public with some discussion and thoughts.
Hello Joe and Stephen
Thanks for your contribution on the Marimekko topics.
I have been playing with your file to try and adapt it to my needs but get stuck when I want to add two extra layer of complexity:
1) I would like to prepare the Marimekko charts looking at manufacturers by segments, just like you did for Markets and segments.
But I will have these done for many different regions and therefore I will need to have a built in filter for users to select their region
2) I would like to use the "page" shelf in Tableau to allow users to look at the charts for this year or for the previous year
I have spent quite some time trying different options but couldn't find a good solution
I hope someone can help.
I have attached some demo data
Thanks in advance
data_for_mekko_charts.xlsx 28.2 KB
Thank you for padding the data, that enabled the attached workbook. I mostly copy-pasted, and then applied a filter to hide the zero values. When you switch between the years, you see no difference in the Marimekko Chart because the percentages are the same in this sample data. If you use this on a dashboard, be sure to pay attention to the exact size of the chart, it should be an exact square.
Personally, I think something like the bar chart in the attached is a more effective view for getting answers to many questions quickly. This is much easier to make, and can be more effective when combined with actions and other guided analytic options.
marimekko_chart_example.twbx 123.7 KB
Thanks very much for your response. It is really close to what I will be trying to achieve.
Your Bar chart example is an in interesting suggestion. I will probably end up using it alongside the Mekko to give it as a guided analytics options to the Mekko e.g. highlights the segments of interests with regards to YoY growth.
Could you explain a bitas to why you used custom SQL to create a Marks field with 4 values in it?
Also why jave you used a set made of the segments-manufactuers?
> Could you explain a bitas to why you used custom SQL to create a Marks field with 4 values in it?
Because we are drawing rectangles with the polygon mark type, and it needs a row for each vertex, so we duplicate the data with the UNION ALL statements to get four copies, one for each mark.
> Also why jave you used a set made of the segments-manufactuers?
I generally like Sets. It is not really needed, I just like using them instead of advanced compute sometimes. So you can remove it and then for each pill that gets a red !, edit the table calc, go to select "Total Overall" from the top drop-down, and set the advanced compute using with both segments and manufactures in the right side list box.
Thanks for the extra details, it makes more sense.
I have been trying your file with different data sets and noticed something interesting/annoying. I couldn't find how to fix it
Although in your files, the columns and rows are perfectly aligned, in somes cases they appear completely misaligned.
It looks like this is due to the fact that some manufacturers are not present in all segments. Tableau deals with these "empty" spaces by inserting blanks. This is causing some misalignment as you can see in the picture
Is there a way to fix it?
I have included the data and the workbook
In the first data source, the data was padded with records zeros. In this one, it is not. See the attached image for an example.
When you add all those extra records with zeros, then the alignment will be correct.
This padding can also be performed with a modification to your custom SQL.
padded_and_not_padded.png 45.0 KB
Indeed that works like a charm now!
Thanks a lot
What would be the SQL code modification for that to be done automatically?
Also, would it be possible to add a parameter so that user can choose to have segments or manufacturers as the X axis?