Grain
Grain controls how date fields are truncated in queries. It's the time resolution of your results.
Available grains
| Grain | Truncates to | Example |
|---|---|---|
| Day | Calendar day | 2024-05-15 |
| Week | Monday of the ISO week | 2024-05-13 |
| Month | First of the month | 2024-05-01 |
| Quarter | First of the quarter | 2024-04-01 |
| Year | First of the year | 2024-01-01 |
Changing grain
Use the Grain toggle in the top bar (Day / Wk / Mo / Qtr / Yr). The query re-runs automatically.
When grain is disabled
Grain is disabled if no date field is selected in the query. Add a time field to enable grain selection.
Effect on charts
The grain affects how dates are labelled on chart axes:
- Day → "May 15"
- Week → "W20 '24"
- Month → "May 2024"
- Quarter → "Q2 2024"
- Year → "2024"