Grafana Reporting Now Available with 3CX Update 6 BETA

Version 20 Update 6 BETA marks a significant leap in call reporting capabilities within the 3CX ecosystem. This update builds on the recently released reporting tools by allowing integration with Google BigQuery, enabling users to harness the power of Grafana for advanced reporting, dashboarding, and data visualization. The new features promise to simplify data management, making it easier for users to generate insights without incurring additional costs associated with add-on products.

Effortless Management of Call Logs

One of the standout features of this update is the ability to store call logs externally, freeing up resources within your 3CX phone system. Users can sync their entire Call Data History to a designated external source, facilitating easier export and management of data. The functionality also allows for quicker backup and restoration processes, enhancing the overall efficiency of call data handling.

To get started with this feature, users should refer to the setup guides for both Google BigQuery and AWS PostgreSQL. It’s essential to note that this update will only sync new call logs; legacy logs will not be transferred.

Creating Custom Reports with Grafana

Update 6 also introduces the ability to connect your 3CX system to external data sources like Google BigQuery or PostgreSQL. This integration allows users to create tailored reports and dashboards using Grafana without the need for costly add-ons. With built-in reports available on the Grafana dashboard, users can also create their own customized reports to fit their specific needs.

How to Get Started with 3CX Grafana Dashboards

Setting up the Grafana dashboards with your 3CX data is straightforward. Follow these steps to begin:

  1. Create a Free Grafana Cloud account or opt for a self-hosted solution.
  2. Consult the Grafana BigQuery setup guide for detailed instructions.
  3. In Grafana, navigate to the left sidebar and select Dashboards → New → Import.
  4. Download the 3CX Grafana Templates and unzip the files. You’ll find:
    • 3cxcalldashboard.json: This dashboard provides a high-level overview of total call activity, including answered and missed call breakdowns, as well as key call duration metrics.
    • Queuereport.json: This report offers detailed analytics on queue performance, showcasing answered rates, wait times, and agent engagement levels.
    • Ringgroupreport.json: This dashboard displays call metrics specific to ring groups, allowing teams to monitor call distribution and response effectiveness.
  5. Click to upload the JSON file and upload each dashboard individually.
  6. Once uploaded, Grafana will prompt you to Select a data source. Choose the pre-configured datasource grafana-bigquery-datasource.
  7. At the top of each dashboard, there will be a textbox labeled BigQuery Table Path. Input your BigQuery table path, formatted as: pbx-12345678.3cx_call_data.public_cdroutput.
  8. Click Save, and you’re ready to delve into your 3CX call data!

Additional Features in Update 6 BETA

This update comes with several additional enhancements aimed at improving user experience and functionality:

  • PKCE Support: This feature enhances security and is compatible with popular applications like Salesforce, Zendesk, Zoho, and Dynamics 365.
  • User Operation Rights Extended: Users now have the capability to view and modify another user’s call forwarding settings, streamlining operations.
  • Multi-Tenant Company Switch: This allows the 3CX system to operate as a single-tenant or multi-tenant solution, available for licenses with 16 or more simultaneous calls.

For a complete overview of all the changes and improvements, users can view the full change log here.

Testing the BETA Version

If you’re interested in trying out the BETA version, follow these simple steps:

  1. Log in to the Admin Console.
  2. Navigate to System > Updates.
  3. Select Update 6 BETA and click on Download.

Keep in mind that this version is intended for testing purposes only. It should not be installed on production systems as it may contain bugs or issues that require further refinement.

Stay Connected and Informed

Join our discussions in the dedicated Partner or Customer Forums. For the latest news and feature releases, follow us on X and LinkedIn.

By integrating Grafana with 3CX, businesses can now unlock unprecedented insights into their communication systems, transforming raw data into actionable intelligence for better decision-making. This update is a game changer for users seeking more control and flexibility in their reporting capabilities, enhancing productivity across the board.

Source Article:https://www.3cx.com/blog/releases/grafana-reporting/