12 Replies Latest reply on Nov 29, 2012 5:14 PM by Shawn Wallwork

# Forums Digest Weekly #2

If you read Forum Digest Weekly #1 then you know what this is all about, so let’s dive right in….

Week’s Best Explanation

Last week’s most difficult question produced a Richard Leeke explanation of how Tableau deals with DateTime, what epoch time is (sort of) and how all this affects durations. What I got out of this whole discussion, so far, is that Tableau needs to work out a better way of dealing with duration time, both in terms of math operations and formatting. Certainly a duration of 47:16 (hh:mm) is much easier to read than 01:23:16 (dd:hh:mm), at least to my eye. What do you think?

Update: Discussion is still going on. “Yeah, it gets very messy, very quickly, doesn't it?” --RL

Alex Kerin says: "Previous_value is one of those hidden gems that keeps on giving..." He used this function to create an exponentially weighted moving average. Further down in the thread he goes on to explain the difference between PREVIOUS_VALUE() and LOOKUP().

Joe’s Corner

Joe Mako replied to a couple of questions this week. Here’s a thread that started last June, got answered, got revived in September, and then again this past week. Here’s Joe’s latest entry. The other question Joe took on this week had to do with Top N and how to use nested table calculations to solve the problem; as well as using the Show Me card to ‘lock in’ the table calculation. Yep, classic Joe stuff.

Featured Forum Folks (not the usual suspects)

Catherine Rivier has never asked a question (according to her content page), but stops by every once in a while, votes for some Ideas, and answers a few questions. She put together a nicely detailed explanation of how to add multiple trend lines to a scatter plot using a dual-axis chart. Mark Holtz has been asking and answering questions since last March, responding to a wide range of topics. He is now ranked 12th on the score card. This week he put together an elegant solution for dealing with FY and non-standard date periods.

Here’s a two-in-one. Last Week’s longest thread is still going strong (so you don’t have to page through the whole thing here’s a link to where the new comments begin). It turned into a discussion between Newcomers and Old Hands, talking about fear of being wrong, how some Zen Masters pick the questions they answer, and encouragement for wider forum participation at all levels. Vusi Nkomo has been searching out low-hanging fruit ever since.

# Newcomer’s Resource Page

Dustin Smith posted this collection of Training Resources. It gives you links to all the important stuff you’ll need to get up and running as fast as possible. I sent the Starter Kit Training Schedule out to my team. Good stuff Dustin.

# Shout Out for Think Data Thursday

This coming Thursday (11/29) is another TDT. The topic hasn't been set yet, so you can help pick it by going here and commenting/suggesting. Even if you don’t suggest, or contribute to the discussion, do join us – you’ll definitely learn something.

# My Shameless Plug

The Idea to add Autosave Functionality to Tableau only needs to move up five slots to make the front page of the Ideas section. So if you’re not one of the 45 people who have already voted for it, please consider giving it an up vote. Front Page or Bust!

Best ‘Thank You’

Here’s a link to the best forum ‘thank you’ I have ever gotten – a Christmas music video. The music is quite moving, even for a Buddhist like me. You’re welcome Stephen Jones, and thank you for sharing.

--Shawn

PS: I just noticed Richard has posted his Hexabin work, as I am posting this blog. So more on this next week. FYI: I decided to make midnight MST Saturdays the cut-off for each week's content. I've already noticed some good stuff coming in from Jonathan Drummey this morning.

Message was edited by: Dustin Smith Restored message content as requested.

• ###### 1. Re: Forums Digest Weekly #2

Shawn, theses collections you are putting together are really phenomenal. Thank you!

Dustin Smith these should really be featured somewhere, to help others find them. Is there anything that could be done about the links that were dropped in transiting the forum content?

• ###### 2. Re: Forums Digest Weekly #2

Thank you Shawn. This is great work, and enjoyable to read. 5 stars from me

• ###### 3. Re: Forums Digest Weekly #2

Another gem from Shawn, well done. I've read it with great interest - it does deserve a special promotion on the forum.

• ###### 4. Re: Forums Digest Weekly #2

Shawn - I love this.  And Joe, I totally agree about placement on this. I've got a couple things up my sleeve I'm going to try put in place tomorrow that should highlight Shawn's weekly update.

The best part about this is that I've been wondering for a while if giving users a place to blog here on the Community site would be of interest.  I think Shawn just answered my question.

• ###### 5. Re: Forums Digest Weekly #2

Just got round to reading this - great work Shawn

• ###### 6. Re: Forums Digest Weekly #2

Thanks Alex. And everyone else for the encouragement.

I want to mention that my biggest difficulty with this project is deciding which people and threads to feature each week -- it really is quit difficult, a bounty of riches! So please don't take offence if I haven't gotten to you or one of your posts yet. If you're answering forums questions with any frequency I promise I'll notice and will get to you, eventually.

--Shawn

• ###### 7. Re: Forums Digest Weekly #2

Thanks for addressing my first point, sounds good, and I am looking forward to seeing what you come up with!

But, how about the links that were dropped in transitioning the forum content?

• ###### 8. Re: Forums Digest Weekly #2

Hi Joe,

This is an ongoing project and one that just when we think we've got a chunk of it done, we uncover additional content that needs to be redirected.  Tracy is great at uncovering these and makes sure it's on my radar on a daily basis.

• ###### 9. Re: Forums Digest Weekly #2

Hi Shawn (and everyone)!  I'm excited to get a shout out here - love the feature!!

Just to clear up the oddness of my account, I'm actually now on my third (or fourth?) login on this site - I'm not sure how/why they didn't follow.  I was always more of a reader than submitter/answerer in the past.  Here's one of my old accounts, for example (one of my favorite solutions of all time):

I've been using Tableau for years, huge fan...  just trying to get a little more involved, share some cool solutions I've come up with over the years, and challenge myself with solving new/odd problems

• ###### 10. Re: Forums Digest Weekly #2

Shawn,

This is awesome! Keep it up!!! I'm always looking for new tips,tricks, intriguing questions I might be able to answer or even just try.

• ###### 11. Re: Forums Digest Weekly #2

Do you have plans to accept bribes for "sponsored" or "promoted" content?

• ###### 12. Re: Forums Digest Weekly #2

Com'on Dimitri, you know I'm totally open to all this! Bribes, sponsorship, promoted content... you bet!

[Only requirement: send \$\$\$ to your fave charity in Tableau's name.]

Send me copies of receipts and Forum Digest Weekly promotion guaranteed!

--Shawn