Trends are an essential part of data analysis as they provide valuable insights into how end-users are interacting with a product. Trends can help you answer important questions about user behavior and activity, such as how often they perform certain actions, how many unique users are performing those actions, and when those actions are taking place.

Overview & Details

Trends Overview

  • Definition: This type of analysis is a powerful and flexible tool that is designed to visualize trends and compositions within data. Trends can help you analyze top events, determine the count of unique users firing events, and identify users' occurrences in your product.
  • Use cases:
    • Determine the count of unique signups firing the 'Created Flow' event in the product within the first 14 days.
    • Analyze the count of DAUs, WAUs, and MAUs over specific time periods.
    • Create custom metrics, track performance over time, and build charts for conversions and KPIs.
    • Track and identify the effect of a certain change in the product.
    • Analyze the impact of your Userpilot content such as flows and checklist completion.
    • Monitor the total count of the Invite Teammate event that was fired from power customers in the past 30 days.
    • Compare key features' performance over time and clarify which users tend to fire certain events

Creating a Trend

To create a Trend, the first step is to open the Trend page.

  1. First, click on Analytics on the dashboard. Then click on Trend.

  1. Here you can create your new Trend! You can add a new name and description to your new Trend.

Note: You can view the list of Trends you have created on the Saved Reports page.

You can also create a new Trend on the Saved Reports page by clicking on the button Create Report.

Trends Report

The interface comprises two sections:

1. Query Builder (Left Section)

Here you can select the data (events and properties) and filters you wish to apply to the report, it consists of three tabs: Events, Filters, and Breakdown.

2. Results and Visualization (Right Section)

You can review query outcomes and choose data presentation options.


  1. First, you need to click on Users. Here you can choose whether you want to analyze the data on a user or company level.

  2. Next, click on Select an Event. You can select events from three categories: Features & Events, Pages, and Content Engagement.

Note: You can only select up to 10 Events

  1. Select Count Type

For each event you have selected, you can determine how you want the event to be counted.

  • Total Count: This is the default count, it calculates the total number of times this event was performed in a given period (hour, day, week, month). For example: if “Sam” created 7 flows, the total count will be 7 on a given day.
  • Unique Users/Companies: The total number of unique users/companies who have performed this event in a given period (hour, day, week, month). For example, if “Sam” created 7 flows, the unique count will be 1 on a given day.
  • Active users: the amount of Active Users who have performed this event. Daily (DAU), Weekly (WAU), and Monthly (MAU) Active Users can be selected.
  • Count Per User: Sum of all the events performed by a single user in a given period. Can either be Maximum, Minimum, Average, Median, and Percentiles (90th, 95th, 99th)

  1. Inline Filters (optional)

Inline filters allow you to filter each event separately (as opposed to the Filters tab, which will filter all your selected events at once)

Events can be filtered based on:

  • Events Properties (also called event attributes)
  • User Properties
  • Company Properties

Formula (optional)

Adding a Formula allows you to view the report's result based on a specific equitation, which can assist you in calculating a more advanced query and digging deeper into your data.

You can make calculations with basic arithmetic Operators such as:

    • Add: +
    • Subtract: -
    • Multiply: *
    • Divide: /
    • Use parentheses to influence the order of operations: ()

Adding a new formula:

  1. Click on + Add Formula.
  2. Write the Formula Name
  3. Add the Formula. You can create it using the operators mentioned earlier.
  4. Choose between Automatic (display the equation result as is in the chart) or Percentage (display the equation result as a percentage % in the chart).
  5. After you're done creating your Formula, click on the Apply button


You can filter all your selected events at once by clicking on the Filters tab. Here you can filter them based on User Properties or Company properties to drill down deeper into the analytics


The Breakdown section enables you to examine data based on a specific filter criterion. For instance, you can break down data according to the users' country, this provides insights into user behavior for distinct countries.

Chart Types and Results

There are different types of data visualization options, and each one of them has its own use cases and advantages in displaying data over time.

Chart Calculation 


Linear is a simple line chart with time on the X-axis, and each data point corresponds to the grouping value you chose. It is useful to show the progression of an event over time.


Cumulative shows how the total value of an event changes over time. It is useful for analyzing trends in the accumulation of values over time, such as total sales over time.

Chart Types


A) Line

Shows the progression of one or more events over time. X-axis is time, Y-axis is event value.

B) Stacked Line

Similar to a Line chart, but shows multiple events stacked on top of each other. Useful for comparing values of different events over time.

C) Stacked Bar

Displays the value of an event over time. Similar to a linear chart, but in a different visual manner. Shows values of events as bars instead of lines.


A) Pie

Displays the relative distribution of values of different events over the entire date range. Useful for showing the proportion of different parts of a whole.

B) Bar

Displays the total value of an event over the entire date range. Useful for comparing total values of different events over a specific range of time.

C) Metric

Shows the total numeric value

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.