Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Introduction as Julio Herrera | Facing Query in Alteryx Practive

julioherrera
6 - Meteoroid

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 :)

4 REPLIES 4
caltang
17 - Castor
17 - Castor

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! 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
O758558
5 - Atom

Yes this helped me thank you!

Hennry1234
5 - Atom

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.

julioherrera
6 - Meteoroid

Thank you for providing links and explaining in steps :)

Labels
Top Solution Authors