Agreed - again this would be nicely solved with UDFs...
I think I would prefer a fully capable FORMAT() function over the ability to create UDFs.
Joe, help me understand the benefit of using a format() over formatting the end result once as a default for the calculation: http://www.clearlyandsimply.com/clearly_and_simply/2011/04/tableau-quick-tip-2-custom-number-formats.html
Here are two common use cases:
- Format differently based on a condition,
- Format to be a part of a concatenated string,
a search like http://www.tableausoftware.com/search/forum/format%20function will result in many other use cases, all can be solved with a FORMAT() function, but not with the custom format options.
Got it - makes sense
Yes pleeeease! We deal a lot with dates in dimensions for projects and being unable to format them is a lingering problem.
More on formatting, showing a percentage and absolute numbers (or dollars) in the same column could be taken care of with this too - for example KPIs which deal with percentages and dollars could be formatted based on a field or calculation row by row.
Currently the only solution is either just flat numbers or a create pre-calculated, pre-formatted string to display it in the necessary format.