Custom graphical report with Team workflow states | Targetprocess - Visual management software

Custom graphical report with Team workflow states

This article is obsolete for On-demand accounts. Please see our guide section on how to create Visual Reports.  

Q: How do I create a custom graphical report with team states on the axis?

Our cards are assigned to team and team iterations. The team has team workflow states for user stories and bugs in the projects' process. The project state report is perfect for reporting to management, but the team has some reports that we want more detail in by using the team workflow states.

The problem is, that when I use EntityState for the axis, it uses the project workflow state.

A: It is possible to build a custom graphical report with team states. Key point there is to use Team Assignment as data source in the report setup.

Team Assignment

Let's build a basic report showing count of entities per team states in selected teams. Here's the setup we'll apply:

Data source: Team Assignment
X: Count
Y: Team > EntityState
Filter for EntityState property: ?it is not None

We'll get the report shown below:

Team Entity State report


It is possible to exclude some states. Let's hide bars for done items. We'll apply the following filter to the EntityState field:

?it is not None and isFinal is false

It is possible to show types of entities on this chart. We'll put the following rule to Color field:


Team Workflow States report Filters

The report now shows types of entities.

Entity Types colored

It is possible to exclude entities of some types. Let's exclude test plans and test plan runs for example. We'll apply the following filter to the Color: Assignable.EntityType field:

?not (it is 'TestPlan') and not (it is 'TestPlanRun')

Names of entity types must be used without spaces between words there.

And let's switch a report from Stacked to Bar mode. We'll get the following:


Still have a question?

We're here to help! Just contact our friendly support team

Email us
The more details you can give us the better
Live chat
Prefer instant messaging? Try our live chat
Service Desk
Add tickets, comments and track status in our Helpdesk
Slack Community
Shape the future direction of Targetprocess

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.

Start your free trial

Enter your email
By clicking "Continue", you acknowledge and agree that we will process your personal data in accordance with our Service Privacy Policy and Terms of Service.

We’ve sent you a confirmation e-mail — please, go check it.

Or get a live
product demo