Report on Counts in TeamDynamix

Environment

TeamDynamix ITS Ticketing Application Reporting 

TeamDynamix.umich.edu -> Users-> Tickets-> Reports - > New Report

Issue

How do I get a report that includes item totals (like number of  closed tickets about a Service or number of a type of asset in use)

Resolution

when building a report, use one of the 

Tickets

• Active Task Count
• Asset/CI Count 
• Assignment Count 
• Attachment Count   
• Children Count   
• Source Control 
• Ticket Count    - use this to aggregate tickets, do NOT select any columns that could be unique on every single ticket such as ID

Knowledge

• Article Count    Article Count  
• Asset/CI Count    Asset/CI Count 
• Associated Services Count    
• Associated Tickets Count
• Attachment Count 
• Display Request Service Button Count   
• Total Feedback Count 
• Unaddressed Feedback Count  

Location

• Location Count 
• Room Count 

Location Rooms

• Room Count

Tasks

• Task Count

Asset

• Article Count  
• Asset Count    - use this to aggregate assets by values such as model, status, location or manufacturer, don't include columns that would be distinct for each asset (like Serial Number)
• Contract Count   
• Ticket Count    
• User Count   
• Using Acct/Dept Count  
• CPU Logical Cores   
• CPU Physical Cores    
• CPU Sockets   
• Discovered Asset User Count   
• IP Address Count  
• MAC Address Count  

Configuration Item

• Article Count    
• CI Count  

Additional Information

From: https://solutions.teamdynamix.com/TDClient/1965/Portal/KB/ArticleDet?ID=1993

When building reports using the custom report builder page, many people want to make a report which is a count of items by some sort of common field(s). For instance, you might want to see [Item]s By Type or [Item]s By Creator. This is a fairly simple report to build.

Each report source has an [Item] Count field which is selectable. For instance, this might be Ticket Count. All you would need to do is to select the fields you want to see counts grouped by as well as the count field. For instance, to create a report of ticket count by type and account, you would select the following fields:

• Type
• Acct/Dept
• Ticket Count

This would show counts based upon unique combinations of both Type and Acct/Dept. You could add or remove fields used in conjunction with the count field depending on your reporting needs.

The main thing to remember is that for a count report to work, you cannot include a field whose value will be unique on every single item. If you do, you will see a row for every item and a count of 1. Item ID, for example, would not be a good field to include in a count report as is always unique.

Report Charts

Charts do not group the data chosen for name/value differently than the actual report data table. The charts really only work well for a two column approach. If three or more columns are selected in your report, the charts may show duplicated data.

Need additional information or assistance? Submit a request here ITS-TeamDynamix Support.