<?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 Influencing the order of chloropeth map legend without numbering in Splunk Search</title>
    <link>https://community.splunk.com/t5/Splunk-Search/Influencing-the-order-of-chloropeth-map-legend-without-numbering/m-p/463937#M130783</link>
    <description>&lt;P&gt;I'm using rangemap (mapped with field colors respectively) in chloropeth maps to sort the legend accordingly. However, is there a way to remove the numbering in front of each range and still have the order in the way I want it ? Once I remove the numbers, the order runs. &lt;BR /&gt;
I tried pre-pending spaces in front but it doesn't work properly. &lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;    &amp;lt;panel&amp;gt;
      &amp;lt;title&amp;gt;Monthly Volume Trend (%)&amp;lt;/title&amp;gt;
      &amp;lt;map&amp;gt;
        &amp;lt;search base="First_Base_Search"&amp;gt;
          &amp;lt;query&amp;gt;search $OriginCtryCode$
          | search $OriginRegion$
          | search $DstCtryCode$
          | search $DestRegion$
          | stats sum(eval(if(_time&amp;gt;=relative_time(now(),"-31d"),SHP_VOL,0))) as Latest30Days,sum(eval(if(_time&amp;gt;=relative_time(now(),"-61d") AND _time&amp;lt;relative_time(now(),"-31d"),SHP_VOL,0))) as Prev30Days by DEST_COUNTRY_CODE
          | eval PercentageDiff=round((Latest30Days-Prev30Days)/Prev30Days*100)
          | table DEST_COUNTRY_CODE,Latest30Days,Prev30Days,PercentageDiff  
          | rename DEST_COUNTRY_CODE as iso2 | lookup geo_attr_countries iso2 OUTPUT country | where !isnull(country) 
          | rangemap field=PercentageDiff "1. Over 50%"=50.01-1000 "2. 20% to 50%"=20.01-50 "3. 10% to 20%"=10.01-20 "4. 0% - 10%"=0.01-10 "5. 0% to -10%"=-9.99-0 "6. -10% to -20%"=-19.99--10 "7. -20% to -50%"=-49.99--20 "8. Over -50%"=-1000--50  | fields+ country, range | sort range | geom geo_countries featureIdField="country"&amp;lt;/query&amp;gt;
        &amp;lt;/search&amp;gt;
        &amp;lt;option name="drilldown"&amp;gt;none&amp;lt;/option&amp;gt;
        &amp;lt;!--option name="mapping.choroplethLayer.colorBins"&amp;gt;8&amp;lt;/option--&amp;gt;
        &amp;lt;option name="mapping.fieldColors"&amp;gt;{"1. Over 50%":0x39A800,"2. 20% to 50%":0x64B73F,"3. 10% to 20%":0xA6D48C,"4. 0% - 10%":0xC4E3B2,"5. 0% to -10%":"0xFF9E81","6. -10% to -20%":0xFF7B5A,"7. -20% to -50%":0xFF5232,"8. Over -50%":0xFF0000,"None":0xFFFFFF}&amp;lt;/option&amp;gt;
        &amp;lt;!--option name="mapping.choroplethLayer.colorMode"&amp;gt;categorical&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.choroplethLayer.maximumColor"&amp;gt;0x53a051&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.choroplethLayer.minimumColor"&amp;gt;0xdc4e41&amp;lt;/option--&amp;gt;
        &amp;lt;option name="mapping.choroplethLayer.shapeOpacity"&amp;gt;0.7&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.map.zoom"&amp;gt;2&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.showTiles"&amp;gt;1&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.tileLayer.tileOpacity"&amp;gt;0.7&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.type"&amp;gt;choropleth&amp;lt;/option&amp;gt;
      &amp;lt;/map&amp;gt;
    &amp;lt;/panel&amp;gt;
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;To further illustrate, I would like the legend to be sorted in this exact order when the numbering is removed:-&lt;/P&gt;

&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="alt text"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/8624i147272BCE50370E0/image-size/large?v=v2&amp;amp;px=999" role="button" title="alt text" alt="alt text" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
    <pubDate>Fri, 03 Apr 2020 14:04:52 GMT</pubDate>
    <dc:creator>andrewwjc</dc:creator>
    <dc:date>2020-04-03T14:04:52Z</dc:date>
    <item>
      <title>Influencing the order of chloropeth map legend without numbering</title>
      <link>https://community.splunk.com/t5/Splunk-Search/Influencing-the-order-of-chloropeth-map-legend-without-numbering/m-p/463937#M130783</link>
      <description>&lt;P&gt;I'm using rangemap (mapped with field colors respectively) in chloropeth maps to sort the legend accordingly. However, is there a way to remove the numbering in front of each range and still have the order in the way I want it ? Once I remove the numbers, the order runs. &lt;BR /&gt;
I tried pre-pending spaces in front but it doesn't work properly. &lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;    &amp;lt;panel&amp;gt;
      &amp;lt;title&amp;gt;Monthly Volume Trend (%)&amp;lt;/title&amp;gt;
      &amp;lt;map&amp;gt;
        &amp;lt;search base="First_Base_Search"&amp;gt;
          &amp;lt;query&amp;gt;search $OriginCtryCode$
          | search $OriginRegion$
          | search $DstCtryCode$
          | search $DestRegion$
          | stats sum(eval(if(_time&amp;gt;=relative_time(now(),"-31d"),SHP_VOL,0))) as Latest30Days,sum(eval(if(_time&amp;gt;=relative_time(now(),"-61d") AND _time&amp;lt;relative_time(now(),"-31d"),SHP_VOL,0))) as Prev30Days by DEST_COUNTRY_CODE
          | eval PercentageDiff=round((Latest30Days-Prev30Days)/Prev30Days*100)
          | table DEST_COUNTRY_CODE,Latest30Days,Prev30Days,PercentageDiff  
          | rename DEST_COUNTRY_CODE as iso2 | lookup geo_attr_countries iso2 OUTPUT country | where !isnull(country) 
          | rangemap field=PercentageDiff "1. Over 50%"=50.01-1000 "2. 20% to 50%"=20.01-50 "3. 10% to 20%"=10.01-20 "4. 0% - 10%"=0.01-10 "5. 0% to -10%"=-9.99-0 "6. -10% to -20%"=-19.99--10 "7. -20% to -50%"=-49.99--20 "8. Over -50%"=-1000--50  | fields+ country, range | sort range | geom geo_countries featureIdField="country"&amp;lt;/query&amp;gt;
        &amp;lt;/search&amp;gt;
        &amp;lt;option name="drilldown"&amp;gt;none&amp;lt;/option&amp;gt;
        &amp;lt;!--option name="mapping.choroplethLayer.colorBins"&amp;gt;8&amp;lt;/option--&amp;gt;
        &amp;lt;option name="mapping.fieldColors"&amp;gt;{"1. Over 50%":0x39A800,"2. 20% to 50%":0x64B73F,"3. 10% to 20%":0xA6D48C,"4. 0% - 10%":0xC4E3B2,"5. 0% to -10%":"0xFF9E81","6. -10% to -20%":0xFF7B5A,"7. -20% to -50%":0xFF5232,"8. Over -50%":0xFF0000,"None":0xFFFFFF}&amp;lt;/option&amp;gt;
        &amp;lt;!--option name="mapping.choroplethLayer.colorMode"&amp;gt;categorical&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.choroplethLayer.maximumColor"&amp;gt;0x53a051&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.choroplethLayer.minimumColor"&amp;gt;0xdc4e41&amp;lt;/option--&amp;gt;
        &amp;lt;option name="mapping.choroplethLayer.shapeOpacity"&amp;gt;0.7&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.map.zoom"&amp;gt;2&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.showTiles"&amp;gt;1&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.tileLayer.tileOpacity"&amp;gt;0.7&amp;lt;/option&amp;gt;
        &amp;lt;option name="mapping.type"&amp;gt;choropleth&amp;lt;/option&amp;gt;
      &amp;lt;/map&amp;gt;
    &amp;lt;/panel&amp;gt;
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;To further illustrate, I would like the legend to be sorted in this exact order when the numbering is removed:-&lt;/P&gt;

&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="alt text"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/8624i147272BCE50370E0/image-size/large?v=v2&amp;amp;px=999" role="button" title="alt text" alt="alt text" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 03 Apr 2020 14:04:52 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/Influencing-the-order-of-chloropeth-map-legend-without-numbering/m-p/463937#M130783</guid>
      <dc:creator>andrewwjc</dc:creator>
      <dc:date>2020-04-03T14:04:52Z</dc:date>
    </item>
  </channel>
</rss>

