Hello,
Hoping for some help with this. We have a Dashboard that was working, at least that's what I was told, one of the panels was hidden until a state was clicked on the map. Now, when a state is clicked, the panel isn't displayed. I know the search is running because when I click on "Edit", I see the report/panel with correct results. The xml is below, can someone help point me in the right direction with what's not working here? Thanks in advance!
<panel>
<title>Consult Communicator Location Map</title>
<map>
<title>Click on a State to see Location Details</title>
<search>
<query>| dbxquery query="Select MODEL,SERIAL,NAME,STREET_ADDR,CITY,STATE,POSTAL_CODE,OLSON_CODE FROM foo" connection="FOO_STDBY" shortnames=t
| search CITY!="SMALL_TOWN"
| lookup geo_attr_us_states state_code AS STATE OUTPUT state_name AS STATE
| stats count by STATE | geom geo_us_states featureIdField="STATE"</query>
<earliest>@d</earliest>
<latest>now</latest>
</search>
<!-- choropleth layer -->
<!-- configure custom tile layer -->
<option name="drilldown">all</option>
<option name="mapping.choroplethLayer.colorBins">5</option>
<option name="mapping.choroplethLayer.colorMode">categorical</option>
<option name="mapping.choroplethLayer.maximumColor">0xAF1D12</option>
<option name="mapping.choroplethLayer.minimumColor">0xEF6B62</option>
<option name="mapping.choroplethLayer.shapeOpacity">0.6</option>
<option name="mapping.choroplethLayer.showBorder">0</option>
<option name="mapping.data.maxClusters">100</option>
<option name="mapping.map.center">(45,-100)</option>
<option name="mapping.map.panning">1</option>
<option name="mapping.map.scrollZoom">0</option>
<option name="mapping.map.zoom">3</option>
<option name="mapping.markerLayer.markerMaxSize">50</option>
<option name="mapping.markerLayer.markerMinSize">10</option>
<option name="mapping.markerLayer.markerOpacity">0.8</option>
<option name="mapping.showTiles">1</option>
<option name="mapping.tileLayer.attribution">&copy; <a
href="http://www.openstreetmap.org/copyright">OpenStreetMap</a> contributors, &copy;
<a href="http://cartodb.com/attributions">CartoDB</a></option>
<option name="mapping.tileLayer.maxZoom">18</option>
<option name="mapping.tileLayer.minZoom">0</option>
<option name="mapping.tileLayer.url">http://{s}.basemaps.cartocdn.com/dark_all/{z}/{x}/{y}.png</option>
<option name="mapping.type">choropleth</option>
<option name="link.openSearch.visible">false</option>
<option name="link.openPivot.visible">false</option>
<option name="link.inspectSearch.visible">false</option>
<option name="link.exportResults.visible">true</option>
<drilldown>
<set token="src_type_tok">$click.value$</set>
</drilldown>
</map>
</panel>
<panel depends="$panel_show$">
<table>
<title>State Details</title>
<search>
<query>| dbxquery query="Select MODEL,SERIAL,NAME,STREET_ADDR,CITY,STATE,POSTAL_CODE,OLSON_CODE FROM lwpoc" connection="FOO_STDBY" shortnames=t | search CITY!="SMALL TOWN" | lookup geo_attr_us_states state_code AS STATE OUTPUT state_name AS STATE | search STATE=$src_type_tok$ | fields - _raw - _time</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="count">15</option>
</table>
</panel>
</row>
... View more