


Hi WF Community,
I'm trying to make a report to get the aging of the request. This will count the number of days until the request status changes to resolved, at which point it will stop counting the number of days. Tried the text mode below but doesn't give me any results.
aggregator.displayformat=HTML
aggregator.function=AVG
aggregator.namekey=datevariance
aggregator.valueexpression=ROUND(DATEDIFF($$TODAY,{entryDate}),0)
aggregator.valueformat=HTML
description=Aging Tickets
displayname=Aging Days
textmode=true
valueexpression=IF({status}="INP",ROUND(DATEDIFF($$TODAY,{entryDate}),0))
valueformat=HTML
Views
Replies
Sign in to like this content
Total Likes
I think I got it.
aggregator.displayformat=HTML
aggregator.function=AVG
aggregator.namekey=datevariance
aggregator.valueexpression=ROUND(DATEDIFF($$TODAY,{entryDate}),2)
aggregator.valueformat=HTML
description=Aging Tickets
displayname=Aging Days
textmode=true
valueexpression=IF({status}="INP",ROUND(DATEDIFF($$TODAY,{entryDate}),2),IF({status}="NEW",ROUND(DATEDIFF($$TODAY,{entryDate}),2),ROUND(DATEDIFF({actualCompletionDate},{entryDate}),2)))
valueformat=HTML
I think I got it.
aggregator.displayformat=HTML
aggregator.function=AVG
aggregator.namekey=datevariance
aggregator.valueexpression=ROUND(DATEDIFF($$TODAY,{entryDate}),2)
aggregator.valueformat=HTML
description=Aging Tickets
displayname=Aging Days
textmode=true
valueexpression=IF({status}="INP",ROUND(DATEDIFF($$TODAY,{entryDate}),2),IF({status}="NEW",ROUND(DATEDIFF($$TODAY,{entryDate}),2),ROUND(DATEDIFF({actualCompletionDate},{entryDate}),2)))
valueformat=HTML