Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Last 12 months

wenyg
8 - Asteroid

How can i input "Feb-23" as datetime and  get past 12 months? such as

wenyg_0-1678981776578.png

 

3 REPLIES 3
Zok
8 - Asteroid

Hello

 

You can rename some fields and reorder if needed

Zok_0-1678982872126.png

 

wenyg
8 - Asteroid

Hi thanks,

   I would like have a dynamic text input to input a datetime as any month (rather than current month) and  its past 12 months based on that.

  For example, in text input, I want to put Feb-23, and then the output I want is Jan-23 all the way to Feb-22. How can we do that? Thanks!

binuacs
19 - Altair

@wenyg One way of doing this with the Analytical App

 

binuacs_0-1679007731772.png

 

Labels