13 Replies Latest reply on Mar 13, 2015 9:11 AM by Shawn Wallwork

Color scale with more than one measure

John Forr Mar 13, 2015 7:49 AM

We have an activity with a start and end time. I'm trying to show the average duration of each activity's time, but in the special case that an activity has started, but not finished, I also want to convey that fact.

I'd like to setup a chart where each dimension has a red-green diverging mark based on an average of duration. If the activity has a start time, but no end time, then I'd like to color the mark a third color. Any ideas on how to do this?

Message was edited by: John Forr Attached Workbook

color scales sample.twbx 1.4 MB

1. Re: Color scale with more than one measure

Shawn Wallwork Mar 13, 2015 7:43 AM (in response to John Forr)

Got a packaged workbook with sample data?

Cheers,

--Shawn
Like Show 0 Likes(0)

Actions
2. Re: Color scale with more than one measure

John Forr Mar 13, 2015 7:49 AM (in response to Shawn Wallwork)

Edited the original post with something that does the first part of what I want, but I can't do the second part.
Like Show 0 Likes(0)

Actions
3. Re: Color scale with more than one measure

Alexander Mou Mar 13, 2015 8:00 AM (in response to John Forr)

If endtime=null then constant
Else....

The constant can be be any color within the dynamic range or outside. This
is a way to differentiate.

On Friday, March 13, 2015, John Forr <tableaucommunity@tableausoftware.com>
Like Show 0 Likes(0)

Actions
4. Re: Color scale with more than one measure

John Forr Mar 13, 2015 8:04 AM (in response to Alexander Mou)

Wouldn't assigned null to a constant interfere with the dynamic range though? How would I have the average be a red-green diverging scale, but the special value of NULL be assigned the color blue?
Like Show 0 Likes(0)

Actions
5. Re: Color scale with more than one measure

Shawn Wallwork Mar 13, 2015 8:06 AM (in response to Alexander Mou)

Alexander did you actually open his workbook and try this answer you are suggesting? If so please post the workbook. If not, please do the work before posting an answer. Thanks,

--Shawn
Like Show 0 Likes(0)

Actions
6. Re: Color scale with more than one measure

Shawn Wallwork Mar 13, 2015 8:20 AM (in response to John Forr)

I can't think of a way of doing this. Essentially you're wanting to combine a single discrete color, with a continuous color range. There might be some trickery you can use, but I've never seen that sort of thing posted here. Maybe someone else has worked it out.

Cheers,

--Shawn
Like Show 0 Likes(0)

Actions
7. Re: Color scale with more than one measure

Ville Tyrväinen Mar 13, 2015 8:24 AM (in response to Shawn Wallwork)
Would this work?

color scales sample_vt.twbx 1.4 MB
Like Show 2 Likes(2)

Actions
8. Re: Color scale with more than one measure

Shawn Wallwork Mar 13, 2015 8:34 AM (in response to Ville Tyrväinen)

Yep! And of course it's you coming up with this Ville.

--Shawn

EDIT: And since Ville like to hide his cleverness, here's what he did:

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
9. Re: Color scale with more than one measure

John Forr Mar 13, 2015 8:36 AM (in response to Shawn Wallwork)

So if I'm reading that right, he set the background color to be one thing, so if there's no value, it displays that instead of the mark. Brilliant!
Like Show 1 Likes(1)

Actions
10. Re: Color scale with more than one measure

Shawn Wallwork Mar 13, 2015 8:43 AM (in response to John Forr)

John just make sure your colors are set to 100%, otherwise the blue will bleed through and wash out the greens and reds.

--Shawn
Like Show 0 Likes(0)

Actions
11. Re: Color scale with more than one measure

Ville Tyrväinen Mar 13, 2015 9:00 AM (in response to Ville Tyrväinen)

Actually I posted a wrong screenshot and wasn't even sure would this work for him.
Like Show 1 Likes(1)

Actions
12. Re: Color scale with more than one measure

Alexander Mou Mar 13, 2015 9:00 AM (in response to Shawn Wallwork)

Awesome Ville!

On Friday, March 13, 2015, Shawn Wallwork <
tableaucommunity@tableausoftware.com
<javascript:_e(%7B%7D,'cvml','tableaucommunity@tableausoftware.com');>>
Like Show 0 Likes(0)

Actions
13. Re: Color scale with more than one measure

Shawn Wallwork Mar 13, 2015 9:11 AM (in response to Ville Tyrväinen)

I agree with Alexander, you are Awesome Ville.

--Shawn
Like Show 0 Likes(0)

Actions