All eazyBI for Jira eazyBI for Confluence Private eazyBI


Returns the number of characters in a specified string. 





MDX expression that returns a string.


Here is one example in the report to count the 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