Introduction to Data Types in Pivot Table: JSON

Data and data bases

We understand your JSON data may contain different types of fields: numbers, dates, strings, time, days of the week and many others!

Setting proper data types at the very beginning is important for correct aggregation in the pivot table and successful data analysis.

Let WebDataRocks take care of handling data types in your JSON dataset.

Today we’d like to introduce to you four most popular cases when setting data types is important:

• If you need to create a hierarchy with more than one level
• When you have data describing days of the week or months and need to sort it in a natural sorting order, not the alphabetical one
• When you have numerical values which need to be interpreted as numbers, not as strings
• If your dataset contains such temporal data as date, date and time or time and you need to control the way it is displayed in the pivot table. For example, you can split the date into sub-hierarchies or show it as a single string.

Our pivot table allows you to define the first object in JSON array which is responsible for:

1. Explicit setting of data types
2. Creating multi-level hierarchies. Just define all the levels of the hierarchy and enjoy a new view of your data. Such a hierarchy can be drilled up & down:

   

3. Defining captions of the hierarchies

See the following CodePen example with the creation of a multi-level hierarchy. Feel free to play with the demo to see the changes!

Dates in JSON

We know that working with dates and displaying them the way you want are tricky tasks for programmers.

With the pivot table, you are able to format dates according to your business logic. But first, you need to make incoming values compliant with ISO 8601. See the simple example of setting a date type on CodePen.

Learn more

How to use data types in JSON at their full potential? To learn how to do it, you are welcome to read a new comprehensive tutorial in the documentation.

Stay tuned to the next talks about data types!