Skip to Content

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

Hi,

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Regards,

    Prashant

    Add comment
    10|10000 characters needed characters exceeded