Forum Discussion
Conditional Column with Match and Specific Text Criteria
Do you have a join defined between the two columns in the model view? It seems a concatenation of Machine Type and Month/Year columns is necessary in each table in order to join the tables on the new concatentated field.
Do you have a join defined between the two columns in the model view? It seems a concatenation of Machine Type and Month/Year columns is necessary in each table in order to join the tables on the new concatentated field.
That makes sense. So if I created a concatenated column first, how would I then create the new column that countsrows where the new concatenated column values match, AND the row in 'WO Raw Data' says 'Repair'?
How do I add that 'match' part to the original statement:
No. of Failures = countrows(filter('WO Raw Data',[MTBF Repair?]="Repair"))