Hello, I've a tabular data like below and I want to color the cells based on the following threshold. 0%-79% ==> Red 80%-99% ==> Yellow 100% ==> Green I am applying below but without any success. I know that this is due to % symbol in the values. <format type="color" field="Passed Rules"> <colorPalette type="list">[#FF9999,#FFE699,#C6E0B4]</colorPalette> <scale type="threshold">80%,100%</scale> </format> So how can I apply colors over the cell? Thanks in advance. @ITWhisperer  ... View more

Hello There, I've the data in below tabular format but it's not showing correctly over the visualization. visualization should show either active or inactive based on the above table but it's showing 0. @ITWhisperer  ... View more

Hello, Panels are not showing/hiding based on the selection of the multiselect input. <form> <label>Multiselect input to hide/show multiple panels</label> <search> <query> | makeresults | fields - _time | eval data="$service_tok$" | eval condition=case(match(data,"\*"),"show_all",match(data,"Windows") AND match(data,"NIX") AND match(data,"VMWare"),"show_all",match(data,"Windows"),"Windows",match(data,"NIX"),"NIX",match(data,"VMWare"),"VMWare") | eval show_all=case(condition="show_all","true") | eval show_windows=case(condition="Windows" OR condition="show_all","true") | eval show_nix=case(condition="NIX" OR condition="show_all","true") | eval show_vmware=case(condition="VMWare" OR condition="show_all","true") </query> <done> <condition match="$job.resultCount$!=0"> <eval token="tokShowAll">case(isnotnull($result.show_all$),$result.show_all$)</eval> <eval token="tokShowWindows">case(isnotnull($result.show_windows$),$result.show_windows$)</eval> <eval token="tokShowNIX">case(isnotnull($result.show_nix$),$result.show_nix$)</eval> <eval token="tokShowVMWare">case(isnotnull($result.show_vmware$),$result.show_vmware$)</eval> </condition> <condition> <unset token="tokShowAll"></unset> <unset token="tokShowWindows"></unset> <unset token="tokShowNIX"></unset> <unset token="tokShowVMWare"></unset> </condition> </done> </search> <fieldset submitButton="false"> <input type="time" token="field1"> <label></label> <default> <earliest>-60m@m</earliest> <latest>now</latest> </default> </input> <input type="multiselect" token="service_tok" searchWhenChanged="true"> <label>Select a Service</label> <choice value="*">All</choice> <choice value="Windows">Windows</choice> <choice value="NIX">NIX</choice> <choice value="VMWare">VMWare</choice> <change> <unset token="tokShowAll"></unset> <unset token="tokShowWindows"></unset> <unset token="tokShowNIX"></unset> <unset token="tokShowVMWare"></unset> </change> <default>*</default> <initialValue>*</initialValue> <delimiter> </delimiter> </input> </fieldset> <row> <panel> <title></title> </panel> </row> <row depends="$tokShowWindows$"> <panel> <table> <title>Windows Request Count</title> <search> <query>host=abcd source="/access.log*" | timechart span=1hr count by host</query> <earliest>-4h@m</earliest> <latest>now</latest> </search> </table> </panel> </row> <row depends="$tokShowNIX$"> <panel> <table> <title>NIX Request Count</title> <search> <query>host=abcd source="access.log" | timechart span=1hr count by host</query> <earliest>-4h@m</earliest> <latest>now</latest> </search> </table> </panel> </row> <row depends="$tokShowVMWare$"> <panel> <table> <title>VMWare Request Count</title> <search> <query>host=abcd source="access.log" | timechart span=1hr count by host</query> <earliest>-4h@m</earliest> <latest>now</latest> </search> </table> </panel> </row> </form> @ITWhisperer  ... View more

Hello, I've the following tabular formatted data: How can I achieve the following: Thanks in advance for your help. @ITWhisperer ... View more

Hello, I've following 4 gauges in a panel and I want to change the color only for "Category:4" gauge based on the below values/threshold of "Category:4" gauge. Range            Color 0-79               Red 80-99            Yellow 100                Green Note: I don't want to change the color of gauges "Category:1", "Category:2","Category:3" (These gauges have different condition/threshold for color) Thanks for your help in advance. @ITWhisperer @gcusello  ... View more