Dashboards & Visualizations

Display all days in the chart errespective of error occurance on that day, Chart should display all the dates as per the date specified in the code.

sushe10
New Member
index = itf host="*itseelm*" logLevel=ERROR EbcName=EBCMFSSALES02 ExceptionMessage="*ORA-01000*" | timechart span=1d count | fillnull value=0 count

earliest -90d@d earliest
latest now latest

Tags (1)
0 Karma

somesoni2
Revered Legend

Give this a try

index = itf host="*itseelm*" logLevel=ERROR EbcName=EBCMFSSALES02 ExceptionMessage="*ORA-01000*" 
| append [| noop | addinfo | eval t=split(info_min_time." ".info_max_time," ") | mvexpand t | table t | rename t as _time ] 
| timechart span=1d count | fillnull value=0 count
0 Karma

sundareshr
Legend

Try this

...  | timechart cont=t span=1d count | ...
0 Karma

Richfez
SplunkTrust
SplunkTrust

When I do

<someindexes> <someothercriteria>  earliest=-90d | timechart span=1d count

I totally get lines with zero in them. Lots of those, in fact, depending on my search.

Can you confirm exactly what you are seeing? Maybe a screenshot or a paste of a few lines where the data's "missing?"

0 Karma
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...