Topic: Grouped by hour - How to automate text Posted: 30 Nov 2015 at 9:23pm
I have a report which shows the number of calls logged each hour, using group by hours and a distinct count of the call reference. This all works well.
What I am unable to do is get the text to show the hours the calls were logged between as shown below:
XX calls logged between 00:00 and 01:00
XX calls logged between 01:00 and 02:00
XX calls logged between 02:00 and 03:00
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
