All Apps and Add-ons

How can we control count in maps+?

abhilasha2410
New Member

Hi Splunker,Please help to find the solution this problem.

My task is to show the Bus location and Service center location in single Map .
Bus locations are stored in Index A ** and Service Centers locations are stored in ** lookup file .
To achieve this I am using MAPS+ Initially when map loads its only showing Bus locations When user click on show Service center then service centers location loaded into the same Map.

To achieve this I am using append query to combine both Bus location and Service Center Location.Both the locations are visible on Map * but problem here is It's also counting the Service centers locations with Bus locations.* Please help me How we can restrict to not count the Service centers location.

My Query:index="A"
|append[|inputlookup Service_lookup ]
|eval markerColor=case(like(Status, "%1%"), "orange",like(Status, "%0%"), "red", 1=1, "lightblue"), icon=case(like(Status, "%1%"),"building",like(Status, "%0%"), "hand-lizard-o", 1=1, "car"),layerDescription=case(like(Status, "%1%"),"building",like(Status, "%0%"), "hand-lizard-o", 1=1, "car")
|table latitude, longitude,BUS_ID,markerColor,icon,iconColor,layerDescription,ServiceCenterName,Status,Address

alt text Count inside rectangular box is sum of both BUS and Service center.

0 Karma
Get Updates on the Splunk Community!

Register to Attend BSides SPL 2022 - It's all Happening October 18!

Join like-minded individuals for technical sessions on everything Splunk!  This is a community-led and run ...

What's New in Splunk Cloud Platform 9.0.2208?!

Howdy!  We are happy to share the newest updates in Splunk Cloud Platform 9.0.2208! Analysts can benefit ...

Admin Console: A Single, Unified Interface for All Your Cloud Admin Needs

WATCH NOWJoin us to learn how the admin console can save you time and give you more control over the Splunk® ...