List reports

Aha! Ideas

This article discusses proxy votes or ideas portal custom domains. You need to be an Ideas Advanced customer to access these features. Please contact us if you would like a live demo or would like to try using it in your account. If your Aha! account was created before October 20, 2020, you may have access to these integrations, but you will need to upgrade to Ideas Advanced for any future enhancements.

The Reports → List page is your go-to tool for creating custom list reports in Aha! Ideas using any combination of hundreds of different data objects. With the list report, you can add column headers for every data object, then filter and sort the data to present different perspectives on your Aha! Ideas environment.

List report of ideas, votes, and statuses.

Click any of the following links to skip ahead:

How to create a list report

Reports are built around relationships between record types. The order you add related record types to your report matters. As you work through the report builder, try experimenting with different record types and see how it affects the report you create.

Creating a list report is as simple as clicking the Create new report button. This will open the Create report interactive modal, which will walk you through the process.

If you are new to list reports or would like some inspiration, choose Use an example list report. The example reports are an excellent starting point from which you can add and narrow down the data you want to see. See the latest ideas by choosing the New ideas report. Or, if you are an Ideas Advanced customer, see how many organizations support an idea by generating the Popular ideas by organization count report. Select one of the options, and watch your pivot table build itself. Then customize the example report to fit your needs.

Otherwise, select Create your own list report, then follow the steps in the report builder to Select records, Add fields, and Add filters to your custom list report. If you know exactly how you want to focus your report, you can set your filter values right from the report builder. And later on, you can always use inline filters to refine your reports too.

Top

Choose your data columns and filters

  1. Click the Customize view dropdown, then click Edit data to add additional data columns to your report. The record name is automatically added for each level that's added to the report.

  2. Add filters as necessary from the filters bar at the top of your report. You can add a basic filter quickly by hovering over the filters bar and clicking the Add filters + icon, or add an advanced filter by clicking the Edit filters icon to open up that step in the report builder. Filters are organized by record type and are searchable to allow you to find specific details without scrolling through long lists.

  3. Once you have selected a filter, you can filter your report by blank (or not blank) values, by specific or a range of values, or by using advanced filters to apply logical strings to your filters.

Top

Customize your report

After adding all of the data columns to the list table that you want to display, you can reorganize the columns, sort the data within the columns, and rename the column headers.

To sort your data by a specific column, hover on the column header and click the More options button. Then, select from one of the sort options in the dropdown. You can also sort multiple columns by clicking Customize data → Sort columns. This will allow you to sort columns based on multiple values, such as alphabetically by record status and record name.

List reports can be customized further in the following ways:

  • To reorganize the columns, click on the column header and drag it to the desired location on your report.

  • To change the name of your column headers, select the text within the column header to begin editing the name.

  • To modify the width of a column, drag the edge of the column header to the desired size.

  • To add a column, delete a column, or add a calculation column, hover on the column header, choose the More options button, then select an action.

Top

Chart your data (Advanced)

If you are an Ideas Advanced user, navigate to Roadmaps → Charts to create beautiful visualizations and charts from the report you just created.

Top

Update your data

You can make updates to your data directly in a list report by clicking the record name you wish to edit. The detail drawer will expand, making it easy to edit a record in the context of your report. After making your changes, simply refresh the page to see your changes in the list report.

When you have more than a handful of records to update, it is better to bulk edit them.

Top

Save list views

To save your current view, click the Save view button in the top-right corner of the page. When you save a view, you will have the option to name it, choose who you wish to share your saved view with, and select if others can edit the view. The Views dropdown lets you access any view you have ever saved.

Top

Share your list report

With your list report completed, you can easily share it with your stakeholders by selecting one of the export options through the Share button on the top-right of the screen.

Top