#FF00000 人がディスカッション中

@Billie Boles​ 

Hi, I think you are missing:

a. A space between Palette' and type

b. a </color-palette> at the end of the colors.

<?xml version='1.0'?>
<workbook>
 <preferences>
<color-palette name='My Red-Black Palette' type='regular'>
    <color>#FF0000</color>
     <color>#330000</color>
</color-palette>
</preferences>
</workbook>

If this post resolves. would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego

This is a known limitation of Slack Block Kit.

The automatic "Color Swatch" preview (the little colored square) that appears next to Hex codes (e.g., #FF0000) is a feature of the standard Text Object (mrkdwn).

Why it fails in Tables:

Slack's new

Workaround:

You cannot "fix" the Table Block behavior. Instead:

1. Use an Image: Generate a tiny 10x10px image of that color and insert it as an image element in the block (if not using a table).
2. Use Emoji: If the colors are standard (Red, Blue, Green), map them to emojis (🔴, 🔵, 🟢) inside the table cell.
3. Abandon Table Block: Use a series of Section Blocks with "Fields" (Columns). Section blocks fully support mrkdwn, so the Hex color preview will reappear.
4. https://trailblazers.salesforce.com/profileView?u=005KX000003d0L3YAI

Before I hop on my little soapbox, how's this?

This can't be configured in the Tableau UI as far as I know, I had to edit the preferences.tps file where I added the following custom color palette:

    </color-palette>

See http://kb.tableau.com/articles/knowledgebase/creating-custom-color-palettes for more details on custom color palettes.

Then the Sales KPI calculation in Tableau is:

IF SUM([Sales]) > 1000000 THEN
    7
ELSEIF SUM([Sales]) > 600000 THEN
    (SUM([Sales]) - 600000) / 400000 + 6
ELSEIF SUM([Sales]) > 100000 THEN
    (SUM([Sales]) - 100000) / 500000 + 3
ELSE
    SUM([Sales]) / 100000
END

This returns a range of 0-1 for red, 3-4 for yellow, and 6-7 for green. This is necessary because we have to insert spacer colors in the custom color palette so the entire range of red/yellow/green is available for each KPI.

Then I set up the colors using the Advanced option to make sure that the full color range is used and to set the Start and Center:

Here's a link to the workbook on Tableau Public: Workbook: ordered diverging kpi color

Now for the soapbox, because this kind of viz has two serious issues:

1) It's using red and green. That makes somewhere between 5 and 8% of the male population (and up to 1/2% of the female population) unable to interpret this viz, I ran this particular set of colors through Vischeck http://vischeck.com for the most common form of color blindness:

With a split-second glance, in 2012 Chairs & Chairmats & Envelopes look like they are in the same range, so the use of color for pre-attentive processing is a total fail here. Now while it is possible to select colors that are distinct enough for color blind people to use this, since you wanted a continuous range that gets more difficult.

2) This viz is using both the hue of the color (red/yellow/green) and intensity (saturation) to identify the range. These are the *least* effective forms of visual encoding for quantitative data per http://mkt.tableau.com/downloads/designing-great-visualizations.pdf (page 8) after position, length, angle, and area/size. (Thanks to Ben Jones for the reference in his book _Communicating Data with Tableau_). While most of us do have red/yellow/green internalized for meanings, there are three continuous ranges here and that makes it even more complicated for users to interpret.

Now you might be able to muck around with the color settings and generate a set of 6 colors that have light/dark red, light/dark yellow, and light/dark green where each set of colors has increasing intensity that doesn't overlap , but you're probably better off spending your time building a different kind of visualization (or multiple visualizations). What are the business questions that are being asked here? If you're trying to identify the worst/best performers then maybe sorting the view might be better (so you are using position). If you're trying to look at change over time then use a line chart (which is encoding for position & length & angle), or maybe a bar chart with absolute or % difference. There are many possible visualizations that could be built out of this data that would help users more accurately answer the questions they have than this kind of chart. The wonderful thing about Tableau is that we can quickly and easily built a set of visuals to answer many different questions.

Jonathan

Keith:

No problem at all. Thats the trick, the center value really looking for the center of your range. In my example .3 was the half of 0 - 0.6. If you create custom divergence, the color scale automatically creates the color palette mixing and you would loose your yellow.

I believe there is a Tableau idea to specify center color also and you can vote it.

OK, I have another option and let me know if this works;

- Using a calculated field for the color;

- created a calc field

- My Calc

     SUM([Sales]) / TOTAL(SUM([Sales]))

- One more calc field - For Color Num. Make it a mea

if [My Calc] > 0 and [My Calc] < .35 then 1

elseif [My Calc] > .35 and [My Calc] < .45 then 2

else 3

end

NOTE: I used my ranges in the condition

- Used the For Color Num on the color shelf and make it 3 stepped color

- Drag your values to display on to the label shelf

This is what I got and hope this helps;

I changed the calc field with diff numbers and it seemed to work.

..kk

@T I​ さん、確認が遅くなってしまい申し訳ありません！

​

ディメンションまたはメジャーの色コードを指定したい場合はファイルを編集する必要があります。

設定ファイルを変更することになるので万一Tableauが動作不良を起こす可能性を踏まえてのサポート外ということですが、基本的には​前回ご紹介したオンラインヘルプの手順に従えば問題ないと思います。

​

カラーパレットにはカテゴリーカラーパレットと、連続カラーパレットと、分岐カラーパレットとの3種類があります。

凡例の数に関係なくいくつでもパレットごとに色を追加できますので、凡例が増えた場合にはまた設定ファイルを開いて色コードを追加すれば大丈夫です。

​

よろしくお願いします。

​

The problem is that most of the built-in diverging color palettes go from one color to another meeting at white or grey in the middle, but you can create your own custom palette that does not do this. Here's how: Create Custom Color Palettes

I created the following palette that goes from black to a bright red:

<color-palette name="Black/Red Diverging" type="ordered-diverging" >

<color>#000000</color>

<color>#FF0000</color>

</color-palette>

Using superstore, I dropped Profit on the Color card, then chose this palette:

However, it still shows a range of colors (not all negatives are black), so I created a calculated field as follows:

Color

IF SUM([Profit])<0 THEN

    0

ELSE

    SUM([Profit])

END

I then dragged this to the color card and chose the palette:

Close, but one of the problems with this is that low values still show very black. If you want postitive values to be more red, then you can fiddle with the color palette settings. For example, here I've selected "Use Full Color Range" and set the Center at 500:

See attached workbook.

use below calculation and Edit Colour Legends as per required

IF [ERROR Flag]='ERROR' THEN "RED"

ELSEIF [ERROR Flag ]='OK' THEN "BLACK"

END

Now Edit Color Legend. Double click on RED color change the code

Hi @christine Johnston

You can use below code to apply border/outline to the box: 

<!DOCTYPE html> 

<html lang="en"> 

<head> 

    <meta charset="UTF-8"> 

    <meta name="viewport" content="width=device-width, initial-scale=1.0"> 

    <title>RCE Box Border</title> 

    <style> 

        .rce-box { 

            width: 300px; 

            height: 150px; 

            padding: 10px; 

            border: 2px solid #000000; 

            border-radius: 10px; 

            outline: 3px dashed

;  

            box-sizing: border-box; 

        } 

    </style> 

</head> 

<body> 

    <div class="rce-box"> 

        <p>Sample Text</p> 

    </div> 

</body> 

</html>