Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Field With Logic - showing all options on chart

Avatar

Level 8
Hello! We have a form with a field called "Departments". In this field is an "Other Functions" choice and if this is chosen, we have logic build in to list additional choices. We have a report to show all active projects by department and it's group by the "Departments" field and status. On the chart, "Other Functions" is showing; is there a way to show the additional choices provided by the logic on the chart? Wendy White AmeriCredit Financial Services, Inc. dba GM Financial
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 10
You can calculate a department field on your custom form. If your fields are: Department - CX - Operations - Other - Risk Other Department - Other a - Other b - Other c Your "Calculated Department" field calculation would be something like this: IF(Department="Other", Other Department, Department) You can then group your results by the calculated department value. Narayan Raum Senior System Admin, Solution Architect & Delivery Lead of Workfront. Service & Business Manager. COE Lead. AVP Enterprise Data Governance Execution (EDGE) SunTrust Bank ------Original Message------ Hello! We have a form with a field called "Departments". In this field is an "Other Functions" choice and if this is chosen, we have logic build in to list additional choices. We have a report to show all active projects by department and it's group by the "Departments" field and status. On the chart, "Other Functions" is showing; is there a way to show the additional choices provided by the logic on the chart? Wendy White AmeriCredit Financial Services, Inc. dba GM Financial

Avatar

Level 10
Hi - Because you are using a chart, I highly recommend Narayan's approach. If it was just a list, you can go into the text mode of the groupings and put your IF statement in. But for charts, you can't touch the text mode. Anthony Imgrund FCB