Jira product discovery filter - xls export

Caroline_Muon July 9, 2024

When I create a filter with Jira Product Discovery, fields with formulas do not show up in my xls export.
How do I get them into an xls export?
Thanks

3 answers

2 accepted

0 votes
Answer accepted
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 10, 2024

There is a fairly easy solution (two actually!) for this with the Better Excel Exporter app!

Options:

  1. Create a new Excel template, and add your JPD formulas as Excel formulas to the template. That way, every time when you export, the Excel formulas will be inserted to the exported Excel file and they will be evaluated normally. (You will basically duplicate your formulas in the template, but you only have to do this once!)
  2. Define a calculated field and implement your formula in Groovy code. When the value of the field is inserted to the exported file, the Groovy formula will be evaluated, that's it. (You will basically duplicated your formulas in Groovy, but assuming that your formulas as fairly simple arithmetic, the Groovy code should be trivial.)

(Discl. it's a paid and supported app developed by our team. Free for 10 users!)

0 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 9, 2024

Hi @Caroline_Muon 

That is not possible yet.  Please see this other question with the response from the JPD team:

https://community.atlassian.com/t5/Jira-Product-Discovery-questions/Exporting-Data-in-Jira-Product-Discovery-issues-with-Formula/qaq-p/2248594

Kind regards,
Bill

Caroline_Muon July 10, 2024

@Bill Sheboy 

Thank you for your reply
Hope that the formulas will soon be integrated into the exports 🙂

Like Bill Sheboy likes this
0 votes
Amina Bouabdallah
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 12, 2024

Hi there!

What formulas are you using? Just tried formulas in my JPD project and did an export, I can see the values!

If you have more details, it might help to diagnose.

Thanks!

Caroline_Muon July 19, 2024

If you extract the data from the project, the formulas are included in the export, if you extract from the filters, the formulas are not included in the file.
For my using, I need to export with filters.

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events