cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with aggregation node in Calculation view

former_member199630
Contributor
0 Kudos

Hello!

I am facing an issue in an aggregation node within a Calculation view.

Basically what I am seeing is that the result of the aggregation node (if I do a data preview) is different from the Calculation view I am using in the Aggregation node, it seems I am loosing data.

Do you know what it could be happening? Should I check anything in particular?

Here, a couple of screenshots, where you can see the result is different applying the same filter.

In the Aggregation node, I select all fields from the Sub-Calculation view.

We are in SPS11.

Thanks, Federico

This is the Calculation view

This is the result for the Sub-Calculation view

This is the result of the Aggregation Node, using the Sub-Calculation view.

View Entire Topic
ricky_shaw
Contributor
0 Kudos

Hi, Probably the mapping condition is wrong. Better check the Join nodes first.

former_member199630
Contributor
0 Kudos

Hi Ricky,

I checked the mappings and joins, everything look ok.

The issue it is with the data preview of the Aggregation node, which gives me other result.

I switched the node to a Projection, and the result of that particular node matches with the Sub-Calculation view. So, the question now is:

Why the result of the same node is different if the node is an Aggregation or a Projection?

Thanks, Fede