3 Replies Latest reply on Apr 12, 2018 5:11 PM by Okechukwu Ossai

    Display 0 when there is no data

    Matthew Hefferon

      Hello Tableau community,

       

      I created a simple dataset to demonstrate my problem. What I'm trying to figure out is how to force a zero when a particular month has no data.

      Screen Shot 2018-04-12 at 12.41.58 PM.png

       

      Walmart doesn't have any spend for month 3/1/18 so it shows nothing in the dashboard as expected. I need to display a zero when there is no data though.

      Screen Shot 2018-04-12 at 12.42.13 PM.png

       

      Attached is a packaged workbook. I've seen a few examples but haven't figured this one out yet.

       

      Thanks in advanced for your help!