Skip to main content
R381 - 2024-12-13

Query Report and Data Modeler Updates

Updated over a week ago

Show all Report Types in Query

When building reports in Query, all Report Types will show up under the dropdown by default. For reports with a Breakdown and a Measure of Sum, Average, Max, Min Value, Median, or Percentile, Overall will now automatically be turned on. This will allow users to access Line, Bar, Metric, Stacked Column, Percentage Area, and Pie Charts from the dropdown without extra configuration.

For Query Reports with a Measure of Count Events, Unique Users, or Unique Values, the Breakdown Overall toggle remains available to turn on and off. It is only necessary to turn it on if your Breakdown has greater than 100 categories. If a Breakdown has less than 100 categories, it will automatically calculate Overall values.

For any granularities other than All Time, you can also use the date drop-down to see the different dates in a time period. If a Query Report doesn't have a breakdown, all Report Types will remain visible, but Stacked Column, Percentage Area, and Pie Charts will be grayed out.

Date Picker Updates

When selecting dates on a Report, Last, Last Full, Since, and Start Of are all now dynamic date options. This means that every time a Report is run with one of these options selected, the date range will manually update itself.

This feature can be used when scheduling reports for longer lookback windows. It also augments the overall Dashboard experience, as it makes it easier for Dashboard builders to "set it and forget it".

A new report header has also been added to help users distinguish report granularity, whether it's a dynamic or fixed date range, and the dates considered in the report.

Edit Derived Field Definitions

A Derived Field's Definition can now be directly updated from the Data Modeler. Since updating the Definition impacts the calculation of the Derived Field, it should be kept in mind that updating the Definition will also impact Reports that rely on the Derived Field.

Add Schema Descriptions

In the Data Modeler, a Schema Description can now be added. It is on the Configuration page beneath the Schema Name.

When a description is added, it will appear in the Schema's tooltip during Schema selection.

Did this answer your question?