


Dear All,
I have report that sums up notes made over time and would like to see it sum up by Owner Home Team Name. Home Team ID is the only option available for grouping. Does anyone know if this is possible? Obviously Id like the simple chart to work with text mode Team Name Grouping.
Kind regards,
Lukasz
Solved! Go to Solution.
Views
Replies
Sign in to like this content
Total Likes
Hi,
This is why we have a User custom form attached to each user with calculated fields, such as "Home Team Name" and "Home Group Name".
See the calculations below for these fields.
Views
Replies
Sign in to like this content
Total Likes
Hi,
This is why we have a User custom form attached to each user with calculated fields, such as "Home Team Name" and "Home Group Name".
See the calculations below for these fields.
Views
Replies
Sign in to like this content
Total Likes
Hi Femke
Do you mean the user form needs to include a dropdown with list of teams?
Thanks
Lukasz
Views
Replies
Sign in to like this content
Total Likes
Hello!
Switch to text mode and there will be a few Home Team IDS. In each, backspace over "ID" and add ":name", that's colon, lower case name. That will witch the long id out for the name.
Views
Replies
Sign in to like this content
Total Likes
Suzy, you're spot on!
Here's the official message from Adobe Workfront in the form of a Blog post:
Good luck Lukasz!
Views
Replies
Sign in to like this content
Total Likes
Hi All,
I tried text mode before but without success
Text mode works for details tab but not for the chart and I cant figure why. I wanted to have record count broken by the team name.
My current text mode setup is:
Report Type: Note
Column setup:
displayname=Owner Home Team
linkedname=direct
namekey=owner:homeTeam:name
querysort=owner:homeTeam:name
textmode=true
valuefield=owner:homeTeam:name
valueformat=HTML
Groupings setup:
textmode=true
group.0.namekeyargkey.0=owner
group.0.namekeyargkey.1=homeTeam
group.0.namekeyargkey.2=name
group.0.valuefield=owner:homeTeam:name
group.0.iscollapsed=true
group.0.valueformat=string
group.0.namekey=view.relatedcolumn
group.0.linkedname=owner
Ill try to check on Femke solution but would prefer to avoid adding a calculated field for something which already exist in the system. Any clues will be appreciated.
Thanks!
Lukasz
Views
Replies
Sign in to like this content
Total Likes
Hey Lukasz,
Ahh, that makes more sense for what you want to do.
Text mode in a grouping does not translate over to the chart. The chart object in Workfront uses fields only, it can't utilize the text mode.
The best option would be to create a user custom form with a calculated field that shows the user's home group name, then use that field for your grouping, and you'll be able to use it in your chart.
The calculated field should be pretty simple, with the calculation being something like '{homeGroup}.{name}' if I recall it correctly.
Good luck!
Views
Replies
Sign in to like this content
Total Likes
Tried this and it works perfectly!
Thanks Everyone