Hi ,
how to add a field for the month so we can see a trend month by month since Jan 2016. for the same query i changed
DATEDiff to month but i need a output grouping in month by month average so i could get it as below format
Row Labels Average of DaysDiff
2016 2.7
Qtr1 3.1
Jan 3.0
Feb 2.9
Mar 3.3
and the result you are looking for...