Just Launched! — Enhanced Pivot Table Reports

Aha! bar chart comparing logged effort against estimates.

Here we go again. We just made reporting in Aha! a lot more powerful. You have a lot of data in Aha! and we want to make sure that you can visualize and report on it in the most compelling way.

So, we are taking our reporting capabilities a step further. Our latest update enhances your ability to create reports and visualize data in Aha! by allowing you to include cell headers and calculate sub-totals on pivot reports.

We added this capability because if you are going to create a complex table, it’s obvious that you need to know what data is in each column and row. You can use these new reports to make better planning decisions, track progress, and easily share updates across your team.

Here are several examples of how enhanced pivot reports can be used to deliver beautiful visual charts.

Highlight important data
The addition of cell headers lets you easily choose and communicate what is important. Create robust pivot reports to give your audience a clear understanding of the data. For example, you can create a report that highlights your strategic goals and includes current status, success metrics, and timing for each goal.

Aha! pivot report showing strategic goal status, success metric, timeframe and value.
Cell headers make it easy to interpret data and avoid having to use Excel to report on your plans.

Communicate strategic alignment
You are often asked what the impact of your key product themes will be to the bottom line. Use pivot tables to show how your strategic initiatives will help achieve your goals, and analyze which initiatives to pursue based on the cost to develop and projected revenue.

strategic-initiative-chart-aha
Strategically align your initiatives to goals, while reporting on cost to develop and projected revenue. 

Make better planning decisions
Added flexibility means you’re better informed and able to address issues before they impact the business. For example, leveraging a custom scorecard on releases that estimates the work required from each team allows you to identify areas where you may need to bring in additional resources or reprioritize features.

pivot-report-aha
Create a custom scorecard at the release level to capture and report on team estimates.

Track team progress
Keeping the team on track and everyone informed is crucial work for any product manager. Want to know how much work is left on a release? Now you can report the logged effort against the original estimate to see which releases are taking more time than expected.

strategic-alignment-aha
Compare logged effort against the original estimate to see remaining work in a release. 

Easily share updates
With the new cell headers, you can also visualize each field independently. For example, you could quickly turn the previous pivot report showing logged effort vs. original estimate into a beautiful chart by selecting the Chart data button. You can even customize the chart type and colors.

Release-estimates-aha
Easily turn your pivot report into a beautiful visualization.

Configuration
This new functionality offers additional flexibility when creating reports and enhances capabilities on existing Aha! reports. As a reminder, it only takes a few minutes to build beautiful custom pivot reports. Here is how:

  1. Create a pivot report under Reports > Pivot >  Select Data
  2. Make a selection in the Cells section to determine what data should appear within cells. Rows will appear on the left and Columns at the top of your report.
  3. The Calculate section will appear, allowing you to make calculations based on totals, averages, counts, minimum, maximum and difference. Create calculations across rows and down columns.

Select data modal for the Aha! pivot table zoomed in on calculate section.

Select the Customize View button on the pivot table page to choose whether cell headers will be shown. Once selected, the headers will be displayed immediately on your pivot table, including automatic sums and totals.

Configure-pivot-report-aha

With Aha! you can visualize everything about your product and your team in a single place. And with enhanced pivot reports, your data just became even more powerful!

Signup for a free Aha! trial — be happy
Enhanced pivot table reports are available to all Aha! customers. If you are not already an Aha! customer, you may want to sign up for a free 30 day trial of Aha! now to see why over 50,000 users trust Aha! to set product strategy, create visual roadmaps, and prioritize releases and features.

About Keith and Aha!

Keith is a product marketing pioneer. He is the VP of Marketing at Aha! — the world’s #1 product roadmap and marketing planning software. Previously he blazed new trails in customer acquisition strategy at RealPage [RP], a top 10 SaaS company with more than 60 products worldwide.

Sign up for a free trial of Aha! and see why more than 250,000 users worldwide trust Aha! to set brilliant strategy, capture customer ideas, create visual roadmaps, and manage breakthrough marketing programs.

We are rapidly growing and hiring!

  • Customer Success Managers (product manager experience required)
  • Product Marketing Managers
  • UX Designers
  • Rails Developers

Work from anywhere and be happy. Learn about our team — see current openings.

Leave a Reply

Your email address will not be published. Required fields are marked *