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 a reporting tool and supporting data that are robust enough to answer all product related questions that stakeholders need 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. Understanding how to get started with building your reports and customizing them is essential for building the reports that answer those questions.

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 blue + New 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.

create-a-new-report-modal.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 what data columns you choose first. 

DEFINITIONS

  • A data column is the data you want to see in your reports such as "Feature name". 
  • A table is what contains data columns, such as "Features". 

Understanding table relationships

When you add your first column, future options of selectable data will change based on the first selection to ensure that you are putting together a table of valid data objects that relate to one another. 

Where having knowledge of the Aha! data model is most helpful is with knowing which Table and Columns to start with 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 using feature columns (i.e. Feature name). If you wish to create a report showing releases by initiative, you'll want to start your new report using release columns (i.e. Release name). 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 examples to illustrate:

  • Report: Feature assignments by release by product - start with selecting the Feature table and columns. 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 table, the Product table and columns would be available but not the Feature table and columns. 
  • Report: Targeted Goals and Initiatives by Release - start with the Release table and columns.
  • Report: List of all Ideas and highlighting those that have been promoted to Features - start with the Ideas table if you want to see all Ideas. If you start with the Features table, the only ideas that will be available for the report are those that have been promoted to Features. 

The screen for adding data columns is organized into a set of database tables on the left and the corresponding table columns on the right. The values for both are sequenced with the most commonly used appearing at the top of the list. 

 

Adding data to new reports

Every screen will have a "+New Report" button. If you click that, you can add new data columns easily by clicking the plus sign (shown above). 

Adding data columns to existing Reports List

The Reports List view is simple because it's data arranged in columns based on the data you want to see. You have only one step to add data columns - click on the green data column icon.

Add-data-columns-to-list-reports.png

Adding data columns to existing Reports Pivot, Chart and Timeline views

The Reports Pivot, Chart and Timeline views have additional steps to arrange your data. Therefore, you must click on "Select Data" which will bring you to new view where you can then add additional data columns. 

Add-data-pivot-reports.png

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Roadmap software to manage your products.
Finally, connect strategy to execution.

Powered by Zendesk