I'm confused with your logic, maybe something wrong.
Anyway, assuming your expectation is below. formula should be
Calculated 1 Good A Good 2 Good A Good 3 Bad A Bad 4 Good A Good 5 Bad B Good 6 Bad C Good
if [Version]="A" then [Status] elseif [Version]>="B" then "Good" end
Thank you for responding!
The only thing I also need to consider is that it is not just B that needs
to get recounted, it is if the 'Bad' items are B, C, D, E, etc. then I need
then to be counted as 'Good'.
On Thu, Dec 15, 2016 at 4:44 PM, Shinichiro Murakami <
I have some more conditions to add.
1. So for 'Status', there are more than just Good and Bad. There are 5
different Sates, but I only want to focus on the Good and Bad ones.
2. The issue is that your calculation worked for changing the 'Bad' states,
but it also changed some other states that had Version A, which i do not
want to do.
3. Additionally, there are versions A,B,C,D,E, etc. but there are also
Versions 1,2,3,etc. I do not want to mess with the 1,2,3 ones. Your
calculation returned these values as null.
Is this enough detail for you? Sorry I was not clear before. I can provide
another table if this is not clear.
Thank you so much!
On Thu, Dec 15, 2016 at 4:53 PM, Jessica Martini <email@example.com>
Attached is the .twb
So you can see on Sheet 1 that it is returning Null values for the numbers.
Also, it is changing the States that are listed as 'WIP' but I only want to
change the states that say 'Change'.
On Thu, Dec 15, 2016 at 6:12 PM, Shinichiro Murakami <
Tableau Help.twb 68.8 KB
TWB does not work at all.
Read thru the link and attach packaged workbook.
I still don't understand fully, but could you check this works or not.
As the data set does not have enough data I can verify, added some and create new data.
That's the reason I'm not sure I can meet your expectations.
if [Version]<>"A" and [State]="Bad"
then "Good" else [State] end
Tableau Help_SM_9.2.twbx 37.8 KB