5 Replies Latest reply on Jul 5, 2017 6:30 AM by Jayson Osmars

    problems with Measure NULLS

    Jayson Osmars

      I have a requirement to display new accounts this year that didn't exist last year which is giving me a headache.  Also I'm new this month to Tableau.

       

      I see empty values for last year for various accounts. and sales of sorts for those accounts for this year.

       

      Any filtering, ZN, lookup, etc

      and

      if the [date] = today() year -1,

      then test that calc measure to give the new accts needed.  Should be straight forward but just isn't working.  and I have a headache.

       

      Any ideas that may help me from the gurus?

       

      Thanks.