How to color only the top of DataView

Fujisawa Miku

Please tell me how to color only the top 3 numerical values in the data view.

Remo Bollhalder

Hi @Fujisawa Miku @Samson Sunny

to add on Samsons ideas, if you need your solution to be dynamic you can:

1. Use the counter on the sorted block and set an alert to "<=3" to highlight the top 3 values
2. If the layout is not supposed to be sorted, you can use the "LARGE()" Formula in Nexel to list the top 3 values in a new Block. If the row entity is static you can use the deepest entity formula, otherwise you will have to get more creative. The formula would look something like this:

LARGE([@a;*;*;Range.Whole],1)

LARGE([@a;*;*;Range.Whole],2)

LARGE([@a;*;*;Range.Whole],3)

Samson Sunny

Hi @Fujisawa Miku,

I have two ideas but not sure if they are the best ones,

1. You can create a algorithm block with the "counter" ranking function to add a counter. Then enable a color alert on the block that you want you color the top 3 values. Use the "Use values of block" to refer to the counter block that you just created and configure the color alert accordingly.
   
2. Use the sort functionality on the block within the layout settings to sort the values of the block in descending order. Then create a Nexel block to compare the values of the block you want to color with the 3rd highest value within the same block. Something like this: =if([@a;;]>=[@a;E001;*];1,0). This Nexel block that is created acts as a flagging cube for you to refer in the color alert "Use values by block" to color the top 3 values.

Let me know if this is what you were expecting.