Home
Designing Analytics Reports
Multi-select report parameter for dates
Migrateduser
<p>Hello,</p>
<p> </p>
<p>I'm trying to add a report parameter (<strong>multi-select</strong>) which has the value as follows:</p>
<p> </p>
<p>- All</p>
<p>- Future Payments</p>
<p>- Current Payments</p>
<p>- Past Payments</p>
<p> </p>
<p>Depending on the values that you select on the report parameter, I need to add a filter on the data set to display only those records which matches below condition.</p>
<p> </p>
<p>- Future Payments : Payment_Start_Date > Current Date</p>
<p>- Current Payments : Payment Start Date < Current Date < Payment End Date</p>
<p>- Past Payments : Payment End Date < Current Date</p>
<p> </p>
<p>So if the user selects both 'Future' and 'Past' report parameter values while running the report, it should only return the respective records only. </p>
<p> </p>
<p>Can anyone help me to set up this? Please let me know if any further info is required. </p>
<p> </p>
<p> </p>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet