We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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