Skip to main content
ChloeWY
Level 6
Jun 19, 2025 5:56 PM UTC
Solved

Chart grouping by days the task was open

Hi all!

I feel like I'm missing something simple here, but I can't figure out what.

I want to create a chart on a task report that shows how many days the tasks were open.  I don't want duration.  I want the work day difference between the planned start date and the actual completion date ("days open").

I was able to use text mode and valueexpression to create a column that shows this "days open" calculation.  

My struggle now is I can't get it to show up in the drop downs on the chart to select it as a grouping.

I even created a text mode grouping to group by "days open".

Any ideas?  Or is what I'm trying to do not possible?

Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
skyehansen
skyehansenAccepted solution
Jun 19, 2025 9:43 PM UTC

If I’m reading this correctly, in order to make a chart you need to use actual fields (either custom fields or default workfront fields will work but textmode calculations will not)

6 replies

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community AdvisorAccepted solution
Jun 19, 2025 9:43 PM UTC

If I’m reading this correctly, in order to make a chart you need to use actual fields (either custom fields or default workfront fields will work but textmode calculations will not)

Translate
NicholeVargas
Adobe Employee
Adobe Employee
Jun 19, 2025 11:23 PM UTC

@chloewy You have to create a task custom field (with the format = Number) for Days Open and use that in your report grouping. Charts cannot read text mode in Workfront, so the field in your grouping would have to be selected from the library and be either a native or custom field like @skyehansen mentioned.

If you already have a task custom form that is associated with all tasks, I'd recommend adding the Days Open field there. If not, you'll want to bulk edit all tasks or project templates so that you can automatically capture this data moving forward. 

 

 

Translate
ChloeWY
ChloeWYAuthor
Level 6
Jun 23, 2025 12:44 PM UTC

@skyehansen @nicholevargas thank you both!

Translate
ChloeWY
ChloeWYAuthor
Level 6
Jul 2, 2025 3:55 PM UTC

Hi @skyehansen and @nicholevargas ,

I'm looking at this again.

I changed the project to be a request queue, so the custom form can be automatically attached to all requests as they're created.

I tried making a custom field on said custom form to calculate the days open, and I'm stuck.

I have a calculated custom field with the format of number.  Here's a screenshot.

I can't get my custom field to work.  It keeps showing N/A. 

Do either of you have any ideas?  Thank you so much!

Translate
skyehansen
Adobe Champion and Community Advisor
Jul 2, 2025 5:21 PM UTC

I think SUB just does numbers. Did you try DATEDIFF?

Translate
ChloeWY
ChloeWYAuthor
Level 6
Jul 3, 2025 2:20 PM UTC

That did it!  Thank you so much!

Translate