Number abbreviations

Options
Victoria_G1
Victoria_G1 Member
in Cards, Dashboards, Stories

Hello!

Is it possible to abbreviate numerical quantities displayed as currencies inside analyzer? For example, in the picture below it says 21 but that is times 1 BN. Is there a way to include the 1 BN abbreviation without having to do any sort of modification inside the ETL?

Thanks!

image.png

Best Answers

  • ColemenWilson
    ColemenWilson Coach
    edited February 26 Answer ✓
    Options

    You could just create a beastmode that is `your value` * 1000000000.

    Screenshot 2024-02-26 at 3.08.29 PM.png

    Then in the chart properties, select General > Divide Values by > Billions.

    Screenshot 2024-02-26 at 3.06.12 PM.png

    End result (this original number in my data is 95.72, once I take the steps above I get the below):

    Screenshot 2024-02-26 at 3.06.48 PM.png

    If I solved your problem, please select "yes" above

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    CONCAT(DIVIDE(`YourColumn`, 1000000000), ' BN')

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • DataMaven
    DataMaven Coach
    Answer ✓
    Options

    CONCAT('$',`Your_Column`,'B')

    Though I like Colemen's solution much better. If you use mine instead, please also mark his as a solution, as it's solid.

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited February 26 Answer ✓
    Options

    You could just create a beastmode that is `your value` * 1000000000.

    Screenshot 2024-02-26 at 3.08.29 PM.png

    Then in the chart properties, select General > Divide Values by > Billions.

    Screenshot 2024-02-26 at 3.06.12 PM.png

    End result (this original number in my data is 95.72, once I take the steps above I get the below):

    Screenshot 2024-02-26 at 3.06.48 PM.png

    If I solved your problem, please select "yes" above

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    CONCAT(DIVIDE(`YourColumn`, 1000000000), ' BN')

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • DataMaven
    DataMaven Coach
    Answer ✓
    Options

    CONCAT('$',`Your_Column`,'B')

    Though I like Colemen's solution much better. If you use mine instead, please also mark his as a solution, as it's solid.

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories