![]() ![]() Use it to specify the label for false values.ĭescriptions for column split-by elements SPLITCOL colvalue Syntax: fieldname Description: You can have none, some, or all of these options on each SPLITCOL. Use it to specify the label for true values. Use it to specify the period to bucket by. You do not need to specify all of the options (start, end, max, and size). Other options depend on the data type of the specified: You can rename the using "AS ", where "label" is the name of the row in the report. Timestamps: duration, earliest, latest, list, and valuesĭescriptions for row split-by elements SPLITROW Syntax: SPLITROW Description: You can specify one or more of these options on each SPLITROW.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 |