- Each conversation thread has its own board. You can save important query outputs - like charts and texts - by adding
them to the thread’s board.
View to expand vizies
To add an insight to a board:
The query insight opens in a separate window showing the query insight in detail.
Hold the pointer over a graph to view detailed values.
See more available vizy options in the Explore Vizy Options section.
Explore board options
Once the vizy is added to the board, users in the conversation can play with the data it displays.
- You can pin insights to a board as well as charts. These insights, displayed on a board, are called vizies.
You can change a vizy’s layout, use it in presentation mode, remove it from the board, or download it as a pdf.
Pin and play with Qbo boards
- Click More: Refresh all vizies ,to see board history, copy vizies to the board, or download the
board as PDF.
You can use board history to track changes to a board. It stores the latest 10 operations performed on the board, including:
All operations are stored with a timestamp.
If you want to restore an older version of a board, select the required version or timestamp from the board history.
In this example we are reverting a board to a state which was in its old state at 7:33 am:
Send a report
If your administrator has enabled Communication Services, you can send and schedule reports. You can create new reports, schedule periodic reports, and delete existing reports.
You can frame a report body, add a subject line, and select users who’ll receive the report.
To download a vizy file:
Go to the board and click on the horizontal ellipsis (3 dots) for the vizy you want to download.
Click Download > Vizy.
Lock-Unlock board feature
Limit the the functionality of all users in the channel of a board. To lock a board, click the horizontal ellipsis (3 dots) on the right of the board and click Lock board.
Once the board is locked, users in the channel will not be able to:
Add/Import new vizy to board
Change board layout
Change vizy types
Add/Edit board filters
Refresh vizy datas
Select a board state from board history
To unlock a board, click the horizontal ellipsis (3 dots) on the right of the board and click Unlock board.
Explore vizy options
You can refresh a vizy, view the vizy in fullscreen, change the chart type, and much more:
Change vizy type: Select the type of graph that you want for your visualization. Qbo intelligently selects the available graph types based on the number of variables in the output.
Refresh vizy data: Refresh a vizy.
Toggle fullscreen: Use this option to toggle between fullscreen and normal view.
Enable/Hide data labels: Display or hide data labels on data points for a vizy.
Show total: View totals in vizies to aid comparisons.
Change title: Edit the title and subtitle of a vizy.
Copy to Board: Copy the vizy to other threads.
Sort: Sort vizy output by the legends available in it. Enabled for chart types like Bar Chart, Doughnut Chart, Horizontal Bar Chart, Pie Chart, Polar Area Chart, and Stacked Bar Chart.
Download: Download a vizy as a CSV (comma-separated value) file, image, or PDF.
Nerd-out your data: See information about a vizy, including:
Vizy completion status: Displayed if the vizy has incomplete data.
Qbo query: Canonical query of the present response; either a base query or customized query.
SQL query: SQL generated by Qbo for the present response.
Metadata - QueryBot: Name of the bot.
Metadata - Executor: The configured data source.
Metadata - Entity: The entity from which the response was generated.
Metadata - Time zone: Established time zone for the product.
Metadata - Query tree: The base or original query before any customization.
Verify your results by displaying the ‘internal query’ to show the SQL generated by Qbo to retrieve the results that you see on your screen. You can run this query on the data source to retrieve the values for the visualization.
Delete Vizy: Permanently remove the vizy from the board.
You can customize your results by adding additional metrics, changing the grouping of the variables and adding filters. These attributes have been picked up from the underlying data during the configuration of Qbo.
Table Options: Only available on table charts; display or hide rows and columns in the table.
Drill down and compare from charts
You can refine the existing vizy output using drill downs. To drill down, right-click on the vizy and select an option.
For example, this vizy shows the spending analysis of different card networks:
To analyse AMEX card spending by age group of users, right-click the AMEX bar, click Drill down AMEX, and select an age group.
The compare icon will only be visible when the metric (aggregate) has been set up in the variance analysis configuration.
You can filter all vizies on a board using a board filter. Find available board filters in the listed at the top of the board.
You can enable or disable a board filter for a specific vizy.
To convert a vizy filter to a board filter, click the board icon next to it.
Edit and remove board filters
You can edit or remove board filters. When you update the value of a board filter, it affects all the vizies in the board that uses it.
Combine board filters
You can combine multiple board filters on the same attributes of different entities to form a single board filter on that attribute.
Hold the mouse pointer over a board filter. If attributes of different entities match, you’ll see a Combine Filters option.
You can separate combined board filters into separate entity level board filters.