Running Reports and Interpreting Results
11. Running Reports and Interpreting Results
11.1 How to Run a Report
Open the report in SQL Editor or click Run on a saved report.
If the report has parameters, fill in values in the Parameters panel.
Click Run in the toolbar.
Wait for results to populate in the Results Grid.
11.2 Results Grid Features
The Results Grid displays your query results in a table format. You can:
Resize columns by dragging the border between column headers.
Sort by clicking a column header (ascending/descending).
Format cells by selecting columns and choosing a format (currency, date, percentage) from the stacked-dots menu.
Export results to CSV or Excel.
11.3 Formatting Output Columns
Before publishing a report, format numeric and date columns for clarity:
Currency - for monetary amounts.
Percentage - for ratios and proportions.
Date - for temporal values (choose format: YYYY-MM-DD, MM/DD/YYYY, etc.).
Number - for integers, with optional decimal places.
11.4 Common Interpretation Patterns
Row count - confirms the grain of your report (one row per policy, claim, etc.).
Null values - suggests missing joins or optional data; if unexpected, review your WHERE and JOIN logic.
Duplicates - indicates row inflation from joins; add GROUP BY to consolidate.
Sum total - useful for sanity-checking aggregate reports against known baselines.