How to use a table filter in Chalk around a Jira Issue/Filter?

[Michael Prewitt]

I would like to use a fairly robust filter, suck as the "Table Filter" around a "Jira Issue/Filter"?

[Michael Prewitt]

Sorry it took me so long to get back to you.   Got the charting and the pivot-tables working.  Thank you for your help

[Michael Prewitt]

I have two Jira Issue/Filters (one for open Jira ticket using the "Unresolved"  status  and one for closed Jira ticktes using the Status field (since there seems to be many resolved and Status codes for closed tickets)    and would for each Jira filter to be able to filter on tickets in a certain date-range, on certain reporters, on certain Assignees, etc...  and would like to be able to do a pivot table so I can  graph the open tickets vs the fixed tickets vs the canceled tickets vs the not-fixed tickets, etc...   

Also, would like to have my two front teeth and world peace...   also a new laborgini and  an all expenced paid month vacation in europe...

The last set of request is to say that what i am asking for may or may-not be obtainable...  but it's worth asking :)

[Andrey Khaneev _StiltSoft_]

That's what you can do with Table Filter and Charts add-on:

• Table Filter macro allows you to filter on date ranges, for reporters and assignees you can use dropdown filters.
• Pivot Table can create a table with number of tickets of each status. You can wrap it with Chart from Table macro to build different chart types.

Please, see links to video and demo site I posted before for details.

[Shannon S]

Michael,

I'm not familiar with Chalk. Can you let me know what you're referring to exactly? Is this an add-on or extension?

Regards,

Shannon

[Michael Prewitt]

Sorry, CHALK (Company-Name Collaboration and Document Tool) is what we call Confluence .

I didn't realize that until I started to investigating why we call it Chalk...  :)

[Shannon S]

Thank you for explaining, Michael.

Using the Jira Issues Macro you can display issues based on a search, JQL, or filter.

Can you explain what you're trying to do? By Table Filter do you mean the 3rd party add-on Table Filter and Charts for Confluence? I don't know for sure if that would work with Jira issues macro, but I did find that Bob Swift's add-on Advanced Tables for Confluence does work with it. See more information here:

• Improving the Jira issues macro with Table Plus macro

Regards,

Shannon

[Andrey Khaneev _StiltSoft_]

Table Filter is compatible with Jira Issues macro. You can watch this video tutorial.

[Shannon S]

Great, thanks Andrey! I wasn't sure. :) 

Shannon

[Andrey Khaneev _StiltSoft_]

You are welcome! Also there is a live demo site to play with Table Filter and Charts add-on if somebody interested in this.