Hi there
I am working on a requirement where the weights have to be created and rolled up based on counts of certain parameters - such as Goals, Objectives, Key initiatives, Activities and Responses.
A Goal can have multiple Objectives, an objective can have multiple Key initiatives and so on.
I started aggregating from the lowest level for the count for this, but while it works on the lowest level, the second level (from bottom) shows me weird results. I see good values in the aggregation level, but that's not what I see after the join.
Aggregation 2 and join 2 are the ones in question. The column I am concerned about, is COUNT_ACTIVITY
For Goal 1, Objective 1 and Key initiative 1, the count from Aggregation 2 returns 2, which is the expected value.
But when I join it back (join_2), I see different values for the same variable. Please see the screenshot below.
For Goal 1, Objective 1 and Key initiative 1, the count from Aggregation was 2, but from join, I get 4.
I was expecting to see 2 (from the aggregation) against all rows corresponding to Goal 1, Objective 1 and Key initiative 1.
Am I doing something wrong here? I haven't come across something like this earlier.
Thanks in advance!