Kubit allows a lot of flexibility in what you create and how you can use and reuse it. When you build a Measure, Filter, or Event and then possibly want to access it multiple times this article is for you!

Subject

A Subject can vary depending on your use cases. They are customized to your specific data model and can be updated or added to as needed.

Subjects are typically:

Examples in Kubit:

• In a Query, you would count Unique User IDs that performed an event.
• In a Funnel, you would analyze the conversion of Visitor IDs through a funnel.
• In Retention, you would analyze the retention rate of Customer IDs.

Measures

Measures are only available in Query and Data Tables. They include one Function (e.g. "Count Events" or "Unique Users") applied to at least one set of Events each can have its own Event Filters.

Create a Measure

You can build a new Measure as needed within each report type

Compound Measures

If you need to add or divide two measures, check out the Compound Measures section of our Query article to learn more about them.

Saving and Updating Measures

When Measures are complicated or defined business logic, it may be hard for everyone across multiple teams to remember all the details. Luckily, it only has to be defined once and can then be saved in Kubit.

1. Build the Measure you want to save and Execute the Report.
2. In the Measure options beneath the report visualization click the vertical 3 dot menu that appears when you hover over it.
3. Click "Save Measure".
4. Complete all necessary inputs and apply any necessary formatting.
5. Click Create or Update depending on what you intend to do.

📘

Saving a measure requires assignment of the appropriate role

If you are unable to Save a Measure, it may be due to your Access Level. Please contact your Kubit Admin to request those permissions.

Filters

Filters are the constraints applied during your analysis to limit the results. There are two ways to control the filtering in your queries:

• Event filter - filters applied to the events
  • These filters will be to the right of each event you've selected. This means only that event will be filtered by the conditions you set.
• Global filter - These filters appear below all the measures or query definitions. There are Global, Cohort and Measure filters.
  • The first is Global and allows you to add filtering using the same approach as with the event filter
  • The Cohort can be used to filter results by a cohort that you might have previously defined. Check out how to create a cohort .
  • The Measure filter allows you to use groups of events. See how to how to create and save a measure to learn how to create groups of popular measures that can be re used.

🎥 Watch our Filter Training Video

They will filter the results for the entire query and all events included.

Each filter contains three parts: Field, Operator, and Value.

Field: a field of the data model. For example: 'App Version', 'Device Name', 'OS', 'User Type'.

• JSON or BigQuery Struct fields can expose their internal data for filtering or breakdown through Nested Properties.

Operators: the logic of when to include/exclude specific values

Value(s) : Depending on the Field data type and selected Operator, there can be multiple values to be selected from a list of lookup values, or manually entered. This means selecting multiple values from the drop down will result in an OR condition on these selections.

For example: I create a filter like platform = "iOS, Android" I am selecting rows where the Platform field is "iOS" OR "Android" in order to be returned.

Case Sensitive Filters

In Kubit we default to text filters being Case Sensitive, meaning if you filter to subscription_type = 'Premium' then the underlying data must have the capital 'P'. If you have instances where the cases are mixed within a column you can disable case sensitivity by clicking the "Aa" button.

If it's blue then it's enabled and grey is disabled.

Filter Against Other Fields

Occasionally it's not a specific value you want to filter by but rather if the value of Column A = the value of Column B. In Kubit you're able to do this by clicking the "V" button and selecting the column you want to compare in the filter logic.

Filter Groups

Both Event Filter and Global Filter support up to three Filter Groups which are connected with a logic operator 'AND'/'OR'. You can think of each Filter Group as a parenthesis.

Saving Filters

Similar to other items, if you find yourself creating the same filters or they are complex you can save them and give them a more meaningful name by clicking the vertical 3 dots that appear next to the filter. Once saved you can reuse this filter across all charts.

📘

Deleting a Named Filter

To delete a Named Filter you must go to the Dictionary page and then to Filter. Locate your filter and then delete it.

Breakdown

When you're analyzing data it's important to be able to slice it by various attributes of the User or Event. Breakdowns allow you to group the results by these fields and even Bin them into more meaningful groups in Query .

Breakdown by a Field: Select the field you want to break down by to see results grouped based on the values of that field. These can be things like "User Type" or "Subscription Mode".

🎥 Watch our Breakdown Training Video

Custom Binning

• Breakdown with Binning
  • When you'd prefer to group values inside of the breakdown into groups or "bins" we've made that available in the Breakdown feature.
  • Select the field you want to break down by and click the context menu to expose "Add Binning"
    • You can bin items based on their values, Value Binning, or ranges of integers, Range Binning. Based on the data type you've selected you may see only one or both.
• Saving Named Binning
  • Once you've created your bin you can save it for reuse by clicking the down arrow in the top right corner of the bin groups above the first bin.

Segments

Within each report type, you're able to add Segments of subjects to breakout the results by if a Subject is a member of a Segment. The best way to think of this is rather than breaking down by a value within a field, you're breaking down by the behavior of a group of subjects. Segments are a type of Cohort that you construct within the Report builder.

Here is a quick example:

You want to see the conversion rate of a checkout funnel but you need to see if the conversion rate is different for Users who have Enabled Notifications.

Enable Notification is an Event and not part of the checkout funnel...so how do you add this logic to your Funnel Report?

The answer: Segments

You will create a Segment of Users who performed the "Enable Notifications" event and then compare it to the Overall group. You're also able to create another Segment of Users who did NOT perform the "Enable Notifications" event and to ensure the groups are mutually exclusive.

How to Interpret Segment Results

Once you've created the Segments you want to break out by you'll see each Segment denoted in the Report with its color. If each Segment is using the same name or it's not very human-readable you're able to rename them by clicking on the action menu.

How to Rename Segments

To Rename a Segment you will click the 3 dots next to the Segment below the Report and then select "Rename".

Save Segment as a Cohort

If you've created a Segment you want to re-use the best thing to do is create a Saved Cohort from it. You're also able to Save a Cohort from a specific date range within your report to investigate further.

Save Report Settings

After a report has been executed you're able to customize the visualization based on how you want the data represented.

These include:

• Report visualization type (i.e. show it as a line, bar, metric, or pie).
• Renaming your Measures.
• Hiding/Showing breakdown groups.
• Adding Measure Formatting (i.e. show the result as a percentage).

Once all modifications have been made you must Save your Report Settings. You can do this by clicking the Save button at the top right side of your Report.

Tooltips & Inspect

In Reports, a tooltip will appear when users hover over the chart. These new tooltips feature:

• Support for Query, Funnel, Path and Retention Report Types.
• Support for Line, Bar, Stacked Column, and Percentage Area visualizations in Query.
• Percent change between data points will appear on hover in Query Reports.
• For Line and Percentage Area charts, users must hover over a point on the chart to see the percent change.
• For Bar and Stacked Column charts, users only need to hover over the bar. This allows users to quickly grasp differences in data over time.

Left Click on Tooltips

Left click on all supported charts except Path opens Create Cohort and Inspect User actions. You're also able to create an Incident directly from the Report. This helps other users see major disruptions or launches to explain shifts in the results.

In Path, users can choose Select Path, Create Funnel, Combine with Others, and Combine with Others Globally. The Combine with Others option allows for a specific path to be hidden on the overall chart. In Query, you can also select Create Incident.

Next Steps

The "Next Steps" section allows you to take all of your Report's settings and bring them over into another Report Type.

This section is beneath the results once you execute your report.

All measures, filters, breakdowns, segments, and date ranges from one report can be brought over to the next. Select the Report Type you want to transfer your settings to in the "Next Steps" menu.