Відео

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: ua-cam.com/video/lG6HgkaKwTU/v-deo.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 ua-cam.com/video/oAtBy0wWN0I/v-deo.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! ua-cam.com/video/KE3zfKjVmFY/v-deo.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!

It will reset the filters but not the parameters. You might want to check out the Reset View button: ua-cam.com/video/V9zT2WFkahE/v-deo.html

@onenumbertableau thanks 🙏

Hi, thanks so much for checking this video out. In that scenario, it's probably best to create a second set of parameters and a second filter field.

Thank you! It would be a bit of a hack but you could do it with an approach like this: ua-cam.com/video/vAuJcRzv4Ow/v-deo.html&ab_channel=OneNumber-TableauExperts

Hi! I suppose you would need to come back and edit the pill to change the name again. If you'll be changing it often, it might be easier to rename the field in the data pane or just create a calculation that only contains the field in question that can be easily renamed whenever you feel like it.

So glad to hear it, hopefully this helps!!

Hmm, it's a good question! I think maybe a FIXED function is your best bet. Something like... { FIXED [Product Line],[Skills]:SUM([Hours])} Hard to say without digging into it together but here is a primer on FIXED functions: onenumber.biz/blog-1/2024/3/13/how-fixed-tableau-level-of-detail-function-works

Right on, you are welcome!!

You are welcome, thanks so much for checking it out!

For sure, thanks so much for checking our videos out!

Hi Dominic! Usually the best place to see that is in the tooltip. So you select the desired data points, hover over the selection for a couple seconds, and the tooltip should show you the totals.

Unfortunately, I don't believe so. Parameters are data source independent but Sets are tied to the data source they are created in.

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

We're glad to hear it was helpful. You're welcome!

That's so great to hear. Thanks for following up and letting us know!

You're welcome. Glad to hear it!

You're welcome!

The easiest way is to publish it when you've selected the home page. It often defaults to displaying the page you were on when you uploaded it! That's the easiest!

hey!! how did you achieve?? could you please help me on the same

@@abhiyt9026 Hi, maybe you can try deselecting "Show tabs" when publishing? I'm not sure if all the individual dashboards can truly be hidden but that might be worth a shot.

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