You can add more charts to the board with similar configurations TablePlus supports line charts, bar charts, pie charts, and scoreboards. Let’s optimize the query for a better format by changing the DATE_TRUNC to the TO_CHAR function and turning off the chart grid for a cleaner look.You can ask TablePlus AI assistant to write a query to get the total number of new users, group by month, and then configure it like this. Click the metrics board icon on the toolbar to open the board designer.Ĭlick the button “add Widget” and add a bar chart (or you can right-mouse click Add > bar chart). Open TablePlus and establish a database connection.Create a live report with various types of charts.

In this tututorial we will learn how to design mini tools using TablePlus 1. INSERT INTO public.orders (id, product_id, user_id, created_at) VALUES INSERT INTO public.products (id, name, price, created_at) VALUES INSERT INTO ers (id, name, created_at) VALUES CREATE TABLE public.products (id int,name text,price int,created_at timestamp, PRIMARY KEY (id)) ĬREATE TABLE ers (id int,name text,created_at timestamp, PRIMARY KEY (id)) ĬREATE TABLE public.orders (id int,product_id int,user_id int,created_at timestamp, PRIMARY KEY (id))

Download TablePlus 5.6.0