TablePlus Documentation
  • Overview
  • Getting Started
  • GUI Tools
    • The Interface
      • Quick Look
      • Menu
      • Toolbar
      • Left sidebar
      • Right sidebar
      • Console Log
      • Query Editor
      • Multi Tabs / Workspaces / Windows
    • Open Anything
    • Code Review & Safemode
      • Code Preview
      • Commit changes
      • Discard changes
      • Safe mode
    • Connections & Command Line (CLI)
    • Database
    • Working with Table
      • Table Basics
      • Row
      • Column
      • Constraint
      • Index
      • Trigger
    • Filter
    • Database Objects
      • Function
      • Procedure
      • View
    • Import & Export
    • Backup & Restore
    • User Management
    • Metrics board
  • Query Editor
    • Editor Basics
    • Multiple Carets
    • Query Favorite & Keyword Binding
    • Query History
    • Streaming Results & Async Loading
    • Autocomplete
    • Split Panes
    • Split Results into Tabs
    • Working With Query Results
    • Format query (beautify/minify/uglify)
    • Query Parameters
    • Customize Query Editor
  • Preferences
    • General
      • Application
      • Table Data
      • SQL Editor
      • CSV File
      • Connections
    • Fonts & Colors
    • Crash & Security
    • Keymap
  • Utilities
    • Plugin
    • DBngin
    • Shortcut Keys
    • Licensing
    • Troubleshooting
Powered by GitBook
On this page
  • 0. Open the Metrics Board
  • 1. Create a simple bar/line chart
  • 2. Create a data table view
  • 3. Create an input field

Was this helpful?

  1. GUI Tools

Metrics board

Build a simple metrics report in less than 5 minutes.

PreviousUser ManagementNextEditor Basics

Last updated 2 years ago

Was this helpful?

0. Open the Metrics Board

Click the Metrics Board button on the toolbar to open the Metrics Board.

Metrics board settings:

1. Create a simple bar/line chart

You can add a bar chart or a line chart by click the + button on the toolbar or using your right mouse click.

  • Click the object to show the settings.

  • Enter the SQL Query, Ex: SELECT 2 as a;

  • Config the refresh rate: - After xx seconds: The chart will be reloaded after xx seconds. - Refresh on event: The chart will be reloaded on an event (which is sent from an input field). - Do not refresh: The chart will not be reloaded, you can reload it manually by click the refresh button at the bottom left.

2. Create a data table view

The data view config is similar to charts

3. Create an input field

Before creating an input field, you must create a chart or a table data view, which has query parameters and the refresh rate: Refresh on Event.

Create an input field

  • You must config the name of the variable.

  • You must create a connection to the object.

  • The object must have the refresh rate: Refresh on Event.

Open Metrics Board
metrics board settings
simple bar chart
data view with a query parameter
input field