Hi! In a dashboard I have a normal table shoring the results (10-point scale) for certain metrics coming from 3 survey (2021, 2022, 2023) + a benchmark. Right now, I applied conditional formatting to colour the lowest scores red, the average scores yellow, the highest green.I would do something differen: the scores from previous years and the benchmark should color either green or red depending on how much they differ from those of the last survey (2023). So if there is more than a -0,5 point difference the score should be red, if more than +0,5 difference green. Is this possible? Or should I organize things differently?

We can create custom metrics for each attributes calculation and then use these metrics in table widget with required conditional formatting.

Table widget conditional formatting rules

Table widget conditional formatting rules | Experience Community