Filter Tableau Data By Wildcard Search With Multiple Keywords
Вставка
- Опубліковано 22 лип 2024
- In this video I will review a dashboard I put together to learn some new concepts and also teach you how to perform a multiple keyword search in Tableau. I'll show you how to perform both an OR search & an AND search against keywords you type into your dashboard parameter. Don't miss this tip!!
Interact with the dashboard at Tableau Public:
► tabsoft.co/30YoXVZ
★☆★ FOLLOW ME BELOW: ★☆★
bit.ly/m/anthonysmoak
☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕
www.buymeacoffee.com/anthonys...
★☆★ Support this Channel: ★☆★
Merch ► shop.spreadshirt.com/AnthonySmoak
Intro 0:00
Dashboard Preview: KPI Date Period Comparison 1:55
Dashboard Preview: Annotation 3:32
Tableau Knowledge Base 6:16
Regex OR Example 7:33
Finally What You Came to See 9:23
Regex AND Example 15:10
Outro 20:10
Source:
kb.tableau.com/articles/howto...
Great Explanation. Definitely gonna use the trick.
Fantastic, thanks for the comment!
Thank you so much , you are amazing
Wow, thank you! I am humbled.
loved it thanks
Thank you!
Amazing video. I haven't even gotten thru it yet, but you're about to teach me everything i was looking for 😂 on the job learning. Wish you were active on twitter!!
Thanks for the comment! Follow me on twitter @anthonysmoak
Hi Anthony, could you please expand on how you made the KPI date periods and the formatting used for the marks card? I think that’s a very useful look. Thanks!
Hi u are great please do not use background music
Thanks for your video! This is exactly what I'm looking for. The 'or' filter works great on me but when I tried the 'and' filter, it generates error message
"The Google BigQuery service was unable to compile the query. Cannot parse regular expression: invalid perl operator: (?=". So, I supposed that I need to change the regex form to match bigquery's? Thankyou!
Thanks for the comment. Try to change from a live connection to an extract and see if that helps.
@@AnthonySmoak Thanks, it helps! Anyway, if anyone encountered same problem as me (bigquery won't process), I found the alternative solution:
use this formula in Regex String (AND):
REGEXP_REPLACE(l[Search Terms (Comma Separated)]),",","(.*?)")
Thankyou again for this video. More people should watch your channel!
@@NadiaSelasNoversega Glad to hear you found an alternative! Please help spread the word about the channel!
Can this work using a wildcard symbol to represent characters? EX: 2*12345 where the asterisk would represent a variable number of zeros?
As long as you find the correct Regex syntax, the sky is the limit on how to filter.
When I go to place the the regex OR filter into the filters section, I am only getting null as my value choice, not true. Any idea why this may be happening?
It's hard to diagnose via here without any context on your data, but just double check that you have the right calculations typed in.
Hi, is it possible to use the regex AND filter to nest multiple strings?
If so how can I achieve this?
Are you asking if the AND filter works with multiple strings? Then yes it does.
Forgive my ignorance. I've created the filter but how do I use it. How do I create that field where the end user can free type the search words?
The free type area is the parameter we created in the video.