How Can I add image to dashboard tile based dql result

[heramb_sawant]

Hi,
I have DQL which shows the SRG recent execution Status on dashboard tile. I want to show Green image if latest guardian execution is Pass and Red image if execution is Fail. How to achieve that.

Regards,
Heramb Sawant

[Akhil-Jayendran]

Hello @heramb_sawant ,

If you’d like to add a traffic light symbol, simply copy and paste the emoji Unicode into your DQL — that should work.
eg [something like ]: | fieldsAdd indicator = if( abs(diff) < 10, "🟡", else: if( abs(diff) > 10, "🟥" ))

If you want to add background colors to your dashboard cells, you can use the visual editor.



Hope this will help you ?

[RohitBisht]

Hi @heramb_sawant ,
In addition to what said above by @Akhil-Jayendran ,you can use a lot of emoji. How I use it is right click within the DQL query and click on emoji as shown below.
Sample query:
fetch logs
| fieldsAdd Pass = if(loglevel != "ERROR", "🟢",else: "🔴")