Great news Tracy!
How about discussing on getting data in proper shape for analysis - what are the approaches to handle one-to-many, transposing (pivoting), unpivoting in the custom SQL - what are the possibilities for Tableau users. I believe this is a basic prerequisite to start up a subsequent analysis, and still in most of the OLTP systems, data is organized in one-to-many relationship which makes it hard to explore.
I have read many articles about how to use the index() function (contributed by Richard Leeke, Rober ) - compute using, at the level, restarting every.
But it is still very confusing to me, and i have to use that very often.
So can we discuss such kind of advanced calculations?
These are great ideas! I know a topic that comes up quite a bit in the user groups is the use of background images. Whether this is in the context of traditional mapping or for more creative things (everyone has seen the Teeth Chart, right?), it's really fun to see Tableau's capabilities.
Maybe a session where all we do is look at cool vizes that use background images and reverse engineer them?
My favorite background image workbooks:
I missed this while preparing my submission to the Sports Viz contest, I'm glad TDT is happening, and thanks for putting this together, Tracy!
Some additional ideas based on what I've noticed as themes on the forums:
Measure Names/Measure Values - what can be done, what are limits and workarounds
Dealing with date/time fields and drawing lines (especially with sparse data where some padding may be necessary)
Understanding calculations at aggregate vs. row-level (the dreaded can't mix agg/non-agg error)
Count Distinct and variations thereof
Totals/Grand Totals - workarounds for dealing with them
I also really like Andy Cotgreave's idea of dashboard makeovers from this thread: http://community.tableau.com/message/177988#177988
We've decided we would do our first Think Data Thursday with a presentation and discussion on: Table Calculations!
In particular, we'll look at Table Calculations and Ranking (i.e. Index), using the Percent of Total with multiple fields on the view and showing how to compare all values in a view compared to one single member of a dimension.
Look for information in the next couple of days of how to attend this session. I'm looking forward to seeing you all there!
Sounds great. For all those interested in Table Calcs, check out this page with 10 downloadable examples of common table calcs like common baseline, weighted average and more. Instructions are included as tabs in each viz.
I couldn't find any other references to this Think Data Thursday thing, i.e. links, registration instructions, etc.
It will be 4:00 AM in my time zone, but maybe it will be possible to record the proceedings and make video available later?
My apologies for having to move this out yet another week! We had some issues getting our registration page out on time and we want to make sure that we have as many people as possible attend. The new date will be July 26 at 11 am PST. I'm sincerely sorry for any inconvenience this may have caused! Dimitri, we will be recording the video so that those who this does not work for will still be able to watch it.
We will still be discussing table calculations, as mentioned above.
Again, my apologies and I look forward to seeing you all next week!
The first (it's the real thing this time!) Think Data Thursday will be on Thursday, July 26 at 11:00 am Pacific time! As mentioned above, we will be discussing Table Calculations--in particular ranking/index and percent of totals. The link to attend this first meeting can be found here:
Looking forward to seeing you all there!