Visualization
Add visualization
You can create various chart visualizations from the results of your query.
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.
Add to dashboard
Edit visualization
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.
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
Table
Display
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.
Changing the type of your table (Image/Link)
Image
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.
Title template: You can edit the text tooltip that appears when hovering over the image.
Size: You can specify the size of the image by providing its width and height.
Link
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.
Text template: Enter the text to be displayed on the link button.
Title template: Edit the text tooltip that appears when hovering over the link.
Conditional Formatting
You can create rules to highlight the cells based on their values.
Click ‘+’ button to add a rule.
Pie
Pie
Data: Choose the data that you want to show in your Pie chart
Display
Legend: Check whether you would like to show legend and whether you would like to show percent values together with the legend.
Center Value: Text formatting of the value that appears at the center of the chart.
Tooltip Value: Text formatting of the tooltip that appears when you hover your mouse on the chart
Colors: Set the individual color of each item
Serial
Serial
Data
Display
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.
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.
Axis options: You can set the label and formatting for each x/y axis.
Goal lines: You can add goal lines to charts to display important values as dotted lines.
Color bands: You can also add color bands to fill a range of important values with color.
Pivot Table
Pivot Table
Data
Display