PROPER Function in Views

Sam_Donabedian

Attempting to add a Calculated Column to a View and am unable to find the PROPER function.

Is this function supported in Views or is there another function available that produces the same outcome?

GrantSmith

@Sam_Donabedian INITCAP is available in views however it's just not listed in the available functions.

Sam_Donabedian

@GrantSmith , that worked, thank you!

MarkSnodgrass

Have you tried INITCAP? That function works in beast modes and formula tiles.

Sam_Donabedian

Thanks @MarkSnodgrass !

We looked for INITCAP and found it was also an unavailable function in Views.

Questions is, why is it available in Beast Modes and Formula Tiles but not Views?

GrantSmith

@Sam_Donabedian INITCAP is available in views however it's just not listed in the available functions.

Sam_Donabedian

@GrantSmith , that worked, thank you!

jaeW_at_Onyx

@Sam_Donabedian some functions are available but not represented in the UI. Did you try it?

I would be surprised because beast modes are processed in the same engine as dataset views (AFAIK).

Sam_Donabedian

@jaeW_at_Onyx , thanks, good to go!

We're actually finding quite a bit is missing in the list of DOMO's functions and are now referring to alternative sites / sources for information (just to be sure we are not missing something). I'm not sure who is responsible for updating the list of functions in DOMO, but it appears to be due.

MarkSnodgrass

@Sam_Donabedian The list of functions in the beast mode editors are inconsistent in the different areas of Domo, even though you can use almost all of them in each area. I have posted in the Idea Exchange to get these consistent to make it clearer for users to know which functions are actually available.

https://dojo.domo.com/main/discussion/55970/beast-mode-editor-formula-list-consistency

Sam_Donabedian

@MarkSnodgrass , thank you, just voted for it 👍️.