I am using that in the SELECT output as well as in the GROUP BY clause.
I am also using a date filter in the were clause, just an:
[[ AND {{ creation_date }} ]]
Now, if I do a range like “Past 6 days - Including today”, I get results in February. If I do a range of “Past 6 months - Including this month”, I don’t get any February results.
This is strange becuase the other SQL queries I have built seem to work fine with the “Including this month” flag.
Any ideas where I should look?
[[UPDATE]]
Even if I take the grouping out entirely and just do “creation_date”, and get the raw detail, it misses the current month/day/etc.
Hi, based on the fact that you use “include today” I guess you use v0.28? As I still haven´t updated yet I can´t reproduce your query.
But one thing you could do to check is rather than grouping it by month, group it by day and see if the filter “last 6 days - including today” include todays values?
You would find out that if “include today/this month” works at all.
Let me know the results
Eva
The “include current month” is working with the other queries, which is why this puzzled me. I just tried creating a new question and it is doing the same thing when I use “Previous x months including this month”, but “previous x days including today” works.
…and I just tried Previous 1 Year (including this year)" and it does not pull from this year, so something is perhaps broken.
As a workaround, I made my SQL a question to pull the newly created records. I thne built another question that used my SQL question as the data source, and by using the filtering there, grouping by creation_date:Month and using the sum of created records, I got the results I needed.