Add new functions to the query language to help locate and summarize columns in a table.
The SummarizeColumns function will sum all numeric columns whose column name matches a specified regular expression pattern. For example:
summarizeColumns('feature\\.Yield\\..*')
will sum the values in all columns that start with 'feature'Yield.'. Any non-numeric columns that match the expression will be ignored.
The NonZeroColumn function will scan all numeric column whose names match a specified regular expression pattern, and return the name of the first column with a non-zero value. For example:
nonZeroColumn('feature\\.Seral\\.(Mature|Old)\\.D')
See the UserGuide for more information about these functions.
There is a new SummaryTable class that can be used to generate simple univariate statistics within a standard table interface. The resulting table may be displayed, saved, joined to another table or formatted using a standard report template. See the API documentation for the SummaryTable class for more information.
Minor changes and fixes:
Dont put a period slider on tables that dont have a time dimension.
Improve the error message for empty expressions.
Add a fix to deal with apparently invalid spatial indexes.
The legend on the MapReport is now drawn with an opaque white background. This makes the legend easier to read when it is located on overlapping features.
The initial strata the was shown in the error traceback in the MatrixBuilder was incorrect. The wrong initial strata was being repeated in every error message.