All eazyBI for Jira eazyBI for Confluence Private eazyBI

LinRegPoint

Calculates the linear regression of a set and returns the value of y in the regression line y = ax + b

Syntax

 LinRegPoint(Numeric expression output x, Set expression, Numeric expression y, Numeric expression x)

Arguments

Numeric expression output x
Numeric expression that represents values for the x axis function will be applied to
Set expression
MDX expression that returns a set function is calculated by 
Numeric expression y

Numeric expression that represents values for the y axis function is calculated by

Numeric expression x
Numeric expression that represents values for the x axis function is calculated by

Examples

Following example shows Remaining Story points trend over Time per Sprint period.

LinRegPoint(
  -- Numeric expression output x
  DateToTimestamp([Time].CurrentHierarchyMember.StartDate), 
  -- Set expression - input period
  Filter([Time].CurrentHierarchyMember.Level.Members,
    [Measures].[Time within Sprint] > 0),
  -- Numeric expression input y
  [Measures].[Story Points remaining],
  -- Numeric expression input x 
  DateToTimestamp([Time].CurrentHierarchyMember.StartDate)
)

eazyBI default calculation Linear trend you can add to the report uses LinRegPoint function to generate trend line on visible rows (x-axis) values.