Add a numeric-to-string format function to beast mode (TO_CHAR or something similar)

Hey,

 

I find myself trying to put multiple data points into complex summary beast modes so that I can provide info at-a-glance in card summaries.  For example, I'd like to be able to generate the following line of text in a card summary:

 

$10,000 Delinquency vs. $50,000 GPR (20.00%)

 

 I can calculate the data points for that summary string.  However, I can't format the numbers properly (I end up with "10000.0000000000000" instead of "10,000").  That said, I could get this done if beast mode supported a numeric-to-string format function similar to TO_CHAR (Redshift's implementation of TO_CHAR for reference, though Oracle also supports TO_CHAR)

 

Can you add TO_CHAR as a beast mode function?  Thanks.

 

Ryan

Tagged:
3
3 votes

· Last Updated

Comments

  • @mdelorey I want to make sure you see this thread - reminder that when we looked at the new card editor at conference I had a question about adding string beast modes to summary #, not just value formats!

     

    (sorry @CFRyan for sneaking onto your thread, but Mark is a great resource on this topic Smiley Happy)

     

    Broadway + Data
  •  No problem!  I think we're trying to solve for the same problem, so it's definitely relevant.  Thanks!

  • Thank you for submitting this @CFRyan. I am assigning to our product manager @ckwright to review and comment.

This discussion has been closed.