Hi,
Currently I am using this formula: AVG(CALC_THROUGHPUT(CASE_START TO LAST_OCCURRENCEE'<%= Activity %>'], REMAP_TIMESTAMPS("DATA_(7)_csv"."COMPLETION_DATE", DAYS)))
This formula works well, however I would prefer if I could actually calculate the dates between two columns, rather than just from one column. Something like this: Start Date - Completion Date
Example :
Thanks,
Terence
Hello Terance,
You can try to assign values from those values into "Save formulas" as Calc_StartDate and Calc_ComplitionDate, then just to include those in OLAP (for scalability and because it's easier to change that in multiple places), then you can just use DATE_DIFF function. For exmaple: DATE_DIFF(dd, Calc_StartDate, Calc_ComplitionDate). Hope that helps. :)
Best regards,
Mateusz Dudek
Hello Terance,
You can try to assign values from those values into "Save formulas" as Calc_StartDate and Calc_ComplitionDate, then just to include those in OLAP (for scalability and because it's easier to change that in multiple places), then you can just use DATE_DIFF function. For exmaple: DATE_DIFF(dd, Calc_StartDate, Calc_ComplitionDate). Hope that helps. :)
Best regards,
Mateusz Dudek
HI, thank you for the reply!
I'm not sure why it isn't working properly. The outputs for the saved formulas are dates. Could you help me with this issue?
Thanks,
Terence
Hi Terance,
Sorry for misleading - change "date_diff" into "datediff".
Example: DATEDIFF( time_unit, table.date_column1, table.date_column2 )
Best regards,
Mateusz Dudek
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
