Dynamically changing colours on value labels

Does anyone know if this if possible either at a widget level AND/OR at a dashboard level?

I've tried a bunch of scripts from ChatGPT but none that work as intended.
They either amend the colours but dont respect and changes being mad to rendering such as cell size changes and filters applied etc, or the reverse where it respects the rendering but not the colours changing..

BenWalkerRH

Posted 10 months ago·Last reply 10 months ago

5 comments

BenWalkerRH

OP10 months ago

Hi DRay

Apologies I've been on AL.

I've actuallty managed to get ChatGPT to help with this one.
Feel free to close :)

DRay

·10 months ago

Glad to hear you're up and running! If you don't mind, could you post the solution here so other people can find it if they have the same request?

DRay

·10 months ago

Hi BenWalkerRH,

Just checking to see if you still need help with this.

DRay

·10 months ago

Hi BenWalkerRH,

Can you look at this article and let us know if it helps? https://community.sisense.com/kb/widget_and_dashboard_scripts/pivot-and-table-widget-scripting-for-replacing-values-with-colored-arrows/25842

It goes a bit further than what you are trying to do, but it should be able to be trimmed down to meet your needs.

Please let us know how it goes!

DRay

·10 months ago

Hello BenWalkerRH,

Thank you for reaching out. I see your question hasn't gotten a response yet, so I'm asking internally to try and get you an answer.