Blog

24
DEC
2019

Show Empty Rows and Columns

Kommentare : 6

Dear Tableaufans,

data analysis is often about “What is IN the data?”. Therefore we sometimes forget to ask the question about “What is NOT in the data?“!!! There is a very easy feature within Tableau which enables you to do so. Showing all values of a dimension  even if there is NO data (NULL) attached to it!

Just navigate yourself to Analysis > Table Layout > Show Empty Columns/Rows at the top of your screen.

With that said – MERRY CHRISTMAS to the DataFam and all Trailblazers!!!

P.S. This feature seems to be secretly released in 2018.3 😉

 

Timo Tautenhahn
Über den Autor
Timo originally coded his own BI-application by making use of different JAVA libraries. He Worked for IBM as BI-specialist and BA-architect before he joined Tableau. Favorite subject: JavaScript API

Teilen

  • google-share

6 Kommentare

  1. Pingback: Best of the Tableau Web: Reflections, predictions, and plans | Tableau Software

  2. Avatar
    Jonathan Drummey 12. February 2020 at 17:55 Reply

    Hi,

    A little clarification on this feature: Show Empty Rows & Show Empty Columns aren’t new features, they’ve been around since at least Tableau 6.1. Also they only work for discrete dimensions and those dimension values can’t have been filtered out by the dimension itself being on Filters, other fields that are context filters, or data source filters.

    Regards,

    Jonathan

    • Timo Tautenhahn
      Timo Tautenhahn 13. February 2020 at 0:54 Reply

      Hi Jonathan,
      thx for leaving a comment! Your blog is another great source for Tableau content! Are you sure? So just by going back within the documentation of this feature it seems like it wouldn’t be the case, but maybe the feature was called/referenced differently before? The first version I’ve been using has been 7.x and I can’t remember that it has been available back then (which doesn’t necessarily mean that it didn’t exist! ;))

      https://help.tableau.com/v2018.3/pro/desktop/en-us/missing_values.htm –> exists
      https://help.tableau.com/v2018.2/pro/desktop/en-us/missing_values.htm –> doesn’t exist

  3. Avatar
    Patrick Schommer 2. September 2020 at 20:45 Reply

    This helped me. Thanks for the tip!

  4. Avatar
    Johannes Swarts 16. September 2021 at 19:41 Reply

    So I cannot use “show empty rows” if the view has already been filtered by a dashboard action?

    Thanks

    • Timo Tautenhahn
      Timo Tautenhahn 13. July 2022 at 13:12 Reply

      If you get rid of data points by filtering them out, the database is not even giving you back those values. Therefore yes, you cannot show those values. BUT if you’d like to show them (so not EXCLUDING those values), you can easily create calculations to change parameters and still show the overall impact/amount of values/distribution/set…etc. Just one small example can be found here:

      https://public.tableau.com/shared/C687QF5TH?:display_count=n&:origin=viz_share_link

Kommentare Cancel reply

*

*

captcha *

Categories

  • Admin Area (1)
  • Data Stories (1)
  • Developer (2)
  • Embedding API (2)
  • Extension API (11)
  • Geek Stuff (3)
  • Hacks (1)
  • Ideas (8)
  • Industry Related (1)
  • Neuigkeiten (6)
  • News (3)
  • Performance (2)
  • Salesforce (1)
  • SAP (1)
  • Success Stories (1)
  • Tableau 10 (1)
  • Tableau 9 (1)
  • Tableau Server (3)
  • Tableau Visualization Extensions (1)
  • Tipps & Tricks (10)
  • Tips & Tricks (1)
  • Tutorials (14)
  • Visual Inspiration (8)

Tags

artilize Azure bericht Cloud Cloud Database conference Datalake dynamisch embed Embedding Extension API Extract API html javascript api kpi mobile munich news on-demand on-tour parameter RLS Salesforce SAP SAP BW Security Snowflake SSO tc Write Back

Last posts

Timo Tautenhahn - Tableaufans.com - Tableau Visualization Extensions - Create and share your own chart types - Live Devs on Stage TC21

Tableau Visualization Extensions

Thursday, 11. November 2021

How to configure Tableau Online Single Sign-On with Salesforce as Identity Provider?

Monday, 16. November 2020

Tableau Extensibility Framework

Thursday, 17. September 2020

Embedding Tableau Responsively

Tuesday, 26. May 2020

How to write back data to Snowflake?

Monday, 18. November 2019
  • Blog
  • About
  • Contact
  • Legal
© 2019 - tableaufans.com - All rights reserved
Concept and design: www.emodia.de