Hi everyone, I'm trying to figure out the date variance of a request (Issue), to when it was resolved into a project. My text mode skills are super-basic and this is what I've come up with:
aggregator.function=AVG
aggregator.namekey=datevariance
aggregator.valueexpression=WEEKDAYDIFF({entryDate},{resolveProject:entryDate})
aggregator.valueformat=HTML
description=Entry date - Resolve project Entry date
displayname=Entry variance
namekey=datevariance
textmode=true
valueexpression=ABS(WEEKDAYDIFF ({entryDate},{resolveProject:entryDate}))
valuefield=dateVariance
valueformat=
Have I missed something? Is this possible? *I've tried to report on Actual Completion Date of the issue, but its not quite the results I'm looking for. Thank you, Ruby Aran Investors Group Financial Services Inc