I’m trying to create a calculated field that includes moving averages.
My client calculates a turnover rate as the count of the distinct id of terminated employee_id (identified as terminated = 1) over the average active (actives defined as active=1)
average is = to the sum of count distinct IDs of the current month +count distinct ids previous month /2.
As I’ll have to offer several filters and breakdowns (gender, region, etc) on it doing blendindings doesn’t seem to be a good approach. Is it possible to perform this kind of calculation with Looker Studio, or is BigQuery required to do it?