-
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
-
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.
-
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>
-
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?
-
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
-
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
-
7. Re: Color scale with more than one measure
Ville Tyrväinen Mar 13, 2015 8:24 AM (in response to Shawn Wallwork)-
color scales sample_vt.twbx 1.4 MB
-
-
8. Re: Color scale with more than one measure
Shawn Wallwork Mar 13, 2015 8:34 AM (in response to Ville Tyrväinen)1 of 1 people found this helpfulYep! 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:
-
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!
-
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
-
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.
-
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');>>
-
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