How can I have a Filter with Costs, of a subset of issues?

[Rita Araújo]

Problem

I need to have a filter with all the cost cards of a subset of issues.

I need to filter my issues (by date, status etc), but i want to see the associated costs instead of the filtered issues.

For example: I want all the costs cards of the issues from project x , in status Done, of the last month.

[Danut M _StonikByte_]

Hi @Rita Araújo,

Try the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app.  

It allows you to calculate the sum of a numerical field (like Cost) for the issues in a filter and split it by various fields like Status, Project or Creation Date. Just like you do it in tools like Microsoft Excel, and the data will be in real time.

The result can be displayed as a table, heat-map table or charts of various types.

You can start with a free 1-month trial. If you need any help, please contact us at support@stonikbyte.com.

Hope this helps.

Danut

[Michal Switala (Appfire)]

Hi Rita,

I have came up for you with the following JQL query which you can add as a filter in your Jira, could you just clarify what are costs cards ? so I can add them into query as well : 

project = SSP AND status = Done AND created >= 2024-05-01 AND created <= 2024-05-31 ORDER BY created DESC

Thanks,

Michal Switala

[Rita Araújo]

Hello that query I already have (that is the easy part).... but I need to see the linked cost issues not the issues itself. My Costs are linked as "Cost assessed by" to the Task.

[Michal Switala (Appfire)]

Hi Rita,

In this case I would suggest using Timeline, what do you think ? it will show linked issues.

[Rita Araújo]

Hello thank you for for help, but we want to extract that info and have a clear vision of our costs, so timeline is not the best solution in that case.