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!!!!!!!!!!
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!
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.
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!
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!
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 🙏🙂
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.
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.
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.
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
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! 😊👍❤
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!
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)?
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)
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
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!
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)
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"
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.
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,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 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! 😊
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.. 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: ua-cam.com/video/0Uar_D57QhU/v-deo.html
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😊
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!!!!!!!!!!
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!
This is called perfection in teaching. I learned a lot. Thank you.
Thank you Santosh! So happy you found it helpful!
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 🙂
Teaching comes so naturally to you...
Thank you, I appreciate your kind note. Practice and video editing has helped 🙂
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! :)
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 :)
Thanks maem finally my hunt for a best teacher has come to an end
Thank you Abhishek!
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!
This was the awesome tutorial you are the Annabelle of tutors in UA-cam!!!
Thank you Mohan :)
You are the best teacher I have ever had in my life.😅.. Amazing your explanation
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!
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.
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 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 great teacher! I was glued for the whole duration. I really love your name (very unique)
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!
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 🙏🙂
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!
Yours videos are helping me to learn Tablue. Thank you for sharing these videos. Looking forward for more such videos.
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!
You are nothing short of AMAZING. Thank you so much.
Thank you Star Jordan
Simply sensational teaching..full of clarity
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)
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!
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/
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!
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!
Truely exceptional way of teaching. I learned a ton from this comprehensive video that any other. Much appreciated.
Really nice way of explaining different concepts. Your channel is best place to learn Tableau on UA-cam. Thank You.
Thank you Dinesh!
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!
Crystal clear Tableau course for free 🎉
Many thanks
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 :)
Exceptional video! Inarguably one of the best I have seen .. Thank you !
Glad you found it helpful. Thank you Nidhi!
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!
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 :)
Best teaching skills MAM.. Thanks for this 👍👍
Thank you Amit!!
You are always so helpful. Big thanks!
Thank you James!! :)
Great summary of filter topics. Thank you!
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 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 😀
Great video. You are an excellent teacher.
Thank you Adriana!
your are amazing this is the best filters video I've ever watched 👌
keep rocking🤞
Thank you Rakesh!
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 🙂
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!
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
excellent teacher , nice knowledge sharing
plz post at least 2 videos per week
Thank you Rahul. I will try to post more often 😊
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.
Very clear and precise explanation.. great video...thank you
Thank you Thennarasu
LOT OF fundamentals u are covering thanks mam :)👍🙂
Glad you found it helpful, Mahesh!
Thank you so much for this deep knowledge on filters
Thank you Pranali, glad to hear you found the video helpful!
Such a useful video.
❤️❤️
Keep posting, your videos clears all the doubts.👍🏻👍🏻
So happy to hear, thank you Vishesh!
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!
Thank you. Excellent tutorial, nicely explained.
We want more videos like this mam keep uploading...
Thank you for your feedback Piyush! I hope you found it useful 😀
Thank you for the detailed explanation😀
Thank you Jayesh!
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!
Very nicely teach tableau.... Awesome....👍👍❤️
Thank you Vijay!
amazing contents, really structured layout. Thank you sooo much
Really enjoyed your video's clips...love that
Thank you Amit!
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.
Thanks belle for sharing another amazing video. Great stuff!
Thank you so much for your feedback Romy, much appreciated!
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.
Thanks so much, you answered a couple of questions I had.
Glad to hear, thank you for sharing David!
Many thanks for this video and the content :) so well presented and useful
Beautifully explained !
Thank you Hitesh
@@sqlbelle hey, can I become your student ?
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?
Very nice thankyou. I really like the viz in tooltip feature.
Excellent.. deep dive about Tableau ..
Thank you Imran :)
Superb.. explained very nicely
Thank you Prajakta!
really You are an exceptional teacher, tkt youuuuuuuuuuu
Thank you Ab Tay!
Very nicely explained .... thanks
Thank you :)
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)
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
I learned a lot from you thanks and love
Thank you Kritik!
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!
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! ⚡
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 :)
Thank you s o much! you are awesome teacher
Thank you!
You are amazing!! Thanks alot 🙏🏽🙏🏽
A-M-A-Z-I-N-G!! Thank you!!
Thank you Justin :)
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"
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.
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 :)
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
25:20 context filters slow down the performance..but you shows it used for performance . how??
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
Love it! Thank you!
Thank you Etienne! Hope the part for context filters was helpful 🙂
simply awesome !
Thank you Premm!
Thank u so much loved this vidoe too much good ❤️
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! 😊
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..
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: ua-cam.com/video/0Uar_D57QhU/v-deo.html
If I have several filters (e.g. country\month\customer\channel) and want multiple filter apply to each other as top N, how should I set?