1 Reply Latest reply on Mar 27, 2015 12:31 AM by Sankarmagesh Rajan

    Limit shown Revenue in a date range to >= specific date in blended data source

    hanno.t

      Hello community

       

      i'm very, very new to Tableau. I have searched the web and this forum, and watched several of the training videos. so far, no luck to solve my problem.

       

      here's what i want to do:

      i have to data sources, blended.

      one has so-called Asset data (from Salesforce).

      the other source has cost and revenue data per day, for several years.

       

      let's say one of the assets has a start date of 1st Feb 2015.

       

      now, in my view I want to see Revenue since 1st Jan 2015.

      I want everything prior to that asset's start date to show $0, and only show revenue for dates that are greater or equal to the start date.

       

      something like this for a calculated field.

      [Revenue $] where [ds] >= [Asset (Salesforce)].[Purchase Date]

       

      (ds is datestamp, which is the date field in the revenue data source).

       

      I don't know the syntax how to write the formula. and i don't know what to write to achieve my desired outcome.

       

      thanks in advance