HR team asked us an interesting modelling question
They want to know the employee average age within the company. As TODAY() function doesn’t exist yet in Pigment, the only option I found so far is to :
1/ Create a metric with today’s day that will need to be updated when required
2/ Allocate a date of birth to each employee in a transaction list or similar
Question : How to write the right formula to get an age (like 36 for 36 yo) result per employee per month taking in consideration the employee base changes over the years, and then be able to determine an average ?
Thank you for your help,
Best answer by NathanView original