I have a summary index which gets indexed once in a month. I have a query which runs based on current month looks back at last 6 months and provides me a report. Is it possible to rewrite a query to show a trend which can go over each months' event and look back 6months of data for each month and provide a report?
Here is the query which looks back at last 6 months from current month. I would like to do the same for all months (look back from each month) and provide a trend