วีดีโอ

You're welcome!

You're welcome!

You're welcome! What do you think of something like this? th-cam.com/video/gNmdgXA3zmI/w-d-xo.html&ab_channel=AndyKriebel

@@onenumbertableau wow, thank you so much for the follow up! This is exactly what I was looking for 👍

@@sienna_personal Glad to hear it!

Glad to hear it was helpful!

You're welcome! We're glad this helped

You're welcome! I think I'd create a separate branch and pivot step for the dates. Then you can pivot the dates in a similar fashion and join them back on the employee id. Does that work?

Thank you very much ! I did it in the same branche, I added one transpose before the aggregation. Then i aggregated all the columns at once !

your video helped me a lot, thank you again! I sent you an invitation on linkedin

I just spent a few minutes trying out ideas and you stumped me! The only way I can find to do it is with the back button.

That sounds like someone applied the Use Data Interpreter feature to a file-based data source. I suppose you'd need to reconnect to the original data source and then select the checkbox next to "Use Data Interpreter" again to recreate the same source file.

Thank you! Can you manually hide them? Like add the "Client Name" field to the Rows shelf, right-click on the one you want to hide and select "Hide"?

Hey! How's this? IF RANK(SUM([Value])) <= 3 THEN "Top 3" ELSEIF RANK(SUM([Value]),'asc') <= 3 THEN "Bottom 3" ELSE "Other" END Then you can drop that field on Color and you'll be good to go! 🙏🏻

@@onenumbertableau Thanks a lot, it worked as intended.👍

You're welcome! Not with a creation like this but we recommend checking out the Reset Views button: th-cam.com/video/V9zT2WFkahE/w-d-xo.html&ab_channel=OneNumber-TableauExperts

Thank you!!

You are welcome!

We're so glad to hear it, you're welcome!

Right-click on the axis, select "Edit Axis", select "Tick Marks" and adjust as wanted (set to None if you want to see no number)

@@onenumbertableau You are the GOAT of solving tableau problems!!!

@@ragragrec1 Wow thanks so much!

You are welcome!

Hey - I think you can, but you would need to adjust your filter accordingly. This simple parameter probably wouldn't work there. You'd need something more like this: th-cam.com/video/PM0O3uVJ-Bw/w-d-xo.html

Thank you, you are welcome!

You are most welcome!

Hey! I would do something like: 1. Create a parameter called "Show/Hide Dimension" (Boolean output) 2. Create a calculated field called "Show [Dimension]." This should read: IF [Show/Hide Parameter] THEN [Dimension] ELSE "" END 3. Put this on Rows/Columns That should help!

Hi Mitch, I suppose it depends on how the data is structured. Would you have the ability to filter to a prior week to see what the values were then or is your data source "real-time" without the ability to easily filter to prior values?

Thank you! Good feedback, here's a copy of the workbook from the walkthrough that you can download: public.tableau.com/app/profile/eric.parker/viz/DivergingBarChart_17185718078620/Title

Hi, I'm not sure what you mean by "outline by value size". Can you share more or a link to the resource you're talking about?

I meant sort the bottom segment by value from highest to lowest, the link I posted above as an example, but it is 8 years old, is any up-to-date approach?

@@oksanavorobiova8929 I don't see a link but I don't know of a way to retain the visual of a stacked bar while doing the nested sort individually per row (e.g. the color sequence is different in each row). Here's the closest thing I could build that resembles what you're asking (I think): public.tableau.com/app/profile/eric.parker/viz/CustomNestedSortPerRow/Title

Hi! I would try creating and Custom View (like this: th-cam.com/video/cmrIhzbvDVA/w-d-xo.html&ab_channel=OneNumber-TableauExperts) saving it as your default, and then utilizing this Reset View button from this video!

You are welcome!

Hi Esther, these calculations should work even if you break them down by a dimension. If you want help designing something custom from scratch, maybe an office hour would be a good fit? Happy to help!

Thank you, we're glad to hear it helped!

You might need to union the table to itself and create a single date field so you can show each value twice. Different scenario but if you jump to around 13 minutes in this video, we walk through a similar scenario. onenumber.biz/blog-1/2023/7/12/how-to-calculate-running-headcount-in-tableau-with-start-and-end-date-fields

That works, its been some time looking for the solution. thank you so much.

@@mahamoodsalamalipm6979 Glad to hear it, you are welcome!

Hey! Thanks for the message. I would think that the issue here is that stories function differently to dashboards. Each tab of the story is essentially a new view or a standalone entity. I am not aware of a viable alternative for stories using this method I’m afraid!

Glad to hear it, you are welcome!

In that case, I would create a Fiscal Year of Today calc and reference that instead for your max date. Something like this. YEAR(DATEADD('month',3,TODAY()))

@@onenumbertableau Thank you so much! This has resolved the error I was experiencing with my report.

@@Esther_Worships Great to hear, you are welcome!

Hi John! Thanks for checking this video out. Unfortunately, this approach won't clear worksheet selections. However, we've got a video dropping on Wednesday about the "Reset View" button that should help with your question!

Great to hear, thank you!

We're glad to hear this is helpful, we like the idea of a Floating vs. Tiled video. Thanks for suggesting!

I don't know if that's very feasible. If you need to define the shared field, you can do that through the Data dropdown on the toolbar in Tableau and then selecting "Edit Blend Relationships". Otherwise you'd need to do something tricky like create a placeholder calculation with matching text and try to blend on that. That could have so very unintended duplication effects however.

Thank you so much!

Interesting! I was just working with a client on this exact problem this morning. However, are you trying to compare months or years? I'm imagine something like today is June 5th but only the 3rd weekday of June, so compare that to May 1-3 since those are all weekdays. I don't have a video on the topic right now, but you're always welcome to shoot me an email or schedule an office hour and we can work on it together!

Also, you might find this Tableau help article interesting: help.salesforce.com/s/articleView?id=001458004&type=1

I have the filter on the worksheet and whenever I click filters And select the filter that I want from the drop down. It's not showing on the dashboard

Fair enough! Click on the dropdown arrow on the top-right of a worksheet in a dashboard, hover over the "Filters" breakout menu and select the one you want to add. Good luck!

@@onenumbertableau That's the issue. That is what I'm doing and nothing happens. I'm watching everyone else explain it that you just do that and the filter appears. For me it doesn't appear

@@DrDrewRulez Look all over your dashboard, it's probably showing up really tiny and crammed at the bottom/side of a layout container. Maybe in the bottom of the dashboard that you can't see until scrolling down.

@@onenumbertableau Thank you! I found it. It kept on appearing under everything. It's a really large dashboard with a lot of stuff so I had to keep on hitting all the drop down arrows on the layout to find it