Get Mode of dimension - apply that dimension's colour in straight table?

110 — Tue, 30 Aug 2022 16:30:11 GMT

I have a measure column that finds the most frequent occurrence of a particular category, but I'd like to highlight the background based on the result of that mode () function.

I've tried simply referencing the colour field, which is linked 1:1 to the category field, but nothing happens.

I've tried using the mode() function on the colour field, but some category colours are the same , so that technique fails also.

Any suggestions would be greatly appreciated, I thought this would be fairly simple to achieve , but am confounded.

Here's an example QVD - I included the target colours based on what they should be - so it's easier to understand.

As you can see from the coloured table / chart, A should return Blue, B Green, and C Red

topic Get Mode of dimension - apply that dimension's colour in straight table? in App Development

Get Mode of dimension - apply that dimension's colour in straight table?