Reporting

Why am I only getting incremental data in my scheduled report?

mbroshi
Engager

I have a scheduled report my-scheduled-report that runs once every morning, and is supposed to get data for the last 7 days. I then have a dashboard that includes my-scheduled-report as a base search via

<search ref="my-scheduled-report" id="base_search"></search>

I then use that in all the panels in my dashboard via panels like:

<panel>
  <title>Unique Users Per Day</title>
  <chart>
    <search base="base_search">
      <query>timechart span=1d dc(userId)</query>
    </search>
    <options ... >
  </chart>
</panel>

My problem is that I only see the previous day's data in my dashboard, not the full week's. It's as if I only get incremental data from the previous scheduled report.

0 Karma
1 Solution

mbroshi
Engager

I think I solved my issue, which had nothing to do with scheduled reports or base searches. My scheduled report has joins and it appears they are getting truncated to 50,000 records. Would be helpful to have an error message somewhere!

View solution in original post

mbroshi
Engager

I think I solved my issue, which had nothing to do with scheduled reports or base searches. My scheduled report has joins and it appears they are getting truncated to 50,000 records. Would be helpful to have an error message somewhere!

Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...