3CX custom reports and wallboards in Grafana

OlegOLP

Platinum Partner
Basic Certified
Joined
Aug 30, 2019
Messages
74
Reaction score
31
Grafana is an open-source data visualization and monitoring tool that allows users to create interactive and customizable dashboards. It is widely used in various industries to visualize and analyze data from different sources, such as databases, cloud platforms, and third-party applications.

Install WebAPI & Webhook for 3CX and connect Grafana to 3CX. Use SQL-like queries to build any reports and dashboards.
https://creomate.com/3cx-grafana

2023-08-16_14-38-20.png


 
  • Like
Reactions: Zahed
Hi there and thank you for the post.
As you already know we are working on Grafana integration. Are you just advertising your product, or does it also mean you will share your Grafana templates/reports with the 3CX community and they will be available to the public too?
 
We have detailed instructions for connecting
https://creomate.com/grafana-3cx-doc

And we also have some very interesting reports, e.g.,

Who hungs up in 3CX?
2023-07-13_16-14-28.png


3CX Call center Agent availability report
2023-08-09_20-08-19.png


Repeated incoming calls to the 3CX call center
repeated_calls.png
 
Great, thank you for the feedback.
 
hello everyone,
Do we have a release date for the 3CX integration with grafana?
This will include support for real-time dashboards?

greetings
 
I need to spend some time with Grafana so I can speak with some authority, but for now I will make some assumptions.

I assume if you are working with historical data (exported 3CX report data or CDR data) that an integration with 3CX is not really required. But I am hoping with the Grafana integration that 3CX will be offering more direct access to the raw data both historical and real-time.

Today, things get really complicated when you need real-time data (important for real-time dashboards). Sure, it is straightforward to request the data, but when you need the data in real-time, poking the API every second to determine whether anything has changed is politely characterized as resource intensive. What is really needed is the ability to passively listen to events in real-time.

Unfortunately, if you have ever attempted to use the Call Control API to try and make sense of the real-time events it provides, you know it is a very challenging task. We have been working with these events for 15+ years and we are still finding unanticipated edge cases, or changes 3CX has made to the those events. Because the events evolve over time, it makes interpreting the meaning of the events an on-going learning process. ...Sigh...

What we really need/want is to know real-time things like who is on the phone, when they change their presence status, how many people are waiting in the queue and for how long, who is logged into queues, etc. The new configuration API may be able to provide some of the answers, but nobody, including 3CX, wants us poking multiple 3CX APIs every second to get real-time updates.

We will just have to wait and see what comes along with the Grafana integration and then we can decide whether a new approach to real-time data if possible. Any efforts 3CX makes to provide easy, supported, access to historical and real-time data is greatly appreciated.
 

Members Online Now

Forum statistics

Threads
111,831
Messages
589,277
Members
164,660
Latest member
RJenkinsROCK