Skip to main content
11. Visualization

How to use the wbe3 analytics tool

S
Written by Saehyun Yoo
Updated over a year ago

Visualization

  1. Add visualization

    1. You can create various chart visualizations from the results of your query.

    2. You can add a new chart visualization by clicking the "Add Visualization" button next to the Result table tab. A modal window will appear where you can choose from one of the options: table, pie, serial, number, or pivot table. The selected visualization will then be added.

  2. Add to dashboard

    1. You can add the chart to one of your dashboards by clicking the "Add to dashboard" button.

  3. Edit visualization

    1. You can edit the data and display format of each chart visualization. Clicking on "Edit visualization" at the top will bring up a modal window where you can make the necessary changes.

    2. Changing the title: When you add a chart visualization to your dashboard, it will display the title of the query by default. However, you can edit the title of an individual chart by clicking the edit button located at the top left of the modal window.

Display Types

Table

  1. Display

    1. You can change the display name of each column, set whether they are hidden, and apply various text formatting options. You can also change the order of the columns displayed by dragging and dropping them.

    2. Changing the type of your table (Image/Link)

      1. Image

        1. URL template: You can use the text from a column by putting the column name inside double curly braces {{}}. The symbol {{@}} represents the current column. You can also input the URL path for the image you want to use.

        2. Title template: You can edit the text tooltip that appears when hovering over the image.

        3. Size: You can specify the size of the image by providing its width and height.

      2. Link

        1. URL template: You can use column text by inserting the column name inside the double curly braces {{}}. {{@}} refers to the current column. Enter the URL path of the image you want to use.

        2. Text template: Enter the text to be displayed on the link button.

        3. Title template: Edit the text tooltip that appears when hovering over the link.

  2. Conditional Formatting

    1. You can create rules to highlight the cells based on their values.

    2. Click ‘+’ button to add a rule.

Pie

  1. Data: Choose the data that you want to show in your Pie chart

    1. Column / Row

      1. Toggle to choose whether you would like to select values horizontally or vertically from the table.

    2. X Axis: Select a column/row to be used as a dimension

    3. Y Axis: Select columns or a row to display the value

  2. Display

    1. Legend: Check whether you would like to show legend and whether you would like to show percent values together with the legend.

    2. Center Value: Text formatting of the value that appears at the center of the chart.

    3. Tooltip Value: Text formatting of the tooltip that appears when you hover your mouse on the chart

    4. Colors: Set the individual color of each item

Serial

  1. Data

    1. Set the x axis column and columns to show as y axis values. You add more metrics to draw at the same time. You can set group by column if there are categories that you would like to separate values and show each of them as a series.

  2. Display

    1. Series: You can specify the color and chart type (bar, line, stacked bar, stacked area). Additionally, you can choose whether to use the left or right y-axis for the series.

    2. Stack type: If there are stack type series, you can choose whether to display them as absolute values or as a percentage of the total.

    3. Axis options: You can set the label and formatting for each x/y axis.

    4. Goal lines: You can add goal lines to charts to display important values as dotted lines.

    5. Color bands: You can also add color bands to fill a range of important values with color.

Number

  1. Data: Choose a Column and Row number to decide which cell’s value you would like to display.

  2. Display: You can change the labels and text formatting shown below.

Pivot Table

  1. Data

    1. Table Rows: Choose the metrics that will become the dimensions of rows.

    2. Table Columns: Choose the metrics that will become the dimensions of columns.

    3. Values: Choose the metric that will be used as the value represented by the combination of Row x Column.

  2. Display

    1. Value Formatting: You can change the text formatting of the value cells

Did this answer your question?