Chart Types

Chart Types

This section covers a whole bunch of chart types that are not part of Show Me, but can be built in Tableau, along with some notes on how to get existing charts to work more like I want them to. There’s also a whole section on the Path Shelf.

Be sure to check out the following sources of material on the Tableau Community:

Multiple mark types on same view:

put multiple measures on same row/column Then choose Dual Axes (synchronize if necessary) Then on the Marks card, click on the upper-right drop-down arrow to choose Multiple Mark Types

Showing Summary and Detail Together | Tableau Software
http://onlinehelp.tableausoftware.com/current/pro/online/en-us/help.htm#multiplemeasures_combocharts.html

Path Shelf

On blood transfusion data, getting a table calc to have connected points for a line chart:

Notes from Mar 2012 WebEx w/Joe Mako

I don’t want to misrepresent Joe’s awesome knowledge here, if there are any mistakes in these notes from our conversation they are almost certainly mine.
In Tableau v7.0, the Tableau DATETRUNC() from the pill menu doesn’t work. 1. Turn Quarter into Continuous field using DATE(DATETRUNC(‘quarter’,[date field])) 2. Set to Exact Date – Continuous 3. Put Month([date field]) on Path Shelf. Note – when on LoD it causes partitioning, when on Path shelf it helps connect marks 3. Then for each measure (axis) select the pill->Format->Hide…Connect Lines

Another comment on PATH shelf

Using  a set to get the path shelf to draw things properly: http://community.tableausoftware.com/message/136628#136628 From Think Data Thursday #4, 9/13/12 Path Shelf needs specific structure of data. In particular, origin/destination need to be in the same column, not separate columns. More on Path shelf From http://community.tableausoftware.com/message/188861#188861 If you’re trying to just get the data together, try these resources: http://kb.tableausoftware.com/articles/knowledgebase/using-path-shelf-pattern-analysis The key bit that is not talked about in that is that if you want to use Tableau’s built-in geocoding to get latitude and longitude, you need to change them to aggregate fields like MIN(State), this forum post has the details: http://community.tableausoftware.com/thread/109399 Finally, I’ve attached a workbook that demonstrates this. point to point mapping.twbx

Putting charts in tooltips:

http://www.tableausoftware.com/community/support/kb/barsintooltips http://www.thedatastudio.co.uk/blog/the-data-studio-blog/andy-cotgreave/charts-in-a-tooltip http://www.tableausoftware.com/about/blog/2010/09/using-bar-charts-tooltips Bullet charts: http://www.freakalytics.com/2011/01/29/enhanced-bullet-charts/ Tableau control charts: http://www.tableausoftware.com/support/knowledge-base/control-charts http://dataremixed.com/2011/10/how-to-make-control-charts-with-tableau/ http://sanpelegrino.tumblr.com/ funky pie charts: http://twitpic.com/72r2jp Treemaps http://www.cs.umd.edu/hcil/treemap/ Box plots: http://www.tableausoftware.com/support/knowledge-base/box-plot-analog

Likert scales:

http://www.datarevelations.com/likert-scales-the-final-word.htmlhttp://www.datarevelations.com/using-tableau-to-visualize-survey-data-part-1.htmlhttp://community.tableausoftware.com/thread/117982 – putting many questions all together to see the spread

More on surveys
http://peltiertech.com/WordPress/charting-survey-results/

Nice post about ordering & annotating data:
http://www.storytellingwithdata.com/2013/09/logic-in-order.html

panel or trellis charts:

http://www.thedatastudio.co.uk/blog/the-data-studio-blog/andy-cotgreave/panel-charts-in-tableau http://www.datarevelations.com/the-likert-question-question.html In Tableau, panel charts really need the X and Y axes to have the same values Joe’s version: http://community.tableausoftware.com/message/181493#181493

http://boraberan.wordpress.com/2013/03/15/trellis-charts-with-tableau-8/

Small Multiples for Tables

http://www.perceptualedge.com/articles/b-eye/tablelens.pdf

Ensuring dual axes are available

Make sure that both fields have the same datatype. One way to check to see what data type Tableau is recognizing a field as is to open the calculated field box, select the desired field and in the yellow box at the bottom right will tell what type of field it is. Note that datatype and number format are independent! See this thread on what can happen when you try mark labels on a dual axis chart without synchronized axes: http://community.tableausoftware.com/thread/114593

Parallel Coordinate Plots

http://public.tableausoftware.com/views/ParallelCoordinatesExample/ParallelCoordinatesExample http://www.tableausoftware.com/support/forum/topic/parallel-coordinates-plot http://www.perceptualedge.com/articles/b-eye/visual_multivariate_analysis.pdf http://www.perceptualedge.com/articles/b-eye/parallel_coordinates.pdf

Combination chart with overlapping bars and line:

Using measure values and unstacking marks to create the overlapping bars, dual axis to create the line. http://vizwiz.blogspot.com/2011/08/tableau-tip-7-easy-steps-to-create.html image[78] calendar view http://www.tableausoftware.com/blog/calendar-data-visualization waterfall charts http://community.tableausoftware.com/thread/107514?start=0&tstart=0 Using Custom Shapes http://community.tableausoftware.com/thread/116844 https://www.interworks.com/blogs/iwbiteam/2012/01/27/using-custom-shapes-tableau cumulative distributions (pareto chart) http://kb.tableausoftware.com/articles/knowledgebase/cumulative-distributions pareto Grouped Bar chart (like what Excel does)

See http://drawingwithnumbers.artisart.org/bars-and-lines/ for a more complete treatment of doing grouped bars and lines.
http://kb.tableausoftware.com/articles/knowledgebase/grouped-bar-chart side by side bars Joe Mako variation on this using Custom SQL that would allow for multiple lines, I think: http://community.tableausoftware.com/message/132454#132454 Also called side by side stacked bars Stem and Leaf plots http://www.datadrivenconsulting.com/2011/04/stem-and-leaf-plots-sorta-in-tableau/ stem and leaf plot Ternary charts http://community.tableausoftware.com/message/179240#179240 ternary plot making more interesting data-rich vizzes: 1.     duplicate a measure (usually as rows) 2. do multiple mark types 3. aggregate or disaggregate the measure as needed 4. turn on dual axis 5. synchronize axes examples – putting sales by customer circles on a bar chart of sales by state putting pie charts on a chloropleth map putting an overall average on a per unit average from TCC11 – JediTricks video Triangle charts http://community.tableausoftware.com/message/178976#178976 triangle plot

More than 2 mark types on same view

Joe Mako hack in Tableau 5 using reshaped data to draw lines as points, bars, and a line http://public.tableausoftware.com/views/BarLineandDot/Example Treemaps Treemaps in Tableau? can be done. Waterfall charts http://www.alansmitheepresents.org/2011/02/waterfall-and-funnel-charts.html

Kaplan-Meier Survival Curves

http://community.tableausoftware.com/message/216551#216551

 

Radial Chart

http://interworks.co.uk/tableau/radial-bar-chart/

[loop category=”wikicontent” tag=”charts,chart-types,bar-charts,Kaplan-Meier,Likert,Likert-scales,Marks-Card,panel-charts,trellis-charts,Path-Shelf,Show-Me,small-multiples,survival-curves,ternary-charts,tooltips,waterfall-charts”]
[field title] – Added [field date]
[content]
[/loop]

Related posts:

    [loop tag=”charts,chart-types,bar-charts,Kaplan-Meier,Likert,Likert-scales,Marks-Card,panel-charts,trellis-charts,Path-Shelf,Show-Me,small-multiples,survival-curves,ternary-charts,tooltips,waterfall-charts” exclude=”this” relation=”and” compare=”not” taxonomy=”category” value=”wikicontent”]

  • [field title-link][field thumbnail-link]

[/loop]

Please add your thoughts and perspectives