Skip to main content

Is there any option to group can be implemented at two different level? 

For example: I want to create rule which count number of districts for which has total revenue zero by each state. Such district Count should not more than 10. Hierarchy country > state > district > Territory.

Kindly suggest how to create a rule for this using Ataccama Web one.

Hi ​@akshayl09 at the moment there isn’t a way to do this in the web app. One of these options would work:

  1. Create an SQL CI/VCI that does part of the required aggregations, for example calculates total revenue per district and puts that in a new column that can be used as an input to the rule. Then create an aggregation rule that aggregates by state and does countDistinctif(revenue=0,district)>10
  2. Use a component rule to perform all aggregations in the component and attach the rule to the source data catalog item.

We encourage you to put this topic on the Ideas space of the community: https://community.ataccama.com/ideas Our product teams watch the suggestions and discussions out there to help refine our development roadmap. Thanks in advance!

 


Thanks, Group data at two different level while creating rule | Community I added this as Idea.


Reply