Skip navigation

Good morning and happy Monday - the last of April! Last week, we had our annual company meeting - always a good time - and there was A LOT of talk about how amazing of a community we have. So THANK YOU all for making our community what it is! Here's this week's digest:

 

 

Announcements

You don't want to miss the Announcing:  Developer Office Hours for Web Data Connector this Wednesday at 10:00 PDT. Ask the developers who created the WDC whatever you'd like. Already have a couple questions you'd like to see them answer? Post it to the above thread.

 

Were you able to make it to Think Data Thursday: State of the Unions with Joshua Milligan? If not, the recording is now up - you'll definitely want to check it out!

 

Check out this post by Tableau Ambassador and Zen Master, Jeffrey Shaffer, on 5 Tips on Designing Colorblind-Friendly Visualizations | Tableau Software.

 

 

Recognition

Two people received the "Questions for Breakfast" badge, meaning that 25 or more of their responses have been marked as correct. Both Tharashasank Davuluru  and Andrew Watson have been helping people get their problems solved. Tharashasank joined the community this past December and has been continuously working his way through achieving each "correct" answer badge. Andrew has been a member of the community since 2012 and has been coming in and out of the community since sharing some great nuggets of content. Thank you both for all you do for the Tableau Community!

 

 

Most Talked About Thread

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

eliza suzuki had a question about finding the MAX Value across dates. After going back and forth with Joe Oppelt and The specified item was not found. to get to the root of the issue. G Marc Turner explained that her original calculations were table calculations and not LOD expressions which is why she was having some issues. He then, provided two calculations that do use LOD expressions and solved the issue for Eliza in on fell swoop!

 

 

(One of the) Top Viewed Threads

In 2014, Mary Solbrig posted ESRI Shapefile importer: R. Since then, it has received 87 replies, and Mary is always engaged answering questions people have about it. Definitely, a fantastic post that is worth checking out if you use R or are thinking about how you can use R with Tableau.

 

 

Top Voted Idea

Three ideas received 6 up votes this week - having them all tie for 1st place. First, Multi-Values Parameters created by Loic Grange giving it a total of 856 votes. Having a background picture in a dashboard (requires transparent chart areas)  created by Geert Janssen now has 60 votes. And finally, Shawn Wallwork's idea Stop Changing Filters & Colors When Replacing Data Source has 176 votes (I'm really hoping for this one )

 

 

In Other News

 

 

That's a wrap! Hope everyone has a great week - until next time, happy analyzing!

 

As always, feel free to send any comments, suggestions, or submissions my direction at trodgers@tableau.com

Good morning Tableau Community! I hope you all had a fabulous weekend. I spent all last week in the Midwest (Detroit and Milwaukee) presenting about Tableau to people who have never used it, and I couldn't help, but talk about the awesome community we have here. With that said, let's see what happened last week!

 

Announcements

Interested in learning more about how to use Tableau with AWS? Check out this webinar Analytics in the Cloud with Tableau on AWS | Tableau Software with Tableau's Ross Perez.

 

Don't forget to submit your applications to apply at TC16 - Austin, this year! Here's the application: http://tabsoft.co/1SbNefN Oh, and did I mention, if you're selected you get a free ticket?

 

Ever run into the need to migrate workbooks and data sources at your organization? Check out this blog post to get some ideas on how to do it - A Tableau Champion's Guide to Migrating Tableau Workbooks and Data Sources | Tableau Software

 

 

Recognition

Last week, Mahfooj Khan received the "I Know Stuff!" badge - meaning that at least ten of his responses have been marked as correct. Mahfooj joined the community less than a month ago, and he's already having an impact! Hopefully, we'll continue seeing you Mahfood Thank you for everything you've done already!

 

 

Most Talked About Thread

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

ChandraSheker A asked Can we Smoothen the Spikes? where he wanted to see his line chart to see less sharp points in the view. This turned into an interesting discussion, as David Milmont, Rody Zakovich, and Shawn Wallwork explained how smoothing the line can be a misrepresentation of the data, however, explained some ways around it. Looks like the solution that solved the issue was using a quick table calculation of a moving average.

 

 

(One of the) Top Viewed Threads

Chris McClellan asked a Q: Vision impaired ? He is working with a client who is concerned about blindness in the general public and is not sure how they would be able to understand what is represented. Zen Master, allan.walker.0, provided several workarounds for dealing with varying degrees of blindness. However, it still looks like it's not quite what Chris' client is looking for. Have any ideas? Let Chris know!

 

 

Top Voted Idea

JOIN Data from Different Sources created by Mark Jackson received 10 votes last week - giving it a total of 615 up votes. This idea becomes particularly useful so that data blending isn't necessary (and you can start aggregating across data sources). This definitely has my vote!

 

 

In Other News

 

 

Have a great rest of your week everyone!

 

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

 

Until next week, happy analyzing!

Welcome to the last week of March 2016! I can't believe we're already this far into the year, and things don't seem to be slowing down anytime soon. Let's take a look into a slice of the community -

 

Announcements

In case you missed it, Tableau 9.3 was released last week. Check out the features before downloading it here: Tableau 9.3: Data, set, flow. And to kick it off, our social media team created this fun love your data quiz that's definitely fun to check out: #DataLoveAffair: Find Your Data's Perfect Match with Union | Tableau Software

 

Have you seen the latest Tableau Ambassador Spotlight - Norbert Maijoor? I learned a lot about Norbert Maijoor and how he uses Tableau - I think we can all learn a thing or two.

 

Last Thursday was a Think Data Thursday with Rody Zakovich teaching us all about how to use dates. If you missed it, you can find the recording here: Think Data Thursday   Dating Rody - YouTube.

 

 

Recognition

Ben Page achieved the "Questions for Breakfast" badge - meaning that at least 25 of his responses have been marked as correct. Ben, a consultant out of Chicago, has been a member of the community since last summer and is making his mark. He's contributed a couple of brain teasers, as well as helped out several people. Thank you for all you do, Ben!

 

Two people also received the "I Know Stuff!" badge (aka 10+ of their responses were marked as correct). Takaaki Koseki and Tableau employee, Cor Bader, both achieved this badge and are helping out this community. Thank you both!

 

 

Most Talked About Thread

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

Angie Tarbet asked a question about Sheet Selector for Dashboard-overlay sheets to use entire real estate on dashboard? She was having a hard time getting the trick of using a parameter to change what is displayed on the dashboard. Suraj Shah was working diligently with Angie, but they couldn't quite get the sheet swap to work with the tree map. In comes social media ambassador, Alexander Mou, who posted an example on Tableau Public, and then, wrote his own blog post about it - Vizible Difference: Seamless Sheet Swapping. Great trick, Alexander - thanks for sharing!

 

 

(One of the) Top Viewed Threads

Alexander Mou started this post in an effort gathering the Evolution of the Order of Operations Diagram. It's a great thread with lots of detail from both Joshua Milligan and Jonathan Drummey.

 

 

Top Voted Idea

In 2012, Thierry Jakircevic created the idea Different Columns Width. I know that I've certainly run into this, and last week, it received 9 up votes, giving it a grand total of 462 votes.

 

 

In Other News

 

 

Hope you all have a wonderful rest of your week. Until next time, happy analyzing!

 

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

Have you had your coffee? Need a second cup? Now would be a good time to grab it and catch up on what's happening in the community.

 

Announcements

This Thursday could be a full dose of Tableau for you. At 8:00 AM PST, Rody Zakovich will be presenting a Think Data Thursday: Dating Rody, where he'll be  uncovering all he knows about dates and Tableau - you won't want to miss it! Then, stay tuned at 10:00 AM PST for the Secure Data and Analytics in the Cloud with Tableau Online webinar with two of our Tableau Online experts.

 

 

Recognition

This past week, Tableau employee, Dan Cory achieved the "Question Slayer", meaning he has had 50 of his responses have been marked as correct. Dan is great at providing workarounds, solutions, and delivering feedback back to our internal team about what the community is talking about. He's a great resource - thank you for everything you do, Dan!

 

Carl Slifer achieved the "Questions for Breakfast" badge meaning 25 or more of his responses were marked as correct. Carl seems to have a knack for keeping track of numbers (just read his bio), and providing details on how to obtain a particular outcome in Tableau. Thank you Carl for being so involved and helping people get answers to their questions.

 

 

Most Talked About Thread

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

Shivang Desai posted a question around Applying a filter to only specific parameter value. In his thread, he's using a parameter that references multiple fields (so that he can change the view), but would like for a filter to be applied only when one particular selection (or field in the parameter) is made. swaroop.gantela provided a solution that takes the calculation a step further by defining the field and it's constraints so that only it is filtered. There was an issue where mixing aggregates was keeping the solution from working, but ultimately, Shivang was able to achieve what he was looking for.

 

 

(One of the) Top Viewed Threads

Priyanka Agrawal needed help finding Current month and previous 6 month calculation, however, she did not have a date field in her data - only strings. Stephen Lavery showed her how to convert her string fields to be recognized as a date, and Joe Oppelt worked with her to explain how more data was needed to get the desired view.

 

 

Top Voted Idea

Shawn Wallwork created Don't Resize Floating Objects When Desktop Size Changes back in September of 2013. This week, it received 20 up votes - giving it a grand total of 38 votes - that more than half of all it's votes in one week.

 

 

In Other News

 

That's it for this week - hope you all have a fabulous rest of your Monday.

 

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

 

Happy Analyzing!

It's another Monday, so you know what that means - time for a roundup of what's going on in the Community. And there seems to be a lot going on! Let's take a look:

 

 

Announcements

New to Tableau and want to learn more? Did you know that there's Tableau for Dummies book written by two Tableau employees? Join Molly Monsey and Paul Sochan for a webinar next Wednesday, March 23 - learn more and sign up here: Tableau for Dummies: Meet the authors | Tableau Software

 

Want to take part in a viz competition that's also for a good cause? The Tableau Foundation is supporting a non-profit helping people in Morocco turn fog into drinkable water. To learn more, check out: Competition: From Fog Nets to Neural Nets

 

We're always trying to get feedback on what people think of Tableau - Request: Please give us your feedback!

 

Next week, is another edition of Think Data Thursday with Tableau Ambassador, Rody Zakovich in Think Data Thursday: Dating Rody. That's right, Rody will be talking all about how to use dates with Tableau - you won't want to miss it!

 

 

Recognition

Three members achieved the "Questions for Breakfast" badge, meaning that at least 10 of their responses were marked as correct. Joey Minix, Tharashasank Davuluru, and Juracy Americo all have helped people get the answers to the questions that were needed. Hopefully, we'll continue to see them all in the community helping people out. On behalf of the community, thank you all!

 

 

Most Talked About Thread

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

mark schukas  was running into an issue where the calculated field he was placing on the color shelf was not being interpreted correctly by Tableau in Calculated Field on the Color marks card.  Tableau employee, Nicholas Hara explained that since the end user was replacing the data source or connecting to a new file that the color legend needed to be reapplied. Looks like the issue was most likely resolved using the Tableau Data Server. Mark, let us know if your answer is resolved by marking how your problem was solved!

 

 

(One of the) Top Viewed Threads

This is an oldie, but goodie. If you've never seen Olivier CATHERIN's Sankey diagram made of dynamically generated polygons post, you need to check it out. These are some beautiful visualizations, and Olivier goes through step by step on how to create them.

 

 

Top Voted Idea

In 2012, Michael Moreyne created the idea New Chart types: Radar/Spider, Perceptual, Tornado. This past week, it received 15 of it's 60 votes. Look like this one might be trending, check it out and vote for it one way or the other if you'd like to see these types of vizzes in Tableau.

 

 

In Other News

 

 

Have a great week everybody and until next time - happy analyzing!!

 

As always, feel free to email me with suggestions or comments on this digest at trodgers@tableau.com

Good morning, from a super wet Seattle! Hope you all had a wonderful first weekend in March. Here's a peak into some of what was happening last week in the Community -

 

 

Announcements

Thank you to Shawn Wallwork who wrote last week's Community Digest - Ending 2/29

 

Don't forget to sign up for being a speaker at Tableau Conference this year: TC16 Call for Speakers!

 

See this new page to check out all the The Tableau Community Ambassadors!

 

We now have new avatars to choose from in the Community. If you don't want to upload an avatar of your own - consider uploading one of these more Tableau inspired ones!

 

new_avatars.png

 

 

Ever looking for new data sets? Check out how Jewel Loree gets some of her data from Wikipedia in - http://www.tableau.com/about/blog/2016/2/excavating-data-gems-wikipedia-50966

 

In the healthcare industry? You'll be sure to want to check out the virtual user group meeting tomorrow at 11:00 AM PST. Register here: Virtual Healthcare Tableau User Group Tickets, Tue, Mar 8, 2016 at 11:00 AM | Eventbrite

 

 

 

Recognition

Congratulations to Łukasz Majewski who achieved the "Questions for Breakfast!" badge - meaning that 25+ of his responses were marked as correct. Lukasz has been a member of the community for just over a year. Several of the posts he jumps on are date and date-time related - maybe one of his specialties?

 

 

Most Talked About Thread

**This is characterized by the number of responses to the thread

lakshminarayana.m was running into an issue where the Calculation based on Data Blending not working. Adam Crahen suggested a couple of ideas - and kept with Lakshmi to ultimately solve the question with a table calculation.

 

 

(One of the) Top Viewed Threads

Back in 2013, scott scottson asked how to Multiple Series On Line Graph. Jonathan Drummey put together step by step directions with screenshots to solve the issue.

 

 

Top Voted Idea

At the end of last year, Shawn Wallwork created the idea for Tableau to Stop Changing Filters & Colors When Replacing Data Source. Today, it already has 115 votes - after receiving 8 up votes just in the last 7 days. It's been the top voted idea for a couple weeks already this year.

 

 

In Other News

 

 

That's it for this week. Hope you all have a good one, and until next time, happy analyzing!!

 

 

As always, feel free to send any comments, suggestions, or submissions my direction at trodgers@tableau.com

Welcome to your weekly dose of the Community Digest. There are always so many conversations and things happening in this community, that it's hard to capture it all! Here's a quick glimpse -

 

Announcements

You may have also started noticing some little badges next to people's names. In particular - Tableau Employees and Tableau Ambassadors. Now, you'll be able to easily see whether someone you're talking to works at Tableau. Below, you're able to quickly see that bunny.hirschmann is a Tableau employee.

 

employee_badge.jpg

Have you heard that our Tableau Support team now has a Twitter handle of their own to answer questions? Read this blog post to learn about another way that you can get answers to your questions: Introducing @TableauSupport! | Tableau Software

 

Are you a part of the 9.3 Beta? Try things like Saying Hello to Versioning in Tableau 9.3 | Tableau Software. Join the Beta and let us know what you think!

 

 

Recognition

If you saw the front page of the Community, you might have seen that Rody Zakovich is in our Community Ambassador Spotlight! This is a new series that we'll doing to highlight our Ambassadors. Rody has been a fabulous member of our community and working with him has made working with him such a pleasure. To learn more about Rody, check out Tableau Ambassador Spotlight - Rody Zakovich

 

 

Most Talked About Thread

**This is characterized by the number of responses to the thread

Ajeet ... is running into an ATTR Problem when he is trying to create a calculated field from two different data sources - Excel and a MySQL db. Łukasz Majewski and Tableau kumar provided a couple of screenshots and updated formulas to get a better understanding of the issue that Ajeet was running into. Amanjot Klair tried explaining why the ATTR was appearing in the first place, explaining that it was because it was coming from the secondary source. He shared a post that goes into more detail. Hopefully, this helped Ajeet - if so, let us know what happened and how you solved the issue!

 

 

(One of the) Top Viewed Threads

Rahul Panday asked a question about when to LOD calculations. He got a lot of valuable feedback and perspectives from Simon Runc, Amanjot Klair, Ben Neville, Rody Zakovich, and Jonathan Drummey. Jonathan, in particular, parsed out some different scenarios for when to use a LOD vs. a table calculation vs. a simple regular aggregate. I would definitely recommend bookmarking this thread if you haven't already!

 

 

Top Voted Idea

In July, Alexander Mou created Replacing Data Source with option to copy over calc fields, groups, sets etc. This idea results from some of the pain points of replacing a data source that he outlines in his blog: Vizible Difference: Replacing Data Source Breaks Everything: Cause, Workaround & Ultimate Fix. The idea received 12 up votes in the last week, giving it a total of 53.

 

 

In Other News

 

Hope everyone has a great rest of their week!

 

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

 

Happy Analyzing!

Good morning everyone! We had a long weekend over here in the US for President's Day, hence why this is going out today. For those of you who got the extra day off, hope it was a great one!

 

Announcements

Last week, we had a Think Data Thursday. It was super interesting - Christopher DeMartini and Thomas Van Buskirk presented Think Data Thursday: Get Hopping with Jump Plot in Tableau. If you missed it, have no fear! It's been recorded and you can check out the video the post.

 

You also may have noticed that the Tableau corporate website got a redesign - and Community is now in the header! I know, I know, the community header/footer doesn't match - yet. We'll get that taken care of this week.

 

Recognition

Two members received the "I Know Stuff!!" badge - meaning that 10+ of their answers have been marked as correct. Jaideep Rokade and Venu Babu Kolasani both joined the community in the summer/fall of 2014, and have recently been more active in the community. Venu has even shared what he's learned about the differences between extract filters and data source filters - Difference Between Extract Filters and Data Source Filters. Thank you both for your contributions! Hopefully, we'll continue seeing you around!

 

 

Most Talked About Thread

Cynthia Wang had a questions about how to get a Calculated Field to capture another row's value. Daniel Vincent started to try by providing a LOD calc, but as Pooja Gandhi noted, it wouldn't work for each row. Daniel then moved on to table calculations, and Alexander Mou also provided a Tableau Public workbook that worked using table calcs as well. However, it was Steve Mayer's solution that solved the issue using nested LOD calculations.

 

 

(One of the) Top Viewed Threads

Gaanesh Kapatralla asked How to invoke another dashboard based on drop-down selection. Shinichiro Murakami suggested using a filter action and filters with "Only Relevant Values", however, they were having issues getting it to work on Tableau Public. Ultimately, Amanjot Klair solved the issue explaining how tabs must be shown when publishing to Public/Online.

 

 

Top Voted Idea

This week's top voted idea was created last week by Tim Ngwena with 10 up votes already - Support for opening URL action link(s) in same or new tab.

 

 

In Other News

 

Just a quick one this week - have a good rest of your week, all!

 

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

 

Until next time, happy analyzing!

Happy Monday everyone! I'm back in the office this week and it sounds like I missed a pretty busy one last week! Let's take a look -

 

Announcements

In case you missed it, last week we had our first ever Developer Office Hours where a couple of our Tableau Developers who work(ed) on the REST API got on a Webex and answered questions from the community. Sounds like it was a success! To see the recording and some of the questions people asked, check out this thread: Join us for Developer Office Hours:  REST API

 

This week, we have a Think Data Thursday event on jump plots with Christopher DeMartini and @Tom VanBuskirk. To see more information and register, visit Think Data Thursday: Get Hopping with Jump Plot in Tableau

 

You might also check out this blog post by ryan.sleeper, one of our Tableau User Group Ambassadors, who shares How to Highlight a Dimension in 3 Simple Steps | Tableau Software

 

 

Recognition

Gerardo Varela achieved the "I Know Stuff" badge - meaning 10 of his responses have been marked as correct. Gerardo has been a member of the Tableau Community since 2013, but recently has started becoming more active. From the looks of things, he has knowledge in many areas of Tableau. Thanks for all your help Gerardo and hopefully, we'll continue to see you in the community!

 

 

Most Talked About Thread

ChandraSheker A asked a question about Counting  where he wants to get the number of non-null customers respective to a given date. However, he's running into issues. It looks like there's an issue with how his data is set up as Stephen Lavery mentions. Shawn Wallwork provided a couple of options using an ifnull calculation, but it still wasn't working as desired. It looks like veronica.simoes.0 also provided a workbook - however, it looks like it might be a different version than what CJ is using. Let us know if you got it figured out CJ or if you need more help!

 

 

(One of the) Top Viewed Threads

This is a question that comes up fairly frequently - selecting multiple values in parameter asked by leo dec in 2014. Jonathan Drummey provided a blog post where he talks about this question (Creating a Dynamic “Parameter” with a Tableau Data Blend | Drawing with Numbers ). Steve Martin provided step by step directions on how this can be done using a set and a filter. However, as noted by Seanna Miller this doesn't solve every scenario - i.e. the case where you don't know what selection(s) your end users will want to make.

 

 

Top Voted Idea

This is actually the second highest voted idea this week (with 9 up-votes) - Log permission change events in postgres db and logs. It was created by Meenakshi Chaudhary and is a request to basically keep an audit into the history of permission changes.

 

 

In Other News

 

Hopefully, everyone has a great rest of their weeks.

 

Until next week, happy analyzing!

 

As always, any comments, questions, or suggestions for this digest, feel free to email me at trodgers@tableau.com.

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

It's the last couple of days before the close of 2015 is upon us and we start with 2016. Where has this year gone?! Though last week slowed down with the holidays, there was still lots of activity. Let's take a quick look -

 

 

Recognition

Last week, there were a couple of accomplishments. First, Norbert Maijoor achieved the "Questions for Breakfast!" badge - meaning 25+ of his responses have been marked as correct. Norbert has been climbing the ranks and has busily helped a lot of people get the answers they need to solve their Tableau questions.

 

Adam Crahen received the "I Know Stuff!!" badge - 10+ of his responses have been marked as correct by others. Adam joined the community back in April of 2014, but recently he's been super active on the forums. He also is fairly active on Tableau Public too. I personally love his Jeopardy viz: | Tableau Public

 

 

Most Talked About Thread

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

Last week, Rajeev Pandey asked a question about Box Whisker Plot along with Time of a Day in Y axis. Shawn Wallwork patiently worked with Rajeev (even on Christmas day!) to understand just what Rajeev wanted, and was able to provide him with a solution. Additionally, he found that KK Molugu had a solution as well, and requested he post the workbook to help Rajeev. Rajeev was unable to provide a workbook, but by posting screenshots and lots of details, as well as being extremely responsive, he was able to get a couple of solutions.

 

 

(One of the) Top Viewed Threads

Back in 2013, Alexandre DAVID asked a question about How to count distinct users on a running period. Several Zen Masters, past and present, jumped in on this thread and provided some rich detail talking about table calculations and densification. This is a fun one to look back over time. With 9.0, it seemed like the solution was at our fingertips using LOD expressions. However, the solution is still constrained by a couple of issues as Jonathan Drummey points out. So this is a case, though where there are a couple of workarounds, there is not yet an easy, straightforward solution.

 

 

Top Voted Idea

Shawn Wallwork's idea Stop Changing Filters & Colors When Replacing Data Source created last month received 10 upvotes this past week, giving it a total of 44 votes. As Matt Lutton mentioned there is a workaround (http://community.tableau.com/docs/DOC-5359) though, it is not the most elegant solution. I've definitely run into this as well - upvote from me as well, guess that makes 45

 

 

In Other News

 

Until next year...

 

Happy Analyzing!

 

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

It's the most wonderful time of the year and the most wonderful time of the week (?!). It's time for this week's edition of the Community Digest and to take a peek into what's been happening around the community -

 

Announcements

No major announcements this week. So instead, I'd like to share a quick way for you to find the places you belong to or have recently visited in the Tableau Community. Click on your avatar in the upper right corner when you are logged into the community, then click on "Your Places."

 

You'll be brought to a list of the places you are following. However, you can change what is shown here by clicking on the different options to the left:

 

 

 

 

Recognition

Last week, Esther Aller, a member of the Tableau technical support team, achieved the "Questions for Breakfast!" badge. That means that at least 25 of her responses have been marked as correct! She joined Tableau this past February and quickly signed up for the community. She has had a major impact already! Thank you for all your help, Esther!

 

puspak Agasti also is making moves. He achieved the "I Know Stuff!!" badge - 10 of his answers were marked as correct. Though Puspak has been a member of the community for awhile now - lately, he's been hanging around and providing some great answers. He is always providing screenshots, and details to help people get answers to their questions.

 

 

Most Talked About Thread

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

siva goberu asked his first question in the Tableau forums with Remaining days calculation  (Start date and End date).  Siva received help from a couple of people - Shanaka Gunaratna originally helped by showing Siva how to use parameters and calculated fields. However, the solution was close, but was giving the total number of days between the two dates in the parameter, as opposed to the remaining days. He then worked with Tableau kumar and Norbert Maijoor. Norbert worked closely with Siva to get all of his follow up questions answered.

 

 

(One of the) Top Viewed Threads

This past week, one of the top viewed threads was started by Cathy Bridges back in 2014 where she was asking about options to Export Dashboards to PowerPoint. Ben Neville gave the solution of using Tableau Server or Tableau Online. However, as others noted, Tableau Server or Online are not always an option. Steve Martin provided a solution from within Powerpoint. Cristian Vasile suggested running a script - which though it didn't help Cathy, it did help Isu Wickramasinghe.

 

 

Top Voted Idea

Jodie Helfer created Pattern Filled Visualizations last week - and it has already received 30 up votes. It's a simple idea that could prove to be very powerful. Zen Masters, Joshua Milligan and Shawn Wallwork think so too.

 

 

In Other News

 

 

I hope everyone has a happy holiday! The Tableau Community team will be out of the office on Friday.

 

Until next week, happy analyzing!

 

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