Card Color Options

phesson
phesson Member
in Cards, Dashboards, Stories

Curious if anyone has a workaround for highlighting the top x rows of a table when creating a card. The color rule options are all based on the value of a column, but I just need to highlight the top 2 rows on the chart (as it is sorted on a measure column greatest to smallest)

Essentially here is what it would look like (and I would want the west and north highlighted in this example, but the numbers will change, so always Rank 1 and 2):

Rank

Area

Metric

1

West

10

2

North

7

3

East

5

4

South

2

Any help would be greatly appreciated.

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited February 2024 Answer ✓

    You could set the color rule based on rank. So when Rank <= 2 then color

    Screenshot 2024-02-14 at 12.54.56 PM.png

    Screenshot 2024-02-14 at 12.54.45 PM.png

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited February 2024 Answer ✓

    You could set the color rule based on rank. So when Rank <= 2 then color

    Screenshot 2024-02-14 at 12.54.56 PM.png

    Screenshot 2024-02-14 at 12.54.45 PM.png

    If I solved your problem, please select "yes" above

  • phesson
    phesson Member
    https://community-forums.domo.com/main/discussion/comment/89357#Comment_89357

    Thank you, how do I do that. Are you saying beastmode formulas can color rows? I didn't think there was a rank function, so the first column is simply the same data as the last column, just displayed as "ranked highest to lowest".

  • ColemenWilson
    ColemenWilson Coach
    edited February 2024

    You can use a rank & window tile in your ETL to create a rank or create a rank with the following beastmode:

    RANK(Metric) OVER (order by Metric DESC)

    This will create a dynamic rank value that you can use to assign your color rule.

    If I solved your problem, please select "yes" above

Categories