Transforming data
The way we see data and visualize trends begins with the data structure. The data structure is key when creating data visualizations. Knowing how it's structured and why it's structured in a specific orientation leads to a smoother workflow build and design that turns into a successful output table to create brilliant data visualizations. We'll cover two tools that transform data in this section: the Transpose tool and the Crosstab tool.
The Transpose tool will pivot a wide dataset to a narrow dataset. This is the tall and skinny dataset that will put the fields in rows, and the values in rows as well. More rows will be created when data is transposed to a narrower dataset. This is great for trying to get one field that contains all the field names and the values associated with those field names alongside each other in rows. A calculation can be referenced on one field, rather than an individual calculation referencing each field if they were in their own columns. Transposing...
