My project flow is:
1. Upload CSV file containing the data > Time Of Call, Project, Disposition, Call Duration, Zip Code, State
2. Generate a report that will find the Best Time to Call (means that I have to find the data where call disposition = successful call) and the Best Day to call
Example:
ViewCalls
| Time |
Project |
Disposition |
CallDuration |
Timezone |
State |
| 01/01/2013 01:45:00 |
Project 1 |
Presentation |
05:51:3 |
EST |
DC |
| 01/04/2013 02:25:00 |
Project 2 |
No Answer |
00:00:0 |
EST |
MA |
| 01/05/2013 02:43:00 |
Project 3 |
Presentation |
03:01:9 |
EST |
DC |
| 01/06/2013 03:55:00 |
Project 4 |
Presentation |
03:01:9 |
EST |
MA |
| 01/07/2013 02:33:00 |
Project 5 |
Presentation |
08:44:5 |
EST |
DC |
| 01/08/2013 04:13:00 |
Project 6 |
Presentation |
05:14:7 |
EST |
MA |
In this example, the
best time to call is around 2:00 because the successful disposition happens during this time (Presentation), the best state to call is
DC
(3 Presentation) because MA has a 'No Answer' Disposition and the best day to call is
Friday because 1/01/2013 and 1/08/2013 falls on Friday.
| Successful Calls |
| Day |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Total |
| Time |
DC |
MA |
DC |
MA |
DC |
MA |
DC |
MA |
DC |
MA |
DC |
MA |
| 1:01-2:00 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
1 |
0 |
| 2:01-3:00 |
0 |
0 |
1 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
2 |
0 |
| 3:01-4:00 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
| 4:01-5:00 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
1 |
| Totals |
0 |
1 |
1 |
1 |
2 |
3 |
2 |
Is it possible for Zoho Creator to produce such report?
Thanks,
CJ