Relative Date Filter for Agent — 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

Relative Date Filter for Agent

edited Oct 10, 2019 1:32PM in Reporting and Analytics for HCM 2 comments

Summary

How do you put a relative date filter on an agent for an analysis?

Content

When creating agents for analyses, we would like to have agents that run with prompted filters on relative dates. I know that you can add a relative date filter in the analysis as a SQL filter. For example, for a report that runs weekly and pulls data from the previous seven days, "date variable" > TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE). However, we are looking to have more advanced capabilities in terms of the reports that we are able to run, i.e. a filter for the CURRENT week (a report that runs every day in a week, but pulls data from the same

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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