Видео

Hey! We haven't yet found a way to add Totals just yet. It seems that others have worked around this by simply using another extension... Hopefully Tableau adds this soon!

Thanks for checking this video out! Can you switch the aggregation from ATTR to MAX and see if that helps? Here's a quick breakdown on why you're getting an asterisk: onenumber.biz/blog-1/2018/2/28/why-am-i-getting-a-in-tableau#:~:text=What's%20going%20on%3F,it%20will%20return%20an%20asterisk.

@@onenumbertableau MAX Worked. Thank you!

@@TransformingTheFosters Glad to hear it, you're welcome!

It will keep the data from the left column and purge the data from the right column.

So glad to hear it, thanks for letting us know!

You're very welcome!

Might be worth setting a up a parameter driven sort in that case: onenumber.biz/blog-1/2020/4/8/giving-your-user-multiple-sorting-options-with-tableau-parameters

Ha! Sounds like you should just roll with the Reset View button if this is proving too tricky: ruclips.net/video/V9zT2WFkahE/видео.html&ab_channel=OneNumber-TableauExperts

Thank you, you're welcome! Are you looking for something like this where you can overlay the two periods on top of one another? Or even to calculate the difference? public.tableau.com/app/profile/eric.parker/viz/OverlaySelectedandComparisonPeriodsonLineGraph/Title A video on this is dropping Wednesday!

Have you tried creating "Range Size" Tableau dashboards? Might be a good solution for that situation.

Hi, unfortunately that won't work. Data from secondary data sources aggregate to match the level of the primary data source. If possible, I would use the more detailed table as the primary table. I cover that concept a bit more in this video around 22:00 as well ruclips.net/video/TaxtdUzbcZs/видео.html

Thank you! Can we put you in charge of product development? 🙏

Maybe try just changing the mark type to Polygon instead of this approach?

Thank you, we're glad to hear you found it helpful!

I used Zoom to record and the free tool Zoomit to screen annotate.

Do you think the macro-demographics of the US have changed that much in a decade? I'm not so sure!

Updated figures look pretty comparable: www.city-data.com/forum/general-u-s/3481412-population-us-time-zones.html

Hi! You'd need to do it one-at-a-tie like this: IF YEAR([Date]) = 2021 THEN [Sales] END Good luck!

Hey! It's called Presentify! Great little app.

@@onenumbertableau thank you so much

Thanks for that! That's a good point!

Does this mean i can't have filter applied to multiple sheets? My dashboard requires 5 sheets.

@@kennisrogers2585 you'll have to experiment a bit. This "Reset" button is a bit of a workaround and does have some limitations. We have managed to get it to work across multiple dashboards before. However, remember that when you're viewing the dashboard in Public/Server/Cloud, you'll have a button to reset the view to default, which might be useful too!

Thank you, so glad to hear you found this helpful!

Hi! Sure! There are loads of ways to filter dates with parameters in Tableau. For example, here's a video on how to filter the selected and comparison periods at the same time: ruclips.net/video/NbD1qnIY4ok/видео.html

Hey! :) In general, users should have a Creator or Explorer license while Viewers can receive alerts but can't create them. Alerts are based on the data in the view, and data they're authorised to view (with their RLS restrictions). So if I create an alert for "Sales > $5000" and I only have permission to view East Region sales, the alert will only trigger for a Sale exceeding $5000 in the East Region. And yes - that would have been a good addition! Thanks for the feedback!

How strange. The URL is functional but presents an error when routing there from RUclips. Try to copy and paste the URL and it should work. Thanks for the heads up, we'll look into it.

@@onenumbertableau Thanks for answering. I've tried copying the URL and pasting it into a few different browsers. It doesn't work there either.

@@Seraphic75 How about from here? data.world/ericparker/customer-survey-responses

You are welcome!

So glad to hear it. Thanks for letting us know!

Hi! I think you could do that by writing a calc that segments those groups, adding it to the rows shelf, and then adding an average line at the Pane level. The calculation would be something like this: IF RANK_PERCENTILE(SUM([Sales])) <= .3 THEN "Top 30%" ELSEIF RANK_PERCENTILE(SUM([Sales])) <= .7 THEN "Middle 40%" RANK_PERCENTILE(SUM([Sales])) <= 1 THEN "Bottom 30%" END Good luck!

Thank you, we're glad to hear it sounds like this was helpful!

Just depends. Tableau is an amazing analysis tool, but it isn't designed to be a spreadsheet tool like Excel or Google Sheets. You can do workarounds to get it there, but that wasn't the original intent and design. You might be interested to check out the Tableau Table Viz Extension if you're trying to build spreadsheets in Tableau: onenumber.biz/blog-1/2024/12/18/tableau-table-viz-extension-explained

Hey! Sorry for the late reply - and thanks for the message. I think all the information stays the same in terms of sections of information you'll need to know - it's just the format of the exam that's slightly different. I found this section pretty helpful when preparing: www.tableau.com/learn/certification/tableau-certified-data-analyst-exam-guide Hope that helps!

You are welcome, thanks for letting us know! We always appreciate that.

If you add fields to the tooltip of the Marks card, they should show up in the initial data preview. However, the experience is not fully customizable unfortunately. You could always look into allow the user to drilldown to a detailed sheet: ruclips.net/video/lG6HgkaKwTU/видео.html

Hi, that sounds really unexpected. Are there any other filters changing or being applied? It seems like the value ranks should not switch like that unless there is something else impacting it. The other thing worth looking at is the scope/direction that is applied to the RANK Table Calculation. If you aren't super familiar with that topic, you can brush up on it in this video starting around 8:00 ruclips.net/video/oAtBy0wWN0I/видео.html&ab_channel=OneNumber-TableauExperts

You are welcome, we're glad to hear this helped you. We appreciate the suggestion too! 😅

Hi! If you aren't able to right-click and drag to add the calculation, you can always change the aggregation from SUM to MAX after the fact too. Just hit the dropdown on the pill, select the Measure breakout menu and select "MAX". Good luck!

@@onenumbertableau Hi, i am having another problem with the PIE chart label overcrowding. When filter the dashboard the labels either crumbled up in the middle of the dashboard or they are overlapping over one another. How can i solve this issue? Do you have a video that addresses this issue? thank you very much and happy holidays!

@@bjoy20101 Hi! There's not perfect way to handle this but one option is to overlay a small pie chart inside of a larger one so the slices appear like they're in the middle of the larger slices. More on that here: www.biztory.com/blog/how-to-label-pie-charts-in-tableau-biztory#:~:text=You%20can%20create%20the%20appearance,pie%20charts%20and%20two%20axes.

@ thank you so much👍

@@bjoy20101 You're welcome!

Can you color them the same as zeroes? In that case, maybe just the ZN function could help e.g. ZN(SUM([Sales]))

You could probably just add a filter like [Unified Date] <= TODAY() and then it will filter out future data. Let me know how that works!

So glad to hear it, you're welcome!

Hi! You could try to set a 3 step color with a diverging color palette or you could even create you own custom diverging palette you can use in the sheet. More on that here: onenumber.biz/blog-1/2019/4/17/creating-a-custom-color-palette-for-tableau

Hi, thank you so much! This might not be a perfect fit but I hope that it's in the right direction. With Dynamic Zone Visibility, you should be able to get containers to appear/disappear based on selections. Let me know if you have any questions! ruclips.net/video/KE3zfKjVmFY/видео.html&ab_channel=OneNumber-TableauExperts

@@onenumbertableau Thanks for the answer, but working with show/hide with multiple containers doesn't seem to be easy. I can't find it anywhere, I tried a few things but to no avail.

Hi! Not exactly but here is a Week to Date vs. Prior Week to Date post: onenumber.biz/blog-1/2020/9/7/week-to-date-vs-previous-week-to-date-in-tableau-wtd Write a calc like this to "Change the week start" that you can use in your week to date calcs: DATEADD('day',-1,[Date Field]) I think that should do the trick!

Hi! I'd recommend trying to add a "Download" object to your dashboard with a download PowerPoint option preset

Amazing, hopefully you find a lot of uses for it. Thanks for letting us know!

You are welcome, so glad to hear this helped!

Dang, that's a pretty solid guess, especially for Mountain Time! I overestimated that for sure

Thank you, glad to hear it was helpful!