All eazyBI for Jira eazyBI for Confluence Private eazyBI

Tail

Returns the specified number of tuples from the end of the specified set. The order of elements is preserved. The default value of Count is 1. If the specified number of tuples is less than 1, the function returns the empty set. If the specified number of tuples exceeds the number of tuples in the set, the function returns the original set.

Syntax

Tail(Set_Expression, Numeric_Expression) 

Arguments

Set_Expression

MDX expression that returns a set of members.

Numeric_Expression

MDX expression that returns an integer number that specifies the number of tuples to be returned.

Examples

The following formula will return the calculate the average velocity from the last 5 closed sprints

Avg(
  Tail(
    Filter(
      -- filter the set of last 5 previous sprints in a board starting from current sprint
      {[Sprint].CurrentMember.FirstSibling:
       [Sprint].CurrentMember},
      [Sprint].CurrentMember.GetBoolean("Closed")
    ),
    -- set the count of last closed sprints for running velocity
    5
  ),
  [Measures].[Sprint Story Points completed]
)

Usually, the Tail function is used together with the Order or Filter functions when you need to extract a certain subset of members.

See the example report Sprint velocity chart in our demo account. The calculated measure "Sprint running velocity in board" uses the Tail function to calculate the average velocity from the last 5 closed sprints

See also