Saved Queries can be used to make QQL widgets. Please note, only Public queries can be used for QQL widgets.
Table:
QQL widget allows you to leverage advanced query searches, and pin frequently used or preferred QQL searches to your dashboards to facilitate quicker and more comprehensive monitoring of testing activities.
Other data visualisations:
For queries that use aggregation and grouping functions, like the example below, you can choose to display the results in formats other than a table.
For instance, if you change the default table view to a bar chart and save the query, adding that same query to a dashboard will display it as a bar chart instead of a table.
For queries that track data over time, you can also display results as a line chart.
Line charts are useful for spotting trends, like how many test cases were created each week, or how your automation coverage has grown month by month.
You can group data by day or month, and optionally apply a breakdown to compare multiple categories on the same chart.
Customizing colors: Chart visualisations also support color customization per value, so your widgets are not just functional, but immediately readable at a glance on your dashboard.
What you can color depends on your query and how you've set up the visualisation.
For pie charts, each slice gets its own color from the preset palette, regardless of the query.
For bar charts, it depends on whether you've applied a breakdown. If you're working with a multi-field
GROUP BYquery, likeGROUP BY project, status, and apply a breakdown by one of those fields, each value in that breakdown gets its own color. Without a breakdown, you can only set a single color for the whole series.
For line charts, if you've applied a breakdown, each category gets its own color, making it easy to distinguish between multiple trend lines at a glance.
