I Have Issue on MQTT to function and Template

[riimeister]

I have a problem when I want to create a dashboard template.

the following is the raw data from the sql server that I have and I want to make a dashboard

in the data I want to create a dashboard using the if else method or whatever,
The first one I want to make is if the DL11_LINE_SPEED data is "0" the dashboard display will change to CO1/CO2/C3/etc status until MC, but when the DL11_LINE_SPEED data > 0 it will display speed numbers. what are the steps? I've tried using var failed.

[jbudd]

The red triangle indicates an error in your function node but you have not shown us the code.

It would be helpful to see what your debug nodes display rather than a spreadsheet style presentation of the data.

[riimeister]

ust

I just made it to display the speed numbers only. for the status if not run I have not made.

[riimeister]

this for example dashboard, what I want to add here is if the machine is not running/speed "0" then the dashboard will display the status either CO/CO2/CO3/etc until MC like the data in sql server

[dynamicdave]

It would help if you could post your flow and a sample of what you see at the 'Speed' debug node.

[riimeister]

this flow debug node

[jbudd]