Skip navigation
2016

It's another Monday - and the last of January. So take a seat, grab a coffee (or a sandwich) and let's take a look into what happened last week and what can inspire you for this week -

 

Announcements

Do you think there could be just one best way to visualize data or could there be several? Check out this blog post by Ben Jones who discusses both points of view: Data Dialogues: To Optimize or to Satisfice When Visualizing Data? | Tableau Software. Feel strongly about it and want to continue the conversation? Start a post in Viz Talk

 

Please note if you downloaded Tableau Server versions 9.2.2, 9.1.4, or 9.0.10 - we ask that you rollback immediately due to a critical fix: Tableau Server 9.2.2, 9.1.4, and 9.0.10 Downloads are no longer available

 

 

Recognition

Last week, two members of the community achieved the "I Know Stuff!" badge - that means 10 of their responses have been marked as correct. The first is Rajeev Pandey. Rajeev joined the community this past summer and has been busily helping people out in the community all the way from Hyderabad, India. Rajeev is great at posting step by step directions with instructions - thank you for your contributions and we hope to keep seeing you!

 

The other member who achieved this badge is actually a Tableau employee, Paul Moran. Paul works on the technical support team out of our London office and we always love seeing him help out in the community

 

 

Most Talked About Thread

**This is characterized by the number of responses in a thread

Anthony Bour, a new member of the community, asked his first question in Setting Date Period of 27 Date Increments. Anthony got quite the response! It started with an "if statement" provided by Norbert Maijoor and Mark Fraser. However, Anthony was looking for something that was automated if possible. In come Shawn Wallwork, Jonathan Drummey, and Yuriy Fal each who provided different solutions. Ultimately, it looked like there was a combination of the solutions that solved the question for Anthony. Anthony, would you be able to mark the answer that best helped as Correct?

 

 

(One of the) Top Viewed Threads

LoD calculations is still something that people are always trying to get their heads' around. This thread is a great example that shows how sometimes it seems as though an LOD calculation may be needed, but really the solution can be solved with just a simple if statement calculation: LOD Calculation Filtering a Dimension without using Filter Card as shown by Shinichiro Murakami and Alexander Mou.

 

 

Top Voted Idea

A couple of our ideas have stayed at the top, so I'm going down the list. Looks like we have some ties with some other ideas that are making it to the top. Eleanor Jarvis created Parameter or Filter for Storyboards just last week and so far it's received 7 up votes. I love seeing ideas for story points!

 

 

In Other News

 

This has been another great week in the Tableau Community world. Hope you have good one this week.

 

Happy analyzing!

 

And as always feel free to send any comments, questions, or suggestions my direction at trodgers@tableau.com

Happy Monday all! This is bound to be another busy week, so let's dive right in to a look at what happened last week--

 

Announcements

If you missed it, last week, we had a Think Data Thursday, you can check out the recording and see more about it here: Think Data Thursday: JavaScript API UX of the Future

 

Did you happen to see the Vizzies last week? Matt Francis and Emily Kund hosted the first ever awards podcast, giving out titles like Community Leader, Best Dashboader, Data Do Gooder, and Must Run on Coffee or Coke, among others. Congratulations to all the winners! Want to watch Emily and Matt in their finest while they announce the nominees and winners? See it here: The Tableau Wannabe Podcast Awards - YouTube

 

Have you heard of MakeoverMonday? Well, very simply, a visualization is taken and the community recreates it to allow either get it to tell a better story or to make it more visually appealing. Andy Kriebel has done pretty regularly MakeoverMondays over the last few years. This year, Andy Cotgreave will be joining him in the series. Every Sunday, they'll be posting the data and challenge here: Makeover Monday Challenge. Then, check out what people have done on Pinterest (Makeover Monday on Pinterest ) or Google (Makeover Monday Challenge - Google Photos ).

 

The new Tableau Ambassadors will be announced by the end of next week - stay tuned!

 

Recognition

Last week, Thomas McCullough achieved the "Questions for Breakfast" badge - meaning that 25+ of his responses have been marked as correct. Thomas has been a member of the community since 2013, but has started picking up more questions over the last couple of months. His bread and butter seems to be calculations. Thank you for all your help Thomas, and hopefully, we'll continue see you around the community!

 

A few people received the "Help Desk" (5+ responses marked as correct) badge this past week, including Andrew Watson, panjala Srinath, and Dimitri Blyumin. Andrew has been a member of the community since 2012 and we're excited to have him back. Panjala has been a member for just under a year and is already starting to make his mark. Finally, Dimitri has been a member since 2010, and we are very excited to have him back! He used to be one of the regulars in this community, welcome back Dimitri Hopefully, we'll continue to see all three of you around here!

 

 

Most Talked About Thread

**This is characterized by the number of responses in the thread
Last week, Simon Runc started an Educational Brain Teaser: Bold Single Label on a Header. This was a great case of showing different ways of doing conditional formatting. And the solutions! There was the idea of simply using a calculated field and placing it the color/size shelf in combination with using minimum of Number of Records suggested by Pooja Gandhi. To using a calculation that looks at the value of a negative and using the built in formatting provided by Rody Zakovich. Or using the rich text editor solution that Mark Jackson to name just a few. Another great example of how there can be several ways to approach a problem in Tableau.

(One of the) Top Viewed Threads

Tomislav Mališ asked if there were a Maximum number of unique shapes in Tableau. This was a new one to me. Tomislav needed to add 955 images for each of his different records. It looked like no one else had run into this particular issue either.  Derrick Austin provided some background information on how they will be added to the twb. Ultimately, Tomislav used a thread created by Shawn Wallwork (QT: Dynamically Switch Images Using Filter ) to explain how he was able to solve the issue.

 

 

Top Voted Idea

Last week's top voted idea(s) were the same as the week before - ISO8601 WeekDate rules applied in Tableau and Shawn's Stop Changing Filters & Colors When Replacing Data Source. So, let's take a look at the third most voted idea of last week -  Control what displays in View Data. This was created by Darrin Schulte back in 2012, and received 9 up votes in the last 7 days. I run into this issue quite often, and have voted it up!

 

 

In Other News

 

 

Hope you all have a great rest of your week.

 

As always, feel free to send any suggestions, submissions or comments on this blog to me at trodgers@tableau.com

 

Happy Analyzing!

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--

 

Announcements

This week, we have our first Think Data Thursday of the week. Starting at 8:00 AM PST - make sure to tune in for Think Data Thursday: JavaScript API UX of the Future.

 

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

 

 

Recognition

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 A 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 trodgers@tableau.com

Happy New Year's everyone! Hopefully, you all had a fabulous holiday ringing in 2016. We had a pretty busy year last year - and I have a feeling more exciting things are bound to happen this year! Let's take a look into how we wrapped up 2015 -

 

 

Announcements

The first Think Data Thursday of 2016 has been announced. You won't want to miss Think Data Thursday: JavaScript API UX of the Future. Learn more and register so you don't miss it!

 

We finally got the translation back up and running at the beginning of last week. Sorry for the inconvenience. For more information, check out FAQ: Tableau Community Translations

 

I don't know how many of you are Star Wars fans, but over the holidays, I went and saw The Force Awakens and was left wanting more. Well, our social media team put together a fun activity of gathering and sharing the Star Wars data. If you missed it, check out what some people created: Star Wars: The Vizzes Continue | Tableau Software

 

 

Recognition

A relatively new user (well, he joined in May 2015, but has been pretty active the last 2 weeks, Bill Saltmarsh has achieved the "Help Desk" badge, meaning 5+ of his answers have been marked as correct. But even better than that, is that of the 8 threads that he has participated in, 5 of those have been marked as correct - that's a pretty good percentage! Hopefully, we'll continue to see you helping people out in the community, Bill

 

 

Most Talked About Thread

Michael Lawton joined the Tableau Community last week and asked his first question on the same day - Can anyone help me figure out how to do this? Enter Bill Lyons and Norbert Maijoor. Both supplied Michael with example workbooks that use Level of Detail calculations. Bill went into detail about what he did and how the calculations worked. He also made some suggestions to unpivot the data so that only one calculation needed to be created instead of multiple. All of this information helped Michael get the answer that he needed and gave him the results he was expecting.

 

 

(One of the) Top Viewed Threads

In August, Rody Zakovich branched off this thread about LOD calculations Should I use FIXED or INCLUDE/EXCLUDE? It's a great thread, as it got replies from several people who go into detail about LODs and the differences in using different functions from people such as Mark Jackson, Jonathan Drummey, Simon Runc, and Bora Beran. It's definitely a good read. One of the takeaways that I found interesting is how Jonathan approached creating a viz, and how it varies whether he has a goal in mind vs. wanting to explore.

 

 

Top Voted Idea

In November, Shawn Wallwork created Stop Changing Filters & Colors When Replacing Data Source. This was the same top voted idea as last week. It received 6 votes, giving a total of 52 votes. Shawn also added a comment to the idea with another idea for the Tableau Dev team - "Fix-the-little-stuff-a-thon." I'll definitely be sending this information to the Dev team, if they haven't already seen it

 

 

In Other News

 

I hope everyone has a great rest of their week!

 

As always, feel free to send any comments, suggestions, or submissions for this digest my way at trodgers@tableau.com

 

Until next week, happy analyzing!