Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a table in this format on SQL:
The Range tab contains the start and end time of each campaign in minutes for each day.
Example:
The first line:
Time | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
---|---|---|---|---|---|---|
Start Time | 480 | 1920 | 3360 | 2800 | 6240 | 7680 |
End time | 1140 | 2580 | 4020 | 5460 | 6900 | 7920 |
Is there a way whereby I can break it like in the table.
Many Thanks for your help.
Kind Regards,
Hasvine
I've downloaded your qvw-file. It's a bit confusing because I'm not good in French.
Also I don't understand termin these working hours, because it could be 8:00AM to 5:00 PM or 9:00 AM to 6:00 PM or even 3:00PM to 12:00 AM, so please clarify this point.
Also mark to which table you need to apply restrictions ( I guess Calendar table, pls confirm, but neither I don't understand to which fields there you need to apply restrictions you have 14 begin/end pairs)
Kind regards,
Andrei
Actually, there are some campaign which works from 08:00 to 11:00 and then close down from 11:00 to 14:00 and then re open from 14:00 to 19:00. This is why I could not classify them by day and some campaigns are open whole day.
I need the appels reçu and appels servis to count only the calls during the respective working time.
I need the changes to the first table CH01.
Many thanks for your help.
KR,
Hasvine
Dear Hasvine,
I really want to help, but I cant understand your requirements so far... So, generally I understood that you need to count calls which were made in working time for each company.
But which field(s) indicates working hours for each company? (which field and which table - according to your qvw app)
what field indicates call timestamp (or just time)? (which field and which table - according to your qvw app)
If you do not need extra data in your datamodel you may apply where clause like this "where timecall<WorkEnd1 and timecall> WorkStart1 or timecall<WorkEnd2 and timecall> WorkStart2" for companies which are working the whole day it will be the same fields.
If you need this data in some other aspects of you analysis you can make such restictions in Set analysis as you did in your CH01 chart.
Hope this helps.
Regards,
Andrei