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$
@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
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 ?
@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?
the count of CO is more that 10k or 25K. Yes count will be zero when not present.
@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.