Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to export reports from BigPicture

Hi,

Can someone let me know how to export data and reports from BigPicture JIRA application? I don't find an option to export the data from BP. I want to export resource capacity planning from BP to excel or PDF format. Appreciate your help in this. Thanks. 

3 answers

Hey, @Vinay Poosa . At "Old Street" we've created a solution that might be of some interest to what you're looking for with our add-on called Custom Charts. It gives you the ability to export data directly from a dashboard to PDF, PNG, and CSV.

Check out our interactive playground: https://www.oldstreetsolutions.com/jira-reporting-playground. Let me know if you have any questions.

I've also added some documentation for you to view over. https://ossapps.atlassian.net/wiki/spaces/CCFJ/pages/1019052416/Export+-+PNG+PDF+CSV.

1 vote
Anna-SoftwarePlant Marketplace Partner Feb 15, 2021

Hi @Vinay Poosa

You can export data from every BigPicture module with BigTemplate. Available formats are pdf, xlsx, and additionally MPP and CSV for the Gantt module. Once it’s done, it’s ready to distribute, print, send over e-mail or instant messaging. Here you can find more information. 
Please let me know if you have further questions.

Best,
Anna

Thanks @Anna-SoftwarePlant . But I need to pay additional $1000 for BigTemplate which we are not looking for. Any other alternate way to export from the BigPicture app itself or any free app to do that? Thanks.

Hi @Vinay Poosa

For this moment, BigTemplate is the only possibility to export data.
I would be grateful if you write why you want to export data. Is there any particular feature that you are missing? If yes, I am deeply interested in your feedback.

@Vinay Poosa Hi, can I ask you why you want to export data in EXCEL or PDF ? What don't you like about the resource management function that is already very good in BigPicture ? Do you have any particular need ? Maybe you can solve it by using a different plugin, which reads Jira's data, for example https://marketplace.atlassian.com/apps/1220925/custom-charts-for-Jira-reports 

@Calogero Kalos Bonasia 1st, I want to analyze the data for the plan vs actuals. 2nd, I want to export the data and integrate it with my other BI system to create a larger dashboard where I pull the data from few other systems and create a consolidated dashboard for making better decisions. 3rd, I want to see a high-level view of the capacity, meaning total % of available capacity, total % of allocations, total % of bench capacity available for the future weeks. 

If these are all possible with the BigPicture itself, please help me with the detailed steps in achieving it.

Please note that, as mentioned above, we are not willing to go for any other paid plugins to get this done. Thanks.

Like # people like this

Hi @Vinay Poosa

Thank you for the detailed explanation. BigPicture is evolving towards an “umbrella” portfolio management app. Hence, it will integrate more and more with popular issue trackers/task management software. At the moment, BigPicture can source tasks from Trello and exchange information with Atlassian plugins, such as Tempo, Portfolio for Jira, and even ScriptRunner. Sockets for Azure DevOps Server, as well as for many instances of Jira Cloud/Server, will follow. Also note, that BigPicture has an API so that you can design your custom app-to-app bridges.

Could you please share with me your opinion on which tool we should also integrate with? I am deeply interested in your feedback. I hope that in the future, BigPicture became the main BI tool.

Regarding analyzing the plan vs. actuals data, you can set Baselines and track deviations from your initial schedule. 

The Baselines can be synchronized with Jira, and the synced fields can be added to Column views or as fields to the Task / Risk Cards.

The Baselines are displayed as bold lines, showing the position of the task at the moment of creating the Baseline. See my image as a reference.

image (81).png

Like Calogero Kalos Bonasia likes this

@Vinay Poosa 

As you saw in @Anna-SoftwarePlant 's answer, BigPicture already has very powerful features inside. My advice is not to leave Jira and BigPicture, but keep the data inside the working environment. Otherwise you lose the power of "synchronized", real-time data.

Like Anna-SoftwarePlant likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Sourcetree

Tip from the team: configure your repos for hosting goodness!

Supported Platforms macOS Windows We recently introduced support for additional hosting services such as GitHub Enterprise, GitLab (Cloud, Community Edition, Enterprise Edition), and...

5,846 views 4 13
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you