Inverse Watch Docs
AppLanding
  • Overview
    • Home
    • Governance
      • Proposal 7
      • Proposal 25
      • Proposal 52
      • Proposal 107
      • Proposal 147 - S1
      • Proposal 189 - S2
  • Products
    • Inverse Alerts
      • See on Twitter
    • Inverse Chatbot
      • /doc
      • /imagine
      • /data
      • /graph
    • Inverse Subgraphs
      • See inverse-subgraph on Mainnet
      • See inverse-governance-subgraph on Mainnet
    • Inverse Watch
      • Go to App
  • User Guide
    • Quickstart
    • Alerts
      • Setting Up an Alert
      • Adding New Alert Destinations
      • Customize Alert Template
      • Multiple Column Alert
    • Queries
      • Creating and Editing Queries
      • Querying Existing Query Results
      • Query Parameters
      • How to Schedule a Query
      • Favorites & Tagging
      • Query Filters
      • How To Download / Export Query Results
      • Query Snippets
    • Visualizations
      • Cohort Visualizations
      • Visualizations How-To
      • Chart Visualizations
      • Formatting Numbers in Visualizations
      • How to Make a Pivot Table
      • Funnel Visualizations
      • Table Visualization Options
      • Visualizations Types
    • Dashboards
      • Creating and Editing Dashboards
      • Favorites & Tagging
      • Sharing and Embedding Dashboards
    • Data Sources
      • CSV & Excel Files
      • Google Sheets
      • JSON (API)
      • Python
      • EVM Chain Logs
      • EVM Chain State
      • GraphQL
      • Dune API
    • Machine Learning
      • Data Engineering
      • Regressors
        • Linear Regression
        • Random Forest
        • Ada Boosting
        • Gradient Boosting
        • Neural Network (LSTM)
      • Training and Predicting
      • Metrics & Overfitting
      • Examples
        • Price Prediction
          • Data Preprocessing
          • Model Creation & Training
          • Metrics Evaluation
          • Back Testing
          • Visualizing
        • Liquidation Risk
  • Admin & Dev Guide
    • Setup
    • Redash
    • Integrations & API
    • Query Runners
    • Users
      • Adding a Profile Picture
      • Authentication Options
      • Group Management
      • Inviting Users to Use Redash
      • Permissions & Groups
    • Visualizations
  • Cheat Sheets
    • Snippets
    • Contracts
  • More
    • Deprecated Apps
    • Github : inverse-flaskbot
    • Github : inverse-subgraph
    • Github : inverse-watch
Powered by GitBook
On this page
  • 1. Numbers
  • 2. Currency
  • 3. Bytes
  • 4. Percentages
  • 5. Exponential

Was this helpful?

  1. User Guide
  2. Visualizations

Formatting Numbers in Visualizations

In several visualizations you can control how the numbers are formatted in the Visualization Editor / Data Labels . You control the format by supplying a format string. Below you can find examples for the various format options.

1. Numbers

Number
Format
Output

10000

0,0.0000

10,000.0000

10000.23

0,0

10,000

10000.23

+0,0

+10,000

-10000

0,0.0

-10,000.0

10000.1234

0.000

10000.123

100.1234

00000

00100

1000.1234

000000,0

001,000

10

000.00

010.00

10000.1234

0[.]00000

10000.12340

-10000

(0,0.0000)

(10,000.0000)

-0.23

.00

-.23

-0.23

(.00)

(.23)

0.23

0.00000

0.23000

0.23

0.0[0000]

0.23

1230974

0.0a

1.2m

1460

0 a

1 k

-104000

0a

-104k

1

0o

1st

100

0o

100th

2. Currency

Number
Format
Output

1000.234

$0,0.00

$1,000.23

1000.2

0,0[.]00 $

1,000.20 $

1001

$ 0,0[.]00

$ 1,001

-1000.234

($0,0)

($1,000)

-1000.234

$0.00

-$1000.23

1230974

($ 0.00 a)

$ 1.23 m

3. Bytes

Number
Format
Output

100

0b

100B

1024

0b

1KB

2048

0 ib

2 KiB

3072

0.0 b

3.1 KB

7884486213

0.00b

7.88GB

3467479682787

0.000 ib

3.154 TiB

4. Percentages

Number
Format
Output

100

0%

100%

97.4878234

0.000%

97.488%

-4.3

0 %

-4 %

65.43

(0.000 %)

65.430 %

5. Exponential

Number
Format
Output

1123456789

0,0e+0

1e+9

12398734.202

0.00e+0

1.24e+7

0.000123987

0.000e+0

1.240e-4

PreviousChart VisualizationsNextHow to Make a Pivot Table

Last updated 1 year ago

Was this helpful?