Get Aging Request | Community
Skip to main content
A
A_EN
Level 4
April 28, 2023
Solved

Get Aging Request

  • April 28, 2023
  • 1 reply
  • 739 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by A_EN

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

1 reply

A
A_ENAuthorAccepted solution
Level 4
April 28, 2023

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

    Terms & ConditionsAccessibility statement

    Loading footer...