Why can't you use the Accountname dimension in filters using the wildcard setting? or just use:
contains([Account Name], 'INC'). In any case, it would be helpful if you supply some sample data in an excel sheet with your expected results.
I need the report to display ALL accountnames when the dashboard is open.
The requirement is that, along with selecting a specific accountname via a quick filter, the dashboard contains a floading parameter box that searches through all 500 or accountnames.
I have it workign fine, just need to figure out the regular expression that lets me replace inc$ (Returns names with inc as the last 3 chars with someting like *inc* that returns any accountname where 'inc' is in the accountname.
Im new to regular expressions and they are a bit cryptic.
I figured it out...
I'm new to regular expressions and they are a bit cryptic.
Agree I haven't even used reg_ex expressions...
I have it working fine, just need to figure out the regular expression that lets me replace inc$ (Returns names with inc as the last 3 chars with something like *inc* that returns any account name where 'inc' is in the account name.
but it sounds like you want to use a wildcard
This is useful > Become a regular with regular expressions
and it has links to various reg expression builders RegExr: Learn, Build, & Test RegEx which help you construct the expression
Also, I found this on Wikipedia Wildcard character - Wikipedia, the free encyclopedia
Hope that helps a little!