All Apps and Add-ons

drill down for field names in map not working

rucb
New Member

I am creating a map in a dashboard, my query for the map in dashboard:
search| stats sum(session_c) as No_of_calls by CO , LAT, LON|geostats values(No_of_calls) as No_of_calls latfield=LAT longfield=LON globallimit=0 by CO
so every circle in map showing CO : No_of_calls, where CO is the field name and No_of_calls is No of calls by that CO.

I have to implement drilldown and need to pass CO fieldname in another page/form but when i click any circle or any CO, its passing one same fieldname of CO in another form/page and not passing clicked/selected fieldname of CO

my drill down code :

/app/heatmap_rx/avg_total_calls?form.CO=$click.name$&form.field1.earliest=$field1.earliest$&form.field1.latest=$field1.latest$

0 Karma

niketn
Legend

@rucb, refer to one of my older answers on limitation on Map drilldown and a work-around (may not be possible if there are multiple unknown values for CO field):

https://answers.splunk.com/answers/613088/how-to-redirect-to-two-urls-from-a-cluster-map.html

Or

https://answers.splunk.com/answers/636338/why-is-the-drilldown-not-working-my-splunk-cluster.html

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

rucb
New Member

We do have values for the Central Office for example a CLLI code and the number of calls are received on a Central office. Do you think in this case it is possible ?

0 Karma

niketn
Legend

@rucb, how many distinct values of CO? Also will all CO be present in all Pies i.e. Count=0 when CO is not present?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

rucb
New Member

the count of CO is more that 10k or 25K. Yes count will be zero when not present.

0 Karma

niketn
Legend

@rucb, sorry if you have 10K-25K values which is 0 when not present, then it would mean each data point will show 25K splits. This seems to be too high, unless I have misunderstood. A mock screenshot of what you currently have will help (mask out any sensitive information).

Also, the reason why I asked above questions was that only if it is less number of splits and all the series are always present you can use approach as mentioned in above answer. Else you would need to request for an enhancement.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability As businesses scale ...