Reporting on Topic Queues | Community
Skip to main content
BrandonNW
BrandonNW
November 5, 2018
Question

Reporting on Topic Queues

  • November 5, 2018
  • 7 replies
  • 1038 views
Happy Monday Guys! We have our Topic Queues separated by Line of Business. What we want to capture is how many requests come into which Topic Queues so we can see which LOB requires more or less resources. I see a way to filter for Queue Topics, but not Topic Queues. Is there an easy way to capture this info and I am just missing it? I can put LOB in the custom form to capture that data, but that feels a little redundant to select the LOB at the Queue level and then get to the form and select it again. Any help would be greatly appreciated... Thanks! Brandon Pritchard System Administrator iNHouse Marketing - Nationwide pritcb1@nationwide.com
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

7 replies

N
NRYNR
November 6, 2018
Hi Brandon, If you have a "Workfront Issue Management" custom form on all of your queue topics where you can define your own parameters, then you can create a calculated field to grab the topic group. Keep in mind, you can only go up one level with this as far as I know. In my case, the calculated field is named "Request Topic Group". Here's the calculation: Queue Topic.Parent Topic Group.Name I suggest using this though, because if you ever change your topic group structure, you won't want to lose that data on the issue. This will keep the parent topic group value in place if you delete it someday: IF(ISBLANK(Request Topic Group), Queue Topic.Parent Topic Group.Name, Request Topic Group)
BrandonNW
BrandonNWAuthor
November 8, 2018
I appreciate the response, but I cannot figure out to make it happen. lol. I am a beginner at this and have never used the calculated fields before. I will search thru the training and help articles for some more info on it. Thanks! Brandon Pritchard System Administrator iNHouse Marketing - Nationwide pritcb1@nationwide.com
N
NRYNR
November 8, 2018
Here's an article that will help: https://support.workfront.com/hc/en-us/articles/216652818-Using-Calculated-Custom-Data
Christina_Jarosz
Christina_Jarosz
August 13, 2019
Hey @Narayan Raum - is this calculation still correct? It won't allow me to save it. Am I missing something?
N
NRYNR
August 14, 2019
Hi Christina, make sure you create the calculated field called "Request Topic Group" and save it without the calculation added first. If you don't do that, then the form builder doesn't think a field by that name exists, causing the invalid expression. Let me know how that works out for you! Narayan Raum Workfront Delivery Lead - SunTrust Bank https://wf-pro.com for Text Mode & Solutions
Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity Advisor
Community Advisor
August 14, 2019
Christina, if you're looking for the same thing the original poster was looking for, this Workfront Cleanup Dashboard might help. It has a lot of great reports on it. Report #7 might be just what you're looking for. https://experience.workfront.com/s/article/Workfront-Cleanup-Dashboard
N
NRYNR
August 16, 2019
Hi all, To further simplify the installation of the "Workfront Cleanup Dashboard" mentioned above, @Doug Den Hoed and I packaged it up and put it in the AtAppStore for a quicker installation with no post-installation configuration necessary. "https://www.atappstore.com/App/wfpro-workfront-cleanup-dashboard/Default.aspx" Check it out here. I recommend anyone interested in testing a package deployment start here since it's a non-intrusive installation with just reports and dashboards. If you have a great report you think needs to be added, let me know and I can look at versioning it. Thanks, Narayan Narayan Raum Workfront Delivery Lead - SunTrust Bank https://wf-pro.com for Text Mode & Solutions
Terms & ConditionsAccessibility statement

Loading footer...