Table Sparklines » Pulse Help

Nested Array data can be displayed as sparklines.

Example SQL Charts / Sparklines within Table

Sparklines can be configured either by:

Right-clicking on a data grid column and selecting the formatter.
On the right-hand side editor pane, click the formatter dropdown for the column you want and select the formatter there

The types of sparkline available are:

Line
Bar
Discrete
Bullet
Pie
Boxplot

The quickest way to see a live demo is to run the following code in the SQL editor:

Kdb Sparklines Example Code

select v,vl_sd_sparkline:v , vb_sd_sparkbar:v ,
        vd_sd_sparkdiscrete:v , vbl_sd_sparkbullet:v ,
  vpie_sd_sparkpie:v , vbox_sd_sparkboxplot:v  from 
  ([] a:1 2 3; v:(asc 9?1 2 3 1 9 8 7 3 -10 -28 7 3 -10 -2; 15?4 27 34 52 54 59  -4 -30 -45 52 54 59 61 68 78 82 85 87 91 93 100 ;6 6 6 6 6 -6 2 2 0))

H2 Database Sparklines Example SQL

/* DROP table foo; */
create table foo (
	id identity not null primary key,
	nums  array
); 

INSERT INTO FOO  (id, nums) VALUES (1, ARRAY [1,2,3,2,-5,-6,3,1,2,5]);
INSERT INTO FOO  (id, nums) VALUES (2, (4,5,6,8,9,14,18,25,10,0,-3));
SELECT ID,NUMS AS N_SD_SPARKLINE FROM FOO;