Skip to Main Content
Status Future consideration
Categories Reports
Created by Reut Levi
Created on Jul 9, 2020

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
  • 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