R318 - 2023-09-28

New Table view, Rolling Measures, Breakdown Filters and Report Names

Updated over a week ago

Table View in Query

Since you can plot only so many lines on a chart, table view is particularly useful when working with multiple Measures or Breaking down by a high-cardinality field such as Country or Screen Title. While the Chart is limited to 20 Breakdown Groups which can be displayed together, in the table view you can browse up to 100 Breakdown Groups:

You can switch between 3 different ways to view Query results:

  • Chart and Table (default)

  • Chart

  • Table

The view option is not part of Chart Settings and cannot be saved, so whenever you share a report with somebody else they will always open it in Chart and Table view.

Constraints

  • A Query can only be displayed in Chart view on a Dashboard or Workspace.

  • Table is limited to 100 rows

Rolling Measures

Want to know what's your weekly/monthly active users on a daily basis? Or what's the moving average for any given day? Rolling Measures is a new feature designed to help you get those answers.

Rolling Options

  • Rolling Sum - for every day of the date range apply the Measure Function and do a sum of the Measure values for the last X days (including the current day)

  • Rolling Average - for every day of the date range do an average of the measure values for the last X days (including the current day)

  • Rolling Window - for every day of the date range apply the Measure Function over the date range window

Constraints

  • Rolling Measures cannot be part of Compound Measures

  • Rolling Measures can span a maximum of 90 days

Breakdown Filters

In some cases it's too much of a hassle to filter out all the unnecessary Breakdown Groups from an already generated Chart. So now you can apply a Breakdown Filter to make sure some groups are excluded during report execution:

For the sake of argument, let's say we want to exclude one of the 3 available Plan Type values from the Breakdown. We can do it like this:

Once the report is executed there is no Premium Plus group on the Chart:

Breakdown Filters are available for all types of Reports.

Report Names

Based on your feedback Kubit will now generate descriptive names for every report in order to improve navigation through History and Search. Here's a couple of examples:

There are a few abbreviations you may notice in the examples above such as TTC and Ret. Here's the full list of such abbreviations and what they mean:

  • In Retention:

    • Retention → Ret.

    • Retention Over Time → Ret OT.

    • User Interval → Ret UI.

    • User Interval Over Time → Ret UIOT.

  • In Funnel:

    • Conversion → Conv.

    • Time to Convert → TTC.

    • Frequency → Freq.

Did this answer your question?