Skip to main content

#0000ff0 personne en discute

いまツリーマップを使っているのですが、値がBKなら黒、Wなら白というように、値に応じて塗る色を変えたいのです。

if

[col] == 'BK'

then '黒'

elseif [col] == 'W'

then '白'

else '青'

end​

という感じでは、黒と指定したところが青になり、白と指定したところが赤になり、という形で全く無関係な色が割り当てられてしまいます。​

本当はBKには#000000、白には#FFFFFFという感じで直接色を指定したいのですが、まあそれはともかく。​

どなたかご存知であればコメントお願いします。​

4 réponses
  1. 16 avr. 2021, 08:31

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

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

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

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

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

    よろしくお願いします。

0/9000

How to formatte a slack message sent to Slack via the API, so that it only displays a short abstract and if a user is interested in it, they can click on it to enlarge it to display more details. By the time they're finished, they should be able to collapse it.

 

We went through the formatting of the messages. And we see that we may add attachments. And more information as well. But we see no way to deliver a message with a 55-character abstract. And then a longer hidden body up to 200 characters which can be magnified or reduced out of view.

 

There are two reasons for doing this:

  1. To reduce the amount of screen space that a message occupies, preventing other messages from being overshadowed or lost.
  2. To enhance the readability of the thread, considering that not everyone needs to read the details since they may or may not be relevant to them.
4 réponses
  1. 18 mai 2023, 11:47

    To format a Slack message with a short abstract that can be expanded or collapsed, you can use message attachments and the

    collapsible

    option. Here's an example of how you can achieve this:

    json

     

    {

     "attachments": [

      {

       "title": "Short Abstract",

       "text": "This is a short abstract of the message (up to 55 characters).",

       "fallback": "Short Abstract: This is a short abstract of the message.",

       "callback_id": "expand_message",

       "actions": [

        {

         "name": "expand",

         "text": "Expand",

         "type": "button",

         "value": "expand"

        }

       ]

      },

      {

       "title": "Full Message",

       "text": "This is the expanded view of the message with more details (up to 200 characters).",

       "fallback": "Full Message: This is the expanded view of the message with more details.",

       "color": "#0000FF",

       "attachment_type": "default",

       "callback_id": "collapse_message",

       "actions": [

        {

         "name": "collapse",

         "text": "Collapse",

         "type": "button",

         "value": "collapse"

        }

       ],

       "collapsible": true,

       "collapsed": true

      }

     ]

    }

     

    In this example, the first attachment contains the short abstract of the message. It includes a button labeled "Expand." When the user clicks on the "Expand" button, it triggers an action (

    expand_message

    ), which can be handled by your application to show the second attachment.

    The second attachment represents the full message with more details. It includes a button labeled "Collapse." Clicking on the "Collapse" button triggers an action (

    collapse_message

    ), which can be handled to hide the expanded view and show only the short abstract again.

    By default, the second attachment is collapsed (

    "collapsed": true

     

    ), so only the short abstract is initially visible. The

    collapsible

    option indicates that the attachment can be expanded or collapsed.

    Adjust the

    "text"

    properties in both attachments to include your desired content within the character limits specified in your requirements.

    Note that this example uses the Slack message formatting via API. Depending on your implementation, you may need to adapt the code accordingly.

0/9000

i have the following formula in process builder.  I would like this formula to update to the field in BOLD  Below is the formula and it works perfectly

 

FYI result displays on a new line each time and adds to the data already held in this field giving a historical record of each time/date/user changes a stage in the system.    (TEXT(DAY(DATEVALUE([Opportunity].LastModifiedDate )))& "-"& TEXT(MONTH(DATEVALUE([Opportunity].LastModifiedDate )))& "-"&  TEXT(YEAR(DATEVALUE([Opportunity].LastModifiedDate )))& "-"& ([Opportunity].LastModifiedBy.FirstName)  &" "&  ([Opportunity].LastModifiedBy.LastName) & " "&  text([Opportunity].StageName )& " "& br() & PRIORVALUE([Opportunity].Stage_Update_Tracking__c ) >/b>  

6 réponses
  1. 28 juil. 2022, 06:29

    Hi Sharene,

     

    You can use the below formula in process builder to make the text bold.

     

    '<h1><span style="color: #.ff0000;"><h1><span style="color:#.ff0000; font-weight: bold;">'

    &

    (TEXT(DAY(DATEVALUE([Opportunity].LastModifiedDate )))& "-"&

    TEXT(MONTH(DATEVALUE([Opportunity].LastModifiedDate )))& "-"&

    TEXT(YEAR(DATEVALUE([Opportunity].LastModifiedDate )))& "-"&

    ([Opportunity].LastModifiedBy.FirstName) &" "&

    ([Opportunity].LastModifiedBy.LastName) & " "&

    text([Opportunity].StageName )& " "& br() &

    PRIORVALUE([Opportunity].Stage_Update_Tracking__c )

     

    Note: Try modifying the styling according to your convenience.

0/9000

I have used the information from Tableau Friction: Dashboard Text Links - Adding and Customizing, no Worksheets Needed to customize my hyperlinks to be a name instead of the website address. I want to take it one step further and change the color to red, get rid of the underline, and bold the hyperlink.

 

The script tableau uses for hyperlinks are below:

<formatted-text>

   <run> Additional information located at </run>

   <run auto-url='true' fontcolor=''⌗0000ff' fontname='Arial' hyperlink='tabdoc:load-url url=&quot;https://website" ' underline='true'>website</run>

</formatted-text>

 

I edited it to be:

<formatted-text>

   <run> Additional information located at </run>

   <run auto-url='true' bold='true'  fontcolor=''⌗8e001c' fontname='Arial' hyperlink='tabdoc:load-url url=&quot;https://website" >website</run>

</formatted-text>

 

The hyperlink is now bold but still blue and underlined. When I open up the edit text the hyperlink text is bold red and not underlined. When it is closed the dashboard still shows it as bold blue with it underlined. If any changes are done in the edit text and applied the hyperlink is no longer a hyperlink.

 

Any help would be great.

1 réponse
  1. 5 avr. 2015, 20:59

    I'm only guessing here, but rather than deleting underline='true' you should make it underline='false'. Also you may be mixing single and double quotes on the new color -- at least you are in what you posted above. These might fix your issue. [I did not test it.]

     

    --Shawn

0/9000

 

hi,

 

I have some values in strings such as g,y,and b. i need to show these values as green dots,yellow dots,and blue dots.kindly help me.

6 réponses
0/9000