Derived Metrics Creation

How can we create derived metrics in dremio, other than calculated field. calculated filed is computed at least granular level, where as few metrics need to be evaluated at other granularity.

Please help me with this.