getMeasures(): Array
[starting from version: 1.4]
Returns a list of the selected measures in the report. Note that getMeasures has an async equivalent – getMeasuresAsync.
Array of objects. Each object in the array contains the following parameters:
name – String. The measure’s name.uniqueName – String. The measure’s unique name.aggregation – String. The name of the aggregation applied to the measure. If the measure is calculated, aggregation is set to "none". availableAggregations – Array of strings. Represents the list of aggregation functions that can be applied to the current measure. If the measure is calculated, availableAggregations is set to []. availableAggregationsCaptions – Array of strings. Represents the list of available aggregations’ captions. If the measure is calculated, availableAggregationsCaptions is set to [].caption – String. The measure’s caption.format – String. The name of the number formatting that will be applied to the measure. formula (optional) – String. It represents the formula. For calculated measures. grandTotalCaption– String. The measure’s grand total caption.groupName (optional) – String. The measure’s group defined in SSAS. Only for the "microsoft analysis services" data source type.type – String. The measure’s type. It is returned for "json", "csv", and "elasticsearch" data source types:"json" and "csv", the type can be the following: "string", "number", "date", "date string", "year/month/day", "year/quarter/month/day", "datetime", "time"."elasticsearch", the type’s possible values are described here: Field data types.If data load is in progress an empty array will be returned.
flexmonster.getMeasures();
/* method returns array of objects
[
{
aggregation: "sum",
availableAggregations: ["sum", "average", "percent"],
availableAggregationsCaptions: ["Sum", "Count", "Percent"],
caption: "Sum of Sales",
format: "currency",
grandTotalCaption: "Total Sum of Sales",
name: "Sales",
type: "number",
uniqueName: "Sales"
},
{
aggregation: "sum",
availableAggregations: ["sum", "count", "distinctcount", "average", "product", "min", "max", "percent", "percentofcolumn", "percentofrow", "index"],
availableAggregationsCaptions: ["Sum", "Count", "Distinct Count", "Average", "Product", "Min", "Max", "% of Grand Total", "% of Column", "% of Row", "Index"],
caption: "Sum of Orders",
format: "",
grandTotalCaption: "Total Sum of Orders",
name: "Orders",
type: "number",
uniqueName: "Orders"
}
]
*/
Try on JSFiddle.
getMeasuresAsync
getAllMeasures
getAllHierarchies
getColumns
getRows
getReportFilters