I am tring to write a custom report that is similar to the historical split skill interval report.
I have copied the report and made all the changes and calculations. the problem I am having is trying to run the report on multiple skills and total the data together rather than the interval data listed separately.
I was informed that you could have a where statement of GROUP BY hsplit.STARTTIME but tried that and get an error. I was also told that all fields need to be a sum. tried that but still having problems.
Please help if you have any docs or have a report that you can send me.
many thanks
Jason
I have copied the report and made all the changes and calculations. the problem I am having is trying to run the report on multiple skills and total the data together rather than the interval data listed separately.
I was informed that you could have a where statement of GROUP BY hsplit.STARTTIME but tried that and get an error. I was also told that all fields need to be a sum. tried that but still having problems.
Please help if you have any docs or have a report that you can send me.
many thanks
Jason