OneNumber - Tableau Experts
OneNumber - Tableau Experts
  • 257
  • 1 196 244
How to Set Up Data-Driven Alerts in Tableau
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8
Want to learn how to set up alerts on Tableau Cloud/Server so that you can track certain metrics in the dashboards or sheets you're following? All you need is a dashboard published to Tableau Cloud and a measure-based axis.
In this tutorial, we run through how to set up and customize data-driven alerts in Tableau.
Data-driven alerts can be scheduled to run at the cadence of your choosing, so it's important to choose your timeframe wisely!
Connect with us:
•Book an hour to work with Ollie: onenumber.biz/office-hours
•Upcoming Tableau Classes: onenumber.biz/onenumber-tableau-classes
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: www.linkedin.com/in/oliverlinley/
Resources:
•Dynamic Zone Visibility Tutorial: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility?rq=dynamic%20zone%20visibility
•Dynamic Zone Visibility Dashboard: public.tableau.com/app/profile/oliver.linley/viz/DynamicZoneVisibility_16799877446940/Scatterplot
Переглядів: 176

Відео

Tableau Prep Foundations | Class Details
Переглядів 419 годин тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 Tableau Prep Foundations is a class that we’ve put together for anyone who wants to analyze their data in Tableau but: •Their data is too messy •They can't get the data formatted the way they want •They don't really know how to structure data for analysis Join us as we explore the foundational concepts behind Tableau's newest t...
How to Add a Back Button in Tableau (Quick Tip)
Переглядів 24321 годину тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 If you're working around a big workbook with multiple dashboards, navigating between them can be difficult. Using navigation buttons can give your end-users a convenient and demure solution. You can access simple, but effective icon packs at flaticon.com to help turn your buttons into more attractive options! Connect with us: •...
How to Union Tables in Tableau Prep
Переглядів 28414 днів тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 When you union tables in Tableau, you append two tables of data vertically. That means if you have two tables that are 1,000 rows each, the result of the union will be a single table that is 2,000 rows. Shared columns will align automatically, and unique columns will not. Unions provide the ability to relate multiple tables tha...
Mastering Tableau Calculations I | Class Details
Переглядів 8514 днів тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 Adopting new technology is daunting, especially if you are coming from another platform you already know well. Many people that are learning Tableau have a background in Excel and maybe even SQL so they understand how calculations work but don't know Tableau's syntax yet. This workshop will bridge that gap. We'll condense month...
How to Build a Help Overlay in Tableau (Quick Tip)
Переглядів 31821 день тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 Have you ever built a dashboard that you felt could be more useful with some hands-on instructions? Perhaps you've added those into the description, or into a text box connected to a few Show/Hide buttons. A Help Overlay is much more demure. Tucked behind a single Show/Hide button, you can add as many arrows, text boxes, and ot...
Tableau: Mystery to Mastery I | Class Details
Переглядів 7221 день тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 Tableau: Mystery to Mastery I is a fast-paced workshop which incorporates the best of the following Tableau classes; Tableau Desktop I and Desktop II. This course will build a foundational understanding of how Tableau Desktop works and is great for people with little to moderate experience in the tool. In this 16-hour class, we...
10 Questions To Prepare for the Tableau Data Analyst Certification
Переглядів 456Місяць тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 Tableau's Data Analyst Certification can be a tricky one to prep for. How will you get tested on Dashboarding? Will you have to build a dashboard? What will the Multiple Choice Questions be like? How much Tableau Prep or Cloud do you need to know? I wrote the certification a few months back and I wanted to share some of my lear...
Swap Worksheets Into a Tableau Dashboard (Quick Tip)
Переглядів 335Місяць тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 Do you dread swapping out worksheets in Tableau dashboards? You lose your dashboard formatting like padding, borders, and background colors. Not to mention, you might lose filters that are associated with a worksheet you are removing. The most efficient way to replace a worksheet in a Tableau dashboard is with the "Swap" button...
Custom Date Filter for Aggregated and Non-Aggregated Measures in Tableau
Переглядів 560Місяць тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 Creating custom date filters in Tableau takes some creativity and ingenuity. They can be especially tricky when they are used to control both aggregated and non-aggregated measures. Tableau is particular about how aggregated formulas are written. If you want to create a custom date filter in Tableau that controls both aggregate...
OneNumber Tableau Training Passport Updates!
Переглядів 93Місяць тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 Resources: •Book the passport or see details: onenumber.biz/tableau-training-passport •See all upcoming classes: onenumber.biz/onenumber-tableau-classes •Contact us at: start@onenumber.biz Want to ramp up on Tableau quickly? All aboard the OneNumber Express! We’re excited to announce some updates to the OneNumber Tableau Traini...
Change Fiscal Year Start in Tableau (Quick Tip)
Переглядів 352Місяць тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 If your organization's fiscal year doesn't start in January and you need to build some visualizations displaying your metrics against your fiscal year, you need to change your fiscal year start in Tableau! While there is a quick method to do that (which we cover here), it isn't a foolproof solution for all scenarios. Check out ...
Dynamic Zone Visibility with Tableau Dashboard Actions
Переглядів 2,3 тис.Місяць тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 Do you want to show and hide sheets on your dashboard with only a click? Dynamic Zone Visibility lets you do exactly that. This is far more dynamic than filter actions, as we can show or hide any number of sheets and their elements from a single interaction. There are a few key steps to getting this right, so follow along to se...
How to Conditionally Format Measure Names Color in Tableau (Quick Tip)
Переглядів 5402 місяці тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 If you're working with a lot of Measures in a Dual Axis chart, you'll need to use Measure Values. By default, Tableau can create a color spectrum for each Measure Value, allowing you to choose from a diverging or sequential color palette. But what if you don't want to color the values with a color spectrum, or a value-based col...
Dynamic Start and End Date Filter in Tableau
Переглядів 3 тис.2 місяці тому
🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6TJkMjsmBytig8 One of my favorite and most-often used date filters in Tableau is a range of dates with dynamic start and end dates. For example, you choose a range of dates (last 7 days, last 14 days, last 30 days, etc.) and then create dynamic start and end date filters that meet that criteria. This is a great way to provide a pre-selected f...
What Tableau Dashboard Size Should You Choose (Quick Tip)
Переглядів 7782 місяці тому
What Tableau Dashboard Size Should You Choose (Quick Tip)
How to Set Up Tableau Pulse
Переглядів 7492 місяці тому
How to Set Up Tableau Pulse
How to Freeze Total Rows in Tableau
Переглядів 1 тис.3 місяці тому
How to Freeze Total Rows in Tableau
Tableau Prep Join Types Explained (All 7!)
Переглядів 6853 місяці тому
Tableau Prep Join Types Explained (All 7!)
Reset View Button in Tableau (Quick Tip)
Переглядів 7763 місяці тому
Reset View Button in Tableau (Quick Tip)
How to Publish a Tableau Dashboard
Переглядів 1,6 тис.3 місяці тому
How to Publish a Tableau Dashboard
How to do DATEADD In Excel
Переглядів 2964 місяці тому
How to do DATEADD In Excel
Sort a Stacked Bar Chart in Tableau from User Selection
Переглядів 1,4 тис.4 місяці тому
Sort a Stacked Bar Chart in Tableau from User Selection
Tableau Classes | Summer 2024
Переглядів 1204 місяці тому
Tableau Classes | Summer 2024
Save a Custom View on Tableau Server or Tableau Cloud (Quick Tip)
Переглядів 6954 місяці тому
Save a Custom View on Tableau Server or Tableau Cloud (Quick Tip)
Tableau Dashboard Filter Actions Explained
Переглядів 4,2 тис.4 місяці тому
Tableau Dashboard Filter Actions Explained
How to Create Aliases in Tableau (Quick Tip)
Переглядів 9665 місяців тому
How to Create Aliases in Tableau (Quick Tip)
Label First and Last Points Only in a Tableau Graph
Переглядів 5295 місяців тому
Label First and Last Points Only in a Tableau Graph
Add Space Between Bar Chart Sections in Tableau (Quick Tip)
Переглядів 1,6 тис.5 місяців тому
Add Space Between Bar Chart Sections in Tableau (Quick Tip)
12 Essential Skills for Every Excel User
Переглядів 4815 місяців тому
12 Essential Skills for Every Excel User

КОМЕНТАРІ

  • @hyeonwoosong244
    @hyeonwoosong244 49 хвилин тому

    love this

  • @_keksdose_7897
    @_keksdose_7897 День тому

    Is it posible to union two tables from different data sorces?

    • @onenumbertableau
      @onenumbertableau День тому

      Unfortunately, this isn't possible in Tableau Desktop. However, you can do this in Tableau Prep if that's an option for you! onenumber.biz/blog-1/2024/9/18/how-to-union-tables-in-tableau-prep

  • @onenumbertableau
    @onenumbertableau 2 дні тому

    Need help with Tableau? Schedule an hour with Ollie: onenumber.biz/office-hours Ready to master Tableau? Check out our lineup of upcoming classes! onenumber.biz/onenumber-tableau-classes

  • @ethanolchoi
    @ethanolchoi 2 дні тому

    Very helpful. Thank you

  • @wallace13400
    @wallace13400 3 дні тому

    The Dynamic sizing is shrinking my charts to a point where you can't see the metrics. Is there no way to adjust it without the container being "fixed"

    • @onenumbertableau
      @onenumbertableau 2 дні тому

      Hmm. It might be worth looking at the Dynamic Zone Visibility approach to see if that gives you the control you need? onenumber.biz/blog-1/2024/8/7/dynamic-zone-visibility-with-tableau-dashboard-actions

  • @steves6557
    @steves6557 3 дні тому

    Very helpful, thank you. This method over others is preferable because it is dynamic and adjusts for the number of digits in a number. 👍

    • @onenumbertableau
      @onenumbertableau 2 дні тому

      You're welcome, thanks so much for checking it out! We're glad it helped.

  • @briankkrieger1685
    @briankkrieger1685 3 дні тому

    Great video and solution! Is there a way to do this so the parameter selection can act as a relative date function (i.e. this month, this week, etc.)?

    • @onenumbertableau
      @onenumbertableau 2 дні тому

      Hi Brian, thanks! Absolutely. We don't have a video on that exactly but you could create several calcs (Termination Date Selected T/F, Termination Date Prior T/F, Hire Date Selected T/F, Hire Date Prior T/F, etc) and reference them in different calculations. This video breakdown might help explain some of what I'm talking about: onenumber.biz/blog-1/2024/8/21/custom-date-filter-for-aggregated-and-non-aggregated-measures-in-tableau

  • @ppjn348
    @ppjn348 3 дні тому

    Awesome video! Thank you!

  • @YogeshPatil-zu2ju
    @YogeshPatil-zu2ju 3 дні тому

    @onenumbertableau: I have tried all the possible ways to solve this scenario for one of my ongoing projects. I have used parameter, filter, but I am not able to solve this completely. could you please help me to solve this problem? It would be greatly appreciated. I have mentioned the scenario here: client wants dynamic month over month for the selected years and also for the same year for KPI's and Visualization based on user selection, and he also wants multiple selection option. Please help me on this.

    • @onenumbertableau
      @onenumbertableau 3 дні тому

      Hi Yogesh! I'm sure there are elements of what you're looking for scattered across our videos, but it sounds like a really specific ask. I think our best bet would be to solve this together in an office hour: www.eventbrite.com/e/tableau-expert-office-hours-tickets-42691995909

  • @YogeshPatil-l8n
    @YogeshPatil-l8n 3 дні тому

    @onenumbertableau I have tried all the possible ways to solve this scenario for one of my ongoing projects. I have used parameter, filter, but I am not able to solve this completely. could you please help me to solve this problem? It would be greatly appreciated. I have mentioned the scenario here: client wants dynamic month over month for the selected years and also for the same year for KPI's and Visualization based on user selection, and he also wants multiple selection option.

  • @philipbmilner1
    @philipbmilner1 3 дні тому

    👏

  • @MrAstonmartin78
    @MrAstonmartin78 3 дні тому

    Hi Didn't U find the appropriate way to save Custom format when drilling upon the dates? Thanks

    • @onenumbertableau
      @onenumbertableau 3 дні тому

      Hi, for what it's worth, you can right-click on a date field in the Data Pane, go to Default Properties, and choose a custom date format from there. Maybe that accomplishes what you're looking for?

  • @onenumbertableau
    @onenumbertableau 4 дні тому

    Check out our upcoming Tableau classes here: onenumber.biz/onenumber-tableau-classes

  • @SonofthewindsInc
    @SonofthewindsInc 7 днів тому

    Mate, this has helped me a lot! Thank you buddy ! 👍

  • @DatDudeBull24
    @DatDudeBull24 8 днів тому

    Hi. Is there a way to do a multi value filter that’s an And type of setup instead of Or. For example if I have a data set of purchases and I want to know who bought shirt and shoes instead of shirt or shoes…is that possible?

    • @onenumbertableau
      @onenumbertableau 8 днів тому

      I suppose the best way to do this would be with a LOD calculation. Here's how you could do that. If you want to make it dynamic, replace the static text searches with parameter. Calc 1: Bought Shirt { FIXED [Customer ID]: MAX( CONTAINS([Product],'shirt') )} Calc 2: Bought Shoes { FIXED [Customer ID]: MAX( CONTAINS([Product],'shoes') )} Calc 3: Bought Shirts and Shoes [Bought Shirt] = TRUE AND [Bought Shoes] = TRUE

    • @DatDudeBull24
      @DatDudeBull24 7 днів тому

      @@onenumbertableau thanks! So in the calculation fields I could replace ‘shirt’ with the field that would contain shirt, shoes, socks etc (ex [Product])?

    • @onenumbertableau
      @onenumbertableau 6 днів тому

      @@DatDudeBull24 Not quite. I'm suggesting that if you want it to be dynamic, 'shirt' could be replaced with a parameter where the user can type in any keyword.

  • @joshuamay7747
    @joshuamay7747 8 днів тому

    Thank you for putting this out. Do you have any advice for doing this with future date ranges?

  • @KayakSoccerDancer
    @KayakSoccerDancer 9 днів тому

    ​@onenumbertableau Definitely like the color change on this, slick. However what if you need want to emphasize different pieces depending on which measure you're swapping? I'm also still confused on how you change the visit format to remove $$, I don't understand your responses to other people asking this same thing. Is there another video for that? Or is it something you can articulate differently, since I appear to be a little slow on the uptake with your other answers to this.

    • @onenumbertableau
      @onenumbertableau 9 днів тому

      Hi, thanks so much for checking out the video! Does this help with the number format question? onenumber.biz/blog-1/2020/9/10/how-to-create-a-dynamic-measure-with-multiple-number-formats-in-tableau

  • @onenumbertableau
    @onenumbertableau 9 днів тому

    Need help with Tableau? Schedule an hour with Ollie: onenumber.biz/office-hours Ready to master Tableau? Check out our lineup of upcoming classes! onenumber.biz/onenumber-tableau-classes

  • @AmarendraD
    @AmarendraD 9 днів тому

    Wondering if this would work for Custom Views?

    • @onenumbertableau
      @onenumbertableau 9 днів тому

      Yes, this should reset to whatever you set as your default view (even if its a custom view!)

  • @KayleenSchreiber
    @KayleenSchreiber 10 днів тому

    I created the calculated fields, but after I add them to the details, they don't show up as an option for a reference line. Could it be because I'm using YEAR for my date axis instead of DAY?

    • @onenumbertableau
      @onenumbertableau 10 днів тому

      Hi, yes that's a good point. I think the date parts need to match between the fields in order for this to work.

  • @XD-ll6rl
    @XD-ll6rl 10 днів тому

    This tutorial is very helpful, however when I try to apply the last step on pie charts, they did not resize very well

    • @onenumbertableau
      @onenumbertableau 10 днів тому

      Hi, thanks for the heads up. I'm glad this helped! Can you try sizing the pie chart to entire view to see if that helps? How to here: ua-cam.com/video/Ic6No-dFORU/v-deo.html

  • @AsherLucas
    @AsherLucas 11 днів тому

    It's kind of embarrassing that Tableau doesn't have a "move field labels to bottom" option in Table Layout... or anywhere. Such a very basic thing to not only have your field labels in the same place, but to be able to move them to the top or bottom. Especially when, traditionally, they tend to show up at the bottom of the charts. Also people have been asking for this for the better part of a decade.

    • @onenumbertableau
      @onenumbertableau 11 днів тому

      I agree this would be such an easy lift and such a quality of life improvement. All we can do is keep asking! Hopefully they can take a moment away from their AI chase to help with little lifts like this.

  • @GalaxySRLH
    @GalaxySRLH 12 днів тому

    Great 👍

  • @julianandressalazar5755
    @julianandressalazar5755 13 днів тому

    It doesn't work for me 😫

    • @onenumbertableau
      @onenumbertableau 11 днів тому

      Hi! Thanks for checking this out. Can you detail what specifically isn't working?

    • @julianandressalazar5755
      @julianandressalazar5755 10 днів тому

      ​@@onenumbertableau Hey! Thanks for answering. My reset button wasn't resetting the filters. I already fixed it and it was tricky. I had to right-click on each of the filters, then go to "Apply to Worksheets", then click on "Selected Worksheets", and then unselect the "Reset Button" worksheet. Great channel by the way 🤓thanks for your content

    • @onenumbertableau
      @onenumbertableau 9 днів тому

      @@julianandressalazar5755 Well done on fixing it! That's awesome! 🚀

  • @leyuliamz
    @leyuliamz 14 днів тому

    Thank you so much for sharing your solution! I had a very hard time figuring this out or even finding a solution through a Google search but you had the answer here all along.

  • @amulyakallakuri1361
    @amulyakallakuri1361 15 днів тому

    Thank you for your video, this was really helpful! I had a question -- If I had a dashboard with a bunch of different fields and wanted to filter all of them based on the start and end date filter, how would I do that? And is there a way I can use this start and end date filter as a slider and have that filter all the data on the dashboard?

    • @onenumbertableau
      @onenumbertableau 11 днів тому

      Hi, thanks for checking this video out! There should be some concepts in this video which should help you: onenumber.biz/blog-1/2023/6/7/how-to-filter-multiple-date-fields-at-once-in-tableau

  • @ChrisReynolds-c4k
    @ChrisReynolds-c4k 15 днів тому

    Omg, Tableau sucks. It's literally one function in Power BI, "UseRelationship".

  • @onenumbertableau
    @onenumbertableau 16 днів тому

    Need help with Tableau? Schedule an hour with Eric here: onenumber.biz/office-hours Ready to master Tableau? Check out our lineup of upcoming classes! onenumber.biz/onenumber-tableau-classes

  • @MrPlskjs
    @MrPlskjs 16 днів тому

    The only video I found that really helped! Thank you very much!

    • @onenumbertableau
      @onenumbertableau 16 днів тому

      That's so good to hear, thanks for letting us know!

  • @WendyWare
    @WendyWare 17 днів тому

    This looks nice but it seems like a lot of extra maintenance/effort as opposed to just putting user instructions in Tooltips. Am I missing some important advantage to this method?

    • @onenumbertableau
      @onenumbertableau 17 днів тому

      Hey Wendy! You're right that the initial effort to getting the Overlay built is higher than putting details in the tooltips. But, once it's built, it should be fairly easy to maintain, given that this would be added after the dashboard is completed. I guess it would be a preferable method to having user instructions in tooltips as it draws our user's attention to the areas of attention straight away (as opposed to hovering over each area to find instructions), and it keeps your tooltips clean to just have the super important data in them. I think another option would be to have an info button with some of the crucial information in it, too, if you don't want the overlay. Hope that helps!

  • @onenumbertableau
    @onenumbertableau 18 днів тому

    Want to dive in with us? Check out our upcoming classes here: www.eventbrite.com/o/onenumber-15678294163

  • @roxastidus4109
    @roxastidus4109 18 днів тому

    Hi, How do you deal with Clients having multiple kind of resolution, it seems that Auto-Mode doesn't respond correctly. the Fonts appears small.

    • @onenumbertableau
      @onenumbertableau 18 днів тому

      Hi! You are right about that. Text doesn't rescale effectively in Tableau. Honestly, I'd recommend going with either a Fixed or Range sized dashboard. Too much can go wrong with a full automatic dashboard. Here's a quick video with our recommendations: ua-cam.com/video/1rR-klvQj8E/v-deo.html

    • @roxastidus4109
      @roxastidus4109 18 днів тому

      @@onenumbertableau Thanks will look at it

  • @PragathiVunnam
    @PragathiVunnam 19 днів тому

    Hi, I have created a worksheet named "Filter by Prefix" and added COURSE_PREFIX( which is a calculated field) to be true in the filter section. In the dashboard I have followed exact same steps and created a RESET button. After clicking the RESET button, the filter COURSE_PREFIX in the worksheet " Filter by Prefix" is changing back to "ALL". Can you please tell me what to do?

    • @onenumbertableau
      @onenumbertableau 17 днів тому

      Hey! Good question - have you tried editing the filter action and removing the COURSE_PREFIX field from the "fields to filter" at the bottom of the action? Maybe that could help!

    • @PragathiVunnam
      @PragathiVunnam 14 днів тому

      @@onenumbertableau Yeah! Will do that. Thank you.

    • @onenumbertableau
      @onenumbertableau 11 днів тому

      @@PragathiVunnam You're welcome!

  • @LaurieMcConville-z7u
    @LaurieMcConville-z7u 21 день тому

    doesn't work for me with several measures. As soon as I add the set to colors, it splits the values into those in the set and those not within the same cell.

    • @onenumbertableau
      @onenumbertableau 18 днів тому

      Hmm. Can you reach out through our web form? Maybe I can help troubleshoot over email. onenumber.biz/contact-us

  • @LaurieMcConville-z7u
    @LaurieMcConville-z7u 21 день тому

    I'm still confused. WHy is visits in currency?

  • @thunderduck999
    @thunderduck999 21 день тому

    Regarding ZN function & your ice cream example, how do you factor in if there is no date in the database? Example, if there is no November 12, 2017 data. In other words, I have no sales for November 17, 2017, that date does not exist in my database. But I want to put zero (0) for that date.

    • @thunderduck999
      @thunderduck999 21 день тому

      Would like to display dates for all months on a run chart even the sales for a particular month is Zero (0).

    • @onenumbertableau
      @onenumbertableau 21 день тому

      Hi! Thanks for reaching out. I'd recommend using the New Rows feature in Tableau Prep to generate the placeholder rows you need. help.tableau.com/current/prep/en-gb/prep_new_rows.htm

  • @onenumbertableau
    @onenumbertableau 23 дні тому

    Need help with Tableau? Schedule an hour with Ollie: onenumber.biz/office-hours Ready to master Tableau? Check out our lineup of upcoming classes! onenumber.biz/onenumber-tableau-classes

  • @mbk7771
    @mbk7771 23 дні тому

    Hi, this video was very helpful. I was able to compare the sales for the last two months in my dataset. I was just wondering if it's possible to do this for every month? For example, if I click on January 2020 in the bar chart, it would show the percentage change in sales from the previous month, December 2019. Thank you!

    • @onenumbertableau
      @onenumbertableau 23 дні тому

      Hi! Thanks so much for checking the video out. Is this helpful? onenumber.biz/blog-1/2021/6/9/month-to-date-sales-compared-to-last-12-months-in-tableau

    • @mbk7771
      @mbk7771 20 днів тому

      @@onenumbertableau Thanks but if i use filter it doesn't show anything

    • @onenumbertableau
      @onenumbertableau 18 днів тому

      @@mbk7771 I'd recommend seeing if you can turn your filter into a Table Calc filter: ua-cam.com/video/nXn3M2qOvC8/v-deo.html

  • @YogeshPatil-zu2ju
    @YogeshPatil-zu2ju 23 дні тому

    @onenumbertableau: I need help on this scenario: I pulled Leads and Booking table from salesforce. I am having two date fields Lead Created date and booking date. I want to create Year-Month filter like(Jan-2024) by using Lead crated date and booking date so that based on the filter selection all the leads and bookings KPI's and visualizations are set to the Month-Year. I tried this with parameter based on Lead created date but I want it for both Lead created date and booking date in one filter only. Please help me on this. Your help would be highly appreciated. Thank You!

    • @onenumbertableau
      @onenumbertableau 23 дні тому

      Hi! I think you're looking for something like this: onenumber.biz/blog-1/2023/6/7/how-to-filter-multiple-date-fields-at-once-in-tableau

  • @pepex90
    @pepex90 23 дні тому

    Hello! How can I remove the filters when, for example, the map is also a filter? That is, the map filters the dashboard, but I want to reset the filters, including the map that is also a filter.

    • @onenumbertableau
      @onenumbertableau 23 дні тому

      Hey! The key here would be to show the action filter (from the map) instead of adding a second dimension-filter for the map. You could click on a sheet that's being filtered by the map, hit the dropdown, go to filters, and select the action filter linked to the map. It should display as a normal filter. Then you might be able to link up the reset button to this field! Let us know if it works!

    • @pepex90
      @pepex90 23 дні тому

      @@onenumbertableauThank you!

    • @onenumbertableau
      @onenumbertableau 23 дні тому

      @@pepex90 You're welcome!

  • @crenshaw007
    @crenshaw007 23 дні тому

    I knew about pivoting data in Excel but I didn’t realize why it’s so important for use in Tableau. This video very clearly and very simply illustrates the situation. Thanks for a great video!

  • @vasudham26
    @vasudham26 24 дні тому

    Would you please show us how to get a dynamic % difference for the current n days vs previous n days? Please and thank you!!

    • @onenumbertableau
      @onenumbertableau 24 дні тому

      Hi! Thanks for checking this video out. I think studying how we did custom date filters in this video might help answer your question: onenumber.biz/blog-1/2024/1/24/custom-date-range-filter-for-selected-and-comparison-periods-in-tableau

  • @onenumbertableau
    @onenumbertableau 25 днів тому

    Find our Upcoming Tableau Classes Here: www.eventbrite.com/o/onenumber-15678294163

  • @YYZ722
    @YYZ722 25 днів тому

    Thank you a million mate!!

  • @mbk7771
    @mbk7771 27 днів тому

    Very interesting! I have subscribed and will be watching your videos. I just have a question. I'm trying to calculate the depreciation value of cars from 2013 to 2022, but every time I do the calculation, I run into aggregation and non-aggregation issues. I want to be able to click on a car model (for example, from 2013) and find out how much it will depreciate over the next 5 years. I also want to predict the depreciation for 2022 and beyond for the next 5 years since I don’t have prices for 2023, 2024, and so on, but I'm really stuck. Thanks!

    • @onenumbertableau
      @onenumbertableau 24 дні тому

      Hi! Thanks so much for checking out the video, we're glad to hear it helped. If you're able to copy/paste the calculation with an error, I might be able to help! This sounds like a bigger undertaking than we'll be able to resolve on YT comments alone. You're welcome to book an office hour if you want to tackle it together: onenumber.biz/onenumber-tableau-classes

    • @mbk7771
      @mbk7771 23 дні тому

      @@onenumbertableauHi, thank you so much for the reply. However, I'm now working on a different dataset because the one I was using wasn't clean, and I messed up with too many calculations and visuals, lol. So, I decided to change it. Thanks again!

  • @dmedilicious8488
    @dmedilicious8488 28 днів тому

    why is it always the US map

    • @onenumbertableau
      @onenumbertableau 25 днів тому

      Mostly just because we build our examples off of the Sample Superstore dataset (so everyone with Tableau can access it), which is based in the US!

    • @dmedilicious8488
      @dmedilicious8488 25 днів тому

      @@onenumbertableau ok. Thanks

  • @mattbman
    @mattbman 28 днів тому

    I completed the Desktop Specialist in June and completed my Data Analyst certification in August. I considered Desktop Specialist an entry level certification and it focuses on the absolute basics of the Tableau Desktop application and how the pieces of the interface interact, including the basic chart types (line, bar, scatter). All questions are multiple choice questions where you select one answer out of 4 or 5 selections. I believe this could be passed by some using Tableau full-time after 6-12 months of usage, I also recommend going through the Exam Outline on the Tableau website point by point to ensure you have all the content covered, I remember at least 3 of the questions I had not used in my practical experience, but I had the answer because it was a specific point I had looked at in the exam outline. As noted in the video, Data Analyst is a next level certification covers the gamut of all the different pieces of workflow that would be required for you to provide a fully functional dashboard report (Tableau Prep to Tableau Deasktop to Tableau Server/Online/Cloud) and the advanced aspects of how to use the dashboarding elements. There are multiple different ways that questions have to be answered, include multiple choice, putting action steps in order using a drag and drop, manually writing portions of code into short text boxes, and a virtual machine that has a Tableau Desktop application that gives you specific instructions on what to do with a dashboard. I believe there were 10 hands-on tasks in the virtual machine and I would say it is about 3 to 4 questions each in difficulty categories of basic, intermediate, and advanced tableau functions. The questions are also phrased using very specific nomenclature so you have to understand the Tableau terms such as dimension, measures, sets, parameters, groups, and hierarchies, without very much additional description, so you need to know those terms and how the different dashboard elements would be affected by them and what would happen if you dragged particular fields or elements to the different cards (colors, marks, size, etc). I have been a full-time Tableau developer for 2 years, put about 4-5 hours into studying prior to the exam and still found it incredibly challenging. The only thing mentioned in the video that I didn't see on the Data Analyst exam was regarding Dynamic Zone Visibility, I did not get a question on that subject, but I could see in being in any rotating set of questions on the exam. I took the exam at a testing center, and was in the room with other people taking different exams, so I also could not speak above a whisper, I also asked the proctor if I could bring in a blank sheet of paper and pen and was refused, I wish that was allowed just to organize your thoughts on some of the harder questions.

    • @onenumbertableau
      @onenumbertableau 25 днів тому

      Wow Matt! This is such a thoughtful and insightful response! That's so helpful and I think a lot of people will really benefit from that. Thank you!

  • @onenumbertableau
    @onenumbertableau Місяць тому

    Need help with Tableau? Schedule an hour with Ollie: onenumber.biz/office-hours Ready to master Tableau? Check out our lineup of upcoming classes! onenumber.biz/onenumber-tableau-classes

  • @physicsfaith
    @physicsfaith Місяць тому

    That was very helpful!

    • @onenumbertableau
      @onenumbertableau Місяць тому

      We're so glad to hear it, thanks for letting us know!

  • @Tanmayislivee
    @Tanmayislivee Місяць тому

    I have 4 order priority in dataset and i want to make 4 donut charts for the same where each chart shows the % of orders fulfilled in specific order priority but im not able to make it can anyone help me out

    • @onenumbertableau
      @onenumbertableau Місяць тому

      Hey - you could make 4 donut charts by dropping your Order Priority field onto columns and then performing a manual sort on order priority to get it into the order you want! Hope that helps!

    • @Tanmayislivee
      @Tanmayislivee Місяць тому

      @@onenumbertableau well by doing that it creates 4 donuts with outer circle fully colored But I want the % of that order priority inside that donut and also I want that the outer circle of the donut should get colored according to the % of the order priority so how can I do this?

    • @onenumbertableau
      @onenumbertableau 25 днів тому

      @@Tanmayislivee Got you. I misunderstood you! You'll need to make four fields to do this and drop them onto Measure Values. You should be fine with percentages.If it doesn't work, let me know!