To GoodData homepage

Topics started by Dipper

1 Topic

D
DipperNew Participant
asked in Metrics and MAQL

Filter Date in Metric

Hi Community,Our HR team are wanting to do 90 Day Turnover by restaurant.  I’ve been able to create the below metric that I can use in a report to bring me back by employee by site however the date is a fixed date.  Any suggestions for how to use a single date within the dashboard filter instead of having it written into the metric?  Ideally I was hoping to get something along the lines of excel with Today() then that date to be overwritten when filtered in the dashboard.Currently the date 11/28/2021 is the period end, I would like this to be dynamic.New Starter MetricSELECT IF (Employee Start Date (HR_Events) + 91 > 11/28/2021 AND Employee Start Date (HR_Events) <= 11/28/2021) THEN 1 ELSE 0 ENDLeaver MetricSELECT IF Employee Start Date (HR_Events) +91 > 11/28/2021 AND Employee Termination date (HR_Events) <= 11/28/2021 AND Employee Termination date (HR_Events) <> 01/01/1900 THEN 1 ELSE 0 ENDThanks in advance

1
Iva Gasparekova
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings