Cards, Dashboards, Stories

Cards, Dashboards, Stories

Card Color Options

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.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

  • edited February 2024 Answer ✓

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

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

Answers

  • edited February 2024 Answer ✓

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

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

  • 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".

  • 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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In