2 Replies Latest reply on Jul 4, 2017 8:12 AM by Rapelang Masiapetlo

    Visualising missing Values as Zeros

    Rapelang Masiapetlo

      Good day guys.

       

      I need some assistance with a problem I am currently having.  I have created a table where I do calculations and showing the values every month, however since there aren't any figures (from the data) for some of the months I am getting blanks on the table/view I created.  Is there any way possible to show the blanks as zeros? Any help would be appreciated.

       

      Below is a screen shot of my workbook, I can't attach the workbook itself because it is sensitive client data.

        • 1. Re: Visualising missing Values as Zeros
          Simon Runc

          Hi Rapelang,

           

          So if the marks don't actually exist, you can create them via a process called "Data Densification" (this isn't that well documented, but in short if you have 2 opposing Blue Pills and a Table Calculation....Tableau will densify the view to include those marks). You can then use the formatting to tell Tableau what text you want to display for NULL results)...the gif below shows this in action!

           

          Densify Data.gif

           

          Hope that does the trick for you....but let me know if not (ideally with an example workbook, so I can take a look at your situation)

          2 of 2 people found this helpful
          • 2. Re: Visualising missing Values as Zeros
            Rapelang Masiapetlo

            Hey Simon,

             

            Thank you very much, that is exactly what I needed. It was very helpful.

             

            Best Regards,

             

             

             

            Rapelang Prince Masiapetlo|Oracle PL/SQL - BI Developer Consultant|Software

            Application and Information Solutions (SAiS) | Office: +267 3191536

            <+267%203191536>|Fax: 267 3191537 <267%203191537>|

             

            *Address: *Plot No: 74769, Mowana Mews, Western Commercial, CBD, P.O.Box

            201150, Gaborone, Botswana|

             

            *Website: *www.sais-erp.com <http://www.sais-erp.com/>

             

            On Tue, Jul 4, 2017 at 4:18 PM, Simon Runc <tableaucommunity@tableau.com>