Word cloud charts provide a visually stimulating way to convey the relative size of data between different metrics. In this walkthrough, we will create a Word Cloud chart based on publicly accessible data from the Covid-19 Coronavirus pandemic. Have a look at the Sample Data section on Connecting to Preset to download this data.
In the instructions below, we will create a word cloud chart that shows new Covid-19 cases from different US states, with larger text sizes representing a higher number of new cases.
Step One: Getting Started
To start, log on to Preset and then select a workspace.
Next, let's define your datasource and select a chart type
At the top of the screen, select +. Then, in the drop-down menu, select Chart.
After you do this, the Create a new chart screen appears.
Step Two: Select a Datasource and Visualization
In the Choose a datasource field, select a data source.
Please see Connecting to Preset to learn how to add a datasource to Preset. Be sure to check out the Sample Data section to add Covid-19 data.
Next, in the Choose a visualization type field, click the Table (default) icon.
The Select a visualization type panel appears.
Look for the Word Cloud chart type—or use the Search feature to filter by the word “Cloud”—and then select.
After you've done this, go ahead and select the Create new chart button.
Step Three: Start Building your Chart
Now we're going to define the parameters of your new chart. To start, in the Datasource & Chart Type area, make sure that the Datasource and Visualization Type match what you just selected.
You can change either or both of these at any time!
Now we will define the time parameters. The Time panel is used to select a Time Column (i.e., the type of time data being used) and a Time Range (i.e., last week, last month, custom, etc.).
In this example, we will use the date_trunc time column and the Last Week time range.
Next we have the Query panel.
This area is used to select the type of data you would like to include and how you would like to filter that data.
In this example, we will select the province time series (i.e., data from states), the SUM(new_cases) metric (i.e., include the sum of all new cases), and the country = US filter (i.e., only data from the US).
The Series field asks the question, what type of data category should be included? The Metric field asks, how will the data be measured?
In the Filters field, select a data filter. To filter by the US:
- Select country.
- Click the country = ◄ field.
- In the Filter value field, enter: US.
- Select Save.
In the Row limit field, indicate how many rows of data should be included (default of 100 rows).
Okay, now let's visualize the word chart.
Step Four: Visualize the Chart
In the Content Panel, select Run Query.
Step Five: Customize the Chart
Preset enables users to customize the appearance of chart types. For Word Cloud charts, you can modify the font size, word rotation, and color scheme.
- In the Minimum Font Size field, enter the font size of the smallest text that appears in the word cloud (i.e., queries with the least amount of filtered data).
- In the Maximum Font Size field, enter the font size of the largest text that appears in the word cloud (i.e., queries with the greatest amount of filtered data).
- In the Word Rotation field, select the orientation of the words in the word cloud:
- Square: Places the words in a roughly square shape, with orientations being both horizontal & vertical;
- Flat: Places all words horizontally; and,
- Random: Places the words horizontally, vertically, and diagonally in a random pattern.
- In the Color Scheme field, select a color scheme family to be applied to individual words in the chart.