Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Only display latest Quarter value

pokhan27
8 - Asteroid

hi Expert

I want to display only the latest quarter value 

for instance if i am in Q3 than i want only to display q3 value am getting all quarter value over here 

 

Please advise 

 

pokhan27_1-1628522304857.png

 

 

pokhan27_0-1628520794798.png

 

5 REPLIES 5
JagdeeshN
12 - Quasar
12 - Quasar

Hi @pokhan27 ,

 

Please find attached a sample workflow to filter to the latest quarter.

 

Hope this helps.

 

Best,

Jagdeesh

pokhan27
8 - Asteroid

Hi

my fiscal starts from Nov to Oct and also you displayed all the value in current quarter

JagdeeshN
12 - Quasar
12 - Quasar

Hi @pokhan27 ,

 

Can you please share the quarters and the date ranges for each?

 

Best,

Jagdeesh

pokhan27
8 - Asteroid

i have data for this fiscal year i.e. from Nov 2020. 

pokhan27_0-1628523789896.png 

 

 

JagdeeshN
12 - Quasar
12 - Quasar

Hi @pokhan27 ,

 

Please find attached a sample workflow.

 

Hope this helps.

 

Best,

Jagdeesh

Labels
Top Solution Authors