You are an exceptional teacher. One of the best I have found on UA-cam. 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! 😊
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!!!!!!!!!!
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!
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!
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. 👏
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.
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.
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 UA-cam which such detailed information. You are truly an expert using Tableau and its core functionality.
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!
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.
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 🙏🙂
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.
@@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
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!
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! 😊👍❤
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)?
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)
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?
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)
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%!!!
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 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: ua-cam.com/video/kWZoa3UfbVs/v-deo.html
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!
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: ua-cam.com/video/dC10teRrv-k/v-deo.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.
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
Hi,In previous version it's said that context filters used to create a temp table,could you please elaborate more on how context filters work in background.If it's not creating temp table now,then how other filters are getting the context result
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!
Hi, I am watching all your videos, they are very informative! Thank you for making them. Here is my question: can I apply a filter to the quick table calculation option? for example using your data, I have made a table with each row is the state, the column is the years (2000,2001,2002,2003 for instance), and measure names(include sum(sales), quick calculated compound growth rate using 2000 as the base) . Now I have a table(each row is state with each years sale number and CAGR), but my purpose is to get a table with sales by year by state and show only the CAGR of 2003 by state (using 2003 based on 2000 only). But by default Tableau will show CAGR for all the years, how can I hide the 2000, 2001 and 2002's CAGR column from the table but still keep the sales for these years? Should I use a filter or LOD expression? Please consider to make a video :D I've worked on this for a while still no clue. I kind of feel manipulating calculated variables are not so flexible compared even with Excel.
Thanks Xin! I think this is doable with a filter, but what you may be looking for is a late filter. I talked about this a little bit in the Table Calculations video - ua-cam.com/video/3_DeQdE25Bc/v-deo.html .. if you check the description, there should be chapters and there's one specific to late filtering. Hope this one helps! Donabel
@@sqlbelle Hi Donabel I watched the late filter part but I failed to use it. I think the problem is I need to apply year as the filter affecting CAGR only without affecting sum(sales). Since year is not a calculated variable, when I put it in the filters section, it will apply to both sales and CAGR . Did I miss anything? Thanks for your help!
@@sqlbelle Here is the tableau link, My goal is to hide the CAGR column from 2013-2035 but keep 2045 one ('cause I forced CAGR calculation using 2045 based on 2016). public.tableau.com/profile/x.w7917#!/vizhome/CAGR_16131449829300/Sheet1?publish=yes
Hi mam, which tableau file will be small, one which is using Extract filter or one which is using Data source filter ? (Note: These are two different files)
Does it mean that we should use the extract filter only when we create an extract, and when we have a live connection we should use the data source filter only? If we have an extract and can we use the data source filter? Or can we use first extract filer, then data source filter ( is there any logic in such action??)
Hi, could you please clarify on this, Is Extract data option can be seen only desktop version and not in public? Because i am not able to see that option in my public version?
Hi Sandeep, Extracts are proprietary files that Tableau can generate based on your data (or a subset of your data). Extracts are optimized, and often used for performance or portability. One of Tableau Public's limitation is it doesn't allow you to save your files locally, and the extract file is primarily a local file. Hope this helps. Donabel
![[UA] NAVI vs MOUZ | BO5 | IEM Rio 2024](http://i.ytimg.com/vi/CMBYk0cbGoA/mqdefault.jpg)
You are an exceptional teacher. One of the best I have found on UA-cam. 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! 😊
Never seen somebody explaining the concepts the way you do it for tableau😊
This is called perfection in teaching. I learned a lot. Thank you.
Thank you Santosh! So happy you found it helpful!
Just excellent. I really appreciate. I wish I had come across your channel early. I can't stop watching all of your videos. Thank you.
Thank you Gursel, I am glad you found the video helpful!
you are the best hands down. I started with simple table calculations and I have reached till here. Never seen someone who teaches so succinctly.
Thank you so much for your kind comment Siddharth! Happy to hear you found it helpful! :)
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!!!!!!!!!!
You are great teacher! I was glued for the whole duration. I really love your name (very unique)
Teaching comes so naturally to you...
Thank you, I appreciate your kind note. Practice and video editing has helped 🙂
So nice to hear your clear voice without the background music, great work, thank you so much!
Big Thumbs up!
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!
Thank you so so much for putting such great precise content out here for free. This is the BEST channel I came across for tableau. ❤️❤️❤️
Thank you Kriti! Im glad you found the video helpful!
aren't you a magician???!!! you got me hooked to these videos. charmed by the quality 💜
Thank you Shraddha! I am glad you are finding the videos helpful :)
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!
Hello Stuti - thank you so so much for your thoughtful comments, I really appreciate your time. And I am glad you are finding these tutorials helpful!
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 so much! I appreciate your feedback!
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. 👏
Thank you Abderrahim 🙂
Thank you for the clarification! The explanation of context filter is extremely clear and easy to understand
Thank you Lily! I am glad you found the video helpful!
You are the best teacher I have ever had in my life.😅.. Amazing your explanation
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.
Thank you Vamsee for your very kind comment, and I am happy to hear you found the video helpful!
I really appreciate the way you explain and make it so easy for us to understand. Thanks a lot
Thank you, I am happy you found it helpful!
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.
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)
This was the awesome tutorial you are the Annabelle of tutors in UA-cam!!!
Thank you Mohan :)
Yours videos are helping me to learn Tablue. Thank you for sharing these videos. Looking forward for more such videos.
Amazing explanation, I have not come across any channel on UA-cam which such detailed information. You are truly an expert using Tableau and its core functionality.
Thank you for your kind comment Taher. I am happy to hear you found the videos helpful/
Simply sensational teaching..full of clarity
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!
Really nice way of explaining different concepts. Your channel is best place to learn Tableau on UA-cam. Thank You.
Thank you Dinesh!
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.
I am very happy to hear you are finding the videos useful 🙂 .. this is the best comment and compliment. Appreciate your support!
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 🙏🙂
Truely exceptional way of teaching. I learned a ton from this comprehensive video that any other. Much appreciated.
You are nothing short of AMAZING. Thank you so much.
Thank you Star Jordan
i really like the way you explain the detail like filter or any other object .Really appreciate your help for understanding Tableau Thanks
Thank you Sana!
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.
Hello Adrian! Thank you for your note, and I am happy to hear you found the video helpful :) Thank you for your support!
You are truly amazing mam. Really enjoyed the full video, esp the explanation on Context filter.
Hello Sneha, I am glad you found it helpful!
Thanks maem finally my hunt for a best teacher has come to an end
Thank you Abhishek!
your are amazing this is the best filters video I've ever watched 👌
keep rocking🤞
Thank you Rakesh!
Great videos, you do a fantastic job of explaining. Please keep it up--I've learned a ton from you!
Thank you Frank, happy to hear that 😀
Awesome video about filters in Tableau. The explanation is so well that I can visualize it during an interview... Thank you..
Thank you Usha, hope you found it helpful 🙂and hopefully will help in future interviews :)
Exceptional video! Inarguably one of the best I have seen .. Thank you !
Glad you found it helpful. Thank you Nidhi!
You are always so helpful. Big thanks!
Thank you James!! :)
Could not have found a better explanation than this. Amazing. Thank you :)
Context filters! I finally understood them :) Thank You!
That's awesome Michal! I am glad it helped :)
Thankyou for the Detailed Lecture.It is very helpful.Looking Forward to have more Awesome Lectures from you :)
Thank you Diksha! Appreciate your feedback! Glad it was helpful!
@@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
Such a useful video.
❤️❤️
Keep posting, your videos clears all the doubts.👍🏻👍🏻
So happy to hear, thank you Vishesh!
As always you are giving good lectures to us. This is one of them. Thanks!
Thank you! I am so happy to hear that. I am glad you found it useful!
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!
Crystal clear Tableau course for free 🎉
Many thanks
This video helped me a lot in understand the filters easily with examples, especially with diagrams and learned a lot.
Thanks for sharing video
Hello Jagadeesh! Thank you for sharing, and I am happy to hear you found the video helpful!
Thank you so much ma'am...So detailed video. Please keep sharing more videos
Great presentation... learned a lot new feature.. I will watch all your other presentation. Thank you!
Thank you so much Guna! Hope you will find the other videos helpful as well!
Great summary of filter topics. Thank you!
Best teaching skills MAM.. Thanks for this 👍👍
Thank you Amit!!
Great video. You are an excellent teacher.
Thank you Adriana!
Really enjoyed your video's clips...love that
Thank you Amit!
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! 😊👍❤
Thank you Vijay!! Appreciate your feedback always.
Thank you so much for this deep knowledge on filters
Thank you Pranali, glad to hear you found the video helpful!
Excellent video with amazing explanation specially Context filter. THANK YOU SO MUCH😀
So happy to hear you found the video helpful. Thank you for sharing Jyoti! Much appreciated!
Thank you. Excellent tutorial, nicely explained.
amazing contents, really structured layout. Thank you sooo much
Very clear and precise explanation.. great video...thank you
Thank you Thennarasu
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)?
Thank you Yanji - and these are great suggestions. I'll definitely try to incorporate them in future videos.
Many thanks for this video and the content :) so well presented and useful
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)
@@sqlbelle That makes sense! Thank you for the instant reply! ⚡
Thanks belle for sharing another amazing video. Great stuff!
Thank you so much for your feedback Romy, much appreciated!
Finally I understand context filters. Can we elect you to become a Tableau zen master?
I am happy to hear you found the video useful KDB324. Thank you for your kind, kind note 🙂 It made my day 🙂
Thank you for the detailed explanation😀
Thank you Jayesh!
excellent teacher , nice knowledge sharing
plz post at least 2 videos per week
Thank you Rahul. I will try to post more often 😊
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?
Thanks so much, you answered a couple of questions I had.
Glad to hear, thank you for sharing David!
LOT OF fundamentals u are covering thanks mam :)👍🙂
Glad you found it helpful, Mahesh!
Great Explanation!
Thank you Donabel.
Thank you so much Eddy, as always, for your feedback and support! I hope you found it informative even if some are still on the more basic side.
Beautifully explained !
Thank you Hitesh
@@sqlbelle hey, can I become your student ?
Thanks for the wonderful video. In the example on context filters, is it possible to show the top 10 sales by state in each region at the same time?
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)
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%!!!
Thank you Yatish! So happy to hear that, thank you for sharing :)
Very nicely teach tableau.... Awesome....👍👍❤️
Thank you Vijay!
Morning Donabel, Context filters in this video are : action filters, tooltip filters ?
Thanks for the awesome video.
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 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:
ua-cam.com/video/kWZoa3UfbVs/v-deo.html
Superb.. explained very nicely
Thank you Prajakta!
Very nice thankyou. I really like the viz in tooltip feature.
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!
Very nicely explained .... thanks
Thank you :)
Hi sqlbelle.. loved your videos ❤️… but how can we learn full course on tableau from you to get the certification?
Thank you Vijaya - I don't have a full course yet, but working on it :)
We want more videos like this mam keep uploading...
Thank you for your feedback Piyush! I hope you found it useful 😀
Excellent.. deep dive about Tableau ..
Thank you Imran :)
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: ua-cam.com/video/dC10teRrv-k/v-deo.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.
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
You are amazing!! Thanks alot 🙏🏽🙏🏽
Thank you s o much! you are awesome teacher
Thank you!
I learned a lot from you thanks and love
Thank you Kritik!
really You are an exceptional teacher, tkt youuuuuuuuuuu
Thank you Ab Tay!
A-M-A-Z-I-N-G!! Thank you!!
Thank you Justin :)
Hi,In previous version it's said that context filters used to create a temp table,could you please elaborate more on how context filters work in background.If it's not creating temp table now,then how other filters are getting the context result
Awesome Video !
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!
this was an amazing video
simply awesome !
Thank you Premm!
Hi, I am watching all your videos, they are very informative! Thank you for making them. Here is my question: can I apply a filter to the quick table calculation option? for example using your data, I have made a table with each row is the state, the column is the years (2000,2001,2002,2003 for instance), and measure names(include sum(sales), quick calculated compound growth rate using 2000 as the base) . Now I have a table(each row is state with each years sale number and CAGR), but my purpose is to get a table with sales by year by state and show only the CAGR of 2003 by state (using 2003 based on 2000 only). But by default Tableau will show CAGR for all the years, how can I hide the 2000, 2001 and 2002's CAGR column from the table but still keep the sales for these years? Should I use a filter or LOD expression? Please consider to make a video :D I've worked on this for a while still no clue. I kind of feel manipulating calculated variables are not so flexible compared even with Excel.
Thanks Xin! I think this is doable with a filter, but what you may be looking for is a late filter. I talked about this a little bit in the Table Calculations video - ua-cam.com/video/3_DeQdE25Bc/v-deo.html .. if you check the description, there should be chapters and there's one specific to late filtering. Hope this one helps!
Donabel
@@sqlbelle Hi Donabel I watched the late filter part but I failed to use it. I think the problem is I need to apply year as the filter affecting CAGR only without affecting sum(sales). Since year is not a calculated variable, when I put it in the filters section, it will apply to both sales and CAGR . Did I miss anything? Thanks for your help!
@@xinwang2032 Are you able to share a sample that I can look at? Even Tableau public or by LinkedIn?
@@sqlbelle Here is the tableau link, My goal is to hide the CAGR column from 2013-2035 but keep 2045 one ('cause I forced CAGR calculation using 2045 based on 2016). public.tableau.com/profile/x.w7917#!/vizhome/CAGR_16131449829300/Sheet1?publish=yes
@@xinwang2032 Please check this workbook out: public.tableau.com/views/CAGRforXW/Alternative1?:language=en&:display_count=y&publish=yes&:origin=viz_share_link
Hi mam, which tableau file will be small, one which is using Extract filter or one which is using Data source filter ? (Note: These are two different files)
Does it mean that we should use the extract filter only when we create an extract, and when we have a live connection we should use the data source filter only? If we have an extract and can we use the data source filter? Or can we use first extract filer, then data source filter ( is there any logic in such action??)
25:20 context filters slow down the performance..but you shows it used for performance . how??
Hi, could you please clarify on this, Is Extract data option can be seen only desktop version and not in public? Because i am not able to see that option in my public version?
Hi Sandeep,
Extracts are proprietary files that Tableau can generate based on your data (or a subset of your data). Extracts are optimized, and often used for performance or portability.
One of Tableau Public's limitation is it doesn't allow you to save your files locally, and the extract file is primarily a local file.
Hope this helps.
Donabel
@@sqlbelle Thank you
Love it! Thank you!
Thank you Etienne! Hope the part for context filters was helpful 🙂