Number abbreviations

Victoria_G1

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!

ColemenWilson

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

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

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

ArborRose

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

DataMaven

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.

ColemenWilson

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

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

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

ArborRose

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

DataMaven

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.