Skip to Main Content

Share your product feedback

Ability to filter pivot reports on counts

In pivot reports, Aha! offers the options to "Within cells list as:" counts, sum, avg etc. It would be very beneficial if we could filter on this numerical options, especially on counts and unique counts (since it's not a standard option offered when creating calculated columns in a list report)

For example, if I create a pivot view for releases in a workspace and I'm showing the number of features in each release using the "Within cells list as: Count Unique Records" on Feature ID it would be very beneficial to filter on 0 to draw attention to exceptions.

  • Attach files
      Drop here to upload
    • Harry Thompson
      Reply
      |
      Nov 4, 2022

      This would be helpful as I need the filter to control what shows up in the pivot report. For example, I only want to show Epics that don't have any activities yet, but can't filter on Activity Count.

    • Robert Rodriguez
      Reply
      |
      Apr 2, 2021

      Yes, this would be very helpful. This is a chart that shows all the ideas by Category. As you can see it is very crowded. I would like to be able to filter by Categories that have, for example, 20+ Ideas submitted so that I can visualize at least the upper 25% of Categories. There is no way to do that currently.

    • Sophie Ramsden
      Reply
      |
      Nov 2, 2020

      This would be useful to provide a report of workspaces without an initiative created with a specific attribute