Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey there,
With example dataset, sales_data_sample.csv, I would like to highlight records where QUANTITYORDERED is greater than 50.
I've played around with the rank function within Style- > Background color -> by expression
=if(rank(QUANTITYORDERED)>50, yellow())
But still cant get it quite working. I want the records to be highlighted even before clicking into any of the data points.
Any tips are appreciated!
Thank you,
Kelly
Try this
=if(QUANTITYORDERED > 50, 'yellow', 'white')
Hey @Chanty4u ,
Thanks for the reply.
Is it possible
1. to pre-highlight the values before having to click into a value
2. only highlight the records above 50?
example this highlights the whole table:
Thanks,
Kelly