Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have ActionID and RiskID.
if I write expression Count(distinct ActionID) output is 100 example
if I write expression Count(distinct RiskID) output is 100 example.just assume.
when I write the expression count(distinct ActionId&RiskID) the out put showing 600 something.
if write the individual output 100 and 100.but using concatenate showing more value .
Thanks
maybe like this
Count(distinct ActionID)+Count(distinct RiskID)
Hi,
Suppose
ActionID, RiskID
1 ,1
2,1
3,2
4,2
5,3
1,3
2,4
3,4
4,5
5,5
in above case u will get distinct count of ActionID & RiskID as 5 but u will get count(distinct ActionId&RiskID) as 10
because for each combination there is distinct value.
Wat exactly u want as output