| CARVIEW |
Select Language
HTTP/2 200
date: Sat, 11 Oct 2025 07:35:35 GMT
content-type: text/html; charset=UTF-8
server: cloudflare
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 1;mode=block
vary: accept-encoding
cf-cache-status: DYNAMIC
content-encoding: gzip
set-cookie: _csrf-frontend=1137c5696d02a621a92167713b75df419794ad55df08f2d37c83db074cad8887a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22wulq9aTbks26joXLXZ-xZQUkWsScIBDP%22%3B%7D; HttpOnly; Path=/
cf-ray: 98ccae7c4c4cc181-BLR
{% set tf = get_time_filter("date", remove_filter=True, target_type='DATETIME') - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {% set tf = get_time_filter("date", remove_filter=True, target_type='DATETIME') %}
- SELECT
- product,
- /* продажи за выбранный на фильтре период */
- sumIf(qty, date >= {{ tf.from_expr }} AND date < {{ tf.to_expr }}) AS qty_cur,
- /* продажи за такой же период год назад */
- sumIf(qty, date >= addYears({{ tf.from_expr }}, -1) AND date < addYears({{ tf.to_expr }}, -1)) AS qty_prev,
- /* абсолютное отклонение и % */
- sumIf(qty, date >= {{ tf.from_expr }} AND date < {{ tf.to_expr }})
- - sumIf(qty, date >= addYears({{ tf.from_expr }}, -1) AND date < addYears({{ tf.to_expr }}, -1)) AS qty_yoy_diff,
- if(
- sumIf(qty, date >= addYears({{ tf.from_expr }}, -1) AND date < addYears({{ tf.to_expr }}, -1)) = 0,
- NULL,
- (
- sumIf(qty, date >= {{ tf.from_expr }} AND date < {{ tf.to_expr }})
- - sumIf(qty, date >= addYears({{ tf.from_expr }}, -1) AND date < addYears({{ tf.to_expr }}, -1))
- )
- / sumIf(qty, date >= addYears({{ tf.from_expr }}, -1) AND date < addYears({{ tf.to_expr }}, -1))
- ) AS qty_yoy_pct
- FROM sales
- GROUP BY product
Tags:
superset
Advertisement
Add Comment
Please, Sign In to add comment
-
⭐⭐⭐ChangeNOW Exploit⭐⭐
Java | 1 sec ago | 0.10 KB
-
✅⭐ Make huge profits on trading ⭐⭐ D
JavaScript | 2 sec ago | 0.24 KB
-
✅⭐ Make $2500 in 15 minutes ✅ NEVER SEEN BEFO...
JavaScript | 3 sec ago | 0.24 KB
-
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ T
JavaScript | 7 sec ago | 0.24 KB
-
⭐✅ MAKE $2500 IN 15 MIN⭐⭐⭐ L
JavaScript | 13 sec ago | 0.24 KB
-
⭐⭐⭐ G2A Payment Exploit ✅ NEVER SEEN BEFORE ⭐...
JavaScript | 13 sec ago | 0.24 KB
-
⭐⭐⭐Make $1500 in 20 minutes⭐⭐
Java | 14 sec ago | 0.10 KB
-
⭐✅ Swapzone Glitch ✅ Working⭐⭐⭐ V
JavaScript | 18 sec ago | 0.24 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
