All eazyBI for Jira eazyBI for Confluence Private eazyBI

Len

Returns the number of characters in a specified string. 

Syntax

Len(String_Expression)

Arguments

String_Expression

MDX expression that returns a string.

Examples

Here is one example in the report to count the length of customer name: https://eazybi.com/accounts/1/cubes/Sales/reports/857349-customers-by-length-of-customer-name


Another example counts the commas in the property "Issue custom date old values". When Jira date picker custom field "Custom date" is imported with change history which automatically generates a measure issue Custom date old values for each issue. That property stores all the previous dates for the date picker field "Custom date" and those dates are generated as a comma-separated list. 

Len([Measures].[Issue Custom date old values]) - Len(Replace([Measures].[Issue Custom date old values], ',',''))


See also

Replace function to replace substring with another substring