Well, that took no time at all. This past week was our first full week into 2016, and we were right about back to where we were activity-wise just before the holidays. Let's take a peak--
Zen Master, Robert Rouse did a guest blog post on the Tableau blog about a nifty trick - Create Dynamic Tableau Dashboard Layouts with Sliding Containers | Tableau Software
Last week, Carl Slifer achieved the "I Know Stuff!" badge - meaning 10 of his responses have been marked as correct. Carl is a relatively new member of the community - only joining this past November. If you read his profile biography, you'll notice he's been a data lover from the get-go. Hopefully, we'll continue to see more of you around Carl! Thank you for the help you've provided this community already!
Most Talked About Thread
**This is characterized by the number of responses in the thread
mark schukas asked a question about calculating sales by day of week where he had two calculations that were very similar, however, he was getting different results and he didn't understand why. Rody Zakovich took on the question and helped to explain what the LOD calculation was doing. After working more with Mark, Rody recognized that Mark probably didn't need to use a LOD at all - so he took a step back to ask what the end goal was. Often times, stating the end goal from the beginning will provide more clarity to the question, and can help others find the simplest solution. Looks like there may still be a little more work to do on this one - if not, please let us know how you solved it Mark!
(One of the) Top Viewed Threads
This is an oldie, but goodie when it comes to action filters. Back in 2013, ashish.lakhani asked a Question about action filter. Joe Mako provided several options for getting the actions to work as desired, and it did not involve changing the data source (contrary to what I had said, back in my support days). Several, if not all, of his recommended approaches still ring true.
Top Voted Idea
Last week's top voted idea was the same as the week before - Shawn Wallwork's Stop Changing Filters & Colors When Replacing Data Source (14 up votes). So, let's take a look at the second highest voted idea - Patrick Van Der Hyde's ISO8601 WeekDate rules applied in Tableau. Patrick and I run into this one pretty often, as our Jive data (the Tableau Community data) is in this format - so we may be biased. However, with 11 up votes this week - we're not the only ones!
In Other News
- As you may have noticed, more and more community members have either be participating in or posting their own Tableau brain teasers. Well, at the request of Shawn Wallwork, we've now made a category in Viz Talk to make these easier to find. Unfamiliar with the brain teasers? These are basically challenges that community members post and others try to find how to do it and will often times rate it. Take a look at some of the ones that have been posted in the past here: Viz Talk and see if you can solve!
- Though this discussion started before last week - the final answer and some clarification/discovery was posted just last week. John Sobczak asked the question: Excel data source file passed to Tableau Server when publishing workbook with Excel data Source? Jonathan Drummey posted the results from some testing and discovered even more when him and Shawn Wallwork did a screenshare offline. As Jonathan notes, this is a good discussion for people to understand since often times just because you've published a Tableau workbook that is connected to an Excel file to Tableau Server, does not necessarily mean that when the data source updates, the updates will be reflected on the published workbook.
- Rody Zakovich posted a new workbook in the Workbook & Calculation Library - check out Counting Active Customers from Sparse Data
- Emily Z asked What is the formula to use to find her target result. Adam Crahen, Renato Baruti, and Tableau kumar provided a couple of solutions. However, it was Adam who continually worked with Emily to help her get a solution by showing her LOD calcs and the edits she needed to make to other specific calculations.
- ukasz.gierada.0 asked How to hide title? Not so easy... This is a pretty neat solution/requirement that's not seen super often. Jim Wahl shows how parameters and layout containers can be used to show or hide a title based on the end user's preference. He goes through step by step instructions to show just how it's done.
I hope you all have a great rest of your week! And until next week, happy analyzing!
As always, feel free to send any suggestions, comments, or submissions for this digest my direction at firstname.lastname@example.org