Forum Discussion

kwmacd's avatar
kwmacd
Cloud Apps
11-30-2023

Indicator Widget Custom Formula: Count unique where 5 or more exist

Hello, fellow Sisense Users I'm trying to create an indicator widget that shows the number of unique email addresses in a dataset ONLY when there are 5 or more records with that email address AFTER ...
Developers
vshen's avatar
vshen
Sisense Employee
12-03-2023

Hi there!

I'm not sure I fully understand the request, but it seems like it can be achieved with an IF clause.

An example:

IF(count([user_emails])>5,count([user_emails]),0)

Here we count the unique user_emails; if there are more than 5 of them, we show this number; if not, we show 0 (you can replace it with NULL, for example).

Let me know if that is something you are looking for.

Additionally, you can read about the IF function (as well as all the other functions) here - https://docs.sisense.com/win/SisenseWin/function-references.htm#OtherFunctions

Best Regards,
Volodymyr