Dashboards & Visualizations

Search waiting for input... no chart is displayed when running Dashboard

quanteq
Path Finder

When using the following search:
source="HomeDP561210.csv" host="Owner-PC" sourcetype="csv" ContractingAgency="" tag=Home tag=Home | eval ActionObligationS1=tonumber(replace(ActionObligationS,",","")) | eventstats sum(ActionObligationS1) as Total | eval Total=if(Total>0,"$".tostring(Total,"commas"),"($".tostring(Total-1,"commas").")")

  1. When creating a Bar Chart in Visualization with the Top values
    of my above search which we then change to a Pie Chart, we save as a Dashboard panel

  2. When viewing the saved Dashboard panel the message "Search is waiting for input..." is displayed without the newly created Pie Chart.

0 Karma
1 Solution

tom_frotscher
Builder

Hi,

change it to this:

source="HomeDP561210.csv" host="Owner-PC" sourcetype="csv" ContractingAgency="" tag=Home tag=Home | eval ActionObligationS1=tonumber(replace(ActionObligationS,",","")) | eventstats sum(ActionObligationS1) as Total | eval Total=if(Total>0,"$$".tostring(Total,"commas"),"($$".tostring(Total-1,"commas").")")

It looks like a conflict with the token syntax on dashboards, i only changed from one dollor sign to two dollar signs. ($ -> $$)

Greetings

Tom

View solution in original post

tom_frotscher
Builder

Hi,

change it to this:

source="HomeDP561210.csv" host="Owner-PC" sourcetype="csv" ContractingAgency="" tag=Home tag=Home | eval ActionObligationS1=tonumber(replace(ActionObligationS,",","")) | eventstats sum(ActionObligationS1) as Total | eval Total=if(Total>0,"$$".tostring(Total,"commas"),"($$".tostring(Total-1,"commas").")")

It looks like a conflict with the token syntax on dashboards, i only changed from one dollor sign to two dollar signs. ($ -> $$)

Greetings

Tom

quanteq
Path Finder

Tom,

Thanks for your input. It worked well!

Juan

0 Karma
Get Updates on the Splunk Community!

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Your Voice Matters! Help Us Shape the New Splunk Lantern Experience

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

Building Momentum: Splunk Developer Program at .conf25

At Splunk, developers are at the heart of innovation. That’s why this year at .conf25, we officially launched ...