You are an exceptional teacher. One of the best I have found on RU-vid. Really enjoyed the full video, esp the explanation on Context filter. Thank you!
Thank you so much for your very kind comment, Nishi. I am very happy to hear you found the video useful. Thank you for your support and positive feedback, much much appreciated! 😊
You killed the contest filter. The van diagram showing how the contest filter behaves is genius and can only be explicitly explained by someone who understands the database and how subquery works. 👏
Your videos are the most detailed, precise, and organized tutorials I've come across so far. Each video is a comprehensive learning experience for the topic at hand. Great teaching content!! Thankyou for the effort!
I am starting out on Tableau reporting. I have checked many videos including the Tableau official videos. But the way you have explained, I think I can commit to a delivery date to my upper management. Thank you. Keep up the good work!
Thank you for the feedback Sara! I was worried about some of the background noise (which was the primary reason for the background music). Appreciate your feedback and support! I hope you found the video useful!
No worries, I don't hear any background noises at all. I found all your videos are very helpful, i have subscribed your channel :) I really like your explanation of the context filter using the top N example, nicely done! One question: what if I turn all the filters into context filters, will that cause any problems?
Hello Sara, Thank you for your kind note. Regarding the context filter, I would not necessarily recommend turning all the context filters on as it could also have a negative effect on performance. There are also times when you would want to have data (or calculations) not affected by the filters, for example in the case of FIXED LOD expressions. Hope this helps! Donabel
@@sqlbelle My coworker passed a Tableau report to me and i saw almost all the filters were added to context filters. So i was a bit confused why she did that... Thank you so much, you are an amazing teacher!
One stop place for understanding tableau filters and right to the point. without any doubt , this is the best video available out thereon filters n u made it easy to understand as usual. Thanks for taking your time n puting this video.
I teach my students how to use Tableau in data analysis. In times, when I had face-to-face contact with them in the classroom, it was easier to show them how Tableau works, how to create reports or dashboards. Nowadays, in pandemia time, they have to work more to achieve the same learning outcomes. Your videos are strong support for my students. You are a great teacher. I appreciate your engagement and efforts in preparation these videos to deliver the knowledge of how to use Tableau in practice. Thank you so much.
Thank you for such a kind note, Piotr. I teach Tableau in the classroom as well, and it's just different teaching it online and I had to re-think and re-imagine the best way I can support them. That's how this channel was born - I wanted to have a way for them to still access my lectures even after the "live" lecture was done. I am experimenting the reverse classroom right now, where students can come for the hands-on and troubleshooting and questions, but it's in the very early experimentation stages. I am very happy to hear the videos can help support your students as well! Take care, and thank you for your kind words and support 🙏🙂
Hi Donabel, Although I was aware of the basic filter concepts in Tableau I learnt few NEW topics from this video 1. Exact differences between Quick Filter and Standard Drag & Drop Filter 2. How multiple filters behave? (Cascading filters) 3. Significance of "All values" when a Continuous field is used in the Filters Shelf 4. "Show Null Controls" option for a Continuous field Filter 5. Latest date filter 6. Browse Periods for continuous date filters Thanks for this excellent video.
Madam, you are a great teacher. I have been going through tableau related videos of a few institutes. Your way of teaching is very different/special from that of others. That also includes how you describe with details and appropriate examples. I subscribed after going through the very first video of yours. I have been going through your other videos as well. Hope that we will see many more like this. Thank you for your great help. I really appreciate it.
As usual another very clear and comprehensive explanation of a complex topic. Watching these videos I always learn something new. Thank you for making the many subtle nuances of Tableau less mysterious and more useful.
Thank you so much for your feedback Derek! Happy to hear you found some new things about Tableau from the video :) ... Tableau has so many features, it's actually quite fun to find out something new as I work with it (and sometimes just wondering why I hadn't discovered them before)
Amazing explanation, I have not come across any channel on RU-vid which such detailed information. You are truly an expert using Tableau and its core functionality.
I was struggling with showing the top 10 with a filter, searched on multiple websites without anything clear, but thanks to this video I was able to fix it using the context filter. THANK YOU VERY MUCH!!!!!!!!!!
Every time I watch one of your videos I learn just a little more. Especially when I perform an analysis in Tableau and a small feature appears that I ignore. Or maybe I wish Tableau had a special feature only to learn fom that it can do what I am asking. I find Tableau fascinating and frustrating but SQL Belle you make it easier. Thank you
Thank you James! I have those moments too where I wish Tableau was able to do something (or do something easier).. sometimes it's by accident or luck (or desperation) that I find out about features. Or, for some cases, I would have a workaround but the actual feature gets released in the next version. Overall I love working with the tool, and happy to hear you're finding the videos useful!
Um, why did I just discover you and this video just now. Great content, great explanation. Absolutely love how you breakdown everything. I'm a seasoned Tableau Developer, but I am having to teach others, so this is helping me understand how to break down these topics myself. Keep doing what you are doing.
Excellent! Sticking to the topic name, you have "filtered" just the right things we needed to know about Tableau filters and presented it so nicely! Loved it! 😊👍❤
@@sqlbelle Mam it would be great if you can make some more lectures on Dashboard,like how they work on real time and what are the things we should keep in mind while preparing any Dashboard on Projects.Some more tips on Dashboards
Started following your channel a week back and even though I have practically read half of the help docs on Tabeleau.com, I get to learn new things in every video of yours! Attention retention throughout the video = 100%!!!
You are a greatest teacher of Tableau that i ever watched. You explained it very clearly and so understandable... Thank you very much... And if I can ask or request, did you ever explain about (1) import data from different files (excel, text, sql) and make the graph in one sheet?; (2) automatic update the graph if we add some data in excel?; (3) link the data (macro excel) to make graph in tableau?; (4) real time graph (may be for stock market)?
One of the very best videos explaining how filter works in Tableau!! 😍 One quick question though: at ~7:20 what if I want to show up only "top 10" customers no matter how you slice/ filter? If there's no state selected it's the top 10 for the whole national, if you select one state it's the top 10 for that state (and only 10, not the rest of all other customers). Thanks!
Hi Bella, You are so awesome in teaching, I am recommending your videos to all my colleagues. We started using tableau just 2 months back. I read so many post and saw many videos but you are exceptional. if possible could you post a video on my USE CASE. Use CASE : I have a Fiscal week filter with only relevant values set for Fiscal month. I am trying to find a way if I select ALL from Fiscal week filter then I should display the measure value related to last week of the selected fiscal month, otherwise display the measure value related to selected fiscal week. Any ideas?
Thank you very much for the great video, I learned a lot! I have a question that bothering me: Can I display sales for each year in different charts (example: Sales for 2018, Sales for 2019, Sales for 2020) but the same sheet by date filter? I will appreciate to get some points from you, thanks again!
That's great to hear Qi! I am glad you found that helpful. Yes there are ways to display them in different charts - a possibility could be a small multiple. Quickest way would be to just put your date in either Rows or Columns. A more complicated way (but can be more organized) would be something like this trellis chart: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kWZoa3UfbVs.html
Yes. Probably best with Set operations since Set Operations are above dimension and measure filters in the order of operations (help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm)
Hello sqlBelle! First of all, excellent video as any other of your videos that I have watched. Just one question, regarding action and tooltip filters, where do they stand on the filters hierarchy? My best guess would be that they are a special kind of dimension filters? Thanks in advance!
Thank you Anastasios. I *think* they are technically regular dimension filters. When there is an action filter, tooltip filter, regular dimension filter - we'll see that these are all independently applied (just like how regular dimension filters behave)
Thank you Simon! I also saw a question from you come through but I cannot seem to see it when I look through the comments. If you still have the question, please feel free to let me know! (I just didn't want you to think I ignored the comment/question). Thank you for your support!
I agree with everyone, you are a great teacher. Your steps are clear and I am able to follow very easily. thank you. I'm working on a Tableau dashboard but I'm having issues with the filters. I'm hoping you can help me. My report has 7 sources from 7 different excel workbooks. I setup the sheets I needed and used relationship to connect them. they all have two things in common, a "Month" column and a "Associate" column. I have a chart representing the 7 sources. When I try to setup the filter in the dashboard and use it the first sheet in filter's correctly but the other don't for some reason. I set the filter to "All Using Related Data sources". I have been struggling for too long with this issue. Help
Amazing stuff! I learnt a lot from your video. Thank you so much! :) I’d like to seek your advice on one issue that I have with filters in a dashboard. I have two worksheets: Worksheet1: Columns: Type of stationeries and Rows: YYWW whereas Worksheet2: Columns: Type of stationeries and Rows: Department. Values are cost for both tables. As there are too many type of stationeries (say, 100 types), I filtered to 5 types in both worksheets. I use both worksheets in Dashboard. When I use Table 1 as a filter and select a week, it shows relevant costs of 5 types of stationeries for departments in Table 2. The issue is when I select the week again to show all weeks, all types of stationeries in Table 2 show up instead of 5 types. How can I fix the filter to 5 types of stationeries as per initially setup in worksheets. I could not find anywhere how to solve it. Appreciate much if you can advise! Appreciate much!
Hello @cococnk388 - Tableau has a very specific feature called Context Filter. It would be one you can add/toggle when you right click on a field in the filter shelf, and select "Add to Context"
Thank you Peter! I am happy you found the video useful, and as always, thank you for your very kind and positive support and feedback. Very much appreciated! 😊
I am new to Tableau and have found your videos so helpful. Thank you. I have a dashboard showing kpi's and other information across the business that is linked to multiple datasets. I am trying to create a dashboard filter so that when I select a articular month for example, all the vizzes within the dashboard filter to that month only. Can this be achieved easily? I have tried a few different things but wasn't able to get the desired result.
Thank you for your comment Mindy, I am happy to hear you found it helpful. Yes you are able to filter across different data sets, but may require a few different strategies depending on how you connected the data sources and how they're used in the dashboard. Here are some possibilities: 1. Are they all different data sets (ie do you see multiple database (or cylinder) icons in your side bar and do they have the same field names? You may need to set up the data relationships for them before the filters may work. (I have this video focusing on blend, but covers this data relationship functionality: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dC10teRrv-k.html) 2. Filter actions (instead of the native dimension filters) usually help "filter" across different data sources more easily 3. There are cases where you may need to create parameters and calculated fields, and use those in your Filter shelf instead. I think there's definitely possibility that what you are trying to accomplish is straightforward. However, I know the true answer is usually "it depends". Without seeing the data set and the dashboard, it may be hard to evaluate. I hope some of these ideas are helpful. Donabel
@@sqlbelle thank you for your suggestions. I will look into these options further. The datasets all work independently to one another as one is finance related and then I have HR and Safety. The only common field is a date. I will experiment a little more. Thank you for your advice.
Sounds great Mindy. If the options I mentioned don't work, please feel free to email me with a sample workbook (just sample data and set up) and I will be happy to see if there are other options I can suggest.
Hi.. I want to get values for shop_name|profit| loss among this shop_name and profit filter should be last 30 days but loss filter should be last 60 days... how can i do this in one sheet? Thanks in advance!
Hello Lavanya, You may need to do this using both parameters and filters. This video may give you some ideas on how to accomplish it: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Uar_D57QhU.html