Hi Chris, What are the additional errors you are getting when trying convert to New LookML? Could not find a field named "datatable.companyaccountid" basic_model:42

In Setup, paragraph 3, found it necessary during setup to be in the swagger-codegen directory: ###3. Download the Swagger-Codegen tools from github. cd looker_sdk git clone git@github.com:swagger-api/swagger-codegen.git ./swagger-codegen cd looker_sd...

Comment removed.

Here is another pattern using CASE WHEN to build a nifty heatmap. sql: | CASE WHEN (1.0 * ${field1} / nullif(${field2},0)) &lt; 1 THEN 1.0 * ${field1} / nullif(${field2},0) WHEN (1.0 * ${field1} / nullif(${field2},0)) &gt;= 1 AND (1.0 * ${field1} / nullif(<!-- --><!-- --><!-- -->...