Adding the Two-Dimensional Filter Statistics Gadget

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. 'Number of Results'  — type the maximum number of rows that you want the gadget to display per page
    7. 'Refresh Interval'  — select if you want the gadget to update automatically.
  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 behavior of the gadget.

Notes about the 'X Axis' and 'Y Axis' variables:

  • 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'.
  • If you are using JIRA Agile with JIRA:
    • JIRA Agile 6.7.1 or later is required to choose the 'Sprint' field as a variable. Also, be aware that issues can span more than one sprint, so the total issues per sprint may not sum up to the total number of unique issues.
    • JIRA Agile 6.7.4 or later is required to choose the 'Epic Link' field as a variable.

Was this helpful?

Thanks for your feedback!

49 Archived comments

  1. User avatar

    Anonymous

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

    28 Aug 2009
    1. User avatar

      Rosie Jameson [Atlassian]

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

      30 Aug 2009
  2. User avatar

    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.

    02 Apr 2010
  3. User avatar

    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!

    15 Oct 2010
    1. User avatar

      Rosie Jameson [Atlassian]

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

      19 Oct 2010
    1. User avatar

      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).

      19 Jul 2011
    1. User avatar

      Aldeep

      Hi,

      Did you managed to accomplish this?

      Thanks

      14 Oct 2011
  4. User avatar

    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.

    11 Jan 2011
  5. User avatar

    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? 

    23 Aug 2011
    1. User avatar

      Aaron

      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.

      06 Oct 2011
    1. User avatar

      Gary Lam

      I would like this feature as well. We heavily use story points for estimation on our development tasks. However, we would like to see the aggergate results of the current workload of all members.

      When will this feature avaiable?

      26 Jul 2012
    1. User avatar

      Edwin Stol

      +1. Is there a feature request for this?

      22 Aug 2012
  6. User avatar

    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? 

    21 Oct 2011
  7. User avatar

    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.

    11 Nov 2011
  8. User avatar

    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

    15 Nov 2011
  9. User avatar

    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...

    18 Jan 2012
    1. User avatar

      Anonymous

      Where can I vote for this functionality? I need some thing to display the sum of story points against a set of predefined labels. I can’t select story points in the two dimensional statistics gadget. Is there perhaps some other gadget that suits my needs?

      29 Feb 2012
      1. User avatar

        Anonymous

        +1 from me as well. Would be great to have the Excel Pivot-Magic integrated in this Gadget, there would be so many usecases for this!

        03 Jul 2012
      1. User avatar

        Matt Doar (ServiceRocket)

        Submit a New Feature at jira.atlassian.com/browse/JRA and add a link to it here so people can vote for it. I've modified gadgets before and it was trickier than I expected.

        16 Aug 2012
        1. User avatar

          Matthew Zach

          Done. 

          JRA-38111 - Sumable custom field in dashboard widget Open

          31 Oct 2012
  10. User avatar

    Anonymous

    Hi,

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

    02 Feb 2012
    1. User avatar

      Giles Gaskell

      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.

      02 Feb 2012
      1. User avatar

        Anonymous

        Many thanks - yes i was using the default dashboard

        03 Feb 2012
  11. User avatar

    Royce Wong

    I wish this gadget would accept date as a dimension and can do a group by day/week/month on it.

    I've been asked by so many of my users to display filter by month. The only gadget can group by date that I am aware of is the Recently Created Issues Report, or is there another gadget can do that?

     

    15 Mar 2012
  12. User avatar

    Wendy Fergusson

    I need to display the two-dimensional filter statistics as a bar graph. Is there any way to do that?

    27 Mar 2012
    1. User avatar

      Matt Doar (ServiceRocket)

      Bar graphs usually have just one dimension. Can you add a link to an example bar graph with two dimensions?

      16 Aug 2012
      1. User avatar

        Wendy Fergusson

        Like this: Chart Macro#BarChart The bar graph has multiple series, which are graphed either as side-by-side groups of bars or stacked bars.

        I need to create quite a few reports like this, which I'm currently doing using a custom macro which queries data out of a database, and then feeding the raw data into the Confluence chart macro. But it would be much simpler if the two-dimensional filter statistics gadget could just graph the results.

        20 Aug 2012
  13. User avatar

    Anonymous

    I want to add this gadget to a WallBoard.   Is there any way to adjust the column width?

    16 May 2012
  14. User avatar

    Anonymous

    I have added the 2-D filter statistics gadget to my wiki page but need the syntax to bring in my data.  Anyone know how to do that?

    29 May 2012
  15. User avatar

    Anonymous

    Is it possible to change the header for a gadget? For instance, I am using JIRA's "Two Dimensional Filter Statistics" gadget and it always shows the gadget name in the header section. Is there a way we can get rid of the name from the header?

    29 Aug 2012
    1. User avatar

      Matt Doar (ServiceRocket)

      Not without recompiling the gadget I think

      29 Aug 2012
  16. User avatar

    Anonymous

    Hello,

    My name is lakshmi. I am trying to create a Two Dimensional Filter Statistics. Insted of count i want last updated date into that. Can anyone help me on this.

    18 Sep 2012
    1. User avatar

      Matt Doar (ServiceRocket)

      Is that the last updated date of all the issues that would appear in the JQL query that the count is a link to.

      It's surprisingly hard to extend and modify the standard gadgets. I usually end up copying all of the source for the gadget and many other classes and moving it to a new package. You may also need a different kind of StatisticsMapper in the searcher class for the field. Not a trivial piece of work.

      ~Matt

      18 Sep 2012
  17. User avatar

    Anonymous

    Hi Matt,

    Thanks for quick response. if you have any example can you please share with me.

    Thanks

    Lakshmi

    19 Sep 2012
    1. User avatar

      Matt Doar (ServiceRocket)

      There's more information about this in "Practical JIRA Plugins", O'Reilly

      19 Sep 2012
  18. User avatar

    Anonymous

    Hi,

    is there any way to find the Date format in PST or specified time zone

    thanks

    28 Sep 2012
  19. User avatar

    Raiza Martins Dias

    When we scroll down the upper menu desappear so we can't see what each column means. This is really a problem when you have many columns.

     

    14 Mar 2013
  20. User avatar

    Anonymous

    What should I fill in the blank "Numeric Field"?

     

    21 May 2013
  21. User avatar

    Anonymous

    I created a filter in jira with name ABC_1234_dce. when i'm inserting Two Dimensional Filter Statistics macro in confluence wiki the filter name drop down button is not showing the filter i created(ABC_1234_dce). But when i changed the filter name ABC_1234_dce to ABC_dce_1234 it is showing in drop down button. is there any problem with filter naming conventions including numeric?

    23 Aug 2013
  22. User avatar

    Gayatri T

    I created a filter in jira with name ABC_1234_dce. when i'm inserting Two Dimensional Filter Statistics macro in confluence wiki the filter name drop down button is not showing the filter i created(ABC_1234_dce). But when i changed the filter name ABC_1234_dce to ABC_dce_1234 it is showing in drop down button. is there any problem with filter naming conventions including numeric?

    29 Aug 2013
  23. User avatar

    Anonymous

    How do I change the column order?

    Below is the default column order.  

    AssigneeStatus
    OpenOpenIn ProgressIn ProgressClosedClosedValidationValidationTo DoTo DoT:
    doe,john005106
    doe,john100001
    doe,john000202
    doe,john000011
    doe,john110002
    Total Unique Issues:

     

    How do I make it look like this?

     

    AssigneeStatus
    OpenOpenTo DoTo DoIn ProgressIn ProgressValidationValidationClosedClosedT:
    doe,john005106
    doe,john100001
    doe,john000202
    doe,john000011
    doe,john110002
    Total Unique Issues:
    29 Oct 2013
    1. User avatar

      Jeff Peters

      Column order is based on the configured Status order.  Consult with your JIRA Administrator and ask him/her to make the needed changes.  This link (Defining Status Field Values) will help the individual find this area if needed.  The ask the admin to use the arrows in the Order column to adjust the statuses per you needs.

      17 Jun 2015
  24. User avatar

    Artur Shokin

    How can the the rows or columns with zero values be shown in 2 Dimentional Report? In the screen shot therer is a column Edwin Wong, which contains only "0". 

    When I'm trying to do the same report for the defect, the Zero-Columns would not show...

    Is there any possibility to fix it? 

    13 Feb 2014
  25. User avatar

    Anonymous

    I have the same issue of columns not showing up in the table that have '0' value. Is there any resolution around it.

    Also how can we control the order in which the columns can be displayed. Currently the default order is alphabetical.

    13 Feb 2014
  26. User avatar

    Abyakta Lenka

    Hi ,

    I am trying to add Epic link or Epic name in the Two Dimensional filter , Its not coming in the x Axis or Y axis.

    When I am trying to add the same in the filter , it comes as none in the value.

    Can we accomplish this any way.

    22 Jul 2014
  27. User avatar

    Chris

    This gadget is not shown in my JIRA 6.4.1 installation - any idea why? Neither can I find it on the market place.

    06 May 2015
  28. User avatar

    Lewis Campbell

    The only way to "title" this chart as such is via the Filter name...the title is always e.g. "Two Dimensional Filter Statistics by Priority"

    Is there anyway to replace this with a custom title?  (If not, imho, one of the major flaws of an otherwise great tool...!)

    22 Jun 2015
  29. User avatar

    Mayur Ingale

    Not able to select the date field (Created or any date & time custom field)... please help me to get this done for 2D gadget.

    26 Jun 2015
Powered by Confluence and Scroll Viewport