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


      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?