I have been getting this error in a Look .
I narrowed it down to one particular field , but the same field works fine in an another look so i am not sure what the exact problem is at this point.
I recently added a link to the troubled field , so i am not sure if that caused the problem but when i validate the lookml i donot see any errors
And also when i run the same query including the troubled field in sql runner it just runs fine and gives me the result. Any idea why this is happening?
Best answer by sri75
It took me sometime but i resolved the issue. Within the URL i set for this field it was referencing a field that doesnt have any connection in the explore , hence it is not working.
Once i included the viewin the explore and gave the appropriate join it started to work.