Converting Nested Task List Column to a count | Community
Skip to main content
T
thisisxeney
Level 2
November 4, 2022
Solved

Converting Nested Task List Column to a count

  • November 4, 2022
  • 2 replies
  • 1025 views

Hello,

 

I am looking to convert a nested task list that I created to show tasks that are in progress or new on a project report that shows non compliant programs.

 

displayname=Late Tasks
listdelimiter=<p>
listmethod=nested(tasks).lists
querysort=plannedCompletionDate
sortOrder=1
sortType=asc
textmode=true
type=iterate
valueexpression=IF({numberOfChildren}=0&&{status}='NEW',CONCAT("NEW - ",{name},' - ',{percentComplete},'% - ',{plannedCompletionDate},' - ',{progressStatus}),IF({numberOfChildren}=0&&{status}='INP',CONCAT("IN PROGRESS - ",{name},' - ',{percentComplete},'% - ',{plannedCompletionDate},' - ',{progressStatus})))
valueformat=HTML

 

I am looking to have this list converted over to a count instead of a list. Here is what I have tried but it comes up empty:

 

displayname=Late Tasks
listdelimiter=<p>
listmethod=nested(tasks).lists
querysort=plannedCompletionDate
sortOrder=1
sortType=asc
textmode=true
type=iterate
valueexpression=COUNT({numberOfChildren}=0&&{status}='NEW',{numberOfChildren}=0&&{status}='INP')
valueformat=HTML

 

Can someone help me with getting this count to work?

 

Thank you,

David

 

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 William

Counting functions are extremely limited in Workfront native reporting, and there is no way to do what you are trying to do in a view. 

I suggest reviewing the documented Calculated data expressions article to see what functions are available to use - you won't find "COUNT" in that list. 

The only way to generate counts (other than using the basic taskCount, opTaskCount, and openOpTaskCount fields which are tracked on project records) is to create a Task Report, group the tasks according to how they should be counted, then use the Summary tab of the report to see the count values. 

Good luck!

2 replies

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
November 4, 2022

are you able to cite the documentation where you found the ability to use COUNT? For example, I usually go to this link:

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions.html?lang=en

 

to get my commands. I don't find it on there, but I do wonder if maybe you stumbled on and started accidentally using fusion commands in wrong space?

William
Community Advisor
WilliamCommunity AdvisorAccepted solution
Community Advisor
November 8, 2022

Counting functions are extremely limited in Workfront native reporting, and there is no way to do what you are trying to do in a view. 

I suggest reviewing the documented Calculated data expressions article to see what functions are available to use - you won't find "COUNT" in that list. 

The only way to generate counts (other than using the basic taskCount, opTaskCount, and openOpTaskCount fields which are tracked on project records) is to create a Task Report, group the tasks according to how they should be counted, then use the Summary tab of the report to see the count values. 

Good luck!

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
Terms & ConditionsAccessibility statement

Loading footer...