layouts/shortcodes/sql/window-frame-units..html
{{ $unit := .Get 0 | default "groups" }} {{ if eq $unit "groups" }}
| time | country | city | wind_direction |
|---|---|---|---|
| 2025-02-17T00:00:00 | France | Strasbourg | 181 |
| 2025-02-17T01:00:00 | France | Strasbourg | 228 |
| 2025-02-17T02:00:00 | France | Strasbourg | 289 |
| 2025-02-17T00:00:00 | France | Toulouse | 24 |
| 2025-02-17T01:00:00 | France | Toulouse | 210 |
| 2025-02-17T02:00:00 | France | Toulouse | 206 |
| 2025-02-17T00:00:00 | Italy | Bari | 2 |
| 2025-02-17T01:00:00 | Italy | Bari | 57 |
| 2025-02-17T00:00:00 | Italy | Bologna | 351 |
| 2025-02-17T01:00:00 | Italy | Bologna | 232 |
| 2025-02-17T02:00:00 | Italy | Bologna | 29 |
{{ else if eq $unit "groups with frame" }}
| time | country | city | wind_direction |
|---|---|---|---|
| 2025-02-17T00:00:00 | France | Strasbourg | 181 |
| 2025-02-17T01:00:00 | France | Strasbourg | 228 |
| 2025-02-17T02:00:00 | France | Strasbourg | 289 |
| 2025-02-17T00:00:00 | France | Toulouse | 24 |
| 2025-02-17T01:00:00 | France | Toulouse | 210 |
| 2025-02-17T02:00:00 | France | Toulouse | 206 |
| 2025-02-17T00:00:00 | Italy | Bari | 2 |
| 2025-02-17T01:00:00 | Italy | Bari | 57 |
| 2025-02-17T00:00:00 | Italy | Bologna | 351 |
| 2025-02-17T01:00:00 | Italy | Bologna | 232 |
| 2025-02-17T02:00:00 | Italy | Bologna | 29 |
{{ else if (eq $unit "range interval") }}
| time | room | temp |
|---|---|---|
| 2022-01-01T08:00:00 | Kitchen | 21.0 |
| 2022-01-01T09:00:00 | Kitchen | 23.0 |
| 2022-01-01T10:00:00 | Kitchen | 22.7 |
| 2022-01-01T11:00:00 | Kitchen | 22.4 |
| 2022-01-01T12:00:00 | Kitchen | 22.5 |
| 2022-01-01T13:00:00 | Kitchen | 22.8 |
| 2022-01-01T14:00:00 | Kitchen | 22.8 |
| 2022-01-01T15:00:00 | Kitchen | 22.7 |
{{ else if (eq $unit "range numeric") }}
| time | city | wind_direction |
|---|---|---|
| 2025-02-17T13:00:00 | Rome | 33 |
| 2025-02-17T08:00:00 | Rome | 34 |
| 2025-02-17T23:00:00 | Rome | 49 |
| 2025-02-17T17:00:00 | Rome | 86 |
| 2025-02-17T11:00:00 | Rome | 93 |
| 2025-02-17T12:00:00 | Rome | 115 |
| 2025-02-17T10:00:00 | Rome | 156 |
{{ else if (eq $unit "rows") }}
| time | city | wind_direction |
|---|---|---|
| 2025-02-17T08:00:00 | Rome | 34 |
| 2025-02-17T10:00:00 | Rome | 156 |
| 2025-02-17T11:00:00 | Rome | 93 |
| 2025-02-17T12:00:00 | Rome | 115 |
| 2025-02-17T13:00:00 | Rome | 33 |
| 2025-02-17T17:00:00 | Rome | 86 |
| 2025-02-17T23:00:00 | Rome | 49 |
{{ end }}