7.3 Statistics

LinLogBook owns a simple interface to define statistics. It uses the sql table statistics which has the following definition:
create table statistics (MenuText UNIQUE NOT NULL,sql NOT NULL);
The first column contains the name of entry in the Statistics menu. The second entry contains the corresponding sql statement to calculate the desired statistic.
You find two examples in the file Statistics.sql. The first example counts the number of confirmed and unconfirmed qsos for each worked band and mode whilst the second example counts the worked and confirmed qsos for each country. This example requires the cty.dat file to be imported.


You implement this statistics by running Update Base Tables from the Edit menu. Select the file Statistics.sql for this update.After restarting LinLogBook the statistics are available.
You can implement your own statistics by updating the statistics table. Have a look at the Statistics.sql file for some explanations.