Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Two things that i still don't find clear enough
1. is it possible to use "IF" inside the set expression of an aggregation (i.e. count,sum..etc.)
for example: count( if(date>today(),date))
2. i would like to count the Users.KEY in case the sum of WasLoginPotential equals to the sum of WasLoggedIn
for example i have this table:
1 | Users.KEY | FactMonthlyLogins.Month | WasLoginPotential | WasLoggedIn |
1 | 4367|5638 | Feb | 1 | 1 |
1 | 4367|5638 | Apr | 1 | 1 |
1 | 4367|5638 | Jun | 1 | 1 |
1 | 4367|5638 | Jan | 1 | - |
1 | 4367|5638 | Mar | 1 | - |
1 | 4367|5638 | May | 1 | - |
1 | 4367|5638 | Jul | 1 | - |
1 | 4367|5638 | Aug | 1 | - |
what you would recommend to do?
1) Definitely you can use it
2) I wold prefer this way
Count({<Users.KEY = {"=Sum(WasLoginPotential)=Sum(WasLoggedIn)"}>} Users.KEY)