Can you generate a dashboard that exhibits {metric} based...

Can you generate a dashboard that exhibits {metric} based on {criteria} within the {time period}, accompanied by a distinct segment showcasing the {metric} of {employee group} who have maintained their tenure with the company for {time period} but have not attained a promotion? I intend to utilize this information to pinpoint areas where we can enhance employee retention.