Dashboards & Visualizations

Stacked Bar Chart by the Number of Records per Category (stacked y-axis) by Week (x-axis)

Path Finder

I'm trying to create a stacked chart with the following data:

y-axis: Number of Change Requests per Reason (stacked)
x-axis: by Week (format: 2017-01-23, 2017-01-30, n)

Result: The Number of Change Requests per Reason (stacked) by Week in the past 2 months

index=snow sourcetype="snow:change_request" reason="Firewall*"
| eval impDate= strptime(u_actual_impl_end_date, "%Y-%m-%d %H:%M:%S")
| where impDate>=relative_time(now(),"-2mon")
| dedup number

0 Karma

Esteemed Legend

Maybe this:

index=snow sourcetype="snow:change_request" reason="Firewall*"
| eval _time = strptime(u_actual_impl_end_date, "%Y-%m-%d %H:%M:%S") 
| where _time >= relative_time(now(),"-2mon") 
| dedup number
| timechart span=1w count BY reason
0 Karma

Ultra Champion

Hi tmaltizo, do you have timestamps in your events?
if you do try this:

 index=snow sourcetype="snow:change_request" reason="Firewall*" | timechart span=7d count(reason)

hope it helps

0 Karma
Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...