Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to group by my required data on the basis of DF_PACKNR with distinct POD numbers so I have used the below aggr function for it and its working fine.
count(aggr(distinct(DF_POD),DF_PACKNR))
But Now I want to apply one more condition on it with different column where need to sort the data on the basis of DF_USER='VR1'.
after applying set analysis on it, Its showing no data.
could you please provide some solution for it to apply set analysis with Aggr.
Hi Vegar,
I am applying like this as below:
AGGR(COUNT(DISTINCT {<DF_USER={'VR1'}>} DF_POD), DF_PACKNR)
Have you tried this?
Count({<DF_USER = {'VR1'}>} Aggr(DISTINCT Only({<DF_USER = {'VR1'}>} DF_POD), DF_PACKNR))
or this
Count(Aggr(DISTINCT Only({<DF_USER = {'VR1'}>} DF_POD), DF_PACKNR))
Hi Sunny,
Its now working fine in our scenario I mean its giving wrong counts.
Would you be able to share a sample to show what you are getting and provide the number/s you are hoping to get?