Wildmatch and ** returning 0

[Anonymous]

Whenever I try to use the wildmatch function or search using **, I get a return of 0. I have gotten around this in the past by using filters, but it has become burdensome.

Is this an issue I have within my settings?

[Anonymous]

I know the function is correct because I took the exact line and ran it on a colleages computer and got a result.

So I am thinking it must be an issue within settings

[marcus_sommer]

It sounds strange. Does the question mark work as a wildcard? Could you give an example of such wildmatch-expression and a search-string?

- Marcus

[Anonymous]

Hey Marcus, thank you for the reply.

Example: If I use the following expression...

Count({<ActivityType={'*Meeting*'}>}[ActivityId])

With the following dataset...

ActivityID	ActivityType
1	Call
2	Meeting
3	Business Meeting
4	Call
5	Email
6	Call
7	Business Meeting
8	Meeting
9	Call
10	Email

It returns a 0 when it should return 4.

- Jimmy

[marcus_sommer · Accepted solution]

Try it again by adjusting the fieldname within the expression from: ActivityId to ActivityID.

- Marcus

[Anonymous]

Thank you marcus_sommer! It was a combination of changing Id to ID and '*Meeting*' to "*Meeting*".