Documentation for JIRA 6.3 EAP developer (EAP) releases only. Not using this? See below:
(JIRA 6.2.x documentation | JIRA OnDemand documentation | earlier versions of JIRA)

Skip to end of metadata
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 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 behavior 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'.

44 Comments

  1. Anonymous

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

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

  2. 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. 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. Are you using GreenHopper? If so, you may find the Agile Gadget useful.

    2. 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. Hi,

      Did you managed to accomplish this?

      Thanks

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

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

    3. +1. Is there a feature request for this?

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

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

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

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

        1. Done. 

          GHS-6477 - Sumable custom field in dashboard widget Open

  10. Anonymous

    Hi,

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

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

        Many thanks - yes i was using the default dashboard

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

     

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

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

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

  13. Anonymous

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

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

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

    1. Not without recompiling the gadget I think

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

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

  17. Anonymous

    Hi Matt,

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

    Thanks

    Lakshmi

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

  18. Anonymous

    Hi,

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

    thanks

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

     

  20. Anonymous

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

     

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

  22. 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. 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:
  24. 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? 

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