Retrieve a list of available calculated metrics. The results will always include these default items:
type. Other attributes can
be optionally requested through the
cja_get_calculatedmetrics( expansion = NULL, includeType = "all", dataviewIds = NULL, ownerId = NULL, filterByIds = NULL, toBeUsedInRsid = NULL, locale = "en_US", favorite = NULL, approved = NULL, pagination = TRUE, limit = 10, page = 0, sortDirection = "DESC", sortProperty = NULL, debug = FALSE )
Additional calculated metric metadata fields to include in the results: "dataName" "approved" "favorite" "shares" "tags" "sharesFullName" "usageSummary" "usageSummaryWithRelevancyScore" "reportSuiteName" "siteTitle" "ownerFullName" "modified" "migratedIds" "isDeleted" "definition" "authorization" "compatibility" "legacyId" "internal" "dataGroup" "categories".
Include additional calculated metrics not owned by user. Available values are
all option takes precedence over
Filter the list to only include calculated metrics tied to a specified dataviewId or
list of dataviewIds. Specify multiple dataviewIds as a vector (i.e., "
dataviewIds = c("dataviewid_1", dataviewid_2",...dataviewid_n")").
cja_get_dataviews to get a list of available
Filter the list to only include calculated metrics owned by the specified loginId.
Filter the list to only include calculated metrics in the specified list as specified by a single string or as a vector of strings.
The data view where the calculated metric intended to be used. This data view will be used to determine things like compatibility and permissions. If it is not specified then the permissions will be calculated based on the union of all metrics authorized in all groups the user belongs to. If the compatibility expansion is specified and toBeUsedInRsid is not then the compatibility returned is based off the compatibility from the last time the calculated metric was saved.
The locale that system-named metrics should be returned in. Non-localized values will be returned for title, name, description, etc. if a localized value is not available.
TRUE to only include calculated metrics that are favorites in the results. A
FALSE will return all calculated metrics, including those that are favorites.
TRUE to only include calculated metrics that are approved in the results. A
FALSE will return all calculated metrics, including those that are approved and those that are not.
return paginated results. Set to 'TRUE' by default
Number of results per page. Default is 10
The "page" of results to display. This works in conjunction with the
limit argument and is
zero-based. For instance, if
limit = 10 and
page = 1, the results returned would be 11 through 20.
The sort direction for the results:
ASC (default) for ascending or
descending. (This is case insensitive, so
desc work as well.)
The property to sort the results by. Currently available values are
modified_date. Note that setting
expansion = modified returns results with a column added called
modified, which is the last date the calculated metric was modified. When using this value for
though, the name of the argument is
Include the output and input of the api call in the console for debugging. Default is FALSE
A data frame of calculated metrics and their metadata.
This function is useful/needed to identify the specific ID of a calculated metric for use in other
expansion argument accepts the following values, which will then include additional columns
in the results:
owner.login columns to the results (
already included by default).
modified: adds a
modified column to the output with the date (ISO 8601 format) each
calculated metric was last modified.
definition: adds multiple columns (the number will vary based on the number and complexity of calculated metrics returns) that provide the actual formula for each of the calculated metrics. This is returned from the API as a JSON object and converted into columns by the function, which means it is pretty messy, so, really, it's not recommended that you use this value.
compatability: should add a column with the products that the metric is compatible with, but this behavior has not actually been shown to be true, so this may actually do nothing if included.
reportSuiteName: adds a
reportSuiteName and a
siteTitle column with the friendly report
suite name for the RSID.
tags: adds a column with an embedded data frame with all of the existing tags that are associated with the calculated metric. This can be a bit messy to work with, but the information is, at least, there.
Other Expansion options that are available: "dataName", "approved", "favorite", "shares", "sharesFullName", "usageSummary", "usageSummaryWithRelevancyScore", "siteTitle", "migratedIds", "isDeleted", "authorization", "legacyId", "internal", "dataGroup", "categories"
Multiple values for
expansion can be included in the argument as a vector. For instance,
expansion = c("tags", "modified") will add both a
tags column and a
modified column to the output.