Skip navigation

Good Monday Afternoon.  The holidays are near and with them come the non stop emails to inform us of yet another 50% off sweater that apparently I need, or someone I love needs.  How do you spend the holidays?

For our family, it's never really holiday season until we all sit around and watch It's a Wonderful Life.  There's nothing like watching an angel get his wings.

 

How do you manage Holidays in Tableau?  Did you know that kettan has built and managed a great FAQ page of links on this very topic?  Check it out here: FAQ:  Holidays & Workdays

 

Announcements

We have a Think Data Thursday on the agenda for December 22nd.  Join the event live at 8 AM Pacific with Emily Kund presenting "Small Tips: Big Results"

Emily is a Tableau Social Ambassador, Podcaster, Government Tableau User Group co-leader, and The Fringe Festival founder.  Follow this link to register for this event.

 

Recognition

You may have noticed that the leader board on the front page is working again. Thank you everyone for your patience as our vendor worked to correct the issue.  I think all of the great work everyone has been doing in the community to help bring Crow's Nest backlog of unanswered questions to an all time low.  But no fear, the broken bits are fixed and its back on to full power.   Thank you to everyone that jumps in and has been helping each other.

 

Do you also ponder what makes the Tableau Community tick?  Shawn Wallwork kicked off a great discussion on this exact topic last week.  Check it out and share your thoughts.

 

A call out of recognition to Shinichiro Murakami as he assistied in over one hundred responses to community questions last week.  Thank you Shin!!

 

Most Talked About Thread

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

John Smith has experienced an issue trying to utilize Postgres with Infobright . Several of the Ambassadors have stepped up to assist John.  Jeff Strauss was first to offer assistance with a suggestion to share logs.  Once John posted logs,  Yuri Fal joined in to assist with a potential workaround utilizing an ODBC connection for this data source rather than the default Postgres driver due to issues encountered in the logs with Infobright.  Toby Erkson has also commented to clarify the difference between a Custom SQL connection and a Join within Tableau and shared a link to specify how to make customizations such as these global.  John has managed to utilize a TDC file to prevent Tableau from creating temp files related to Infobright but he is still experiencing performance issues.  Maybe you have a lot of knowledge about Infobright and it's integration with Postgres and have a suggestion to add?  This one is still searching for just the right solution.

 

Most Viewed Thread

We had a another great bit of collaboration n the most viewed thread fo the week here Rank - Calculate when field not in table .  Customer Andrew Hills question about creating a counting the number of values per rank value.  Norbert Maijoor was first on the scene and prompted Andrew for a workbook to enable some hands on manipulation.  Andrew supplied a sample data workbook and that's all it took to bring some of the best minds in the community to task on this.  Simon Runc, Yuri Fal, and Norbert each joined with comments and workbooks to help build a workbook that helped Andrew get to a solution.  As Yuriy mentions in this thread, a great help on your Tableau journey is to hold onto the best tips/tricks you learn and keep them close as a reference when tackling the tougher issues you encounter.

 

Top Voted Idea

Last week, More Subfolders in Project Folder  [ RELEASED ] created by Lisa Akahoshi back in 2012 was singled out for 12 new upvotes afte Ken Wong from Tableau's Product Management team commented about this idea and making it a reality in 2017.

 

In Other News

  • As mentioned above,  Tableau employees have been joining in with many community members to remove the backlog from our Crow's Nest.  i wanted to say thank you to all of the community members for jumping in and assisting with so many of these questions as welll.  These unanswered posts tend to be the some the hardest questions posed in the community and we find that asking a few leading questions often is all that is needed to engage the rest of the community on helping find a great solution. 

  • Did you see the Educational Brain Teaser: Twisted KPI Table posted by Ɓukasz Majewski a week ago?  i noticed the post had not seen a response on Thursday of last week so I jumped in with an early thought about Conditional Formatting and that's all it took for the community to go to town.  Eventually, it was Yuri Fal that supplied the winning answer to this very tough challenge.  Check out Yuriy's answer and the entire thread to expand your knowledge of Tableau. Clearly Yuri Fal knows a thing or two about the Force.
  • Annabelle Rincon reminded everyone that the community isn't just a place to come get your questions answered.  You can come here to show off your great work and get feedback.  Check out her post and link to her Tableau Public viz showing her career resume.

 

 

That's it for me this week.

 

Per usual, feel free to send any comments, questions, submissions for this digest to community@tableau.com



Hello Community,

 

I hope everyone that visited Tableau Conference 2016 had a wonderful week of learning, connecting with other Tableau users, and of course celebrating #data16 .  If you have pictures or stories to share about your experiences at Tableau Conference, please share in the Tableau Conference user group.  We would love to see them.   I've started a Pictures thread here - Pictures from TC 2016  to get things started. 

 

Now that TC is complete and we are home, our team has plenty to catch up on.  Did you learn a new skill and want to try out your own Jedi like skills, head over to Crow's Nest where we have a list of unanswered posts from your fellow community users.  See if you can find one or two to answer and show off those newly learned skills. 

 

 

 

Announcements

Did you attend one of Jonathan Drummey and Matt Coles sessions related to VizAlerts at TC2016?  Jonathan has posted videos and files from this session here - VizAlerts session at 2016 Tableau Conference #data16: the video and files .  For you Tableau Server administrators, be sure to check this great tool out.

 

 

Most Talked about Thread

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

New community member Khalid Baker asked How Can We Use Up and Down Arrows for Specific Columns? .    Ashish Chaudhari responded to request a sample workbook and once Khalid posted his sample, the community went to work to assist.  Simon Runc created a detailed response with example calculations and even a small gif image showing how to create a calculation.  The creativity of our community members to share their knowledge with each other is inspiring.  Way to go Simon. 

 

Another very popular thread this week was Jesse Narang's post Calculate total number of active people at end of every quarter  that was answered by a newer member to our community, Sherzodbek Ibragimov Sherzodbek  has already generated 2,483 points since joining the community last July.  Welcome Sherzodbek..  thank you for your great contributions! 

 

 

 

Most Viewed Thread

Shawn Wallwork kicked off the most popular thread for the week with his 10.1 Favorite New Feature?  generating over 2000 views and drawing attention to many of the great new features below the surface in v10.1 of Tableau. 

 

 

Top Voted Idea

We received 10 votes last week for the idea Print PDF -> Select Multiple Sheets created in August by Rahul Upadhye.  Tableau's Zi Krostag is following this Idea closely so be sure to weigh in if this is a feature you would find helpful as well. 

 

In Other News

 

We are all happy to be home and ready to get back to the work of helping users be successful with Tableau.  Thank you to each of you that came by and introduced yourselves to our team at TC.  We enjoy each of your stories and we always appreciate any feedback to help make the community even better. 

 

That's all I've got for this week! Per usual, feel free to send any comments, questions, or suggestions for this digest to community@tableau.com

 

Have a great week and happy analyzing!

Happy Monday and welcome to the Tableau Community! I hope you all had a fabulous weekend.

 

Can you believe that October is over half way done.  Some people love Christmas but I'm all about Halloween.  Do you have a creepy clown outfit this year or maybe you are going as your least favorite political candidate?  Whatever your choice, it's time to get that candy stocked, the pumpkins cut and the makeup ready.  Boooooo

 

 

Announcements

There's just a few weeks until TC16 in Austin. There's still time to sign up! Check out more information here: Tableau Conference 2016 | Austin, TX | November 7-11 | #data16  Don't miss the chance to meet up with everyone here to finally put a face with a name at the Community Meetup on Tuesday at 2:45 (Learn | Tableau Conference 2016 ).  Have you earned a Community Badge?  Come by Community Alley and pick up a sticker of your favorite badge to display on your TC Badge.

 

We have completed the first Ideas archiving project as mentioned here Community Update: Ideas to be archived.  Archiving older ideas helps keep the current ones relevant.

 

Last week, Emily Kund, and Ravi Mistry joined together to present an great Think Data Thursday titled "Constant Learning and the Beauty of Mistakes".  Check it out at the link on YouTube if you missed it.

 

 

Most Talked about Thread

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

Maziiar Abadi  had a question about converting [hh]:mm in an excel cell into workdays (assuming a workday is 8 hours).    praveen p offered a suggestion utilizing a calculated field however the source data does work with this suggestion.   Mahfooj Khan stepped up to assist with an initial reply that broke up the answer by DD:HH:MM:SS after converting the original field to seconds.  After a few more comments back and forth,  Mahfooj provides a calculation that will work to provide the result in numbers of 8 hour days.    Maz had some additional questions about formatting the view and Mahfooj suggests that rather than applying another calculation to the view, it would be better to use the Tableau formatting features.

 

 

Most Viewed Thread

New user, Peter Gabe  (Welcome Peter) asked a question about replacing the value of a field based on the condition that the field has a specific value in the data.   Alex Xu provides the first response using a conditional if/then else statement based on the string value of the field.  One of the Tableau Ambassadors, Shinichiro Murakami stepped in with a table calculation soltuion and even built up an example workbook for Peter to refer to.   Peter responded with a thank you and a question related to changing the view to a stacked bar chart but the solutions are quite complex.  Yuri Fal stepped in with a working final view but making clear that the answer might too complicated to be useful and showing how and why LOD Calcs can be so useful if your data allows them.

 

 

Top Voted Idea

Loic Grange created Multi-Values Parameters four years ago and this has gone through many iterations over time.  The idea received another 6 upvotes this last week.  Check out the comments for various ideas to help and some workarounds.

 

 

In Other News

 

That's all I've got for this week! Per usual, feel free to send any comments, questions, or suggestions for this digest to community@tableau.com

 

Have a great week and happy analyzing!

Happy Monday to everyone.  Are you ready for Fall?   For our family, this means it's grape harvest time.  But for most people this time of year means it is time to celebrate Oktoberfest.

 

Did you know the origins of Oktoberfest go back to the marriage of King Ludwig to Princess Therese on October 12, 1810?  The marriage was held in Munich and the citizens of the town were invited to the event.  That must have been some party because the people of Munich have been gathering together most every fall since then to recreate the party.  They even moved it up a few weeks into September to take advantage of the better weather. Today, more than 6 million people attend Oktoberfest.  I made my trek in 1990. If you haven't been, I would recommend checking it out.

Image result for oktoberfest

 

Announcements

For those of you who missed Pooja Gandhi and Shawn Wallwork presenting the Tableau Think Data Thursday last week, it is now available to watch on our YouTube channel: - Tableau Potpourri with Pooja and Shawn - YouTube

Have you seen the Tableau 10.1 Beta has already come out?! Want to learn more or join? Check it out here: Tableau Beta Program | Tableau Software

Tableau Conference is right around the corner, y'all.  Are you going to be joining us in Texas come November?  Don't delay as this conference always sells out.  Check out the announced keynote speakers and sign up today: Tableau Conference 2016 | Austin, TX | November 7-11 | #data16

 

Recognition

Congratulations to david.li.8 who achieved the "Questions for Breakfast" badge. That means that he's had 25+ of his responses marked as correct! David has been a member of the community since February of 2014. Thanks for all your help David!

 

Also, a special shout out to Panjala Srinath  for achieving the "I Know Stuff!" badge (10+ of his responses have been marked as correct).  Panjala joined the community in February of last year, but recently has really started getting active. We hope to continue seeing you in the community! Thanks for all your contributions!

 

Most Talked About Thread

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

Ivan Monnier asked a question about Tableau Server licensing Re: Can a 8-core License work on a 16-core server?   Glen Robinson came to his assistance first with ideas to limit the core count within Windows.  Ivan went and created an idea for Tableau to better manage this scenario (you can vote it up here: https://community.tableau.com/ideas/6652 ) . Toby Erkson provided a method of setting a Windows limitation of 8 cores via Windows Task manager, and Jeff Strauss suggested turning off the additional cores in the Bios.  Matt Coles, a Tableau employee, suggested considering a virtual machine which would allow for a solution that scales as needed if the license is changed in the future to a 16-core license.

 

Most Viewed Thread

The most popular thread this week was started by Marshall Daly and asks How do YOU use the new Google Sheets data connector w/ Tableau?.  This post has generated over 850 views with 16 likes and 6 replies.  Check it out if you are looking for ways to capture form data from surveys or use data from any Google sheet.

 

Top Voted Idea

Veronica Simoes created an idea for more capability to customize the schedule of Tableau Server.  This idea has generated 12 votes since it was created on September 9th. You, too, can read about this idea and vote for it here: Customize schedule

 

In Other News

Phelis Nakato asked: How can I filter date-time data in my dashboard to show a viz for a range of time, a date slider of some sort? and Praveen p responded with assistance to show how to utilize a Range of Dates filter.

Dan Harrison asked Re: How to hide a bar based on specific subset of the bar and was kind enough to supply an example Tableau Workbook for the community to work with for assistance.  The correct answer was supplied by Adam Crahen and utilizes a LOD calculation

 

That's all we've got for this week (not that there wasn't a ton more happening!). Have a great rest of your week, and until next time, happy analyzing!!

 

As always, feel free to send any comments, questions, or suggestions for the digest to community@tableau.com

Happy Monday everyone! Did you get enough Gold, Silver and Bronze over the last few weeks? As the Olympics come to an end, take a moment to look back over Olympic history with this great viz from Alexandria Duke.

 

Announcements

Thanks to everyone that took part in the Tableau Torch Viz Contest.  Our Round 5 winner will be announced tomorrow.

 

Of course the big news is Tableau 10's release last week.  If you have just returned from an amazing summer vacation and didn't realize that your favorite data visualization/exploration tool had a new version, then now is your time to check it out.  Here are all the new features in v10. We have put together a Community based Tableau 10 Resources Page to help you navigate the many available resources.  Let us know if  you find something to add to the list.

 

Most Talked About Thread

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

 

Nick Zhao asked a question about Tableau Sorting and using another measure to help break a tie.  User Luciano Vasconcelos and Rajeev Pandey responded to assist.  Luciano built two rank() fields on different measures and added these as Discrete values on the Rows shelf in front of the Name field to sort the view.  For those wondering how to do this yourself, you can hide those ranked fields in the view by turning off the "Show Headers" option from the drop down of each ranked field on the Rows shelf.  Thanks for the great tip and help Luciano. 

 

Most Viewed Thread

Our own Tableau 10 is finally here! Tell us about your Tableau TEN-ured story is the most viewed thread this week.  Check out the great stories shared by and add your own story to the mix.  We want to know how long you have been using Tableau, how you came to start your journey and your feedback on the new features in the release.  This is a great thread to learn more about Tableau's amazing community of users. 

 

Top Voted Idea

Last June, Hiroshi Takeuchi created an Idea to add a Connector for SugarCRM.  His Idea had 6 additional votes last week.  How Sweet is that? 

 

Speaking of Ideas - check out all of your Ideas that made it into Tableau 10

 

 

In Other News

  • We have a new spotlight on a Tableau Ambassador.  This month we learn more about Simon Runc and his jourey fom Omniscope to Tableau at the Body Shop. 
  • Speaking of Simon Runc.  Simon will be presenting at this week's live community meeting - Think Data Thursday:  My Daily AdVIZture - August 25, 2016.  You can join Simon as he shares a visualization he built in Tableau to show interesting information about his commute to and from work.  Simon will demonstrate his talents as he builds this visualization.  If you are inspired, maybe you could share your summer vacation on Tableau Public with what you learn.
  • Have you seen the new Device Designer in Version 10?  Try it out on Tableau Public.  Finally a viz on my phone!  Tips on Using the New Device Designer in Tableau Public 10 | Tableau Public
  • There are plenty more posts related to Tableau 10's new features, check out the Tableau Blog to keep up on all the great tips and tricks included in this release. 
  • Beth Hurst came to the community and posed the question How to change the order of operation in a Grand Total of a Calculated FieldMatt Lutton came forward and shared the one of the awesome training videos related to Aggregation and Granularity.  Beth watched the video but was still not getting the results she wanted.  So Matt called in the big guns with a mention of Jonathan Drummey.  Jonathan did a quick look through the viz and saw 8 levels of nested table calculations and suggested simplifying things with a LOD caclculation.  Then one of our newest Ambassadors, Yuri Fal stepped up with a workbook that shows the use of a LOD calculations to replace all those complicated Table Calcs. 

That's a wrap for this week! Have a good one and until next time - happy analyzing!!

 

As always, feel free to send any comments or suggestions to us at community@tableau.com

Good afternoon. I hope everyone had a great Fourth of July.  The Tableau Community team has been busy the last week and we missed out on an update last week.  Tracy is off visiting Europe on a long overdue vacation.  Diego was under the weather last week and I had a incident with a golf cart, a fall, and some concrete that resulted in a concussion and a few days out of the office.  You'll have to visit with me at Tableau Conference for all the details.  Let's get to what's been happening in the Community while we were all busy --

 

Announcements

Have you seen today's post on How to Create Density maps Using Hexbins in Tableau?  Check out the great visualization showing Tornato Density over the last 65 years and then give it a try yourself with the included instructions.

 

We are on Round 2 of the the Tableau Torch Contest .  Have you submitted your Tableau 10 viz for this round.  The theme for round 2 is "Cheer for the home team".

 

Recognition

Congratulations to Mahfooj Khan for receiving the Question Slayer badge indicating that 50+ of his responses have been marked correct.  Mahfooj is a fairly new member to the community as he joined in March of this year.  That's a lot of contributions over the last few months. Congratulations Majfooj.

 

In addition, Veronica Simoes and Luciano Vasconcelos are recent recipients I Know Stuff!! Badge indicating 10+ correct responses.  Congratulations to all of our badge winners this week.

 

Most Talked About Thread

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

Niranjan Banarjee asked a question about utilizing Tableau with Microsoft ExcelMahfooj Khan helped by shoing Nranjan how to utilize custom sql to create a union between the various files.

 

Most Viewed Thread

Ben Rasilim creatd a question about question about comparing values from multiple data sources and then using the results as a filterswaroop.gantela stepped in and provided detailed instructions utilizing LOD calculations and Table Calculations with the calculation examples.  Swaroop is a long time member of the community (since May of 2014) with over 7000 points.  Another great Tableau community member helping a new user get going.

 

Top Voted Idea

The top voted idea over the last two week is Stop Changing Filters & Colors When Replacing Data Source created by Shawn Wallwork last November.  This idea has 258 votes.  Your votes matter so please vote up if this impacts you.

 

In Other News

Please check out the article about Toby Erkson, Tableau's Community Ambassador of the month has been spotlighted on the front page of the community.  Learn more about Toby and his Tableau journey here.

 

That's all for this week.

 

As always, feel free to send any comments, questions, or suggestions for this digest to community@tableau.com

 

Happy Analyzing!

It's the middle of June in 2016 so that means it's Soccer time.  The Euro Cup 2016 and Copa America are both in full swing.   Do you have a favorite Tableau Soccer visualization?  Here are a few I am aware of:  Goal Scorers Over the AgesEfficiency of World Cup Players,  and here is even on created by Dan Mantena for this year's Copa to track standings and odds..  Argentina definitely is the odds on favorite.

 

Tableau Conference On Tour - London is going on this week as well.  Our Community engineer, Lénaïc is working at this year's Conference.  Be sure to stop by and say "Hi" to Lenny.

 

Announcements

Have you ever attended or watched a Think Data Thursday presentation and thought to yourself that you'd like to share insights, tips, or just something interesting about using Tableau?  We are looking for presenters for upcoming Think Data Thursday's.  Now is your chance to share your knowledge.  Contact the Tableau Community team if you are interested.

Have you checked out the upcoming version of Tableau? Are you a small business that uses QuickBooks Online?  In Version 10 of Tableau, you will be able to connect directly to your data.  Check out more about this upcoming feature here .  And there is still time to check out the Beta of Version 10.

 

Recognition

Congratulations to Ivan Young for achieving the Questions for Breakfast! badge this week.  This badge recognizes the fact that Ivan has 25 correctly marked answers in the community forums.  Additionally, we have three members that have recently received the Help Desk badge recognizing 5 correct answers.  Congratulations to Jason Harmer, msa s, and Tableau's own Adam Cogswell!

 

Most Talked about Thread

Michelle Barrineau posted a question asking for help to tweak the appearance of Bubble charts to make them look more interesting.  Simon Runc offered up the use of custom shapes as one possible solution. There is a great side discussion around presenting to Executiives with Toby Erkson.  Simon offered up a potential idea of tweaing the flat bubble shape slightly to allow for a more 3d look to the bubble and Michelle countered witha  modification to the "Ratings" shape inspired by the suggestion.   A great community post bringing together ideas around best practices, visualization communication and how to tweak Tableau just enough to get a desired result.

 

Most viewed thread

Allen Gapara created a question asking how to Automatically Select a parent by selecting a child. Ivan Young (our 25 correct marked badge achiever this week) provides a resolution utilizing a Parameter and a Table Calculation to return the desired value.  This thread had over 800 views last week assuring that Ivan's solution not only helped Allen but a lot of other users as well.  This is a great example to show the power of Table Calculations in Tableau.

 

Top Voted Idea

This weeks' top voted idea takes us back 3 years to a very popular request by kettan to create a Hierarchy Filter within Tableau.  This Idea gained another 12 votes this week with over 732 views.

 

In Other News

Tracy Rodgers has posted a new article up spotlighting another of the amazing Tableau Ambassador, Joe Oppelt.  If you haven't read it yet take a read and learn about Joe's journey with Tableau.  If you are just starting your Journey with Tableau or you have been using it for years, Joe has a few words of advice that I am sure you will find helpful.

 

That's it for this week. Have a great week and keep analyzing.  Please send any comments, suggestions, or submissions for this digest to community@tableau.com

Happy Monday and welcome to the second half of May.  Today marks my first writing of the Community Digest.  To mark the occasion, I am sharing a few facts about my birth State of South Dakota and one of it's most famous landmarks..  no not Mount Rushmore, I am talking about Wall Drug Store in Wall, South Dakota.  Wall Drug entices Family Vacationers with advertising appearing around the world to stop and get some free ice cold water.   Don't miss taking your picture on a Jackalope on your next cross country drive.  

 

Announcements

Have you signed up for attending Think Data Thursday this week?  Join Tableau's Tableau Junkie for a presentation about 'Making Social Media and Web Data work for You'.  This live event kicks off on Thursday morning, May 19th at 8:00 AM Pacific.  More information and sign ups are here:  https://community.tableau.com/thread/206482

 

Recognition

Congratulations to Shinichiro Murakami for earning the Answer Wizard badge recognizing that 100 of his answers have been marked correct. Shin frequently answers questions in Japanese and English and frequently participates in the Japan user group. 

 

Additionally, Ashish Chaudhari and Ivan Young  both received the "I Know Stuff!" badge (10+ of their responses marked correct).   Ashish joined the community last September of last year and Ivan joined in  January.  Welcome to the community

 

 

Most talked about Thread

Toby Erkson posed a question about a visualization from a presentation that he attended and aksed how it could be improved.  Simon Runc joined in and provided some ideas and shared a article "Rules of Viz".   Shawn Wallwork contributes some thoughts about areas  of the forums where we get to know our fellow members and Kristy McGee brings us back round to the original viz to close things. up. 

 

One of the Top Viewed Threads

Mohit Sharma provided a question to the community How to resolve aggregate and non-aggregate comparison error within IF statement? about resolving aggregate and non-aggregate comparison within a If Statement and Shinichiro Murakami provides a solution showing the use of LOD calculations to utilize the desired level of aggregation.  This is a great reminder of the power of Level of Detail calculations in Tableau.   Thank you to Tharashasank Davuluru and Mohit Sharma for stepping in and helping to better understand the issue. 

 

Top Voted Idea

Shawn Wallwork posted the idea  Stop Changing Filters & Colors when Replacing Data Source last November and has 213 votes so far with 15 more votes this week.  This is certainly a pain point we hope will be addressed shortly.

 

 

In Other News

Habeeb Mohammed posted a question asking What is the best institute/class for Advanced Tableau Development training?  and Zen Masters Jonathan Drummey and Shawn Wallwork joined my responses to provide some resources and encouraging contributions in the Community as a way to help.

Don't forget, if you haven't joined the Tableau version 10 Beta, you still have time.  Check out Ryan McShane's article 10 Reasons to Join the Tableau 10 Beta | Tableau Software.

 

That's it for this week. Have a great week and keep analyzing.  Please send any comments, suggestions, or submissions for this digest to community@tableau.com