I have a requirement to show avg number of days from when a generic build resource is populated to when a named resource is populated.
Generic resources = RESOURCE with a "_" in the name like charges_builder.
Requirement: IGNORE generic name of ccl_consult
Requirement: if no "_" (generic) resource, use start date of COMMITTEE_CAT = "ERC - Assigned" to first date name is populated
One DEFECT_ID could have multiple generics or multiple names for each RESOURCE_TYPE
For example, DEFECT_ID 10811 should show the avg days from ClinDoc Resource and Primary Assignee (even though both happen to be the same name here). I would like to see two values since there are two RESOURCE_TYPES and is should count from the 7/31 date NOT 7/19.
How do I write the expression to give me the time that a specific RESOURCE_TYPE went from generic to named?
!Thanks Sunny... but something looks off when I pull that in. Here's another version using a Cyclic Group (cResourceTypeResource).
If you select CCL Resource and then a person, the result confuses me.
I think your screen shot was meant for someone else.
Perhaps I was using the wrong fields.
What I need is the avg days for EACH Generic *-* resource until a name was populated other than *-*.
For 6602, I would need one value for CCL Resource, ClinDoc Resource, Enterprise Clinical Informaticist, MPage Resource, Primary Assignee and Rules Resource.
Right now, I only see one calculation for the entire ticket.