Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New Table by Status type

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!

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

May be this?

count({<CaseMonthYear={'$(vCurrMonth)'}, CaseStatus = {'New Defect','Existing Defect'} >}distinct CLOSED_DTTM)

View solution in original post

2 Replies
vishsaggi
Champion III
Champion III

May be this?

count({<CaseMonthYear={'$(vCurrMonth)'}, CaseStatus = {'New Defect','Existing Defect'} >}distinct CLOSED_DTTM)

Not applicable
Author

Perfect, thanks!!