How to Create Small Multiple Line Charts in Tableau

[@SethWalters]

This was fantastic. Thank you for your tip Andy.

[@nicolelily]

So helpful, again. Thank you!

[@syedmohammed3391]

Thank you so much Andy. I was wondering if we can use the same Column and Row Divider formula with the Sample Super Store data set for Sub-Categories.

[@vizwiz]

Yes you can

[@LukeBeacon]

It might make for longer videos, but it would be cool if you could go through the process as more of a 'problem and solution' type system, where you slowly build the final view and solve problems as you encounter them. For example with the row divider, you could have not wrapped it in an INT at all and then figured that out as you went along. I feel this would better mimic the trial and error learning process most people employ with Tableau and help develop problem solving skills within the Tableau environment. Longer videos are OK I think since most people would be using Tableau to learn for their profession and wouldn't mind watching a longer video. Just a thought. :)

[@vizwiz]

+Luke Beacon true, but then the videos would take too long.

[@praveenranj]

You are awesome, love your videos and the way you describe. Cheers

[@aws0698]

Great video! How do you get the candidate names to appear at the top center of each pane?

[@vizwiz]

+Alex Smith I do it via a calculation that I place on the secondary axis. You can download the workbook from my blog to see how I did it. vizwiz.blogspot.com/2016/03/tableau-tip-tuesday-how-to-create-small.html

[@MrJohnDai]

Hi Andy, could you elaborate on this? In your workbook I can see a calculated field of "Candidate to Show", however I couldn't figure out how to place the label at top center using the same calculations. thanks.!

[@vizwiz]

First, download the workbook from my blog to see how I did it. vizwiz.blogspot.com/2016/03/tableau-tip-tuesday-how-to-create-small.html Look at the Max Rating Offset calculation that's on the secondary axis, then go to that field on the marks card and you'll see how I set the label up.

[@MrJohnDai]

Thank you very much for your prompt reply, got it :)

[@Anonymous_Pers0n]

informative and a strong additive to my learning

[@carolinewilson4342]

Is there a way to also do multiple bar charts?

[@vizwiz]

Change the mark type to a bar. 😊

[@rajeshtukdeo]

Great video..What's the logic behind calculations of column and row divider fields?

[@SirBrettley]

See this: datapsientist.blogspot.com/2014/09/auto-scale-auto-arrange-shapes.html

[@markschild]

This is a great video, although, you should add a part two where you show the secondary axis.

[@navinsai5726]

Hey Andy: I am also in need of much similar charts and your tutorial really helped me a lot to ahcieve 90% of my requirement. I have a situation where I need to display the TOP 20 stores YTM ( Year to Month/Date ) sales volumes and also display them in descending order of sales volumes based on latest months data. I have created a Store Rank for each month that gives a Rank to the store based on the sales volume and I have Month Start Date as Columns, Sales Volumes as Rows and Store Names as Level Of Detail. I created a sort field with calculation as below IF ({ FIXED [Store Name] : MAX([Store Rank]) } = [Store Rank]) AND ( { FIXED [Store Name] : MAX([Month Start Date]) } = [Month Start Date] ) THEN [Store Rank] END I have tried to Store Rank as the sort field but it didn't give me the desired result, Also, I don't know what aggregation I need to use in the sort field. I just selected Median but didn't give the desired output. Any help on this is much appreciated.

[@shashidharpathikonda1497]

Love it!

[@JY-yo2ke]

Any way to realize independent axis for each small charts, if they are on different scale? Huge thanks!

[@vizwiz]

Jiayin Zhao not in this types of design. You would need to create a separate chart for each block. But that then defeats the purpose of this chart type. You want to be able to see the size differences for relative comparison purposes.

[@joseherrera9690]

@@vizwiz try normalizing the data -> norm_value = (value - min_value) / (max_value - min_value) ... this will work for the chart only, use another field to show the actual value

[@vizwiz]

@@joseherrera9690 yes, that would definitely work. I wanted to keep the comparisons across the charts. Good idea for JY’s question!!

[@OxfordComma97]

Using this video for a school assignment but I cant seem to find a link to the data anywhere, where are you getting the polling data used to make these visualizations?

[@vizwiz]

YouGov has great data sets.

[@AlecGuerenstein]

Thanks a lot for this! I'm looking for a way to build a trellis / panel chart based on [Measure Names] instead of a single measure. In other words, each panel should reflect the evolution in time for a different measure selected through Measure Values filter. Any suggestions? Thanks in advance.

[@adolfohc78]

Hello Andy, great video! I managed to replicate your viz with my data but in my viz I want to add another line for comparison with each other cell (for example, adding the Trump trend to to the cells from Cruz, Rubio, etc) and at the same time not to include the individual cell corresponding to Trump. I'm not sure if explained myself. Is it possible to do this? Thanks for your tutorials!

[@rashmisinha204]

Hi Andy can you plz do one more video on trelis chart like u did in workout Wednesday week 7...

[@waltertoy8749]

Sorry where can I download the workbook? It says you can in the video. Thanks

[@sumibits]

Hi... Wanted to know logic behind Column divider and row divider formulae. How they are working ..... ?

[@hma4019]

This is a great video! Really helpful. However, I ran into a glitch. For my chart, Dept ID was the variable I was using instead of Candidate. When I tried to select "dept ID" for the "compute using" for column divider and row divider the "dept ID" variable was not in the list for either of my calculated fields. Anyone have any suggestions?

[@enzimuzakki1218]

Cool!! , now how I add the title for each chart.... someone can help me?

[@navinsai5726]

Just pull the candidate or any filed that you want to the label text and it shows the title for each chart.

[@tahmidyusuf6674]

Hiii, can anyone please provide the link of this polling dataset?

[@vizwiz]

Tahmid Yusuf download the workbook and unzip the twbx.