Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try it again by adjusting the fieldname within the expression from: ActivityId to ActivityID.
- Marcus
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
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
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 | |
6 | Call |
7 | Business Meeting |
8 | Meeting |
9 | Call |
10 |
It returns a 0 when it should return 4.
- Jimmy
Try it again by adjusting the fieldname within the expression from: ActivityId to ActivityID.
- Marcus
Thank you marcus_sommer! It was a combination of changing Id to ID and '*Meeting*' to "*Meeting*".