Estimated call volumes in a chart.
I have been asked to create a chart estimating the call volume from various clients per day in one graph. I have the total calls over a period of time. How can I display this on a graph without manual...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendis there a maximum number of days that this needs to handle? That could affect the solution.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
19 to 22 days maximum
------------------------------
Nicholas Geer
------------------------------
------------------------------
Nicholas Geer
------------------------------
- MarkShnier__YouAh the # of business days days in a month. The expedient way to do this would be to use an automation to maintain the required children.
Trigger when a date span record is added or modified or deleted.
Step 1. delete all the children.
Step 2 through 23. Add a child record for the correct date. You will need to have the trigger record have 22 fields for the correct date. ie
WeekDayAdd([start Date],1)
WeekDayAdd([start Date],2)
Then last step will be to delete any children outside the end date.
If you were doing this negatively in a pipeline to start with it's a bit more technical but it could probably be done more elegantly.
If you do it with an automation as I described above you should be able to push the button and migrated it to be a pipeline.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------