Skip to main content
Solved

Group by while creating the rule

A
Data Pioneer
Forum|alt.badge.img+1

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.

Best answer by Lisa Kovalskaia

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!

 

View original
Did this topic help you find an answer to your question?

2 replies

Lisa Kovalskaia
Ataccamer
Forum|alt.badge.img+3

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!

 

Cansu
A
2 people like this
  • Cansu
    Cansu
  • A
    akshayl09
A
Data Pioneer
Forum|alt.badge.img+1
  • akshayl09Data Pioneer
  • Author
  • Data Pioneer
  • 22 replies
  • June 2, 2025

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

Cansu
1 person likes this
  • Cansu
    Cansu

Reply


Most Liked this week

Community Terms of Use & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings