Search the JIRA 5.0.x Beta and RCs Documentation:

Index
Downloads (PDF, HTML & XML formats)
Other versions

This documentation relates to JIRA 5.0.x Beta and RCs only.
The latest official version is JIRA 4.4.x
If you are using JIRA 4.4.x either view this page in the JIRA 4.4.x documentation or visit the JIRA 4.4.x documentation home page.
Skip to end of metadata
Comment: Corrected links that should have been relative instead of absolute.
Go to start of metadata

The Two Dimensional Filter Statistics gadget displays statistical data based on a specified issue filter, in a configurable table format.

For example, you could create a filter to retrieve all open issues in a particular project. You can then configure the gadget to display the statistical data on this collection of issues, in a table with configurable axes — e.g. Assignee versus Issue Type.

What does it look like?

The Two Dimensional Filter Statistics gadget should appear as follows on the dashboard:

Adding the Two Dimensional Filter Statistics gadget to your Dashboard

  1. Go to your JIRA dashboard and click 'Add Gadget'.
  2. The 'Gadget Directory' will appear. Locate the 'Two Dimensional Filter Statistics' gadget and click the 'Add it Now' button. Then click the 'Finished' button at the bottom of the Gadget Directory.
  3. The Two Dimensional Filter Statistics gadget will appear on your dashboard as follows, ready for you to configure:
    1. 'Saved Filter'  — start typing the name of the filter, or click the 'Advanced Search' link to search for a filter/select one of your favourite filters/select a filter that you have created.
    2. 'X Axis'  — select an issue field¹ on which the X-axis will be based.
    3. 'Y Axis'  — select an issue field¹ on which the Y-axis will be based.
    4. 'Sort By'  — select how to sort the values of your selected field:
      • 'Natural' — this will use the field's native sorting order, e.g. for the "Assignee" field, the assignee names would be sorted alphabetically.
      • 'Total' — this will sort by the number of issues that match each value, e.g. for the "Assignee" field, the assignee names would be sorted by the number of issues assigned to each person.
    5. 'Sort Direction'  — select whether the field values should be sorted in Ascending or Descending order.
    6. 'Show Totals'  — select whether to show row/column totals.
    7. 'Number of Results'  — type the maximum number of rows/columns that you want the gadget to display per page.
    8. 'Refresh Interval'  — select how often you want the gadget to update the displayed activity (never / every 15 minutes / every 30 minutes / every hour / every two hours).
  4. Click the 'Save' button.
To move the gadget to a different position on the dashboard, simply drag-and-drop. You can also change the look and behaviour of the gadget.

¹ If choosing a custom field, please note that the following types of custom fields are supported by this gadget out-of-the-box: 'Group picker', 'Multi select', 'User picker', 'Select list' and 'Version picker'.

17 Comments

Hide/Show Comments

  1. Aug 28, 2009

    Anonymous

    Is it possible to use the Two Dimensional filter with a cascading select field?

    1. Aug 30, 2009

      Rosie Jameson [Atlassian Technical Writer]

      Not at this time, sorry. You may like to vote for the following: http://jira.atlassian.com/browse/JRA-6411

  2. Apr 02, 2010

    Laszlo Radics

    How hard it is to add support for a custom field type?

    In 3.13 I was able to do it by adding a 'label' Velocity template for the type, so it got rendered complete with link to the proper filter result page:

    [radicsl@giplda022 templates]$ cat view-userpickerprojectrole.vm

    #if ($!value)
      #if ($!urlPrefix)
        <a href="$

    Unknown macro: {urlPrefix}

    ">$!value.getFullName()</a>
      #else
        $!value.getFullName()
      #end
    #end

    This does not work in 4.0.2, apparently.

  3. Oct 14, 2010

    Anonymous

    I really like the Two Dimensional filter but it only shows counts of issues. Is there another Gadget that also shows a two dimensional view but instead of counts could be configured to perform other statistics (e.g. Sum of Remaining Estimate)?

    This would allow display of a gadget showing e.g. work remaining organized into a convenient 2D matrix.

    Thanks!

    1. Oct 18, 2010

      Rosie Jameson [Atlassian Technical Writer]

      Are you using GreenHopper? If so, you may find the Agile Gadget useful.

    2. Jul 19, 2011

      Anonymous

      Yes this is exaclty what I'm also looking for. I don't use Greenhopper. I just want to have a Pivot-Table that shows e.g. Assignee (Developer) and any other criteria (could be labels, project-components,...) and then see the remaining efforts in the table. With a good filter this helps for planing and controlling a project(part).

    3. Oct 14, 2011

      Aldeep

      Hi,

      Did you managed to accomplish this?

      Thanks

  4. Jan 11, 2011

    Anonymous

    I am missing something on this step:  'Saved Filter'  — start typing the name of the filter, or click the 'Advanced Search' link to search for a filter/select one of your favourite filters/select a filter that you have created.

    I don't have any filters.  My advanced search shows nothing.  I keep getting the error message:No project or filter specified.

    As far as I can tell, there is no place for me to put a project.

  5. Aug 23, 2011

    Jason Keglovitz

    The 2-D statistics gadget is excellent.  I'd love to be able to use other summable fields beyond issue count such as story points.  Is it possible for me to customize/fork the gadget to add this functionality? 

    1. Oct 06, 2011

      Aaron Steele

      I agree, this would be a fantastic feature!!! We are trying to do something similar and because we can't use the gadget, we are having to get reports directly out of the planning board. Any thoughts would be very much appreciated. Thank you.

  6. Oct 21, 2011

    Anonymous

    This filter is working well for me except for one thing: when I try to click on the actual numbers within the table I get a message that says "there is no current active search" (instead of seeing the issues I'm expecting to see).  It looks like this is happening because the results for the X-axis have brackets added to them - that is, instead of seeing "apples" the X-axis is being displayed as "[apples]".  Any way I can remove those brackets other than manually removing them every time I want to drill down? 

  7. Nov 11, 2011

    Anonymous

    Why has the functionality of this gadget changed between Jira 3.x and Jira 4.4. I have migrated to 4.4 and the existing gadget performs differently.  The gadget has a seperate mulit-select custom variable as both the x and the y fields. In Jira 3.x  gadet provided a sum of the items applicable to a single item of the multi-select box. In Jira 4.4 it provides a sum of teh number of instances when the same set of items are selected in the multi-select box.

    If one issue has a variable with A & B selected, teh gadget returns one record for [A];[B] instead of two records; one for A and one for B.

  8. Nov 15, 2011

    Anonymous

    When using this gadget and drilling down to issues it seems that JQL gets messed when using scandic letters. for example:

     

    project = xxxx AND "Tehtävän tarkenne" = "Dashboard/Välilehti" ORDER BY "Tehtävän tarkenne" ASC, status DESC

     

    should be

     

    project = xxxx AND "Tehtävän tarkenne" = "Dashboard/Välilehti" ORDER BY "Tehtävän tarkenne" ASC, status DESC

     

    is there any solution to this? I knoww if I change custom fields and description to not include scandic letters it should work, but then meaning of those fields is not the same. It is not Finnish.

     

    Please advice

  9. Jan 18, 2012

    Anonymous

    Any progress on summable fields and additional filters? It would really be great if JIRA was able to do computation on its own instead of forcing us to use Excel to consolidate information...

  10. Feb 02, 2012

    Anonymous

    Hi,

    I don't have the 'Add Gadget' option on my Dashboard. How do i get it available?

    1. Feb 02, 2012

      Giles Gaskell [Atlassian Technical Writer]

      Hi there,

      It might be because you are using JIRA's default dashboard, which is only configurable by JIRA administrators.

      To add gadgets to a dashboard, you need to create your own dashboard(s) first (see Managing Multiple Dashboard Pages for details). You should then see the Add Gadget button at the top right of your dasboard(s).

      If you don't, then I'd suggest having a look at our Getting Help page (especially if you need to contact Atlassian Support).

      Cheers,

      Giles.

      1. Feb 03, 2012

        Anonymous

        Many thanks - yes i was using the default dashboard