Hey guys,
Thought I'd post this here to give you guys some ideas. We started using SugarCRM again recently and I dug up this custom dashlet I'd written a few years back.
As some of you might know from threads I've posted in before (original thread, revisited) we really find it useful to get a quick snapshot of how many outbound calls our reps make during the day. I have just completed my newest SugarCRM dashlet to show daily call volumes.
Here's a screenshot to give you an idea: Call Volume Dashlet
Basilly this works in realtime, you can see the total outbound calls made during the last 5 days (or whatever, Sugar lets users pick dates at runtime) for all configured users. Premise to make this possible is that either:
a) SugarCRM is installed in the asteriskcdrdb (or whatever database your cdr table resides in), or
b) Your asteriskcdrdb.cdr table is replicated to your SugarCRM database (this is what we do)
I am using an intermediate table to match Sugar users' GUID with their asterisk extension, and so we pull reports as per their Sugar username.
I have another similar dashlet to show the number of booked appointments (something I've put together as a custom feature code in asterisk) for the reps as well. Both graphs together really gives management a good glimpse of what's going on this week as soon as they login to Sugar.
I am willing to post the custom dashlet files if anyone is interested, though of course I can't promise any real support.
Member Since:
2008-02-21