Knowledge Drop
Last tested: Dec 16, 2020
Make sure you’re not referencing the LookML field instead of the tables field. This example you can see that the measures sql is referencing this measure itself within the sql which causes the loop;
measure: memberships {
description: ""
type: sum
sql: ${memberships} ;;
}
What you should have is the ${TABLE}.field_name referencing:
measure: memberships {
description: ""
type: sum
sql: ${TABLE}.ended_memberships ;;
}