2 Replies Latest reply on Dec 28, 2012 6:07 AM by Alex Kerin

    How to only update a value when the data changes instead of having blanks

    Jeff McDonald

      Hi all,

       

      I have a worksheet with 2 linked data sources. One of them shows the number of times a house has been looked at by Realtors. The other has information about changes to the property, such as price changes. As of now my worksheet looks sort of like this:

       


      JanuaryFebruaryMarchApril
      123 Main St



          Avg Price$159,000
      $200,000
          Count of Showings
      12





       

      What I'd prefer is if I could make Tableau force February to be $159,000 instead of blank and April to be $200,000 instead of blank. Is that something Tableau can do easily? Or even with difficulty? I'd rather handle it in Tableau than have to monkey with my data.

       

      Thanks,

       

      Jeff