Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to sum "Licenses" based on distinct "Users".
Need help!
May be this:
Sum(Aggr(Only(Licenses), Users))
or
Count(Aggr(Only(Licenses), Users))
Update: Not sure if you would Sum or Count? I think it should be Count, but don't really know your data. Also not sure how your data is but if you have user as dimension you can try this
Count(DISTINCT Licenses)
May be this:
Sum(Aggr(Only(Licenses), Users))
or
Count(Aggr(Only(Licenses), Users))
Update: Not sure if you would Sum or Count? I think it should be Count, but don't really know your data. Also not sure how your data is but if you have user as dimension you can try this
Count(DISTINCT Licenses)
SUM(Aggr(COUNT(Licenses),Users))
or
SUM(Aggr(SUM(Licenses),Users))
Could you please be a bit more descriptive?
May be
SUM(Aggr(COUNT(Licenses),Users))
or
SUM(Aggr(Distinct COUNT(Licenses),Users))