how can i create a filter which shows last 6months data from current date.
If you have a timestamp field in your dataset you can do this.