Hello people, I introduce myself as Julio Herrera. How can I dynamically filter rows in Alteryx based on a date range that is input by the user, and then create a summary report that includes the total count and average value of a specific numeric field within the filtered data?
Can anyone mention the steps for the same?
Thank you in advance :)
What you’re looking for is an Analytic App! https://help.alteryx.com/current/en/designer/apps-and-macros/analytic-apps.html
It gives you the ability to have a user interface where users can input their dates with the Date interface tool!
Yes this helped me thank you!
There are the steps mentioned below to filtering date used
1. First select the date field that used in filtering. Use the dropdown select the incoming date field. The field must be a "Date" field type.
2. Second Please Specify the Date selection method. Use starts and end dates: Both start and end dates are included in the filter.
Thank you for providing links and explaining in steps :)