Hello everyone,
I would appreciate if anyone can help me, I would like to draw a bar chart which it's drill-down dimension includes the year, half-year, quarter, and month, how can I calculate the average tenure of organization which calculates base on the sum of tenure of all employees divide on the count of the number of employees in each month, year and quarter, based on the selected dimension?
I write below formula but it dosen't work :
sum(aggr(sum(TOTAL_TENURE)/Count(PERSON_ID),$(='['&GetCurrentField([drill])&']')))