After uploading data files on BStreams, you can manage your datasets in the BStreams Data Manager.
Basically, a dataset (also known as a data set) is a collection of data. It corresponds to the content of a single data file, in which each column of the table represents a particular variable and each row corresponds to a specific item of the set of data.
In the rest of the article, we refer to the World_University_Rank dataset.
You can get it as a Google Sheets at the following URL:
https://docs.google.com/spreadsheets/d/1pnSQUfOHQ9y1dFKjC4LHNishW9yCVT93dXYpIlH9LN0/edit?usp=sharing
Once you upload and edit the file on BStreams, it will look like the following image
Basic settings
Locale: it defines currencies, decimal and thousand separators as well as the translation of month and weekday names. The default locale property for BStreams is English but, for example, if you set to Italian (or any other European country), you will get the following:
- numeric fields: comma and point as decimal and thousands separator
- currency fields: the € suffix and two decimals
- dates: the day-month-year formatting or, in the extended form, the month’s full Italian name
In addition of the locale, for every single field, you can define six properties:
Field: is the column containing the related data. Right next to it, click on the “three dots menu” to hide a column, edit or remove a function.
Type: click on the drop-down menu to establish the type of element the field section refers to. Choose among numbers, text, percentage, money, and date-time.
Format: If your calculated field is a numeric element, you can decide the number format. The default format is AUTO and is it helpful if a numeric field of the source file contains at least a decimal value. Choose among different number formats depending on your needs.
Expression: allows adding a symbol or number before or after the numeric value.
Set wisely the field’s properties
It is crucial to get confident about how to set the field’s properties because they will be reflected in the visualizations which you will create.
insert the following note into a colored rectangle or use another way to emphasize it Remember that every dataset change (for example, the editing of a calculated field or a metric, or the editing of a data type or format) will affect every BStream, whether published or local.
For instance, consider the Type property in some specific cases: for example, if you had a field named Year and you wanted to use it as a dimension on a line chart, it’s a good practice to set its type to Text; otherwise, you will get something like 2,021 because the Year field will be read (and visualized) as a numeric value by default.
Numbers: The default format is AUTO, which ensures that the number of decimals within charts is automatically set, depending on the data to be displayed. When you view the dataset it shows the original values, while in any visualization BStreams automatically sets the decimals to create coherence. For instance, if a value in the source dataset was 42.35122196, BStreams shows 42.35 within any charts or maps.
BStreams sets the number of decimals based on the average of the values present in the field: if greater than 1000, the decimals will be truncated while, at the other opposite, if the average is less than 10, BStreams will set the maximum number of decimals, specifically three.
For example, if you have the values 3,45 – 14 – 12,32564, the average is 9,91, thus less than 10. Hence, the values will be formatted as follows: 3, 450 – 14,000 – 12,325. If the average had been between 10 and 100, then there would be two decimals, that is, 3,45 – 14,00 – 12,32, and so on.
If all the field values are integer, AUTO does not produce any results, while by changing the format, it is possible to force the desired number of decimals.
Currency: the currency format depends on the selected locale. When you change it, values will be visualized with its currency symbol and a predefined number of decimals.
The currency symbol cannot be hidden or changed while the number of decimals can be modified only within the Style panel of the chart.
For example: if the locale was English (United States) the currency format is $ with 2 decimals.
Expression: finally, if a field whose values do not fall into any of the predefined types, you can finally add a prefix or a suffix in the expression box to make its meaning clearer.
Want to learn more about scatterplots? Email us at support@bstreams.io
If you haven’t checked our blog yet, give it a look and let us know what you think about it.
Read more here