dbquery not work in dashboard

[coope84]

hello, here is my query string: | dbquery dbcenter "select (1 - (phy.value / (cur.value + con.value))) *100 \"HIT RATIO\" from v$sysstat cur， v$sysstat con， v$sysstat phy where cur.name = 'db block gets' and con.name = 'consistent gets' and phy.name = 'physical reads'" ,It's worked in the search app,but I cannot see results when use dbquery in dashboard, here is my xml

database center




| dbquery dbcenter "select (1 - (phy.value / (cur.value + con.value))) *100 \"HIT RATIO\" from v$sysstat cur， v$sysstat con， v$sysstat phy where cur.name = 'db block gets' and con.name = 'consistent gets' and phy.name = 'physical reads'"
0
now
true
false
none
row
10
visible
visible
linear
linear
radialGauge
gaps
0.01
default
shiny
all
0
ellipsisMiddle
right

[martin_mueller]

Without grasping the entirety of your post due to bad formatting, I see single dollar signs in your query. Escape those with another dollar sign to get $$, to avoid Splunk trying to replace $foo$ tokens.