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?

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

• ###### 1. Re: When to clean the data, and when to get clever with tableau?

In case somebody sees this later, I found that if you right click a filter, and click "Add to context", then all of a sudden the LODs pay attention to the removal of the specific measures. It also makes that pill turn grey.

• ###### 2. Re: When to clean the data, and when to get clever with tableau?

Anyone who uses Tableau should study this chart. It puts a lot of things into context regarding LOD's