How to color only the top of DataView
Fujisawa Miku
Active Partner
in Platform
Please tell me how to color only the top 3 numerical values in the data view.
0
Accepted Answer
-
Hi @Fujisawa Miku @Samson Sunny
to add on Samsons ideas, if you need your solution to be dynamic you can:
- Use the counter on the sorted block and set an alert to "<=3" to highlight the top 3 values
- 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)
2
Answers
-
Hi @Fujisawa Miku,
I have two ideas but not sure if they are the best ones,
- 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.
- 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.
0 - 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.
