Aggregate Filter by Formula

I have an aggregated table that shows a selected company's prescriptions and compares them to the rest of the industry. The table groups by a drug category, then shows the selected company's data (# prescriptions, total cost, total sales, etc) and compares that to the rest of the industry. 

When the selected company has 0 total prescriptions for a drug category, I want to suppress that row in the aggregate table. However, "Filter Aggregate Values" will not accept a "New Formula" and allow you to specify the filter formula. I can drag "Number of Prescriptions" into an aggregate filter and select only rows where SUM() > 0, but that applies to ALL the prescriptions in the row when I want to filter out rows where SUM() = 0 for the selected company only. 

Is there a way to accomplish this? Why can't you use a formula on insight aggregate filters?

5replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Dan, we do not support aggregate filter by formula yet although it is on the roadmap. However, we may have a workaround. Let's follow up on zoom call to make sure we have the use case correct and test the workaround. We can update with our results here.



  • Has this feature been implemented yet and/or do you have a viable workaround?

    • Joe Steinbrunner we did not have a workaround in Dan's use case. Sometimes you can get around this by creating an alias to your transactional table, self-joining and removing null rows with an insight filter. The feature to support aggregate filters is being considered for our next release but we do not have final commitment and an ETA. The next release is adding the engine support necessary to achieve the feature so it will definitely be soon. I'm already tracking this closely for Inmar and will keep the team in the loop on this status.


      Like 1
    • Dustin Basil 
      Will this post be updated when you have an ETA or should I create a ticket for this same functionality?

    • Laurentiu Pteanc It would be best to create a ticket to more closely track this for you as well as keep you in the loop w/r/t feature requirements and implementation details. Thanks!

Like Follow
  • 7 mths agoLast active
  • 5Replies
  • 190Views
  • 4 Following

Product Announcement

We are happy to
announce Incorta 4.8 !!!