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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

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.

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.

@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 

@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 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
Posted in Sourcetree

[dev team] Sourcetree for Windows 2019 Preview - Dark Theme

Hi folks, While the full post is over on our blog I'd like to share the dark theme we've got planned for 2019 here directly as well to keep the discussion going.  The ...

3,723 views 19 19
Join discussion

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