Why does an R search not work on a dashboard?

[krwinters11]

I have a search that is working great in the search app of splunk that includes and R script (through the R Project App). When I save it as a Dashboard Panel the search no longer works when I go to the dashboard, but it still works in the search app. Does anyone know why?

My hunch is that the dashboard is flattening out the lines of the R search and ignoring new lines. The search works like this:
...search... | r " source('predictR.r')
output=data.frame(predictR(input)) "
BUT not like this:
...search... | r " source('predictR.r') output=data.frame(predictR(input)) "
Which is why I think that the dashboard ignores new lines when the search app does not.

Any ideas? 🙂

[mikebd · Accepted solution]

Use ; as a statement delimiter.

[krwinters11]

Awesome! thank you so much! I love when the solution is so simple 🙂

[SanthoshSreshta]

Can we use Where condition here, so that we can get the results based on condition.???
if we can get that, can you please post the answer to

https://answers.splunk.com/answers/256185/drill-down-in-dashboard-with-r-integration-based-o.html?mi...

[rfujara_splunk]

Maybe try inserting \n at the end of each line. Just an idea...

[krwinters11]

It doesn't like that 😞 any other ideas?

[aljohnson_splun]

Could you try using < ![CDATA[ > in the dashboard?

[krwinters11]

Where would I put it in my search?