Coming Soon! We’re launching a new sub-community within the Google Cloud Community dedicated to cloud security: The Google Cloud Security Community. In preparation for the launch, this site will be in read only mode from 22 September 12am PST - 23 September 7pm PST
I’ve figured out how to calculate a 12-month trailing average (TTA) in a look for the purpose of understanding trends. Here’s how I did it. It requires the use of a custom filter to select the right data and then a table calculation to get the result.
Step 1 - Custom Filter
In your new Look, create a Custom Filter to select the 12 months previous to the last completed month. Using a date-month field, here’s the formula: