<?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: Splunk map size of Piechart/How to remove field from pie portion in splunk map in Dashboards &amp; Visualizations</title>
    <link>https://community.splunk.com/t5/Dashboards-Visualizations/Splunk-map-size-of-Piechart-How-to-remove-field-from-pie-portion/m-p/176089#M10911</link>
    <description>&lt;P&gt;instead of using a rangemap try using eval and case condition, i would call it something like:&lt;/P&gt;

&lt;P&gt;eval severity=case(secs&amp;lt;1 AND secs&amp;gt;3,"Good",secs&amp;lt;=3  AND secs&amp;gt;4,"Fair",secs&amp;lt;=4 AND secs&amp;gt;2000,"worse") | geostats latfield=latitude longfield=longitude count by severity&lt;/P&gt;</description>
    <pubDate>Mon, 15 Jun 2015 10:11:33 GMT</pubDate>
    <dc:creator>Venkat_16</dc:creator>
    <dc:date>2015-06-15T10:11:33Z</dc:date>
    <item>
      <title>Splunk map size of Piechart/How to remove field from pie portion in splunk map</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/Splunk-map-size-of-Piechart-How-to-remove-field-from-pie-portion/m-p/176088#M10910</link>
      <description>&lt;P&gt;Hi..I have little tricky requirement. I need to display health score of device by Location as "Good" "Bad" and "Fair" on Splunk Map.&lt;BR /&gt;
But the Size of Pie should be depends upon usercount. and portion of pies should be only Good Fair or Bad. I wrote the query but It is taking Usercount also as a portion of pie. I ned to remove that but Still I want size according to user count.&lt;BR /&gt;
Intersting fact is : Good+Bad+Fair != Usercount as Usercount is population not the people who are using that app.&lt;/P&gt;

&lt;P&gt;Search query is : &lt;BR /&gt;
|inputlookup network_mapping_file.csv|fields latitude,longitude,UserCount|geostats latfield=latitude longfield=longitude  max(UserCount) as UserCount |appendcols[search index=ms sourcetype=transaction  | join inner hostname[|inputlookup network_mapping_file.csv|fields hostname,latitude,longitude,UserCount] | search transaction="StaticFile3MB"   | eval secs=round(duration/1000) |  rangemap field=secs Good=0-3 Fair=3-4 Bad=4-2000 | geostats latfield=latitude longfield=longitude  count by range]&lt;IMG src="https://community.splunk.com/storage/temp/1459-maps.png" alt="alt text" /&gt;&lt;/P&gt;

&lt;P&gt;Please suggest how I can determine the size of pie according to usercount without using it in portion of pie. As in image..Blue is User count . I need to remove that and just want to display Green red and yellow in pie.&lt;/P&gt;

&lt;P&gt;Thanks,&lt;BR /&gt;
Disha&lt;/P&gt;</description>
      <pubDate>Mon, 28 Sep 2020 17:58:11 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/Splunk-map-size-of-Piechart-How-to-remove-field-from-pie-portion/m-p/176088#M10910</guid>
      <dc:creator>disha</dc:creator>
      <dc:date>2020-09-28T17:58:11Z</dc:date>
    </item>
    <item>
      <title>Re: Splunk map size of Piechart/How to remove field from pie portion in splunk map</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/Splunk-map-size-of-Piechart-How-to-remove-field-from-pie-portion/m-p/176089#M10911</link>
      <description>&lt;P&gt;instead of using a rangemap try using eval and case condition, i would call it something like:&lt;/P&gt;

&lt;P&gt;eval severity=case(secs&amp;lt;1 AND secs&amp;gt;3,"Good",secs&amp;lt;=3  AND secs&amp;gt;4,"Fair",secs&amp;lt;=4 AND secs&amp;gt;2000,"worse") | geostats latfield=latitude longfield=longitude count by severity&lt;/P&gt;</description>
      <pubDate>Mon, 15 Jun 2015 10:11:33 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/Splunk-map-size-of-Piechart-How-to-remove-field-from-pie-portion/m-p/176089#M10911</guid>
      <dc:creator>Venkat_16</dc:creator>
      <dc:date>2015-06-15T10:11:33Z</dc:date>
    </item>
  </channel>
</rss>

