Getting Data In
Highlighted

filter by last six month data on last month date

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
Highlighted

Re: filter by last six month data on last month date

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
Highlighted

Re: filter by last six month data on last month date

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
Highlighted

Re: filter by last six month data on last month date

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
Highlighted

Re: filter by last six month data on last month date

I have uploaded image above please see

0 Karma
Highlighted

Re: filter by last six month data on last month date

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