Help!
Hi! I am using Quickbase to house and report call center metrics. It has proven to be a wonderful tool! I am however, running in to an issue in the displaying of true total service level metrics. This...
Forum Discussion
QuickBaseJunkie
Qrew Legend
Qrew LegendHi Ben,
Not sure if you've found your answer yet, but I can sympathize, having worked in the Call Center industry for a number of years!
The best I can come up with (in QB) in order to have the summaries and reports show the correct data is to "flatten" it with the use of a parent table.
Using the parent table you can build summaries for each Offered, Answered, and Abandon. Then recreate your Service Level formula on the Parent as well.
Basically you're taking out the need for any 'summarizing' on the Service Level before building your reports or charts.
If you want this reporting by day then it may be easiest to create records in the parent that go out a number of days and set a date field to the key field. Then in the relationship to the call data instead of using the "related parent" as the key reference, you can use the date field and the relationship will 'automatically' populate (this may depend on how the calls are getting entered into the QB).
This method can get more challenging as you may want to report weekly, monthly, or quarterly... again flattening the data.
In these cases, it may be better suited to do the analysis/reporting outside of QB.
Let me know if this information is helpful 👍😀
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
Not sure if you've found your answer yet, but I can sympathize, having worked in the Call Center industry for a number of years!
The best I can come up with (in QB) in order to have the summaries and reports show the correct data is to "flatten" it with the use of a parent table.
Using the parent table you can build summaries for each Offered, Answered, and Abandon. Then recreate your Service Level formula on the Parent as well.
Basically you're taking out the need for any 'summarizing' on the Service Level before building your reports or charts.
If you want this reporting by day then it may be easiest to create records in the parent that go out a number of days and set a date field to the key field. Then in the relationship to the call data instead of using the "related parent" as the key reference, you can use the date field and the relationship will 'automatically' populate (this may depend on how the calls are getting entered into the QB).
This method can get more challenging as you may want to report weekly, monthly, or quarterly... again flattening the data.
In these cases, it may be better suited to do the analysis/reporting outside of QB.
Let me know if this information is helpful 👍😀
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------