All eazyBI for Jira eazyBI for Confluence Private eazyBI

VisibleColumnsSet

EAZYBI Returns the set of all members, which are visible in columns where each member represents one column.
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

VisibleColumnsSet()

Arguments

n/a

Examples

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

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

See also