Confluence User •

23 May, 2016 •

confluenceUser •

•

confluenceUser •

Hi Daniel

One option is to use your own SQL in Datalist>Source>Select Binder>Configure JDBC Datalist Binder.

Example using MySQL below:

 

SELECT id, firstName, lastName, email FROM dir_user
UNION
SELECT "","","", CONCAT("Total Users = ",COUNT(*)) FROM dir_user

The last line of the datalist will show the total in the last column. You can replace COUNT() with SUM() or AVG() etc.

1

CSV | Excel | XML | PDF