You can configure PopSQL to show results on the right (for rapid iteration), or on the bottom (for wide results). Look for the icons in the top right of the app.
In the results table, there's a lot you can do:
- Filter columns
- Sort columns
- Hide columns
- Conditionally format columns
- Expand a row to read it in a vertical format
- Highlight cells to copy/paste into a spreadsheet
When applying filter or conditional formatting to a column in a dashboard, this is persisted across reloads and users.
Here's a video demonstrating what you can do with the table:
Conditional formatting helps you draw attention to certain values in your table. For example, you could highlight late values with the color red. For each conditional formatting you apply, it is broken up into 1 or more rules to apply to the column. For each rule, you choose a color and 1 or more conditions that trigger the rule. For example, in the video below, we apply a formatter with three rules each with one condition to color based on the text value. To do a numerical range, you would create a rule with a less than condition and a greater than condition.
If you need more room to view your results, you can hit the
Explore button or press
Cmd+E to view your results full screen.
Export button to export your results to a file, or copy them to your clipboard. We support:
- TSV (tab separated values): great for copying/pasting into a spreadsheet
- CSV (comma separated values)
For more information about sharing your results, see Sharing a Link to Your Query and Results.
Updated 4 months ago