Table widget conditional formatting rules | XM Community
Skip to main content

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.

You can also create embedded fields in survey to capture your calculation and then using these embedded fields in dashboard.

You can also create embedded fields in survey to capture your calculation and then using these embedded fields in dashboard.

Hi @CxEx, could you elaborate a bit on this method? Do you mean making an ebedded field for each KPI?

Leave a Reply


Terms & Conditions