Custom SQL

Custom SQL Query is useful for retrieving data from VDV's MySQL data base by issuing standard SQL queries.  In order to simplify this process the Custom SQL Query includes a wizard for building the SQL query.   In the wizard you can Select Variables from specific Sites and use the Where input field to select data within specific range.  It is also possible to create Mathematical Function on each Variable.

The results can be viewed as Graph or Table, Saved to a file and view Statistics to see the Average, Max, Min, Sum and Standard Deviation for each variable.