OK here is what I would do.
Create date parameters to filter the overall report dates (if needed based on size of data).
1. Create a formula field for the for the date as "DAte Group" :
date({Qlog1.Call Date})
2. Group on this formula and change to "For each Day".
3. create a time formula as "Time GRoup":
time({Qlog1.Call In Time})
4. create a Group header1B.
5. Go into your existing Chart and change the "On Change of" field to the @TimeGroup formula field.
6. Drag the chart to the GH1B
Check it out and see is working as you want per day (one chart per day group header).
Youc an also exclude data using your select expert with:
time({Qlog1.Call In Time}) in TIME(08,00,00) to TIME(18,00,00)
If you really want this to be every 1/2 hour you can write a formula to convert your time field to be every half hour and group on that instead but it will be a long statement...
if time({Qlog1.Call In Time}) in TIme(08,00,00) to Time(08,30,00) then time(TIme(08,00,00) else
if time({Qlog1.Call In Time}) in TIme(08,30,01) to Time(09,00,00) then time(TIme(08,30,00) else
if time({Qlog1.Call In Time}) in Time(09,00,01) to Time(09,30,00) then time(TIme(08,00,00) else ...
If I come up with a better formula for the 1/2 hour I willpost that for youlater but that is easy to swap out if the rest of it works
Edited by DBlank - 10 Aug 2009 at 2:53pm
IP Logged
