QuerySurge Data Health Widgets give you a real-time view into your progress at all levels, from QueryPair development to execution and results. Data Health Widgets appear on the Data Health Dashboard after login to QuerySurge. The Widgets are configurable, so you can see the slice of your project that you want to see, in the way you want to see it.
in this article
Key Widget Metrics
- Data Verification – A single data verification is the comparison of a “cell” in a Source results to the analogous “cell” in the Target results. The Data Verification count for a Scenario is the count of all Source - Target "cell" pairs that have been compared, for all QueryPairs in the Scenario.
- Pass Rate – The number of QueryPairs in a Scenario execution that Pass compared to the total number of QueryPairs in the Scenario. QueryPair execution may result in Pass, Fail, Warning, Killed or Error statuses.
- Data Reliability – The number of failing data comparisons relative to the total count of data verifications.
There are many types of Widgets available for you to track project progress:
- QuerySurge Launcher Widget
- Quick links to QuerySurge Views
- Scenario Outcome / Pass Rate Widget
- The Pass/Fail Outcome of your recent Scenario Runs in passing/failing QueryPairs (bar graph) along with the Pass Rate per Scenario metric (blue curve). Note that the vertical axis for the bar graph is on the left, while the vertical axis for the blue curve is on the right.
- Scenario Outcome / Data Reliability Widget
- The Pass/Fail Outcome of your recent Scenario Runs by Pass/Fail Rate (bar graph) along with the Data Reliability per Scenario metric (blue curve). Note that the vertical axis for the bar graph is on the left, while the vertical axis for the blue curve is on the right.
- Suite Outcome Over Time / Pass Rate Widget
- The Pass/Fail Outcome by Suite over time, using the Pass Rate as the outcome metric.
- Suite Outcome Over Time / Data Reliability Widget
- The Pass/Fail Outcome by Suite over time, using the Data Reliability as the outcome metric.
- Design Time Run Outcomes By Folder Widget
- A pie-chart view of Design-Time Run outcomes, using QueryPair Outcome as the outcome metric.
- QueryPairs Created Over Time By Folder Widget
- A line graph of the count of QueryPairs created over time, by Design View folder.
- QueryPairs Created Over Time By User Widget
- A line graph of the count of QueryPairs created over time, by QuerySurge User.
- Last Run Scenario Summary Widget
- A summary of the latest Scenario executed in QuerySurge.
You can configure your Widgets in a number of different ways, so that your Widgets provide the information you want about the slice of your project that you're interested in.
- Widget Titles
- You can change your Widget title simply by single-clicking on the title bar to edit the title. When you are done, hit the enter key to finish editing the title.
- Widget View
- You can "turn off/on" specific data in a Widget simply by clicking on its legend. In this example the "Pass Rate" is turned off. You can turn it on by clicking on the greyed-out legend.
- Widget Zoom
- You can zoom in on many Widgets. If you want to zoom in, just click and drag on the portion of the Widget that you want to zoom in on. That area will highlight. Then, release the mouse and the Widget will zoom. A Reset Zoom button will appear, which you can use to zoom out.
- Widget Data Selection
- You can "point" many of the Widgets at specific data (by default, Widgets will report on all of your data). In order to "focus" in on specific data, at the upper right of the Widget, on the Widget toolbar, click on the View Settings icon. The Widget will flip, showing its Settings options. In this example, we are limiting the Widget to Scenarios that have "Customers" in the Scenario Name. The Widgets use a fuzzy match to find your data. Once you've entered your Value, press the Save button to flip back to your Widget.
Using Widget Panels
You can have multiple Panels of Widgets in the Data Health Dashboard. Each Panel shows 4 Widgets by default (and you can maximize any individual Widget). You can add Panels to the Dashboard as well. To add a Panel, use the Add Panel button at the lower left.
The new Panel will be empty. Use the Add Widget button (at the lower left, again) to open the Available Widgets slider.
Drag and drop new Widgets and configure them to fit your needs (see the previous topics for information about configuring Widgets.) Once you've created multiple Widget Panels, use the Previous and Next buttons (lower right) to move between the Panels.