Introduction
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. 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.Usecases
- 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.- First, click on Analytics on the dashboard. Then click on Trend.

- 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.
Events
-
First, you need to click on Users. Here you can choose whether you want to analyze the data on a user or company level.
-
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.
- Select Count Type
- 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)

- 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: ()
- Click on + Add Formula.
- Write the Formula Name
- Add the Formula. You can create it using the operators mentioned earlier.
- Choose between Automatic (display the equation result as is in the chart) or Percentage (display the equation result as a percentage % in the chart).
- After you’re done creating your Formula, click on the Apply button

Filters
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
Breakdown
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







FAQs
How can I calculate MAUs using a Trends report?
How can I calculate MAUs using a Trends report?
To get an accurate number of MAUs, you can select 
Any Event
with filter
source
equals
web-client
as shown below:\
Can I get the User Engagement data breakdown by a custom company property?
Can I get the User Engagement data breakdown by a custom company property?
No, currently user events data cannot be brokendown by a custom company
property unless the custom company property is being passed as a user
property. Our dev team is actively working on providing the support for this
ability in the future.