Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've created a table chart to show me all cases closed in the current month, now I would like a separate table that shows me the same except the case status is either a new defect or an existing defect.
Here is what I am using for my current table value:
count({<CaseMonthYear={'$(vCurrMonth)'}>}distinct CLOSED_DTTM)
any guidance or suggestions greatly appreciated!
May be this?
count({<CaseMonthYear={'$(vCurrMonth)'}, CaseStatus = {'New Defect','Existing Defect'} >}distinct CLOSED_DTTM)
May be this?
count({<CaseMonthYear={'$(vCurrMonth)'}, CaseStatus = {'New Defect','Existing Defect'} >}distinct CLOSED_DTTM)
Perfect, thanks!!