nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira product discovery filter - xls export

Caroline.Muon

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

Accepted answers

Bill Sheboy

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

Aron Gombas _Midori_

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

Options:

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

All comments

Bill Sheboy

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

@Bill Sheboy

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

Aron Gombas _Midori_

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

Options:

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

Amina Bouabdallah

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

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jira-product-discovery

jpd