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
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
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
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.
I have uploaded image above please see
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.