4 Replies Latest reply on Jul 19, 2013 2:18 AM by Jim Wahl

# TV guide style listings in Tableau? Can't figure this out...

Hey, we're trying to use Tableau to build something like this:

http://entertainment.ca.msn.com/tv/listings/

What we're having problems with is getting the software to understand that a 2 hour show should have a longer box than a 1 hour show, etc. Some of the shows are as short as 15 minutes.

We need to be able to have 15, 30,60 etc minute blocks in rows like this. What we're experiencing is a lot of white space if a 2 hour show is stacked above a 30 minute show, etc.

The example above is perfect. Any help appreciated!

• ###### 1. Re: TV guide style listings in Tableau? Can't figure this out...

--Shawn

PS: Others have found this tip helpful, and have already gotten answers to their questions, after taking the corrective actions. Hope you will too.

1 of 1 people found this helpful
• ###### 2. Re: TV guide style listings in Tableau? Can't figure this out...

Thanks Shawn, I was confused about that. It said if I post to community it goes to 'everyone'. I used to select a number of sub-forums, I guess they've changed how it works here. I've moved it to forums, thank you!

• ###### 3. Re: TV guide style listings in Tableau? Can't figure this out...

This is kind of a cool Tableau challenge. And I don't think it's that difficult. The below was created with a Gantt chart, but you have to convert times to numbers; for example 2:30 = 2.5. with a duration also specified in numerical values. The duration becomes the size of the Gantt bar.

The numbers mess up your x-axis, but you can fake an axis (and put it at the top) using a dummy "Timeline" network with shows called 2:00 AM, 2:30 AM, ...

You can't draw a box around a Ganntt chart, but you can add some white space by multiplying the duration by 0.99.

I'd be happy to play with this some more (and interested to see what you come up with), but could you post some sample data TV show data or a packaged workbook with what you've go so far.

Jim

• ###### 4. Re: TV guide style listings in Tableau? Can't figure this out...

Wow... You stomped it, thanks so much, that's exactly what we're after. Let me get clearance on posting a workbook.

I also thought it was a really interesting way to use Tableau, haven't really seen anything quite like this yet, but it seemed like it should be possible and you've just confirmed!