Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Key Metric to count years from Enterprise Hire Date to now

Accepted answer

12

Views

1

Comments

Stefano_Mazzocca

Stefano_Mazzocca Rank 6 - Analytics & AI Lead

Nov 26, 2024 11:42AM in Oracle Fusion Data Intelligence

I'm trying this but for the same Enterprise Hire Date I got different results. Why?

I also tried the following but I got similar results:

SUM(TIMESTAMPDIFF(SQL_TSI_YEAR, "HCM - Workforce Core"."Employment Information"."Enterprise Hire Date", CURRENT_DATE))

Tagged:

FDI

0

Best Answer

Stefano_Mazzocca Rank 6 - Analytics & AI Lead

Nov 26, 2024 11:56AM Answer ✓

It's not about create a Key Metric but a Calculation

2