All eazyBI for Jira eazyBI for Confluence Private eazyBI

VisibleRowsSet

EAZYBI Returns the set of all members which are visible on rows where each member is representing one row.
This function uses report visible members only and will not return expected results when drilling into details. We recommend disabling drill actions with special annotations comments.

Syntax

VisibleRowsSet()

Arguments

n/a

Examples

The following formula would return average issues created dynamically over the members for the dimension that is selected on rows - e.g. Average in filtered Time period or Average over selected Projects.

-- annotations.disable_drill=true
Avg(
  VisibleRowsSet(),
  [Measures].[Issues created]
)

See also