Walkthrough: Create your first analysis

Prev Next

In this walkthrough, you will:

  • Create a simple analysis from table data
  • Target specific data by applying sorting and filters

An Analysis is a visualization of data stored in Tulip. Analyses automatically update to reflect recent data.

In this walkthrough, you’ll learn the basics of analyses by creating one in the Analytics Editor.

In order to follow this walkthrough, you must first complete the exercises in Build Your First Table.

At the end of the exercise, you will have an analysis that looks like this:
ex first analysis final

Exercise: Chart quantities by product

In this exercise, we are going to create a bar chart analysis that shows the sum of quantity for each type of product.  We want to see the disparity of units produced between each type of product (bicycle frame, drivetrain, wheel).

Select Work Orders table for new analysis

  1. Select the Dashboards tab in the top navigation bar. Click Create Analysis.
  2. Click the Table tab and select the Work Orders table.
    ex first analysis select table

Configure analysis data

  1. Click the Display dropdown and select Bar.
    ex first analysis select display bar

  2. Click the Date Range tab. In the dropdown, select All time.
    ex first analysis date range

  3. Click the Operations tab and then Add a new operation.

  4. Select Aggregation functions → Sum.

  5. Click <Select a variable or function>. Select Table Field → Work Orders Quantity.

ex first analysis select operation SUM

The operation determines the data you want to see. In this case, we want to see the sum of product quantities.

  1. Click the Groupings tab and then Add a grouping.
  2. Select Table FieldsWork Orders Product.
    ex first analysis select grouping PRODUCT

The grouping determines how you want to organize the data. In this case, we want to group the data by each product.

  1. In the Visualization panel, add the following fields for each axis:
  • X Axis - Product
  • Y Axis - Quantity
    ex first analysis visualization panel fields
  1. Name your analysis so you can easily identify its purpose, such as “Sum of Quantity by Products”.
    ex first analysis name analysis

Filter data by status

To narrow down the data, let’s filter the data to only include completed work orders.

  1. Click the Filters tab and then Add a new filter.

  2. Select FunctionContains.

  3. For the field, select Work Orders Status.

In the String Value box, type “Complete”.
ex first analysis STATUS filter

Now you have a bar chart that shows the sum of units for all completed work orders per each product type.

Next Steps

Learn about what you can achieve with analyses:


Did you find what you were looking for?

You can head over to community.tulip.co to post your question or see if others have faced a similar question!