Two dimensional filter to show Status instead of count

[Geetha Bhat]

Hi,

I have a requirement to see the status of various project for various different activities. I am using two dimensional Filter for this. However I get the count instead i want status like In progress, Done etc. Is this achievable? If yes solutions please.

[Jack Brickey]

Set you x-axis to Status. You have two axis to work with so choose the fields you want to report on in the x/y axis.

[Geetha Bhat]

Hi Jack,

thanks for your response. From the screenshot in my original email I would like project name ( Desktop) in Y-Axis and the activities ( like comms, EDG etc) on X-axis and instead of the count 1, I need status . So at the end it should read for each project what is the status of the activities. Ex: For Project desktop, EDG is “in progress “ instead of 1, for project Desktop Comms is “completed” instead of 1. Is this achievable ?

[Nic Brough -Adaptavist-]

You can't do this because it does not make sense.

The point of the 2d statistics is that it shows you what issues have <field 1> and <field 2>.  The number is there to tell you how many match each combination.

Imagine you have 3 issues that match EDG and Desktop.  These could easily be in three different status.  So if you wanted the status, the result would need to display, um, nonsense, because it would have to show all three issues being in the same status but not.

As Jack says, you need to swap one of the two axes to status if you want to use this gadget to display status.

There is one other thing you might be trying to do here, which is report on project status rather than issue.  The 2d filter gadget reports on issues, not projects.  You'll need to find or write a report or gadget that can calculate and display it from your data.

[Jack Brickey]

Nic is spot on. This would be a 3-D gadget.

you could use one 2-d per project and use status and activities.