Calculated Field: Last Seen

Lets jump in creating a last seen calculated field.

We'll go to the admin tab and we'll go to calculated fields.

Let's add a new one and the object type we want here is employees.

We'll add a title for our calculated field like Last seen and we'll click create.

Since we want a filter bucket field, let's add our first bucket.

In this case, we'll title it Last 7 Days.

Next we'll add our field to match and what we're looking for here is the last active date.

We'll select our matcher for is in the date range and we'll set this to in the last seven days and we'll include today.

Let's go ahead and add a new bucket and we'll say for the last 30 days we'll click submit.

We'll go ahead and update our in the last and we'll make this 30.

Add one more bucket and we'll say in the last 90 days we'll update the in the last again and we'll make that say 90.

All right, now we have our last seen calculated field.

Let's build a report to see what this looks like.

We'll switch our subject to employees and we'll select a field.

In this case, we're looking for the last seen calculated field we just created.

We can now see our calculated field grouping all of our active employees by their last active date.

We can see here there's currently only two, but if you're following along in your instance, you'll probably see a more interesting chart.

It