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

Custom metric doesn't work inside dashboard

Received Response
1
Views
1
Comments

Summary:


Content (required):

Hello,

We realize a new custom analysis in order to calculate the #Avg Time To Fill (Days), we use this formula:

AVG( CAST( TIMESTAMPDIFF( SQL_TSI_DAY, "Job Requisition - Dates"."Creation Date" , "Job Requisition - Dates"."Filled Date" ) AS INT))

When we open the dashboard page we have a wrong value, while after we refresh the page we obtain the correct one, calculated also as we open direct the report.

How could we solve this bug, I m attaching the nquery log of the analysis, the catalog file and the screenshot of the problem.


I hope in your help,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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