search

GoogleCloudPlatform / data-science-on-gcp

Source code accompanying book: Data Science on the Google Cloud Platform, Valliappa Lakshmanan, O'Reilly 2017
Apache License 2.0
1.31k stars 715 forks source link

Chapter 3 - Datastudio Pie chart flights #24

Closed joozz closed 4 years ago

joozz commented 6 years ago

When setting up the "islate" definition, the current formula is

CASE WHEN (ARR_DELAY_copy < 15) THEN "ON TIME" ELSE "LATE" END

the brackets are not accepted, so the formula shall be:

CASE WHEN ARR_DELAY_copy < 15 THEN "ON TIME" ELSE "LATE" END

See: https://support.google.com/datastudio/table/6379764?hl=en