All Collections
Data
Upload
Formatting Data in Visualizations
Formatting Data in Visualizations

Learn the different formats (ways) you can display data on visualizations

Jennifer Funk avatar
Written by Jennifer Funk
Updated over a week ago

Format is the way in which a data value can be displayed. This appears everywhere that you can visualize data (maps, charts, time series, correlations, etc).

Most often, data is automatically formatted as a number. However, some data is pre-identified by our data experts and automatically visualized another way (Unemployment Rate is a great example, it is automatically formatted as percent)

When you upload currency or percents through the user data upload process, those values will automatically be formatted that way.

Depending on the visualization and/or presentation goal, you may want to change the format for the data point selected.

  • Number - typical format, used when the data value is a number (100 = 100)

  • Currency - used when the data value is representing USD. This format will show your number as $.00 (100 = $100.00)

  • Percent - used when the data value is a percentage. This format will show your number with a % (100 = 100%)

  • Ratio as Percent - used when your number needs to be multiplied by 100 to be shown as a percentage. It is recommended to normalize when using this format (100 = 10000%; 0.6 = 60%)

  • Rate per 100k - used when your number needs to be multiplied by 100K to show the desired rate. It is recommended to normalize when using this format (100 = 10,000,000; 2.6 = 260,000)

  • Duration - used to show time. This format expects the input to be in seconds (100 = 1 minute, 40 seconds; 3 = 00:03)

  • None - this format is not a numerical format and will show the input value without manipulation.

Did this answer your question?