One of the most effective ways to communicate your analysis is choosing the right data visualization. This article walks through the fundamentals of visualizing data in Count including:

  1. How to Create a Visual in Count
  2. Layers
  3. Subplots
  4. Groups

1. How to Create a Visual in Count

When you're building your notebook, you start with creating a cell and building a query. Once you're happy with your query, it's time to start visualizing your data. Each cell output can display either a table of results (the default) or a visual.

To get your cell to display a visual instead of a table, click the visual button beneath your query bar:

At this point Count with give you a default visual. If you want to change/customize the default, click the Edit Visual button beneath the visual.

Now we'll dive into the Edit Visual Features & Functions. First, let's understand what each element on our Edit Visual page means.

We'll now dive into each of these concepts in more detail.

2. Layers

Layers are where we map columns to axes. They are the most fundamental part of each visual.

Each layer has the following:

  • Layer Type (Bar, Circle, Line, Area, Square)
  • X-Axis
  • Y-Axis
  • Color
  • Size
  • Path (for Line only)
  • Detail (a.k.a. Tooltip)

This video walks through how to create a sorted bar chart using a single layer:

We have a single layer that has:

  • Layer Type: Bar
  • X2: count_distinct_day
  • Y: artist

The Power of Multiple Layers

The best part of layers comes when you have more than one layer on a single plot. By default, Count will lay each layer on top of each other, sharing the same axes if possible. But you can always use the secondary x (top), and y(right) axes.

For example, if we want to add a line to the chart above to show the total number of streams for their top 10 tracks for each artist, we can do the following:

We added a new layer that has:

  • Layer Type: Line
  • X: count_distinct_track_id
  • Y: artist

This layer now has the same y-axis: artist but Unique Tracks is now on the bottom X-axis instead of the top since their scales are very different.

Using Secondary Axes

To map something on one of the Secondary Axes (Top, or Right), use the X2 and Y2 buttons on the layers.

You can plot multiple layers on the same axes but they will all have to use the same scale.

3. Subplots

Subplots define the grid of independent plots we want in our final visual. You can add multiple subplots if you want to display data side by side.

Note: The subplots need to come from the same table, so you cannot have 2 subplots with independent data, only independent axes.

The video below shows how to create and use subplots:

In the example above, we created 2 subplots, one on top of the other. These subplots had different independent y-axes, but they shared an x-axis (month). This is because month was on a Group. Let's learn more about those now...

4. Groups

Groups are a great way to partition your chart, and create hierarchied axes. These are like axes that sit at the highest level so they apply to all subplots and all layers.

The following shows how to use groups to make a hierarchied axis.

We put both artist and track name in the Y Group. If we were to add any subplots or new axes, that Y Grouping would persist.

For more about building visualizations in Count, check out our Quick Guides, and Formatting Vizualizations pages!

Visualization Quick Guides:

Did this answer your question?