<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: How to add percentages to Bar Charts? in Dashboards &amp; Visualizations</title>
    <link>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609171#M49962</link>
    <description>&lt;P&gt;Give this a try&lt;/P&gt;&lt;P&gt;**UPDATED&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;| inputlookup Migration-Status-All.csv
| search Vendor = "Symantec"
| stats count by "Migration Comments"
|  eventstats sum(count) as Total
|  eval perc=round(count*100/Total,2)
| eval dummy = 'Migration Comments'
| chart sum(perc) over "Migration Comments" by dummy&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 11 Aug 2022 20:17:44 GMT</pubDate>
    <dc:creator>somesoni2</dc:creator>
    <dc:date>2022-08-11T20:17:44Z</dc:date>
    <item>
      <title>How to add percentages to Bar Charts?</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609167#M49961</link>
      <description>&lt;P&gt;Hi,&lt;BR /&gt;&lt;BR /&gt;I have a series of bar charts and when I hoover each bar, I currently see the count value.&lt;BR /&gt;&lt;BR /&gt;What I actually need is the percentage value.&lt;BR /&gt;&lt;BR /&gt;Here is my current query and bar chart:&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="POR160893_0-1660221712147.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/21001iA9A14DBBD6EFC65F/image-size/medium?v=v2&amp;amp;px=400" role="button" title="POR160893_0-1660221712147.png" alt="POR160893_0-1660221712147.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;LI-CODE lang="markup"&gt;| inputlookup Migration-Status-All.csv
| search Vendor = "Symantec"
| eval dummy = 'Migration Comments'
| chart count over "Migration Comments" by dummy&lt;/LI-CODE&gt;
&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;How can I change my query to show a percentage when hoovering over each bar?&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;Many thanks,&lt;BR /&gt;Patrick&lt;/P&gt;</description>
      <pubDate>Thu, 11 Aug 2022 14:37:47 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609167#M49961</guid>
      <dc:creator>POR160893</dc:creator>
      <dc:date>2022-08-11T14:37:47Z</dc:date>
    </item>
    <item>
      <title>Re: How to add percentages to Bar Charts?</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609171#M49962</link>
      <description>&lt;P&gt;Give this a try&lt;/P&gt;&lt;P&gt;**UPDATED&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;| inputlookup Migration-Status-All.csv
| search Vendor = "Symantec"
| stats count by "Migration Comments"
|  eventstats sum(count) as Total
|  eval perc=round(count*100/Total,2)
| eval dummy = 'Migration Comments'
| chart sum(perc) over "Migration Comments" by dummy&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 11 Aug 2022 20:17:44 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609171#M49962</guid>
      <dc:creator>somesoni2</dc:creator>
      <dc:date>2022-08-11T20:17:44Z</dc:date>
    </item>
    <item>
      <title>Re: Add percentages to Bar Charts</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609176#M49963</link>
      <description>&lt;P&gt;I get no results for either:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="POR160893_0-1660223721402.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/21002i6F128A25A9647DAC/image-size/medium?v=v2&amp;amp;px=400" role="button" title="POR160893_0-1660223721402.png" alt="POR160893_0-1660223721402.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;or (changing the per to perc):&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="POR160893_1-1660223757012.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/21003i5C964DE8332BBC38/image-size/medium?v=v2&amp;amp;px=400" role="button" title="POR160893_1-1660223757012.png" alt="POR160893_1-1660223757012.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 11 Aug 2022 13:16:06 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609176#M49963</guid>
      <dc:creator>POR160893</dc:creator>
      <dc:date>2022-08-11T13:16:06Z</dc:date>
    </item>
    <item>
      <title>Re: Add percentages to Bar Charts</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609216#M49968</link>
      <description>&lt;P class="lia-align-left"&gt;Try the updated query above.&lt;/P&gt;</description>
      <pubDate>Thu, 11 Aug 2022 20:18:05 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609216#M49968</guid>
      <dc:creator>somesoni2</dc:creator>
      <dc:date>2022-08-11T20:18:05Z</dc:date>
    </item>
    <item>
      <title>Re: How to add percentages to Bar Charts?</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609283#M49974</link>
      <description>&lt;P class="lia-align-justify"&gt;Thanks .... works perfectly (and I gave you Kudos!)&lt;/P&gt;</description>
      <pubDate>Fri, 12 Aug 2022 08:55:49 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/How-to-add-percentages-to-Bar-Charts/m-p/609283#M49974</guid>
      <dc:creator>POR160893</dc:creator>
      <dc:date>2022-08-12T08:55:49Z</dc:date>
    </item>
  </channel>
</rss>

