Why some charts are loading slowly on dashboard?

[indeed_2000]

Hi
I have a dashboard that show several chart, some of these charts load slowly.

1-is it possible to put radio buttom that have two value like (OFF, ON) whenever user open dashboard won't load those chart, when user hit on load them.

2-is it possible to set load priority that first load light chart, after load them completely start to load heavy one!

    <panel>
      <title>Number of Request Called From Webservice</title>
      <chart>
        <search>
          <query>index="app" "INFO  [APP] [log]"  | rex "status\[(?&lt;status&gt;\w+)"

| timechart count(status)  by status usenull=f useother=f limit=0</query>
          <earliest>$tokTime.earliest$</earliest>
          <latest>$tokTime.latest$</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
        <option name="charting.axisTitleX.visibility">collapsed</option>
        <option name="charting.axisTitleY.visibility">visible</option>
        <option name="charting.axisTitleY2.visibility">visible</option>
        <option name="charting.axisX.abbreviation">none</option>
        <option name="charting.axisX.scale">linear</option>
        <option name="charting.axisY.abbreviation">none</option>
        <option name="charting.axisY.scale">linear</option>
        <option name="charting.axisY2.abbreviation">none</option>
        <option name="charting.axisY2.enabled">0</option>
        <option name="charting.axisY2.scale">inherit</option>
        <option name="charting.chart">area</option>
        <option name="charting.chart.bubbleMaximumSize">50</option>
        <option name="charting.chart.bubbleMinimumSize">10</option>
        <option name="charting.chart.bubbleSizeBy">area</option>
        <option name="charting.chart.nullValueMode">gaps</option>
        <option name="charting.chart.showDataLabels">minmax</option>
        <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
        <option name="charting.chart.stackMode">default</option>
        <option name="charting.chart.style">shiny</option>
        <option name="charting.drilldown">all</option>
        <option name="charting.layout.splitSeries">0</option>
        <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
        <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
        <option name="charting.legend.mode">standard</option>
        <option name="charting.legend.placement">bottom</option>
        <option name="charting.lineWidth">2</option>
        <option name="height">181</option>
        <option name="refresh.display">progressbar</option>
        <option name="trellis.enabled">0</option>
        <option name="trellis.scales.shared">1</option>
        <option name="trellis.size">medium</option>
      </chart>
    </panel>
  </row>

any idea?
Thanks

[bowesmana]

You could do this for your option 2.

In your heavy chart panel add these two "depends" statements and the <done> section

<panel depends="$heavy_search_done$">    
  <search depends="$light_search_done$">
    <query>index="app" "INFO  [APP] [log]"  | rex "status\[(?&lt;status&gt;\w+)"
| timechart count(status)  by status usenull=f useother=f limit=0</query>
    <earliest>$tokTime.earliest$</earliest>
    <latest>$tokTime.latest$</latest>
    <sampleRatio>1</sampleRatio>
    <done>
      <set token="heavy_search_done">1</set>
    </done>
  </search>
</panel>

 and then in your light search, add a similar <done> section, but set token="light_search_done"

That means your light search will run first and when it's done, the heavy one with start and when that is finished, it will display the panel.

[gcusello]

Hi @indeed_2000,

The best approach, in my opinion is putting this paned in a dedicated Dashboard.

If you want to maintain it in the same dashboard, you could put an input, without a default value used only by this panel so it will not be loaded until you add the value.

Or you could try to optimize the search using Post process Search methis (if applicable) or an acceleration method.

Ciao.

Giuseppe