Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Select data in 01 financial year (a period between 02 years)

Highlighted
8 - Asteroid

I have a list of files/records contains date-time field following format YYYY-MM

How can I select the following period if I only want to choose a single financial year:

 

eg:

FY18: PERIOD:

 

2018-04

....

2019-03

 

 

FY19: PERIOD:

 

2019-04

....

2020-03

 

 

Highlighted
Alteryx Certified Partner

Hi @hungdm ,

 

How would you like to do that? To filter with a filter tool or to select in a form as an analytical app?

Would you be able to share a sample dataset for me to understand how it looks like? 

Highlighted
8 - Asteroid

@fmvizcaino 

document attached! plz take a look!

Highlighted
Alteryx Certified Partner

Hi @hungdm ,

 

Solution attached.

Let me know if you need further help.

 

Best,

Fernando Vizcaino

Labels