![]() ![]() Numbers: sum, count, avg, max, min, stdev, list, and values.Strings: list, values, first, last, count, and distinct_count (dc).The set of allowed functions depend on the data type of the fieldname: Here, label is the name of the cell in the report. Cell value Syntax: (fieldname) Description: Define the values of a cell and optionally rename it. They are followed by split rows and split columns, which can be interleaved, for example: avg(val), SPLITCOL foo, SPLITROW bar, SPLITCOL baz. ![]() Pivot elements include cell values, split rows, split columns, filters, limits, row and column formatting, and row sort options. pivot element Syntax: ()* (SPLITROW )* (SPLITCOL colvalue )* (FILTER )* (LIMIT )* (ROWSUMMARY )* (COLSUMMARY )* (SHOWOTHER )* (NUMCOLS )* (rowsort )* Description: Use pivot elements to define your pivot table or chart. objectname Syntax: Description: The name of a data model object to search. Required arguments datamodel-name Syntax: Description: The name of the data model to search. This requires a large number of inputs: the data model, the data model object, and pivot elements. Run pivot searches against a particular data model object. Also, read how to open non-transforming searches in Pivot. The pivot command does not add new behavior, but it might be easier to use if you are already familiar with how Pivot works. Fundamentally this command is a wrapper around the stats and xyseries commands. The pivot command makes simple pivot operations fairly straightforward, but can be pretty complex for more sophisticated pivot operations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |