DappLooker Docs
  • 👋Welcome
  • Data APIs for AI
    • Overview
    • Changelog
    • API Authentication
    • API Endpoints
      • GET: Crypto Token Market Data
      • GET: List of All Tokens
      • GET: Multi-Timeframe Technical Analysis
      • GET: Agent Details
      • POST: AI-Powered Query via NLQ
    • Best Practices
    • Conclusion
  • DappLooker Analytics
    • 🗃️Products
      • 📶Analytics
        • 🔎Browse and Search data
        • 📈Creating Charts
          • No-Code Charts
          • SQL Charts
        • 🔢Custom Values
        • 📊Dashboards
          • Create Dashboard
          • Add Charts to Dashboard
          • Discover Page
          • Link dashboard to another dashboard
          • Adding Filters to Dashboard
            • Time Filter
        • ♻️Convert No-Code to SQL
        • 🔗Making Charts and Dashboards Public
      • 🔍Subgraph Analyzer
      • ✨AI Studio
        • AI Studio API Support
      • 🤖DataBOT
        • 🎮Discord Bot
        • ▶️Telegram Bot
        • 🌐Connect with Leading Networks and dApps
      • 🔑DappLooker SDK
        • 🔎Tracking API Usage
    • 🌐Supported Networks
      • Blockchain Data
      • Smart Contracts
      • Subgraphs
      • SubQuery
      • Offchain Data Sources
    • 📲Registering Data
      • My Dashboard Overview
      • Smart Contracts
      • Subgraph
      • Subquery
      • Off-Chain Integration
    • 🔖Featured Projects
    • 🎯Features
      • XRay Feature
      • Filtering
      • Summarize
      • Downloading
        • Download Chart Data
      • Editor Panel
        • Preview Chart
        • Joining Data
        • Types Of Join Data
        • Sorting
        • Row Limit
        • Convert to models
        • Duplicate a Chart
        • New Collection
      • Creating Custom Column and Custom Expressions
      • 📷Screenshot
      • 🗃️Collections
        • Browse Collection
        • Personal Collection
        • Team Collection
    • ⛓️Smart Contract Live Query
    • 🔔Push Notifications
      • 👀Where to view notifications?
      • 📰Push x MetaMask Snaps
    • 👨‍⚖️Case Studies
      • 1️⃣Community Updates
      • 2️⃣DeFi Reports
      • 3️⃣On-Chain & Off-Chain Analysis
      • 4️⃣User Retention Analysis
      • 5️⃣DappLooker Telegram Bot
      • 6️⃣Subgraph Powered No-Code Dashboards
      • 7️⃣API Use Case: Beamswap
      • 8️⃣Embedding Use Case: GRTDataHub
    • 💰Pricing
      • Pricing Breakdown
      • Discounts And Payments
    • 💻Deploy a subgraph on the DappLooker custom node
    • 🥷DappLooker No-code Ninjas Program!
    • 🤝Sponsor With Us
    • 🔗Relevant Resources
    • ☎️Contact Us
  • API Guides
    • Get API Key
    • How to Get an API of a Chart
    • Render Chart or Dashboard as an Image with API
    • Mintbase
      • Individual Store Level APIs
      • Mintbase Protocol Level APIs
    • Nordek Developer APIs
  • Explorers
    • CeloSpy
    • VaraSpy
Powered by GitBook
On this page
  • Show custom values in data tables
  • Show Custom values on charts

Was this helpful?

  1. DappLooker Analytics
  2. Products
  3. Analytics

Custom Values

PreviousSQL ChartsNextDashboards

Last updated 1 year ago

Was this helpful?

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.

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

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

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

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

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

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

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

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

🗃️
📶
🔢