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 LegendYou will need the daily numbers to do a daily chart. My suggestion would be to set up an automated process using an Automation or a Pipeline to set up child records under these records so that you end up with one daily record for each day. Then you would base chart on the daily records.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
That was my assumption. The next step would be to create a series of child records between two dates that each contains the (estimated call value/number of days).
I don't know how to do this inside QuickBase but I assume you would create an automation that:
Creates a new Day based on the formula Date=(Start Date + Automation Counter)
Adds 1 to Automation Counter if the counter doesn't equal the number of days between End Date and Start Date
And the automation ends when the Automation Counter equals the number of days between End Date and Start Date
Am I going in the right direction?
------------------------------
Nicholas Geer
------------------------------
I don't know how to do this inside QuickBase but I assume you would create an automation that:
Creates a new Day based on the formula Date=(Start Date + Automation Counter)
Adds 1 to Automation Counter if the counter doesn't equal the number of days between End Date and Start Date
And the automation ends when the Automation Counter equals the number of days between End Date and Start Date
Am I going in the right direction?
------------------------------
Nicholas Geer
------------------------------
- MarkShnier__Youis there a maximum number of days that this needs to handle? That could affect the solution.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- 19 to 22 days maximum
------------------------------
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
------------------------------