Hi,Yes, you can create a single explore based on a query, also you can define joins relationship in the model.https://cloud.google.com/looker/docs/derived-tableshttps://cloud.google.com/looker/docs/working-with-joins Best regards.

You can edit the manifest.lkml file and include the constants you need in development mode on the branch.

Hi,In manifest.lkml you can add constant values, as shown:constant: name{value: "3.28084"} https://cloud.google.com/looker/docs/reference/param-manifest-constant

In my opinion and from my experience Merge results should be used as one of the last options, since you are running 2 or more queries simultaneously and there is an extra consumption of the Looker instance.Anyway, check each query time to detect if t...