Skip to Content

Can not get any measures while using join as a data source for aggregation node.

Oct 08, 2017 at 02:49 PM


avatar image


While building Calculation view, I tried to use join as a data source.

from data source, output is connected to aggregation node.

but to make use of aggregation functions, type of output from data source must be measure. In my case I am not able to get join node output as a measure.

Is there any way to manually change join output type to measure?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Prashant Patil Oct 10, 2017 at 07:04 AM

Hi Saurabh,

As per my knowledge, we can not make any field from Join node as measure. However we can still use the measure fields (Ex: Net amount) in aggregation functions of the immediate Aggregation node.

In your case, I think we can add the column Net amount as 'Add as aggregated column' in the immediate aggregation node and make use of it in aggregation functions.



10 |10000 characters needed characters left characters exceeded