The system will not subtract an int from a date. The whole problem is trying to figure out how to convert a date to 90 days before the entered date.
I have played around with the DayofYear function in filters and derived metrics, but I still cannot get it to work.
Thanks anyway.
I understand exactly what you are saying and this should work, but P1 is of type date and 90 is of type int. It will not subtract an int from a date. Is there a way I can use the DayofYear function to turn P1 into an int, subtract the two, and then turn that number back into a date?
Thank you...
I want to take a prompt answered date, P1, subtract 90 days from P1 to get P2 and end up with a date range of P2 to P1. I have played with the following syntax, but I cannot figure out a way to replace P2 with (P1-90 days) since "90" is not of type "date".
ApplyComparison...
I am not finding the function parameter listing for the count function. Am I supposed to be modifying the function or the metric? Could you please be more specific as to how to change it to "true"?
Thank you so much for your help!!
How do you accurately count the number of reports, not the number of jobs, that a user has run over a certain period of time in EM?
By running simple test reports, it is known that a job is NOT the same as a report. Running two reports may give a total job count of 4, when I really want to see...
When exporting a report to Excel, 40260 rows, it times out after exactly 2 minutes with the Export using plain text option. I have tried the guidelines in TN5600-7X0-0276, set the Request timeout to 3600 seconds, increased the JVM Heap Size to 256 MB, and increased the ASP Script Timeout/...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.