🔢Custom Values
To convert a dataset value to USD use the steps below:
Show custom values in data tables
After selecting the dataset from Indexed data, locate the Settings button at the bottom left corner of the page.
Click on the Column name and then click on the Settings button to access additional options.
Within the Column formatting options choose the "Style" to "Currency".
Scroll down until you find the "Multiply by Number" section, Note somewhere the value "1e-18" and then Copy-paste here to convert the value to USD.
Once you've entered the value, click on the "Done" button to save the changes. Now, you should be able to see the converted value in USD format.
Show Custom values on charts
Click on the settings button which is located in the bottom left corner of the chart.
Then Click on The Three dots " ... " next to the Sum of amount.
Within the formatting options choose the "Style" to "Currency" & in "Multiply by Number" section, Note somewhere the value "1e-18" and then Copy-paste here to convert the value to USD.
After the changes are done in formatting, Now you can see the amount is showing in USD
These steps will help you format and convert the dataset value to USD using the specified settings.
Last updated
