topic Re: filter by last six month data on last month date in Getting Data In

filter by last six month data on last month date

abhishekdubey00 — Wed, 19 Jun 2019 13:22:48 GMT

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

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

FrankVl — Wed, 19 Jun 2019 17:59:22 GMT

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

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

abhishekdubey00 — Wed, 19 Jun 2019 18:42:09 GMT

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

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

FrankVl — Wed, 19 Jun 2019 18:53:13 GMT

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.

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

abhishekdubey00 — Wed, 19 Jun 2019 19:08:03 GMT

I have uploaded image above please see

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

FrankVl — Thu, 20 Jun 2019 07:34:53 GMT

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.