This week we explored the cost of 20g of protein in various foods. During Watch Me Viz, I showed how to create toggles to allow the user to filter by vegan and vegetarian foods. I did this with parameter actions; if you want to learn more, watch the video below.

In the end, though, my fancy filtering with parameter actions didn't quite work out. I hadn't account for the option when the user might want to look at all foods. So I ended up using basic filtering. I overcooked the whole process, but I bet you'll learn something anyway.

I then went through the entire dashboard design process using containers, padding, shading and more. Check that out if you're interested in learning how to use layout contains.

Here's the #WatchMeViz recording, followed by the interactive viz. Enjoy and thanks for watching!

From UNDP:

The Human Development Index (HDI) is a summary measure of average achievement in key dimensions of human development: a long and healthy life, being knowledgeable and have a decent standard of living. The HDI is the geometric mean of normalized indices for each of the three dimensions.

This week, I really liked the original visualization, so during #WatchMeViz,  I spend the time recreating the visual. I got most of the way there in an hour and finished it off in the evening. The questions on the live stream are super helpful...thank you!

A couple things I learned:

1. Hover action interactivity is very, very slow in Tableau. I ended up changing it to a select action.
2. Labeling is overly complicated.
3. Tables in a tooltip can look really good. And they are very responsive.

Makeover Monday is back! Every Monday I'll be running a #WatchMeViz and every Wednesday, Eva will be running #VizReview. Subscribe to my YouTube channel for reminders of the latest events.

https://youtube.com/andykriebel

This week was a makeover of a visualization by Visual Capitalist about the top 10 military spenders. During Watch Me Viz, I iterated through 15 different charts before settling on a bump chart. If you want to learn about sets, parameters, table calculations, containers and more, watch the video below.

Below the video you can see my viz, or click here. Enjoy! If you need clarifications on anything, please comment on the video here.

1. Back to Viz Basics
2. Week 4 Challenge
3. My Workbook

KPI Samples from Tableau Public:

If you're not participating in the Back to Viz Basics community project yet, you should be. It's all about creating effective, simple charts, which is exactly what you need to be able to do before you build anything fancy. This will definitely help you master data visualization best practices.

For week 3, the objective was to build a text table of Olympic medal counts. Sounds simple, but unfortunately, building good looking tables isn't one of Tableau's strengths. 

I also started the #WatchMeViz livestreams again. You can find all of them on this playlist. Thank you to those that attended live and asked good questions and left thoughtful comments. Below is the livestream as well as my final viz.

Until next week...

For #MakeoverMonday week 43 we analyzed data about apparel exports to the US during the Coronavirus pandemic. In this session of #WatchMeViz, I showed 28 different ways to visualize time series data (there are way more) before we all settled on a viz that's basically the same as the original and looks nicer.

Subscribe to my YouTube channel here to get all of my latest Tableau Tips and notifications for upcoming live streams.

Show Notes / References:

1. Data Set - https://data.world/makeovermonday/2020w43-apparel-exports-to-us
2. Tableau Reference Guide (incredible repository of thousands of Tableau tips) by Jeffrey Shaffer - http://www.tableaureferenceguide.com/
3. How to Shade Between Two Lines with Polygons by Rody Zakovich - http://www.datatableauandme.com/2017/08/how-to-shade-between-2-lines-in-tableau.html
4. Title Capitalization - https://capitalizemytitle.com/ 

This week is a nice quick tip that I showed a couple years ago at TC during a Tableau Tips battle with Jeff Shaffer. There are times when you want to make sure that your users cannot click on a dashboard. This tip shows you how to make that work.

Enjoy!

Sometimes you don't want to show the zero label on an axis, but you still want to show all of the other axis labels. In this video, I show you how to do it. 

Special thanks to Jeff Shaffer for showing me this trick during one of our TC Speed Tipping sessions.

UPDATE: 14 August 2018

1. Users can click on a specific sheet on a dashboard and then export that via the tiny button on the toolbar, but that has a few of its own problems: (1) You may not want to show the toolbar therefore making the export impossible, (2) People have to be trained to know exactly where to click to get it just right, and (3) You have no control over the output of the CSV.
2. You can export a CSV using Tabcmd, but that’s not useful for the average dashboard consumer.
3. You can add .csv to the end of the URL like http://[Tableau Server Location]/views/[Workbook Name]/[View Name].csv.  But again, you never know what that output is going to look like.

1. Add the image icon on the dashboard and place it wherever you like.
2. Add a URL link to the image.  In the dashboard above, the URL is http://public.tableausoftware.com/views/ExporttoCSV/Dashboard.csv?:showVizHome=no.
   
   This is where the magic sauce happens. When you add .csv to the end of a Tableau URL, Tableau will export the first sheet on the dashboard alphabetically.  Yes, it’s that simple!  And it’s totally undocumented.  Special thanks to the one and only Tableau Jedi Mark Rueter for this tip!  But note that Tableau orders upper case before lower case. 
3. What I did was float a sheet named AExport onto the dashboard.  I changed the height to 1 and made everything white and transparent and chose Fit Entire View so that it would be inconspicuous.  I had to name it with a capital A so that it would be the first sheet alphabetically on the dashboard.
   
   
   
   
   
   The AExport worksheet started off like this:
   
   
   
   
   
   Basically, you can put anything you want on this sheet.  I then changed the transparency to 0% on the Color shelf, changed the default worksheet color to white, removed the row banding and removed the row and column dividers.  The worksheet now looks like this:
   
   
   

1. Create a worksheet that you want to export.
2. Remove all of the formatting to make it look invisible.
3. Be sure to give it a name that makes it first alphabetically on the dashboard.
4. Place the worksheet on the dashboard, float it, make it fit the entire view, make it really small, move it somewhere inconspicuous.
5. Add an image onto the dashboard, float it and add a URL to it that is the URL for the dashboard with .csv on the end.

Live From #Milan for @infolabIT @VizWizBI in #Tableau #Tip and #Tricks and #Makeovermonday with @TriMyData #vizmilan https://t.co/hjbrZukqLy

— The Information Lab (@infolabIT) October 20, 2017

• 24 Oct @ 2pm BST
• 31 Oct @ 2pm BST