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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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

11

Views

1

Comments

Stefano_Mazzocca

Stefano_Mazzocca Rank 6 - Analytics 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 Lead

Nov 26, 2024 11:56AM Answer ✓

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

2