on 05-05-2017 1:25 PM
What is the difference (aggregation behavior) between an aggregation node directly under semantics and another aggregation node used in a (graphical) calculation view?
--> Is there a different aggregation behavior regarding calculated columns?
--> Is there any setting for calculation after aggregation in an aggregation node?
Both should work the same way;
All calculated columns in aggregation node would be calculated after aggregation by default - you can't change that; If you need calculation before aggregation, then use projection node with formula before the aggregation node.
You may use the stacked nodes to meet your biz requirements - but that doesn't change the functionality of the nodes - it remains same.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot for your quick repsonse! Unfortunately I have a different aggregation behavior. I have created a calculated column and in the aggregation node under semantics the result is calculated on an aggregated level and correct. In the other aggeration node the calculated column is calculated before aggregation, which is not correct. It is also the same result if I change the node to projection.
User | Count |
---|---|
73 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.