Skip to Content
1
Jul 25, 2022 at 01:29 PM

Distinct count on Multiple columns in final aggregation

166 Views Last edit Jul 24, 2022 at 09:53 AM 2 rev

Hi All,

I want to calculate distinct count from multiple columns.

image.png

In calculation view, by dragging the SO and PO number, the distinct count of SR values are incorrect. ie) 5. Expecting output as 1. How to design on distinct count the multiple Columns (SR, SO and PO). For getting unique SR, i kept SO_NUM and PO_NUM as transparent filter to TRUE. But in this layer, i am calculating the SO and PO count, so getting the error as "Transparent filter property not allowed for view attributes which are referenced in expressions(calculationNode (finalAggregation) -> attributes -> attribute (SO_COUNT) -> expression). How to perform distinct count on multiple columns in final aggregation.

As i searched in old forums, i didnt proper solution for this issue.

Thanks.

Attachments

image.png (10.2 kB)