Versions Compared

Old Version 3

changes.mady.by.user Borja Moro Moreno

Saved on

compared with

New Version Current

changes.mady.by.user Borja Moro Moreno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Expand
titleWatch video tutorial
Widget Connector
overlayyoutube
_templatecom/atlassian/confluence/extra/widgetconnector/templates/youtube.vm
width600px
urlhttp://youtube.com/watch?v=7Y8rQp3CRgc
height300px

...

Creating a Voronoi treemap

Here we describe how to create this chart using examples. Let's go step by step through the process with another example:

Rw ui steps macro
Rw step

Go to Data Search and open the required table.

Rw step

Perform the required operations to get the data you want to use in the chart.

Rw step

Click the gear icon on the toolbar and select Charts → Diagram → Voronoi treemap.

Rw step

Click and drag the column headers to the corresponding fields.

Image RemovedImage Added

Required field

Description

Data type

Signals

The variables to analyze, whose unique values will be represented as separate polygons in the diagram and thus will determine the number of polygons into which the diagram will be divided. You can add as many as you need to construct a hierarchy of subdivisions, which will be determined by the order of addition, the first corresponding to the top level and the last to the bottom level.

Any type but json or bigint

Value

The measuring variables whose values will be used to establish the proportions of each of the polygons. You can add more than one in order to have several measuring criteria but they cannot be used at the same time. You can switch between them inside the diagram but the first you add will be used by default.

float, integer, duration

Rw step

The Voronoi treemap is displayed. This is a visual depiction of the average response length of the connections to Devo in each city and with each response time over one day. 

Image RemovedImage Added

Customizing the Voronoi treemap

...

Expand
titleExample 1

Visualization of the average response length (avg_responseLength column) per city over the last day and comparison of three of the cities.

  • Press 

    Status
    titleG
     and select Knoxville and Alcorcon by pressing 
    Status
    titleCtrl
     + clicking the cells. Move the mouse over the Madrid cell to compare it to the other ones. 

The cells selected will appear at the lower part of the right panel while the cell over which you hover will appear at the top, showing in both cases their information and aggregated values. The one at the top will be compared to those at the bottom, showing their differences in red or green (fewer or worse).

  • Hit the 

    Status
    titleG
     key again when you finish to go back and remove the comparison panel to the right.

Image RemovedImage Added
Expand
titleExample 2

Visualization of the average response length (avg_responseLength column) per city over the last day, ordered by size and colored using a spectrum based on the average response length (avg_responseLength column).

  • Press 

    Status
    titleD
     to apply the Squarified Ordered visualization.

  • Press 

    Status
    titleN
     to calculate cell size using their weight.

  • Select avg_responseLength in the Color by field.

The spectrum of colors shows the average response length (maximum is red, minimum is green) and the cell size represents also the average response length (the larger they are, the longer the response). With this visualization, we establish a correlation between size and color, making it easier to spot potential problems by looking at big red cells.

Image RemovedImage Added

Query example

You can recreate the example explained above with the data from the following query and mapping the fields as follows:

Query

Required field

Column added

Code Block
from siem.logtrust.web.activity
group by city, responseTime
every -
select avg(responseLength) as avg_responseLength,
count() as count

Signals

city
responseTime

Value

avg_responseLength
count