What's new in Customer Journeys?

Connect and learn more! ×
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?

Received Response
14
Views
1
Comments
edited Oct 27, 2023 9:43AM in Reporting and Analytics for HCM 1 comment

Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my formula or change my formula in order to load the report much faster?

Content (required): ((Invalid_grad_until + Invalid_grade) / Total #) *100

KPI formula needs to be enhanced/optimized to reduce load time of the report.

Version (include the version you are using, if applicable):

23B

Code Snippet (add any code snippets that support your topic, if applicable):

(((COUNT(CASE WHEN (NOT("Workforce Management - Person Real Time"."Person Legislative Information"."PER_PERSON_LEGISLATIVE_DFF_GRADUATE_UNTIL_" BETWEEN (TIMESTAMPADD(SQL_TSI_MONTH, 3,  "Worker"."Enterprise Hire Date")) AND (TIMESTAMPADD(SQL_TSI_MONTH, 24, "Worker"."Enterprise Hire Date")))) THEN "Worker"."Person Number" ELSE '' END)) + (IFNULL((FILTER("Worker Assignment"."Head Count" USING (CAST((CASE WHEN "Grade"."Grade Code" IN ('Dummy DM - Grade', 'N/A', 'Unknown') THEN '0' ELSE "Grade"."Grade Code" END) AS NUMERIC) >= 15.1))),0))) / (FILTER("Workforce Management - Person Real Time"."Person"."Person Count" USING "Workforce Management - Person Real Time"."Person Legislative Information"."PER_PERSON_LEGISLATIVE_DFF_GRADUATE_UNTIL_" IS NOT NULL))) * 100

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!