Add and understand data columns for new or existing reports

Creating reports that provide transparency on product roadmaps is an important responsibility of the product manager. Communicating the "why," "when," and "what" behind product plans requires both a reporting tool and supporting data. And they must be robust enough to answer all product-related questions that stakeholders need to have answered. There are four different types of Aha! reports — list, pivot, chart, and hierarchy — and well over 100 data objects to help with this endeavor.

Building a new report

Getting started with the creation of a new report doesn't mean you have to start with a blank canvas. Click on the Add report button found on each of the report pages and start with an example report. Or create a custom report from the ground up. The examples can also provide a launching point for further tailoring the content to meet your specific reporting needs.

Aha-create-new-report.png 

The key to getting started is identifying what is at the heart of the report you wish to create. Do you wish to create a report focused on feature assignments and status? Or a break-down of initiatives and goals by each release? The answer helps determine the primary record type you choose.

  • The primary record type serves as the foundation for a report. For example, if you wish to create a report that shows features and their related goals, you will want to start your new report using features as your primary record type.
  • A column is the data you want to see in your reports, such as Feature name
  • A record type is the data table that contains the data columns, such as Features

Note: When you select a record type, Aha! will automatically create a column that includes the record's name.

Aha-report-primary-record.png

Understanding table relationships

When you select your primary record type, the available related record type columns will dynamically change to ensure that you are putting together report with valid data relationships.

Having knowledge of the Aha! data model is most helpful when choosing the primary record type. This will be based on the type of report you wish to create and the data element you want to serve as the foundation for your report. For example, if you wish to create a report that shows features based on feature goals, you'll want to start your new report selecting Feature as your primary record type. If you wish to create a report showing releases by initiative, you'll want to start your new report by selecting Initiative as the primary record type. Think about the data and related elements you need to include in the report and always start with the table that is lowest in this data model hierarchy because the data relationships flow upward. 

Here are a few report examples to illustrate:

  • Feature assignments by release by product: Start by selecting Feature as the primary record type. In turn, both the Release and Product tables and columns will be accessible for the report. On the other hand, if you would have started with the Release record type, the Product record and columns would be available but not the Feature record and columns. 
  • Targeted goals and initiatives by release: Start with the Release record.
  • List of all ideas and highlighting those that have been promoted to features: Start with the Ideas record if you want to see all Ideas. If you start with the Features record, the only ideas that will be available for the report are those that have been promoted to Features.  

 Aha_DataModel.png

Adding data to new reports

Every page will have an Add report button. If you click that, you can add new data columns easily by clicking the + icon (shown above). 

Adding data columns to existing Reports List

The Reports > List page is simple because its data is arranged in columns based on the data you want to see. You have only one step to add data: Click on the Add data icon on the upper-left of the page.

aha-list-add-data.png

Adding data columns to existing reports pivot, chart and timeline views

The Reports > Pivot page, the Reports > Chart page, and the Reports > Custom page all have additional steps to arrange your data. Therefore, you must click Add data, which will bring you to a new view where you can add and arrange the data columns. 

Aha-reports-pivot-config.png

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request
Powered by Zendesk