Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
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
Free Trial

Alteryx Designer Desktop Discussions

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

Time calculation based on time stamp

ArnabSengupta
8 - Asteroid
‎08-31-2020 02:16 PM

Hi All,

 

I have a data set of different machine state (running, error, idle etc.) I want to calculate how long the each machine spends on different state's per day and per machine. The time stamp is given in descending order with the first record being latest

 

I have attached a sample data set.

Preview file
9 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
BrandonB
Alteryx
Alteryx
‎08-31-2020 02:26 PM

The Multi-Row tool allows you to reference cells above and below the current cell as shown below

 

multi row.png

 

Reply
0 Likes
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All