Custom measure on system_activity model

[kirioso]

Hi there, is it possible to make custom measure in system_activity explore ? For example, to fetch latest Scheduled Job for a specific Scheduled Plan.

Something like MAX(scheduled_plan.CREATED_AT).

Will appreciate for any suggestion…

[izzymiller]

While you can’t extend the System Activity model and build your own measures in LookML, you can use Looker’s Custom Fields functionality in the explores!

Looker Documentation

Adding Custom Fields

Add custom dimensions and measures that become new field picker choices.

If that labs feature is turned on, you should see the options at the top of the field picker on the left

, or from the Gear icon on the dimension or measure you’d like to build something custom off of.

[IanT]

Why doesn’t this model allow you to extend it?

[Jonathan_Palme1]

+1. Have wanted to be able to extend i__looker and System Activity models since forever.