2 Replies Latest reply on Jun 27, 2016 11:33 PM by mortenbodaugaard.jrgensen

    When to clean the data, and when to get clever with tableau?

    Christopher Dorosky

      I've got some data with two distinct types of problems.

       

         

      RaterQuestionRatingProduct
      JoeTaste3cake
      JoeTexture2cake
      JoeAppearance4cake
      JoeUniqueness5cake
      JoeTaste1jello
      JoeTexture2jello
      JoeAppearance5jello
      JoeUniqueness3jello
      BobTaste5cake
      BobTexture4cake
      BobAppearance5cake
      BobUniqueness3cake
      BobTaste2jello
      BobTexture2jello
      BobAppearance2jello
      BobUniqueness2jello
      JessicaTaste3jello
      JessicaTexture3jello
      JessicaAppearance4jello
      JessicaUniqueness5jello
      JessicaTastecake
      JessicaTexturecake
      JessicaAppearancecake
      JessicaUniquenesscake

       

      Problem 1: Jessica has Null scores for cake, but if I do a COUNTD([PRODUCT]) it will return 2. I can get around this with several calculated values, counting the ratings, etc...

      Is it recommended to fix the data in excel, or to get around this in tableau?

       

      Problem 2: I need to count he number of rating question categories with an average below 3.0, per rater. I do that with this formula:

      {FIXED [Rater]: SUM(IIF(([Average Per Rater]<3.0), 1, 0))}

      This works fine. I get 1 for Bob, 2 for Joe, 0 for Jessica.

       

      It has been decided that uniqueness no longer matters for this calculation.

      Excluding or hiding the data in the table does not help.

      I've tried this calculation:

      {FIXED [Rater]: SUM(IIF(([Average Per Rater]<3.0) AND ([Question] != "Uniqueness"), 1, 0))}

       

      But this creates bizarre answers. No clue what it is doing. Should I even be trying to do this, or should I go into excel and delete the data? Is there a way to globally completely ignore something like this?

       

      I've attached the workbook with the data embedded.

       

      Thanks,

       

      Chris