We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Summarize tool (First and Last)

SH_94
11 - Bolide
‎03-04-2021 09:15 AM

Hi,

 

May i know when i should use the First and Last (in the action choice) in using the summarize tool?

 

 

Jacob_94_0-1614878144540.png

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
mbarone
16 - Nebula
16 - Nebula
‎03-04-2021 09:39 AM

The first and last will give you just that - the first value and/or last value for a field.


Example:

SALES

10

20

30

40

100

5

18

 

First_Sales will give you "10" and Last_Sales will give you "18".

Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All