> For the complete documentation index, see [llms.txt](https://docs.dapplooker.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.dapplooker.com/dapplooker-analytics/products/analytics/custom-values.md).

# Custom Values

To convert a dataset value to USD use the steps below:

## Show custom values in data tables

1. After selecting the dataset from Indexed data, locate the Settings button at the bottom left corner of the page.

<figure><img src="/files/jGG3SC6kIfnaDP4LYIqc" alt=""><figcaption></figcaption></figure>

2. Click on the Column name and then click on the Settings button to access additional options.

<figure><img src="/files/xUfHc41XHfD0IWK2kYnV" alt=""><figcaption></figcaption></figure>

3. Within the Column formatting options choose the "Style" to "Currency".

<figure><img src="/files/oKbb1mjR5bd5TDJPr5ro" alt=""><figcaption></figcaption></figure>

4. 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.

<figure><img src="/files/3LuEoiaBj730ZW6ZSsIC" alt=""><figcaption></figcaption></figure>

5. 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.

<figure><img src="/files/9NEUdV0EOO3wn7SQXa2h" alt=""><figcaption></figcaption></figure>

## Show Custom values on charts

1. Click on the settings button which is located in the bottom left corner of the chart.

<figure><img src="/files/F9qI1zLSCJZuMzHjL1da" alt=""><figcaption></figcaption></figure>

2. Then Click on The Three dots " ... " next to the Sum of amount.

<figure><img src="/files/GetH7HNecbujx0teCqJc" alt=""><figcaption></figcaption></figure>

3. 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.

<figure><img src="/files/I8eR7AK1y8UNWxMGCRHV" alt=""><figcaption></figcaption></figure>

4. After the changes are done in formatting, Now you can see the amount is showing in USD

<figure><img src="/files/HeTNOejkFzcMkocv20xF" alt=""><figcaption></figcaption></figure>

These steps will help you format and convert the dataset value to USD using the specified settings.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.dapplooker.com/dapplooker-analytics/products/analytics/custom-values.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
