Exploring Cohorts
How to get the required insights from Cohorts?
When we select the required entity, the Cohort is created!
You can create detailed cohorts of your business entities using lookup consoles. Let's take a look at the various actions that can be taken here.

How can I change the service area or the city in Cohorts?

You can change the location of the cohort by clicking on the map icon at the top and selecting the desired location.

How can I change the time period for Cohorts?

In order to change the time period for cohorts, click on the calendar icon on the top left.
Once the window opens, the users can either:
  • Enter custom time periods (For example, Jan 16, 2020, to Jan 23, 2020)
  • Choose "Today", "Last 2 days", "Last 60 days" and so on.

How do I add more columns to Cohorts?

In order to add more columns to Cohorts, click on the "Add columns" option in the top right corner.
The users can add two types of columns to the entity consoles:

Entity Property

This allows users to add entity properties to the table. These could be the user id, amount, revenue, and so on.

Entity Metrics

This allows the users to create metrics to calculate the data of their entity. For example, if you want to understand average revenue per user, time taken for each trip by the user, orders of the users and so on.

How to add an entity property column on Cohorts?

  • In the top left corner, click the Add Column button.
  • Select the Entity Property option from the drop-down menu.
  • Select the desired properties. For example, user_id, user age, revenue and so on.
  • Click the Apply button.

How to add an entity metric column on Cohorts?

One of the most powerful aspects of Entity Consoles is the ability to create cross-entity metrics without having to worry about joins or writing a single line of SQL. Instead of joining tables across databases.
Locale's Entity Consoles assist you in gaining meaningful insights by creating cross entity metrics such as Orders per rider, Revenue per vehicle, Profit per User, and much more!
  • In the top left corner, click the Add Column button.
  • Select the Entity Metric option from the drop-down menu.
  • Select the desired metric type you want to create
  • Fill in the required fields and add the filters
  • Click the Apply button.

What are the various types of entity metric columns that can be added to the Cohorts?

The users can add three different types of metrics on the entity metric column console.
Entity Property Metric
This metric allows you to add entity properties (e.g.- user id, amount, average revenue per user) to the table.
For example, What is the count of the total km driven by the bike
Read more about how to create it here:
Event Count Metric
This metric calculates the number of times an event has occurred at an asset, e.g.- the number of trips started from a particular point.
For example, What is the unique count of the users that have cancelled in a particular area.
Read more about how to create it here:
Time Difference Metric
This metric calculates the time taken between any two events. For example, what is the time taken for short-distance trips, time taken between orders started and orders completed, and so on.
For example: How long does an order take to reach one of the remote areas?
Read more about how to create it here:

Can I apply filters to different columns in Cohorts?

Yes, the users can dissect the lookup table with powerful filters on top of columns and drill down to entities with specific properties, metric values, or thresholds. You can then save these filters to represent user behaviours, vehicle properties or almost anything based on the properties or metrics as cohorts!
  • First click on the entity filters option
  • Next, click on add filter
  • Choose the column you want to add a filter for and set the values accordingly.
For example: user_age > 30, order_amount < $50, idle_time <40 hours and so on
  • Click on apply to complete the process.

How do I sort the columns in the entity console?

The entity console's columns can be sorted in either descending or ascending order. Select the Sort option from the drop-down menu after clicking on the column you want to sort.
  • Select A-Z for ascending order.
  • Select Z-A for descending order.
And click on Apply sort.
Adding the sorting filters
In order to delete or change the sorting of the entity columns, click on the Sort option and delete.
Removing the sorting filters

How do I view my entities on the map in Cohorts?

You can view the entities on the map in Cohorts by enabling the geo view.

What insights can we draw from the entity console?

Copy link
On this page
How can I change the service area or the city in Cohorts?
How can I change the time period for Cohorts?
How do I add more columns to Cohorts?
How to add an entity property column on Cohorts?
How to add an entity metric column on Cohorts?
What are the various types of entity metric columns that can be added to the Cohorts?
Can I apply filters to different columns in Cohorts?
How do I sort the columns in the entity console?
How do I view my entities on the map in Cohorts?
What insights can we draw from the entity console?