Chart grouping by days the task was open

[ChloeWY]

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 solution]

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]

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

[ChloeWY]

@skyehansen @NicholeVargas thank you both!

[ChloeWY]

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!

[skyehansen]

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

[ChloeWY]

That did it!  Thank you so much!