Pouyan Pourmand
06/03/2026, 9:27 PMMauricio Cabezas
06/03/2026, 9:54 PMPouyan Pourmand
06/03/2026, 11:49 PMstart and end dates on their employment table. for example given an user has selected March to June, how many employees were active using this formula:
start before or on March first and the employment end date on or after June 1stMauricio Cabezas
06/04/2026, 12:34 AMPouyan Pourmand
06/04/2026, 8:39 PMMauricio Cabezas
06/04/2026, 10:02 PMBETWEEN "2026-03-01" AND THIS(DAY)), or do you want users to be able to select the date (month? specific day?) dynamically from a dashboard filter and have the metric react to it?Pouyan Pourmand
06/04/2026, 11:34 PMMauricio Cabezas
06/05/2026, 12:46 AM