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

# Color scale with more than one measure

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

• ###### 1. Re: Color scale with more than one measure

Got a packaged workbook with sample data?

Cheers,

--Shawn

• ###### 2. Re: Color scale with more than one measure

Edited the original post with something that does the first part of what I want, but I can't do the second part.

• ###### 3. Re: Color scale with more than one measure

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>

• ###### 4. Re: Color scale with more than one measure

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?

• ###### 5. Re: Color scale with more than one measure

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

• ###### 6. Re: Color scale with more than one measure

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

• ###### 7. Re: Color scale with more than one measure

Would this work?

• ###### 8. Re: Color scale with more than one measure

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
• ###### 9. Re: Color scale with more than one measure

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!

• ###### 10. Re: Color scale with more than one measure

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

--Shawn

• ###### 11. Re: Color scale with more than one measure

Actually I posted a wrong screenshot and wasn't even sure would this work for him.

• ###### 12. Re: Color scale with more than one measure

Awesome Ville!

On Friday, March 13, 2015, Shawn Wallwork <

tableaucommunity@tableausoftware.com

<javascript:_e(%7B%7D,'cvml','tableaucommunity@tableausoftware.com');>>

• ###### 13. Re: Color scale with more than one measure

I agree with Alexander, you are Awesome Ville.

--Shawn