added
R307 - 2023-07-14
about 1 year ago by Stefan Enev
- Include NULL values in result set when applying any negative operator in Filter
- Ability to create Cohorts from any bin in Query and Funnel
Include NULL values in result set when applying any negative operator in Filter
The negative operators in Filter are: !=
, not contains
, not starts with
, not ends with
, not matches
. To explain the change using an example, the query below would previously exclude all Search Content
events for which Show Title
does not exist from the result set.
![](https://files.readme.io/fbe6dae-negative-filter.png)
Null values are displayed as N/A
in Kubit when using Breakdown, so if we add a Breakdown per Show Title like to the example above, we can now see the nulls are included since there is an N/A
group in the results:
![](https://files.readme.io/15558bd-nulls-included.png)
Ability to create Cohort from any bin in Query and Funnel
When you have a Breakdown in Query or Funnel you can now conveniently create a Cohort by right-clicking on top of the bar representing a particular bin.
![](https://files.readme.io/0d8f53f-create-cohort.gif)
Note
- This convenience feature is available only for Bar chart and Funnel chart.
- You also need to be in
Expanded
view (which is default for Funnel with Breakdown and Query withTime Unit = All Time
)