Toggle navigation
Home
▼ Details
Products and pricing
Chart gallery
User stories
Text analytics
CDC NAMCS Library
Blog
Tutorials
Contact
Sign in
Post Editor
← All help posts
View post
Save
<img src="/uploads/upload/image/5200/direct/1595435153215-1595435153215.png" alt="Diagram showing the relationship between raw data values (shown as gray shapes on the left) and their formatted display values (shown as blue horizontal bars of varying lengths on the right), illustrating how survey data is stored internally versus how it is presented to users" style="width: 490px;" class="fr-fic fr-dib"> Survey engines usually represent data internally in a cryptic format for computers, and have additional "meta data" that describes how to present the data for people. For instance, a survey may have a question **q1** which is presented to English-speaking respondents as "Generally, how would you say things are in your life?". Similarly the response values are represented in data as integers (e.g. 1, 2, ...) but displayed to the user as "Very happy", "Pretty happy", etc. #### <img src="/uploads/upload/image/5200/direct/1655481478369-1655481478369.png" alt="Survey results showing two questions from a Gender and Generations Survey: Q1 about happiness levels (Very happy 30.5%, Pretty happy 50.9%, Not too happy 15.4%, Don't know/Refused 3.2%) and Q2 about health rating (Excellent 25.4%, Good 51.7%, Only fair 17.8%, Poor 4.9%, Don't know/Refused 0.3%), with horizontal bar charts displaying the response distributions" class="fr-fic fr-dib"> ## Format toolbar button You can toggle the format button in the toolbar to see the underlying values in every question. <img src="/uploads/upload/image/5200/direct/1655481711421-1655481711421.png" alt="Protobi interface showing the Format button highlighted in yellow in the toolbar, with the same survey questions displayed below showing numeric values (1, 2, 3, 9) instead of text labels, demonstrating the toggle between formatted text and raw data values" class="fr-fic fr-dib"> ## Format dialog To see and refine the mapping for specific questions, press the element icon (blue circle) and choose "Format...". This will bring up the following dialog: #### <img src="/uploads/upload/image/5200/direct/1580824730847-1580824730847.png" alt="Edit format dialog box showing a table with columns for Value, Format, Mean, Sort as, Sort last, Hide, and Remove, displaying the mapping between numeric values (1, 2, 3, 9) and their text labels (Very happy, Pretty happy, Not too happy, Don't know/Refused), with a checkbox option to 'Group unformatted values into [other]' and a 'Clear all formats' link at the bottom" style="text-align: center; width: 600px;" class="fr-fic fr-dib"> - **Value** corresponds to the raw value in the data file - **Format** is the string for display - **Mean** is an alternative value to be used for calculating summary statistics - See practical use cases in this [tutorial](/edit-access/alternative-values) - **Sort as** is an alternative value to be used for sorting - **Sort last** indicates the value should be sorted at the end, regardless - **Hide** indicates the value should not be shown in the distribution - **Remove** deletes the row from this dialog
Publishing
Date
Status
Published
Draft
Slug
edit
Content
Thumbnail
Categories
Manage
New to Protobi?
Charts
Making Changes
Intermediate topics for editors
Frequently Asked Questions
SERMO Topics
Tutorial Pages
Internal Docs
Data Processing
Videos
Obsolete
GSG Admin
SERMO Admin
GSG Topics
How to...
Basics for viewers
Basics for editors
For project admins
Advanced topics
Assessments
Articles (in-progress)
New and updated articles
Process data in Protobi
superseded
Text open-end questions
Troubleshooting
Tracking studies
Organizing the view
API References
Tools
AI Database
Checking AI...
Convert to MD
Danger zone
Delete