Use COUNTD instead of SUM
Can you try using Average
IF Avg([Rapid Check]) <= 2 THEN 1 ELSE 0 END
Please attach your workbook or data to understand the issue.
Well, if I use the CountD, I get 2, if I use Avg. I get 0.
The correct number is 4. I've calculated the data out in Excel, and can see the number I should get is 4. For some reason, when I sum it, it doubles it.
Emily, We can't open .twb as it is without data, pl attach .twx, so what is CORRECT number you are Looking For 1 or 4?
sorry, won't be able to post data. I'll keep playing with it to see if I can figure it out on my own
ok, taking another stab at this. I cannot post my data, so I'm hoping the more details provided here will help.
This is what I'm seeing:
Formula: "RC <= 2 hrs": IF [RapCheck] <= 2 THEN 1 END
RapCheck: IIF([Status Hold] > [status Checked In],DATEDIFF('minute',[status Checked In],[Status Hold]),Null)/60
Looking at another workspace I have, I can see that this is correctly, applying a '1' to my RC field.
I've added this formula in the last column: COUNTD([RC <= 2 hrs])
Now, what I want to do, is take this formula and roll it up to get the Total number of RC <= 2 by Customer. Would this be a LOD calculation? OR how can I get the total number of RC <=2?
If I do this: COUNT([RC <= 2 hrs]) - I get 55
If I do this: COUNTD([RC <= 2 hrs]) - I get 1
If I do this: SUM([RC <= 2 hrs]) - I get 55
The number I need to get is 28! When I look at how many cases in Tableau and in Excel that have RC <=2, the number is 28. I can see that in Tableau, I just cannot get it to total.
Any help is greatly appreciated.