Fixed Calculations and Other Level of Detail Functions

[corey_gaunt-163]

Hello fellow Lookers,

I am relatively new to using LookML and I am coming from a long time working with Tableau and their calculated fields. 

Is there an easy way to incorporate fixed calculations and other LOD functions when constructing views? 

The best route I’ve found for constructing fixed calculations is to created a derived table view, then join that view into my explore. If that is the best way to accomplish these types of calc, that is fine, but I have to imagine that there is a better way.

Seems wasteful to create a table for one dimension / measure.

Any and all advice is welcomed!