Splunk Search

|stats count(sum) as a grouped TIMECHART

TCK101
New Member

Hello
...query

| bucket span=1month _time 
| eval date=strftime(_time, "%Y/%m/%d ") 
|stats count sum(2017_totals) as "Last_Year" sum(2018_totals) as "This_Year"  by  date county

Example Results:

The count is the number of the rows - e..g sales
Last_year is the SUM of totals for that month / year
This_year is the SUM of totals for that month / year

date                country      count     Last_Year      This_Year

2018/12/01     UK                27         300                400
2018/12/01     USA              22          200               350
2018/12/01     CHINA         12           150               200
2018/11/01     UK                 33           250             300
2018/11/01     USA              24           205            360
2018/11/01     CHINA           18           140           190

How can I get this in a chart where date is the X axis and group by COUNTRY

At the moment, the chart is just showing One country count and Last_Year This_Year as a bar chart

I wanted the chart to be something like X axis is time and with EACH country and its values in a bar.

Tags (1)
0 Karma

somesoni2
Revered Legend

Give this a try

...query
| bucket span=1month _time 
| chart count sum(2017_totals) as "Last_Year" sum(2018_totals) as "This_Year" by _time county limit=0
0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...