2 Replies Latest reply on Nov 8, 2019 4:15 PM by shweta pai

    Salesforce data Missing values visible over 12 months but disappear when I select an individual month

    shweta pai

      Hi all,

       

      I am connecting tableau to Salesforce and I am looking at the trend of certain categories over time.Some categories don't have any values  in certain months. To show the missing values as 'zero' ,I clicked 'show missing values' under the month for the 'Date' of interest and used ZN(Numbers) instead of ZN( ).

       

      The issue I am facing is , the missing values show up as 'zero' . when I look at all months together, but when I select an individual month (such as November 2019), the missing values disappear.(Screen shots attached)

       

      Is there an additional step that I am missing?

       

      Missing values Visible!

      Screen Shot 2019-11-08 at 2.43.55 PM.png

       

       

      Missing Values Not Visible!

      Screen Shot 2019-11-08 at 2.44.21 PM.png