Getting Data In

filter by last six month data on last month date

abhishekdubey00
Engager

I have date field which is showing date I want only last date of every month and i want filter only last six month if i choose in time picker last 6 moth it shows last date of month like

2019-05-31 23:59:59.999999+00

2019-04-30 23:59:59.999999+00

2019-03-31 23:59:59.999999+00

2019-02-28 23:59:59.999999+00

2019-01-31 23:59:59.999999+00

2018-12-31 23:59:59.999999+00

how it will possible please suggest me
alt text

0 Karma

FrankVl
Ultra Champion

Assuming your date field is called date

...your base search...
| bin _time span=1mon
| stats latest(date) as last-date-of-month by _time
| fields last-date-of-month
0 Karma

abhishekdubey00
Engager

but its showing only may date of data i need last six month data from now last six month with only last date of every month

0 Karma

FrankVl
Ultra Champion

Can you upload a screenshot somewhere and post the link here? If you are actually searching over 6 months of data, I don't see how it would only return dates from may.

0 Karma

abhishekdubey00
Engager

I have uploaded image above please see

0 Karma

FrankVl
Ultra Champion

You're doing bin _time span=6mon. That must be span=1mon. You're searching over 6 months in total, but want to group the data monthly to get the latest(date) per month.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...