Date Drills

Introduction

When a visualization has a date/date-time axis, you can drill in different time levels (year, quarter, month, date, hour, minute).

Simply right-click on the chart โ†’ select a period โ†’ the chart will show the values aggregated up to that time period.

Mechanism

Date Drills only affects the result set of your SQL report

Date Drills does not alter the SQL of your report - it only performs aggregations on the resulted data. Do take care when you work with averages or ratios to avoid incompatible drillings.

For example, your original result set contains Daily average order value (AOV). Using Date Drills to aggregate it to Monthly level may not make sense as you will take average of averages.