Last tested: Jan 8, 2020
Say you want to see a user's first and last query dates. This could be pretty difficult because it is in system_activity so you can't edit the lookml, and you can't easily min/max dates.
We will use a combination of Custom Dimensions, Custom Measure and Table Calcs to achieve this.
Here is a picture of what that looks like.
diff_days(${history.created_date},now())
add_days(${day_diff_1},now())
add_days(${day_diff_2}*-1,now())
With the above steps we can easily create a first instance and last instance date per dimension.
This content is subject to limited support.