Frequently Asked Questions from Tableau Training: Vol. 1

Data

Frequently Asked Questions from Tableau Training: Vol. 1

by Katie Wagner

Chances are, several people have the same questions about Tableau as you do. The Questions from Tableau Training series spotlights these questions and provides answers. Questions are pulled straight from InterWorks’ Tableau training classes. You can check out the full list of posts on the Questions from Tableau Training blog channel.

FAQs from Tableau Training

As I travel the country spreading #DataVision, there are a few questions that repeatedly pop up in trainings. Today, I’ve decided to tackle a few of the most frequently asked questions to help our efficiency in Tableau.

Q: How do I create custom continuous color palettes?

  • Change the TYPE from Regular to either Sequential or Diverging. You can choose multiple colors for Sequential but only a starting and ending color for Diverging.
  • For an easier way to create color palettes, check out the Color Tool from InterWorks. Color Tool for Tableau is a free, automated application that lets you create custom color palettes for Tableau with minimal effort.
  • You may also be interested in learning more about sequential and diverging color palettes here.

Q: How do I handle a “divide by zero” situation in Tableau?

  • Use the IIF function. The function “IIF(test, then, else, [unknown])” asks for four pieces:
    1. TEST = What are you trying to evaluate?
    2. THEN = What is the outcome if it’s true?
    3. ELSE = What is the outcome if it’s false?
    4. UNKNOWN = What is the outcome if it’s neither true nor false? (This section is optional and usually treated as a null value.)
  • Tableau’s Online Help provides the following example to avoid dividing by zero when creating the Discount Ratio:

Discount Ratio

Q: How do I see an individual, distinct list of all members of a measure?

  1. Use the measure somewhere in your view (typically the Rows shelf).
  2. Right-click on the measure active field and choose Dimension.
  3. Right-click on the measure active field and choose Discrete.

Q: How do I create a dynamic date band controlled by a reference line? For example, how do I add three months to a specified reference date?

  1. Right-click an axis to create a reference band.
  2. For the minimum value, create a new parameter with a range of values from your date field.
  3. For the maximum value, create a calculated field using the DATEADD function (e.g. DATEADD(‘month’,3,[Min Value Parameter]).
  4. Be sure to bring the calculated field into the Detail button on your Marks card so that its values are available in the reference band.
  5. Right-click on your [Min Value Parameter] field and select Show Parameter Control, giving users the ability to make the reference line dynamic.

Q: Why doesn’t Tableau recognize all of my fields for an incremental refresh in a data extract?

  • The field must be an integer (18 digits long), date, or date/time, and it must be unique to be used as an increment key.

Q: How do I show the entire dimension label without manually adjusting the column width?

  • CTRL+Up or CTRL+SHIFT+B makes the cells taller/larger and wraps the continuous text to the next line.

Q: Is there a keyboard shortcut for creating a new calculated field?

  • ALT+A+C

Q: What is Tableau’s starting, zero or epoch date for calculations?

  • 1/1/1900
  • If you need to convert a column to a specified epoch, use this formula: DATETIME(DATEADD(‘second’, INT([Name of Date Column]), #1900-01-01#)), with the numbers between ## representing the specified epoch. Many thanks to Michael Treadwell for this great response. 

Q: Why didn’t my Tableau Data Extract ask me to save to a file location?

  • “Honey Badger and TWBX don’t care (where the extract goes, because it’s really going into the ZIP folder from temp)!” – James Wright

At InterWorks, we love to tackle challenges. If you have any additional questions, please feel free to use the comment section below or contact us.

Contact Us!

More About the Author

Katie Wagner

Analytics Consultant | Training Lead
Preppin’ Data Project: Week 1 Note: A big thank you to Carl Allchin and Jonathan Allenby for initiating the Preppin’ Data project for our community. Hunker down, ...
Split and Pivot Your Data with Tableau Prep With the release of Tableau Prep in April 2018, analysts have been given an incredibly valuable tool for their analytical kit. ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072