All eazyBI for Jira eazyBI for Confluence Private eazyBI

Titleize

EAZYBI Converts a string into title case, capitalizing the first letter of each word and transforming the rest of the letters to lowercase. Strings written in CamelCase will be separated at the capital letters.

Syntax

 Titleize(String_Expression)

Arguments

String_Expression

MDX expression that returns a string expression to be converted to title case.

Examples

Formatting Issue Summaries

The following example will return issue summaries converted to title case.

Titleize([Measures].[Issue summary])

Formatting custom string expressions

The following table shows example strings and the output that the Titleize function will return for each of them.

String ExpressionTitleized String
"this is a quick bugfix""This Is A Quick Bugfix"
"InProgress""In Progress"
"BUG: NEEDS SOLUTION""Bug: Needs Solution"