AND-Mode Days Between Calculation

[cbaqir]

I am currently using the AND-Mode option but I noticed that while the correct ticket (DEFECT_ID) numbers are showing, the calculation between the selected dates is not.

When RES_STATUS_AND_MODE  Ready for Validation Prod and Validated Successfully Prod are selected for DEFECT_ID 11112, I should see a turnaround time of 0 days. However, When RES_STATUS Ready for Validation Prod and Validated Successfully Prod are selected for DEFECT_ID 11112, I see a turnaround time of 0 days but this is an OR selection and does not show those tickets that went through Both statuses.

The calculated expression value is 20:

SUM(
Aggr(
Max(RES_STATUS_START_DATE)- Min(RES_STATUS_START_DATE)
,DEFECT_ID)
)
/Count({$}DISTINCT DEFECT_ID)

[cbaqir]

I am trying to show a table with the associated statuses and dates but I can't figure out why they aren't showing up correctly. If I have selected 2 statuses, I would want to see only those and their associated start dates. Any suggestions?

[swuehl]

Can't see how you were trying to do this.

But maybe like this

Target Prod Release Month	DEFECT_ID	RES_STATUS	Max({<RES_STATUS = $::RES_STATUS_AND_MODE >} RES_STATUS_START_DATE)	Min({<RES_STATUS = $::RES_STATUS_AND_MODE >} RES_STATUS_START_DATE)
			09/11/18	09/11/18
Sep-2018	11112	Ready for Validation Prod	09/11/18	09/11/18
Sep-2018	11112	Validated Successfully Prod	09/11/18	09/11/18

[cbaqir]

Thanks. So when I disable the Avg expression, I only see the 2 rows.