Beast Mode - FORMAT Function
Currently Beast Mode does not support the MySQL FORMAT function:
http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_format
Since we can have summary numbers which are concatenated with strings, format would allow the number to be pre-processed with comma thousands separators.
Please enable this feature.
Comments
-
Let's make this happen! It'd be great for concat functions. One of those things the boss asks you about all the time!
0 -
-
0
-
@totesmgoets Thanks for reaching out, there is currently no update on this feature request. I'm working with our data function team to see what options we have for this request. Thanks.
0 -
@ckwright Has any progress been made on this yet? We still think it would be useful. Right now we have a pretty elaborate beast mode to get around it. You need to replace 'x' with your function. It's a mega pain, and there's no way it's not processing more than if you just used the FORMAT function.
CASE
WHEN LENGTH(concat(round('x',0),'')) < 4 then concat(round('x',0),'')
WHEN LENGTH(concat(round('x',0),'')) = 4 then CONCAT(SUBSTRING(concat(round('x',0),''),1,1), ',', SUBSTRING(concat(round('x',0),''),2,3))
WHEN LENGTH(concat(round('x',0),'')) = 5 then CONCAT(SUBSTRING(concat(round('x',0),''),1,2), ',', SUBSTRING(concat(round('x',0),''),3,3))
WHEN LENGTH(concat(round('x',0),'')) = 6 then CONCAT(SUBSTRING(concat(round('x',0),''),1,3), ',', SUBSTRING(concat(round('x',0),''),4,3))
WHEN LENGTH(concat(round('x',0),'')) = 7 then CONCAT(SUBSTRING(concat(round('x',0),''),1,1), ',', SUBSTRING(concat(round('x',0),''),2,3), ',', SUBSTRING(concat(round('x',0),''),5,3))
WHEN LENGTH(concat(round('x',0),'')) = 8 then CONCAT(SUBSTRING(concat(round('x',0),''),1,2), ',', SUBSTRING(concat(round('x',0),''),3,3), ',', SUBSTRING(concat(round('x',0),''),6,3))
WHEN LENGTH(concat(round('x',0),'')) = 9 then CONCAT(SUBSTRING(concat(round('x',0),''),1,3), ',', SUBSTRING(concat(round('x',0),''),4,3), ',', SUBSTRING(concat(round('x',0),''),7,3))
WHEN LENGTH(concat(round('x',0),'')) = 10 then CONCAT(SUBSTRING(concat(round('x',0),''),1,1), ',', SUBSTRING(concat(round('x',0),''),2,3), ',', SUBSTRING(concat(round('x',0),''),5,3), ',', SUBSTRING(concat(round('x',0),''),8,3))
WHEN LENGTH(concat(round('x',0),'')) = 11 then CONCAT(SUBSTRING(concat(round('x',0),''),1,2), ',', SUBSTRING(concat(round('x',0),''),3,3), ',', SUBSTRING(concat(round('x',0),''),6,3), ',', SUBSTRING(concat(round('x',0),''),9,3))
WHEN LENGTH(concat(round('x',0),'')) = 12 then CONCAT(SUBSTRING(concat(round('x',0),''),1,3), ',', SUBSTRING(concat(round('x',0),''),4,3), ',', SUBSTRING(concat(round('x',0),''),7,3), ',', SUBSTRING(concat(round('x',0),''),10,3))
END0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有