Hello i have the following problem:
I have a column/dimension with user names and a date.
|User_Login| |Date|
User1 2022-xx-xx
User2 null
User1 2022-xx-xx
User3 2022-xx-xx
I have some Users that doesn't have a date, and i want to ignore those in my count of users.
I would like to show the count of user names from this table, in regards to if it has a date.
So if i would express it logically it would be something like:
Count user_login if Date exist, give a value, if date null=skip.
So far:
i have something like "Count({USER_LOGIN ={${<USER_LOGIN ={"=Sum(DATE)>0"}>}USER_LOGIN ))}>" and it doesn't work.
Br
