Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am try to build a table with the following metric by User.
COUNT({<[Security ID] = {"=Count({<$(=vSelectedDate)>} DISTINCT [Account ID]) <= 3"}>} DISTINCT [Security ID])
In a KPI, it gives the correct answer. But if I put it in a table, it seems like the securities are grouped by user, but not the accounts.
In other words, "Count({<$(=vSelectedDate)>} DISTINCT [Account ID]) <= 3" does not consider the user on the table row, but all the accounts for all users.
Is there a way to avoid this?
Thanks!
Create a new key in your script
AutoNumber([Security ID]&User) as Key
and then try this
COUNT({<Key = {"=Count({<$(=vSelectedDate)>} DISTINCT [Account ID]) <= 3"}>} DISTINCT [Security ID])