• Beta
Word Cloud Chart
  • 15 Nov 2020
  • 3 Minutes To Read
  • Contributors
  • Print
  • Share
  • Dark
    Light

Word Cloud Chart

  • Print
  • Share
  • Dark
    Light

Overview

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.

Select_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.

2020-11-15_New_chart.png

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.

Note:

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.

Select_datasource

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.

Create_a_new_chart


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!

Datasource_and_chart_type

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.

Time_panel

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).

Note:

The Series field asks the question, what type of data category should be included? The Metric field asks, how will the data be measured?

Select_metric

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.

Select_country

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.

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.

Customize_word_cloud

Was This Article Helpful?