ColorPalette Expression using case providing an wrong answer

vengat4043 — Tue, 30 Jan 2024 15:32:43 GMT

Panel_1:
<set token="V20">$result.value_20$</set>
<set token="V40">$result.value_40$</set>
<set token="V0">$result.value_0$</set>
<set token="V100">$result.value_100$</set>

Panel_2:

<format type="color" field=">6hrs-<8hrs">
<colorPalette type="expression">case(value<="$V20$", "#006400", value>"$V20$" AND value<="$V40$", "#ffb200", value>"$V40$", "#800000")</colorPalette>
</format>
<format type="color" field=">8hrs-<10hrs">
<colorPalette type="expression">case(value<="$V20$", "#006400", value>"$V20$" AND value<="$V40$", "#ffb200", value>"$V40$", "#800000")</colorPalette>
</format>
<format type="color" field=">10hrs-<12hrs">
<colorPalette type="expression">case(value<="$V20$", "#006400", value>"$V20$" AND value<="$V40$", "#ffb200", value>"$V40$", "#800000")</colorPalette>
</format>
<format type="color" field=">12hrs-<14hrs">
<colorPalette type="expression">case(value<="$V20$", "#006400", value>"$V20$" AND value<="$V40$", "#ffb200", value>"$V40$", "#800000")</colorPalette>
</format>
<format type="color" field=">14hrs-<16hrs">
<colorPalette type="expression">case(value<="$V20$", "#006400", value>"$V20$" AND value<="$V40$", "#ffb200", value>"$V40$", "#800000")</colorPalette>
</format>

The above is Scenario, i have created the tokens from the Panel_1 result and passing those tokens into the Colorpalette expression to highlight the cells dynamically. But i can't able to reach the desired output. How can i reach the desired output?

topic ColorPalette Expression using case providing an wrong answer in Dashboards & Visualizations

ColorPalette Expression using case providing an wrong answer