Dashboards & Visualizations

a pipeline added to the subsearch when creating a dashboard with drilldown and base searches

FAnalyst
Engager

I need help about this subsearch using pivot command 

Base search : | pivot  Traffic  All_Traffic FILTER  zone is "$form.srcZone$"

sub search: count(src_zone) AS src_zone_count SPLITROW zone AS zone TOP 100 count(zone) ROWSUMMARY 0 COLSUMMARY 0 SHOWOTHER 1 

the problem is that there is a pipeline added by splunk before the subsearch I wnat the subsearch to be  exectuted without the pipline 

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

By subsearch, do you mean a chained search e.g. a search in a panel that has a base defined referencing a base search defined elsewhere in the dashboard?

If so, there is no way to remove the pipe from the generated query. However, given that pivot is just a wrapper for stats and xyseries, can you not just refactor your search to deal with the table produced by the pivot command by using stats command and similar?

0 Karma

FAnalyst
Engager

hello thank you for answering 

here is the panel search when it gets excused when  I delete the pipeline added by splunk and run the search again the issue  will be resolved  

| pivot Traffic All_Traffic FILTER zone is "User  Zone" | count(zone) AS zone_count SPLITROW zone AS zone TOP 100 count(zone) ROWSUMMARY 0 COLSUMMARY 0 SHOWOTHER 1

 

I am taking this approach because I want to build a dashboard from a datamodel and I want it to be dynamic so the user can choose from the dirlldown the zone that the dashboard base search will take the user input and pass it to the panels searches that would give results for the zone chosen by the user 

0 Karma
Get Updates on the Splunk Community!

CX Day is Coming!

Customer Experience (CX) Day is on October 7th!! We're so excited to bring back another day full of wonderful ...

Strengthen Your Future: A Look Back at Splunk 10 Innovations and .conf25 Highlights!

The Big One: Splunk 10 is Here!  The moment many of you have been waiting for has arrived! We are thrilled to ...

Now Offering the AI Assistant Usage Dashboard in Cloud Monitoring Console

Today, we’re excited to announce the release of a brand new AI assistant usage dashboard in Cloud Monitoring ...