When we request data for February 2020 everything work fine, but when we request data for April 2020 - get the following error: Argument type mismatch in function LESS: 'layouy_instability.cumulative_layout_shift.histogram is type bytes, '0.1000' is type double.
(https://yadi.sk/i/SycCFAbJXHhHdQ)
SELECT
origin,
form_factor.name,
-- Cumulative Layout Shift
COUNT(layout_instability.cumulative_layout_shift.histogram.bin.start) as cls_count,
SUM(
CASE WHEN layout_instability.cumulative_layout_shift.histogram.bin.start < 0.1
THEN layout_instability.cumulative_layout_shift.histogram.bin.density
END
) / sum(layout_instability.cumulative_layout_shift.histogram.bin.density) as cls_good,
SUM(
CASE WHEN layout_instability.cumulative_layout_shift.histogram.bin.start >= 0.1 AND layout_instability.cumulative_layout_shift.histogram.bin.start < 0.25
THEN layout_instability.cumulative_layout_shift.histogram.bin.density
END
) / sum(layout_instability.cumulative_layout_shift.histogram.bin.density) as cls_needs_emprovement,
SUM(
CASE WHEN layout_instability.cumulative_layout_shift.histogram.bin.start >= 0.25
THEN layout_instability.cumulative_layout_shift.histogram.bin.density
END
) / sum(layout_instability.cumulative_layout_shift.histogram.bin.density) as cls_poor
FROM
[chrome-ux-report.country_ru.{yearMonthInput default="202001" type="input"}]
WHERE
origin in (
'https://lenta.ru', 'https://m.lenta.ru',
'https://www.gazeta.ru', 'https://m.gazeta.ru',
'https://www.championat.com', 'https://m.championat.com',
'https://news.rambler.ru', 'https://www.afisha.ru', 'https://daily.afisha.ru',
'https://price.ru', 'https://rambler.ru', 'https://video.rambler.ru',
'https://doctor.rambler.ru', 'https://travel.rambler.ru', 'https://sport.rambler.ru',
'https://weekend.rambler.ru', 'https://horoscopes.rambler.ru', 'https://weather.rambler.ru',
'https://kassa.rambler.ru', 'hattps://afisha.rambler.ru', 'https://woman.rambler.ru',
'https://auto.rambler.ru', 'https://tv.rambler.ru', 'https://top100.rambler.ru',
'https://dating.rambler.ru', 'https://games.rambler.ru', 'https://mail.rambler.ru', 'https://finance.rambler.ru', 'https://eda.ru',
'https://www.ferra.ru', 'https://indicator.ru', 'https://secretmag.ru', 'https://motor.ru', 'https://www.passion.ru',
'https://quto.ru', 'https://rns.online', 'https://www.wmj.ru', 'https://autorambler.ru',
'https://www.livejournal.com', 'https://letidor.ru', 'https://moslenta.ru'
)
GROUP BY origin, form_factor.name
ORDER BY origin, form_factor.name
LIMIT 1000