Happy Monday, happy May! Spring has come in this part of the world, and I've got to say getting out of bed in the morning when the sun is shining is much easier. I still need my coffee though - grab your cup of joe or a snack, and let's a take a peak into the Tableau Community.
In case you missed it, Pooja Gandhi has the Ambassador Spotlight on her. Pooja was such a blast to talk with - she's as friendly in person and on the phone as she is on the forums! To see our interview, read Tableau Ambassador Spotlight - Pooja Gandhi.
Did you see the Announcing: Developer Office Hours for Web Data Connector? If not, the recording is on that thread. The Dev Office hours are becoming a big hit. If you have other topics you'd like to have covered by a Tableau Developer, just let us know and we'll try to make it happen!
This is blog post by Alan Eldridge is fantastic for learning more about when to use what type of calculation - basic? LOD? Table? This might be one to bookmark: A Handy Guide to Choosing the Right Calculation for Your Question | Tableau Software
Tableau's own Matt Coles achieved the "Question Slayer" badge - meaning that he's had 50+ of his responses marked as correct. You know Matt from his work in the Server Admin area, and in particular for his work in developing VizAlerts. Thank you for all the work you do in this community, Matt!
Additionally, kumar.c has received the "I Know Stuff!" badge (10+ of his responses were marked as correct). Kumar has been a member of the community since 2014, but has recently become more active. Great to see you back, Kumar!
Most Talked about Thread
**This is determined by the number of responses in a thread
Shivang Desai asked a question about Getting total sales in tableau for all order numbers that have order number same as beverages. Shivang received a lot of help. Adam Crahen gave him a solution that worked with 9.0 and above, however, it was soon discovered Shivang only had 8.3. Ashish Chaudhari, Tharashasank Davuluru, and Tableau kumar were able to help quite a bit. But, another issue appeared when Shivang went to add a grand total. Shivang, if you're able to upgrade to 9.0+, that would solve both your issues. If not, you may need to combine two sheets together on a dashboard. Hopefully, you've found a solution - if so, please mark the answer that solved it!
(One of the) Top Viewed Threads
Andrew Pick was hitting a csv legacy connection row limit. He needed to use the legacy connection because he was using CustomSQL. One of Tableau Senior Software Engineers, Dmitry Chirkov, saw the thread, and was interested because he'd never seen this behavior before. Andrew did a little more digging and discovered it has more to do with the columns than the number of rows. It still sounded a little odd. Cristian Vasile suggested he try a transformation/analysis tool that would allow Andrew to get the data he needed directly into a .tde file.
Top Voted Idea
This one has been a top voted idea a couple of times recently. Shawn Wallwork created https://community.tableau.com/ideas/5655 at the end of last year, and now it has a grand total of 187 up votes. Fingers crossed we get this one included soon!
In Other News
- Have you tried out the SPLIT() function when you need to break up a string? Shawn Wallwork solved James Diza's Create datetime out of string without dateparse on live connectionissue using this solution - making it much easier and elegant to work with.
- Amber Loranger posted Slow Queries to Stored Procedures on MS SQL Serverto show instructions on ways to avoid this in the TabWiki.
- Are LOD calculations easy? You be the judge, and take on timothy rafferty's Another 'easy' LOD question.. or is it ? He got quite a few people to chime in, coming up with different solutions, with different end results.
- Diego medrano posted this a couple of weeks ago, but I wanted to make sure all you Server Admins out there have seen it: Tableau Server: Everybody's Install Guide
- How to fill areas defined by 3-digit zip codes posted by Chris Wells generated some interest from the community (including some Tableau employees). Adam Crahen gave a solution that blended some lat/long data. However, Kent Marten showed that this will be done much more easily in 10.0 - so sign up for the beta!
That's a wrap for this week. You'll start seeing more of the community team delivering this digest in the near future. Please send any comments, suggestions, or submissions for this digest to firstname.lastname@example.org