Hi, I am trying to configure some Sales Reports where I can show weekly statistics of things like the number of calls made. From tutorials that I have watched, I have been able to create a report which shows the calls made for the last X number of weeks, showing the week number by using the custom function “week({t}.{f})”, however ideally I would like to instead be able to display the Week Commencing date - does anyone know if this is possible?
Emma,
you can literally use all SQL functions that are available. What you are doing in this field is writing SQL Code. What you can do dpeends on the database you use. So if you are running on MySQL all MySQL functions are available.
Another goo read to understand the capabilities is this document http://www.spicecrm.io/download/customizing-queries-in-kreporter/ that explains this in more details what are the customization capabilities.
regards, the SpiceCRM and KReporter Team