Charts: Difference between revisions

From VoIPmonitor.org
(Add common issue section explaining why flow diagrams and pie charts show different SIP response percentages - covers different time intervals and in-progress call latency)
(Rewrite: konsolidace struktury, odstranění duplicit, přidání tabulek pro přehlednost)
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
= Charts =
= Charts =


Charts are used to plot various data sources like number of concurrent calls or quality of calls over time. Data sources can be combined to one chart allowing the viewer to see the correlation of desired data sources like SIP 4XX/5XX responses on ASR. The graph itself is interactive – clicking on a particular legend hides the datasource. Hovering on a datasource highlights it and shows the local value.
Charts visualize call data (concurrent calls, quality metrics, SIP responses) over time. The graph is interactive – click legend items to hide/show data sources, hover to see values.


Charts also appear in the CDR view's right panel, automatically filtering based on the current CDR selection.


Charts are also present in the CDR window in the right mini-window sharing the same functionality with only difference that in CDR section the graph takes data from the current filter.
<kroki lang="mermaid">
%%{init: {'flowchart': {'nodeSpacing': 15, 'rankSpacing': 30}}}%%
flowchart LR
    A[Click + button] --> B[Configure Date Range]
    B --> C[Add Series<br/>Data Sources]
    C --> D[Apply Filters<br/>Common/RTP]
    D --> E[Set Description<br/>& Save Template]
    E --> F[View Interactive<br/>Chart]
</kroki>


== Add chart ==
== Creating a Chart ==
 
To create new graph click on the + button.
 
[[File:charts-add.png]]
 
== Chart configuration ==
Chart configuration contains three tabs at the top – base chart data, filters – common and filters – rtp. The filters tab is used to filter data sources by various criteria – for detailed description please refer to CDR chapter.
[[File:charts-threetabs.png]]
 
The chart configuration panel is divided to three sections. Date range, series and description.
 
 
[[File:charts-form.png]]


# Click the '''+''' button in the Charts panel
# Configure the '''Date range''' (time interval and X-axis density)
# Add '''Series''' (data sources to plot)
# Apply '''Filters''' (Common/RTP tabs – same as CDR filter)
# Set '''Description''' to name and save the chart as a template


=== Templates ===
=== Templates ===


Templates store chart configurations for reuse. To save a new template, enter a name in the Description field – a "Save" button appears next to the template dropdown.


[[File:charts-templatecombo.png]]
=== Date Range ===


{| class="wikitable"
! Setting !! Description
|-
| Time interval || Start/end date for the chart
|-
| X-axis density || Granularity of data points (minute, hour, day)
|}


template field contains predefined chart configurations and custom templates which you can create / modify. To create new template - write name of it to description title field which shows save template button next to templates combo box.
== Series (Data Sources) ==


The Series section defines what data to plot. Add multiple series to compare metrics.


=== Available Series Types ===


=== Date range ===
{| class="wikitable"
! Series Type !! Description
|-
| '''Number of calls''' || Min/max/avg concurrent calls, total call distribution
|-
| '''MOS / jitter / delay / packet loss''' || RTP quality metrics
|-
| '''RTCP''' || RTCP protocol statistics
|-
| '''ACD, ASR, PDD, SIP responses''' || Signaling metrics
|-
| '''Codecs''' || Codec usage distribution
|-
| '''CallPerSec''' || Calls Per Second (CPS) rate
|}


[[File:charts-daterange.png]]
{{Note|1='''ACD Average''' = mean duration of calls ''started'' in the interval. '''ACD Immediate''' = mean duration of calls ''ongoing'' in the interval (shows higher values for short intervals).}}


* Time interval
=== Series Configuration ===
[[File:charts-timeinterval.png]]
* Time axes is density on the X axis.


[[File:charts-density.png]]
{| class="wikitable"
! Column !! Description
|-
| '''Param''' || SIP response code (for SIP response series)
|-
| '''Axis Side''' || Assign to Left or Right Y-axis
|-
| '''Primary''' || Sets the Y-axis scale; non-primary series use this scale
|-
| '''Type''' || Line, bar, area chart type
|-
| '''Line''' || Line decoration style
|-
| '''Color''' || Series color
|-
| '''Fill''' || Fill area below line
|-
| '''Markers''' || Show data point dots
|-
| '''Smooth''' || Smooth lines between points
|}


== Filters ==


=== series ===
The '''Filters - common''' and '''Filters - RTP''' tabs filter chart data using the same criteria as the CDR filter form. The date range is set separately in the main configuration section.


Series section contains data sources for the charts.
For filter details, see [[Call_Detail_Record_-_CDR#Filtering]].


[[File:charts-seriessection.png]]
== Filtering by Provider (IP Groups) ==


==== series column ====
Use IP groups to filter charts by specific providers without manual IP configuration.


Series column chooses which data source will be plotted.
=== Setup ===


*number of calls shows min/max/avg simultaneous calls distribution and total calls distribution [[File:charts-templatenumberofcalls.png|thumbnail]]*MOS / jitter / delay / packet loss shows RTP statistics *RTCP shows RTCP protocol values*ACD, ASR, PDD, SIP responses shows signalization related values*codecs shows codec distribution*CallPerSec shows Calls Per Second (CPS) rate over time - use the CallPerSec template for quick CPS visualization
# '''Create IP Group:''' GUI → Groups → IPs → New group → Enter provider IPs/CIDRs
# '''Create Chart:''' Click + → Select series type (e.g., "MOS / jitter / delay / packet loss")
# '''Apply Filter:''' Filters - common tab → Group Filters → Select your IP group from "Caller Groups" or "Called Groups"


* ACD average shows averaged call duration for all calls which started in the given interval.
{{Tip|To compare multiple providers: add separate series for each, apply different IP group filters, and use the settings icon to name each series for the legend.}}


* ACD immediate shows averaged call duration for all calls which are ongoing in the given interval. Thus this chart will show higher ACD for short intervals.
== License Usage Per Sensor ==


[[File:charts-seriescolumn.png]]
To track license utilization for specific sensors:


==== param ====
# Navigate to '''GUI → CDR'''
# Filter by '''id_sensor''' for your target sensor
# Open '''Charts''' panel → Click '''+'''
# Select '''Number of license calls''' template


Param column specifies SIP response code
{{Note|1=Total license usage may be lower than sum of individual sensors due to CDR deduplication (matching last 6 digits of caller/called within ±10s window).}}


[[File:charts-paramcolumn.png]]
'''487 Request Terminated''' calls are excluded from concurrent call counts.


== Custom SIP Header Analysis ==


==== axis side ====
To visualize traffic by custom headers (e.g., <code>x-route</code> for carrier routing):


=== Prerequisites ===


Axis side is used to assign data source to the left Y axis or to the right Y axis.
<syntaxhighlight lang="ini">
# /etc/voipmonitor.conf
custom_headers = x-route
</syntaxhighlight>


Enable in GUI: Settings → CDR Custom Headers → Check "Show as Column"


[[File:charts-axissidecolumn.png]]
=== Method: Compare Specific Route vs All Traffic ===


==== primary ====
# Create chart with '''two series''' (both "number of calls")
# '''Series 1:''' Filter <code>x-route = %</code> (all traffic with header)
# '''Series 2:''' Filter <code>x-route = ATT</code> (specific route)


Primary checkbox is used in case where more datasources are drawn on left or right Y. The primary checked datasource fills the whole Y axe and non-primary datasources use that scale. Here is example:
The gap between lines shows relative contribution (visual comparison, not calculated percentage).


[[File:charts-primarycolumn.png]]
{{Note|For exact percentages, use direct SQL queries on the database.}}


==== type ====
== Troubleshooting ==


Type of graph
=== SIP Response Colors Change ===


[[File:charts-typeofgraphs.png]]
Colors are '''not fixed''' – the dominant (most frequent) response code gets green, others rotate. This is a known limitation (VG-3031 feature request).


==== Line ====
=== Flow Diagrams vs Pie Charts Show Different Percentages ===


Decoration for line type chart
'''Cause 1:''' Different time ranges configured. Verify both use identical intervals.


[[File:charts-linetype.png]]
'''Cause 2:''' Near current time, flow diagrams show lower 200 OK because:
* In-progress calls haven't completed signaling
* Database write latency excludes recent calls


==== Color ====
'''Solution:''' Use time periods at least several minutes old for consistent comparison.


Color of chart
=== Tools Concurrent Calls Stats vs Charts Differ ===


[[File:charts-colorcolumn.png]]
{| class="wikitable"
! Source !! Counting Method
|-
| '''Tools → Concurrent Calls Stats''' || Counts every CDR leg separately (for license compliance)
|-
| '''Standard "concurrent calls" chart''' || Counts every CDR leg separately (matches alerts)
|-
| '''"concurrent calls - license chart"''' || Merges correlated legs into end-to-end calls
|}


==== Fill / Markers / Smooth ====
To match alert behavior, use standard "concurrent calls" chart (not license chart) with same filters.


*Fill fills area below the line type chart
=== Making Charts Match License Count for Specific Segments ===
*Markers plot dots at line
*Smooth draw smoothes line instead of straight lines between points


[[File:charts-fillmarkerssmooth.png]]
Apply IP filters to count only specific traffic:


=== Description ===
* '''Carrier IP filter:''' Counts calls between your system and that carrier only
* '''Customer IP filter:''' Counts calls between customers and your PBX only
* '''No filter:''' Counts ALL captured traffic (determines actual license usage)


Description names graph, axis and sets legend position (top/left/right/bottom or no legend).
=== Alerts Fire Once During Sustained Spike ===


[[File:charts-description.png]]
Alerts use '''edge triggering''' – they fire when crossing the threshold, then remain triggered. A new notification requires the metric to drop below threshold and cross again.


Setting your own title will allow to save a created graph for repetitive use. Once the title is filled or changed, the save button will appear next to type chart.
=== Chart Timeouts for Multi-Day Ranges ===


[[File:charts-savetemplate.png]]
'''Primary solution:''' Increase MySQL buffer:


== Filters - common ==
<syntaxhighlight lang="ini">
[mysqld]
innodb_buffer_pool_size = 16G  # 70-80% of available RAM
</syntaxhighlight>


Filters CDR data in the same way as CDR filter formular except date range which is in the first base chart data section.
'''Workarounds:'''
* Generate charts during off-peak hours
* Use [[Reports#Daily_Charts_Report|Daily Charts Report]] to schedule automatic generation


[[File:charts-filters-common.png]]
For detailed tuning, see [[Scaling]].


== Filters - RTP ==
=== Filter Works in CDR List but Not in Chart ===


Filters CDR data in the same way as CDR filter formular
Check for:
* Special characters in filter values (parentheses, quotes)
* Wildcard (<code>%</code>) behavior differences
* Different time ranges between CDR list and chart
* CDR Summary table issues (test with <code>disable_cdr_summary = yes</code>)


[[File:charts-filters-rtp.png]]
=== Cannot Aggregate Time-of-Day Across Days ===


== Common Issues ==
Charts show continuous time-series (Mon 9AM, Mon 10AM, Tue 9AM...). They '''cannot''' aggregate similar time slots across days (e.g., "total 9-10AM calls for the week").


=== Why do flow diagrams and pie charts show different SIP response percentages? ===
For time-of-day pattern analysis, use direct SQL queries or third-party reporting tools.


Flow diagrams (time-series charts in the Charts module) and pie charts (CDR dashboard sections) may show different percentages for the same SIP response codes even when they appear to cover the same time period. This typically has two causes:
== See Also ==


==== Different Time Intervals ====
* [[Reports]] – Scheduled reports including Daily Charts
* [[Groups]] – IP and telephone number groups for filtering
* [[Alerts]] – Threshold-based alerting system
* [[Scaling]] – Database performance tuning


The most common cause is that the charts are actually configured for slightly different time ranges.
== AI Summary for RAG ==
 
*'''Resolution:''' Ensure both the pie chart (CDR Dashboard) and the flow diagram (Charts module) are configured with exactly the same time interval. Check the time filters in both views carefully - the Dashboard pie chart uses the CDR view's time range, while Charts has its own independent "Date range" settings.
 
==== Flow Diagrams Near Current Time Show Lower 200 OK ====
 
For time periods very close to the current time, flow diagrams will naturally show a lower percentage of 200 OK responses compared to pie charts, even with identical time intervals.


This occurs because of how VoIPmonitor captures and records calls:
'''Summary:''' Charts in VoIPmonitor visualize call data over time with interactive graphs. Create by clicking + and configuring date range, series (number of calls, MOS/jitter/delay/packet loss, RTCP, ACD/ASR/PDD, codecs, CallPerSec), and filters. Templates save configurations for reuse. For license usage per sensor: CDR filter by id_sensor → Charts → "Number of license calls" template. Total license may be lower than sum of sensors due to CDR deduplication (last 6 digits matching). Use IP groups (GUI → Groups → IPs) to filter by provider. Three concurrent calls counting methods: Tools/standard chart count CDR legs separately; "license chart" merges legs. Common issues: SIP response colors rotate (no fix, VG-3031), flow vs pie charts differ near current time (use older periods), chart timeouts (increase innodb_buffer_pool_size), cannot aggregate time-of-day across days (use SQL).
 
*'''Calls in progress:''' Calls that are still active when you query the data have not yet completed their SIP signaling and cannot be classified with a final response code. They are excluded from flow diagram calculations.
*'''Database latency:''' Even after calls complete, there is a delay before they are processed, saved to the database, and become available for chart queries. This negative caching period means that very recent calls may not be included in flow diagrams yet.
*'''Result:''' The flow diagram shows the percentage of completed/categorized calls, which skews toward lower success rates for periods close to "now" because many 200 OK calls are still in progress or not yet written to the database.
 
*'''Resolution:''' For accurate, consistent comparisons between flow diagrams and pie charts, use a time period that is at least several minutes old (older than your typical call duration plus database write latency). Historical time periods will show consistent percentages across both chart types.
 
== AI Summary for RAG ==


'''Summary:''' Charts in VoIPmonitor visualize call data over time with interactive graphs. Create charts by clicking + and configuring date range, series (data sources), and description. Available data sources include number of calls, MOS/jitter/delay/packet loss, RTCP values, ACD/ASR/PDD/SIP responses, codecs, and CallPerSec for calls per second metrics. Templates provide quick chart configurations. Filters (common and RTP) can be applied to CDR data same as CDR filter forms. Common issue: Flow diagrams (time-series charts) and pie charts (CDR dashboard) may show different SIP response percentages due to different time intervals or because flow diagrams near current time show lower 200 OK percentages - calls in progress are not yet categorized and there is database latency before calls are available for chart queries. For accurate comparisons, ensure both charts use exactly the same time interval and use historical periods (several minutes old) to avoid in-progress call effects.
'''Keywords:''' charts, graphs, visualization, number of calls, CallPerSec, CPS, MOS, jitter, delay, packet loss, RTCP, ACD, ASR, PDD, codecs, templates, filters, IP groups, provider filtering, license usage, id_sensor, concurrent calls, license chart, CDR leg, color rotation, chart timeout, innodb_buffer_pool_size, custom SIP header, x-route, wildcard filter


'''Keywords:''' charts, graphs, visualization, number of calls, CallPerSec, CPS, calls per second, MOS, jitter, delay, packet loss, RTCP, ACD, ASR, PDD, codecs, templates, filters, time interval, flow diagram, pie chart, SIP response percentage, different percentages, in-progress calls, database latency, negative cache, CDR dashboard
'''Key Questions:'''
'''Key Questions:'''
* How to create charts in VoIPmonitor GUI?
* How to create charts in VoIPmonitor GUI?
* How to view Calls Per Second (CPS) in a graph?
* How to view Calls Per Second (CPS) in a graph?
* What metrics can I visualize in VoIPmonitor charts?
* How to monitor MOS, jitter, delay, and packet loss over time?
* How to monitor MOS, jitter, delay, and packet loss over time?
* How to use CallPerSec template for CPS visualization?
* How to identify license usage per instance/sensor?
* How to use IP groups to filter charts by provider?
* Why do SIP response code colors change in charts?
* Why do flow diagrams and pie charts show different SIP response percentages?
* Why do flow diagrams and pie charts show different SIP response percentages?
* Why does the flow diagram show lower 200 OK percentage than pie chart for recent time periods?
* Why do concurrent calls in Tools differ from Concurrent Calls chart?
* What is the difference between "concurrent calls" and "concurrent calls - license chart"?
* Why do charts timeout for date ranges longer than a day?
* How to create percentage comparison for custom SIP headers?

Latest revision as of 16:50, 8 January 2026

Charts

Charts visualize call data (concurrent calls, quality metrics, SIP responses) over time. The graph is interactive – click legend items to hide/show data sources, hover to see values.

Charts also appear in the CDR view's right panel, automatically filtering based on the current CDR selection.

Creating a Chart

  1. Click the + button in the Charts panel
  2. Configure the Date range (time interval and X-axis density)
  3. Add Series (data sources to plot)
  4. Apply Filters (Common/RTP tabs – same as CDR filter)
  5. Set Description to name and save the chart as a template

Templates

Templates store chart configurations for reuse. To save a new template, enter a name in the Description field – a "Save" button appears next to the template dropdown.

Date Range

Setting Description
Time interval Start/end date for the chart
X-axis density Granularity of data points (minute, hour, day)

Series (Data Sources)

The Series section defines what data to plot. Add multiple series to compare metrics.

Available Series Types

Series Type Description
Number of calls Min/max/avg concurrent calls, total call distribution
MOS / jitter / delay / packet loss RTP quality metrics
RTCP RTCP protocol statistics
ACD, ASR, PDD, SIP responses Signaling metrics
Codecs Codec usage distribution
CallPerSec Calls Per Second (CPS) rate

ℹ️ Note: ACD Average = mean duration of calls started in the interval. ACD Immediate = mean duration of calls ongoing in the interval (shows higher values for short intervals).

Series Configuration

Column Description
Param SIP response code (for SIP response series)
Axis Side Assign to Left or Right Y-axis
Primary Sets the Y-axis scale; non-primary series use this scale
Type Line, bar, area chart type
Line Line decoration style
Color Series color
Fill Fill area below line
Markers Show data point dots
Smooth Smooth lines between points

Filters

The Filters - common and Filters - RTP tabs filter chart data using the same criteria as the CDR filter form. The date range is set separately in the main configuration section.

For filter details, see Call_Detail_Record_-_CDR#Filtering.

Filtering by Provider (IP Groups)

Use IP groups to filter charts by specific providers without manual IP configuration.

Setup

  1. Create IP Group: GUI → Groups → IPs → New group → Enter provider IPs/CIDRs
  2. Create Chart: Click + → Select series type (e.g., "MOS / jitter / delay / packet loss")
  3. Apply Filter: Filters - common tab → Group Filters → Select your IP group from "Caller Groups" or "Called Groups"

💡 Tip: To compare multiple providers: add separate series for each, apply different IP group filters, and use the settings icon to name each series for the legend.

License Usage Per Sensor

To track license utilization for specific sensors:

  1. Navigate to GUI → CDR
  2. Filter by id_sensor for your target sensor
  3. Open Charts panel → Click +
  4. Select Number of license calls template

ℹ️ Note: Total license usage may be lower than sum of individual sensors due to CDR deduplication (matching last 6 digits of caller/called within ±10s window).

487 Request Terminated calls are excluded from concurrent call counts.

Custom SIP Header Analysis

To visualize traffic by custom headers (e.g., x-route for carrier routing):

Prerequisites

# /etc/voipmonitor.conf
custom_headers = x-route

Enable in GUI: Settings → CDR Custom Headers → Check "Show as Column"

Method: Compare Specific Route vs All Traffic

  1. Create chart with two series (both "number of calls")
  2. Series 1: Filter x-route = % (all traffic with header)
  3. Series 2: Filter x-route = ATT (specific route)

The gap between lines shows relative contribution (visual comparison, not calculated percentage).

ℹ️ Note: For exact percentages, use direct SQL queries on the database.

Troubleshooting

SIP Response Colors Change

Colors are not fixed – the dominant (most frequent) response code gets green, others rotate. This is a known limitation (VG-3031 feature request).

Flow Diagrams vs Pie Charts Show Different Percentages

Cause 1: Different time ranges configured. Verify both use identical intervals.

Cause 2: Near current time, flow diagrams show lower 200 OK because:

  • In-progress calls haven't completed signaling
  • Database write latency excludes recent calls

Solution: Use time periods at least several minutes old for consistent comparison.

Tools Concurrent Calls Stats vs Charts Differ

Source Counting Method
Tools → Concurrent Calls Stats Counts every CDR leg separately (for license compliance)
Standard "concurrent calls" chart Counts every CDR leg separately (matches alerts)
"concurrent calls - license chart" Merges correlated legs into end-to-end calls

To match alert behavior, use standard "concurrent calls" chart (not license chart) with same filters.

Making Charts Match License Count for Specific Segments

Apply IP filters to count only specific traffic:

  • Carrier IP filter: Counts calls between your system and that carrier only
  • Customer IP filter: Counts calls between customers and your PBX only
  • No filter: Counts ALL captured traffic (determines actual license usage)

Alerts Fire Once During Sustained Spike

Alerts use edge triggering – they fire when crossing the threshold, then remain triggered. A new notification requires the metric to drop below threshold and cross again.

Chart Timeouts for Multi-Day Ranges

Primary solution: Increase MySQL buffer: 

[mysqld]
innodb_buffer_pool_size = 16G  # 70-80% of available RAM

Workarounds:

For detailed tuning, see Scaling.

Filter Works in CDR List but Not in Chart

Check for:

  • Special characters in filter values (parentheses, quotes)
  • Wildcard (%) behavior differences
  • Different time ranges between CDR list and chart
  • CDR Summary table issues (test with disable_cdr_summary = yes)

Cannot Aggregate Time-of-Day Across Days

Charts show continuous time-series (Mon 9AM, Mon 10AM, Tue 9AM...). They cannot aggregate similar time slots across days (e.g., "total 9-10AM calls for the week").

For time-of-day pattern analysis, use direct SQL queries or third-party reporting tools.

See Also

  • Reports – Scheduled reports including Daily Charts
  • Groups – IP and telephone number groups for filtering
  • Alerts – Threshold-based alerting system
  • Scaling – Database performance tuning

AI Summary for RAG

Summary: Charts in VoIPmonitor visualize call data over time with interactive graphs. Create by clicking + and configuring date range, series (number of calls, MOS/jitter/delay/packet loss, RTCP, ACD/ASR/PDD, codecs, CallPerSec), and filters. Templates save configurations for reuse. For license usage per sensor: CDR filter by id_sensor → Charts → "Number of license calls" template. Total license may be lower than sum of sensors due to CDR deduplication (last 6 digits matching). Use IP groups (GUI → Groups → IPs) to filter by provider. Three concurrent calls counting methods: Tools/standard chart count CDR legs separately; "license chart" merges legs. Common issues: SIP response colors rotate (no fix, VG-3031), flow vs pie charts differ near current time (use older periods), chart timeouts (increase innodb_buffer_pool_size), cannot aggregate time-of-day across days (use SQL).

Keywords: charts, graphs, visualization, number of calls, CallPerSec, CPS, MOS, jitter, delay, packet loss, RTCP, ACD, ASR, PDD, codecs, templates, filters, IP groups, provider filtering, license usage, id_sensor, concurrent calls, license chart, CDR leg, color rotation, chart timeout, innodb_buffer_pool_size, custom SIP header, x-route, wildcard filter

Key Questions:

  • How to create charts in VoIPmonitor GUI?
  • How to view Calls Per Second (CPS) in a graph?
  • How to monitor MOS, jitter, delay, and packet loss over time?
  • How to identify license usage per instance/sensor?
  • How to use IP groups to filter charts by provider?
  • Why do SIP response code colors change in charts?
  • Why do flow diagrams and pie charts show different SIP response percentages?
  • Why do concurrent calls in Tools differ from Concurrent Calls chart?
  • What is the difference between "concurrent calls" and "concurrent calls - license chart"?
  • Why do charts timeout for date ranges longer than a day?
  • How to create percentage comparison for custom SIP headers?
Retrieved from "https://www.voipmonitor.org/doc/index.php?title=Charts&oldid=10195"