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
how it will possible please suggest me
Assuming your date field is called
...your base search... | bin _time span=1mon | stats latest(date) as last-date-of-month by _time | fields last-date-of-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.
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.