How to use data studio for beginner's.

Eaiest thing to do is learn the basics and then use a template.

Get the report to update automatically by setting tue date range as "last month"

Code mentioned for day of the week:

CASE
WHEN Day of week IN ("Monday") THEN "1"
WHEN Day of week IN ("Tuesday") THEN "2"
WHEN Day of week IN ("Wednesday") THEN "3"
WHEN Day of week IN ("Thursday") THEN "4"
WHEN Day of week IN ("Friday") THEN "5"
WHEN Day of week IN ("Saturday") THEN "6"
ELSE "7"
END

My blog - [ Ссылка ]

свернуть