$SYS_USER and filter

[Elio-6b3d]

Hey,
I am new here
What am I missing , why the filter is 0 although I have data in the table (should be 3)?

Thanks,
Elior

Moderator note: Edited out personal information from visuals.

[Elio-6b3d]

Moderator note: Edited out personal information from visuals.

[Luke]

I believe you want it to be:

=ROWS(FILTER(A_Tasks, "A_Tasks[Assignee]=$[SYS_USER]"))

[Elio-6b3d]

@Luke

=ROWS(FILTER(A_Tasks, "A_Tasks[Assignee]=$[SYS_USER]"))

Hey Luke and thanks for you answer , I want to count how many tasks each user have.
I tried you suggestion:

same result ...

Moderator note: Edited out personal information from visuals.

[Luke]

What is the format on your Assignee column? Is it set to Contact?

[Elio-6b3d]

rowlink & picklist , if I write my name explicate ((FILTER(A_Tasks, "A_Tasks[Assignee]=""Elior Neeman"""))) it works, and I don't know why...

[Luke]

If you do not want to use the format that I am suggesting and want to keep that field as is, you are going to have to probably do a comparison on a concatenation of $[SYS_USER][First Name] and $[SYS_USER][Last Name].

I would suggest though that you use the Contact format for any fields that you want to compare using $[SYS_USER].

[Luke]

Moderator note: Edited out personal information from visuals.

[Elio-6b3d]

Thanks

[Taylor]

Hi folks, great thread @Elio-6b3d and @Luke! Quick reminder to please blur out any personal information from images, visuals, etc. Our customers' privacy and safety is very important to us