Dashboards & Visualizations

How to create geomaps with bubbles ?

georgear7
Communicator

I have my output table created from the mentioned query. 

index=foo host=bla03u source=*.log sourcetype=bol_logs | chart values(Status) by Application_Name,Country,Transaction_Name

Source table:

Application_NameCountryTransaction_NameStatus
App1AustraliaHomepage0
App1AustraliaLogin0
App2SingaporeHomepage1
App3ChinaHomepage0
App3ChinaLogin1

 

Output table:

Appplication_NameCountryHomepageLogin
App1Australia00
App2Singapore1 
App3China01

 

Status :

0 - 'Success'

1 - 'Failure'

From this output table, I want to create one geomap with bubbles. My app should shows in red, if value '1' is present anywhere and app should shows in green, if both Homepage and Login contains value '0'.

Please suggest how to achieve this.

Tags (1)
0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...