Skip to main content
Topics#Tableau Desktop & Web AuthoringQuestion de michael madisha
michael madisha (Roche diagnostics) a posé une question dans #Tableau Desktop & Web Authoring
8 mai 2024, 15:23

Calculation to Get only Cases where CodeType = 'Install' and 'Complete' and both Status 'Closed'

Hi All, I am trying to get Cases where the only two conditions are met. A case with both CodeType 'Install' and 'Complete' and both Status 'Closed'. see below. I have attached packaged workbookCalculation to Get only Cases where CodeType = 'Install' and 'Complete' and both Status 'Closed'

Exercise 2.twbx
6 réponses
  1. Chris Geatch (British Airways)
    9 mai 2024, 11:04

    A simple version?

    {FIXED [CaseNo]: MAX([CodeType]="Complete" AND [Status]="Closed")}
    AND
    {FIXED [CaseNo]: MAX([CodeType]="Install" AND [Status]="Closed")}
Rédiger une réponse...
0/9000