topic Re: Trellis Layout with PieChart in Dashboards & Visualizations

Trellis Layout with PieChart

davidcraven02 — Mon, 22 Jan 2018 10:42:42 GMT

I have a pie chart which displays a breakdown of all Operating Systems but after trying to use the Trellis drill down it does not work. I don't know what I need to add in order to make it display correctly.

Please see my dashboard source code.

   <form>
       <label>OTL Client Desktops Test</label>
       <fieldset autoRun="true" submitButton="true">
       <row>
         <panel>
           <title>Operating System for client</title>
           <chart>
             <search>
               <query>`GEN_ProductionWorkstations` 
                   | rename User_Name0 as LastKnownUser, Caption0 as operatingSystem, Version0 as Version, Model0 as Model 
                   | search $companyCode$ 
                   | dedup machine 
                   | stats count by operatingSystem</query>
               <earliest>$Test_Time_Range.earliest$</earliest>
               <latest>$Test_Time_Range.latest$</latest>
             </search>
             <option name="charting.axisTitleX.visibility">collapsed</option>
             <option name="charting.axisTitleY.visibility">collapsed</option>
             <option name="charting.axisTitleY2.visibility">collapsed</option>
             <option name="charting.chart">pie</option>
             <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
             <option name="charting.drilldown">all</option>
             <option name="charting.legend.placement">none</option>
             <option name="height">394</option>
             <option name="refresh.display">progressbar</option>
             <option name="trellis.enabled">1</option>
             <option name="trellis.size">medium</option>
             <option name="trellis.splitBy">operatingSystem</option>
           </chart>
         </panel>
       </row>
     </form>

Re: Trellis Layout with PieChart

493669 — Mon, 22 Jan 2018 10:51:08 GMT

If you try to run below query in search in your app:

  `GEN_ProductionWorkstations` 
                        | rename User_Name0 as LastKnownUser, Caption0 as operatingSystem, Version0 as Version, Model0 as Model

What is the output you are receiving

Re: Trellis Layout with PieChart

davidcraven02 — Mon, 22 Jan 2018 11:03:37 GMT

What was the reason for this? It runs and returns data

Re: Trellis Layout with PieChart

493669 — Mon, 22 Jan 2018 11:10:48 GMT

Try below:

<form>
        <label>OTL Client Desktops Test</label>
        <fieldset autoRun="true" submitButton="true">
        <row>
          <panel>
            <title>Operating System for client</title>
            <chart>
              <search>
                <query>`GEN_ProductionWorkstations` 
                    | rename User_Name0 as LastKnownUser, Caption0 as operatingSystem, Version0 as Version, Model0 as Model 
                    | search $companyCode$ 
                    | dedup machine 
                    | stats count by operatingSystem Version</query>
                <earliest>$Test_Time_Range.earliest$</earliest>
                <latest>$Test_Time_Range.latest$</latest>
              </search>
              <option name="charting.axisTitleX.visibility">collapsed</option>
              <option name="charting.axisTitleY.visibility">collapsed</option>
              <option name="charting.axisTitleY2.visibility">collapsed</option>
              <option name="charting.chart">pie</option>
              <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
              <option name="charting.drilldown">all</option>
              <option name="charting.legend.placement">none</option>
              <option name="height">394</option>
              <option name="refresh.display">progressbar</option>
              <option name="trellis.enabled">1</option>
              <option name="trellis.size">medium</option>
              <option name="trellis.splitBy">operatingSystem</option>
            </chart>
          </panel>
        </row>
      </form>

It seems you need to add one more field in stats by clause
Hope this helps...

Re: Trellis Layout with PieChart

davidcraven02 — Mon, 22 Jan 2018 12:45:38 GMT

Absolute legend! Thank you!!!!