Hi community,
I created a dashboard and would like to use a variable so that the end-user can easily switch between first-to-first // first-to-last occurrences.
Could you help me with getting the syntax right.
Thank you!
Page 1 / 1
Hi Thorsten,
the error message is raised because of the single quote you have put around the 'value' of your variable. In this part of the formula, we have a statement and not a value.
AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE['Approval PO: L1'] TO <%=TEST%>['Approval PO: L4'], REMAP_TIMESTAMPS("_CEL_P2P_ACTIVITIES"."EVENTTIME", DAYS))) will work perfectly when the variable is either FIRST_OCCURENCE or LAST_OCCURENCE:
regards
Marc
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.