Chart grouping by days the task was open

Question

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!

skyehansen · Accepted Answer

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)

NicholeVargas · Answer

@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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded