community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More

Audit Trail Help.... Look for certain events in timeline

Asteroid

HI,

 

I have an audit trail that resembles the following data :

 

IDTimestampDetailsObject/ActionInteraction
276412/04/2019 14:13:18OpenAppHome
276412/04/2019 14:13:25NavigateViewSales
276412/04/2019 14:13:30NavigateViewData
276412/04/2019 14:13:39NavigateViewLeads
276412/04/2019 14:13:40Search : UKListBoxUK_Search
276412/04/2019 14:21:46NavigateViewLeads
276412/04/2019 14:22:26TableDownloadCustomer_Table
276412/04/2019 14:25:26NavigateViewItems
276412/04/2019 14:25:39TableDownloadCustomer_Table
276412/04/2019 14:26:05Back  
276412/04/2019 14:26:06NavigateViewData
276412/04/2019 14:26:08BackView 
276412/04/2019 14:26:09NavigateSheetItems
276412/04/2019 14:38:19ExitAppItems

 

What i have been asked to do is check run through the table to see if the following pattern occurs:

 

Navigate to Leads view and check if the next chronological view is the Items view. If so, check if the Customer_Table is downloaded before the next Navigation event occurs.  I need to be able to count the number of instances where this happens.  

 

The identifier is the ID (which relates to each user session).

 

So, in the above dataset - I would have a count of 1 because at 14:21 the user Navigated to Leads page.  The next chronological page was the Items page and subsequently the Customer_Table was downloaded before the user navigated away to the Data page.

 

This is  properly giving me a headache so any help is greatly appreciated 

 

Yours Hopefully,

 

Fiorano

 

Alteryx Certified Partner
Alteryx Certified Partner

@fiorano,

 

I used a Multi-Row formula to calculate the audit rule.  I grouped by the ID and used this expression:

IF 
	[Details] = "Navigate" AND [Interaction] = "Leads" AND
	[Row+1:Details] = "Table" AND [Row+1:Object/Action] = "Download"
THEN "True"
ELSE "False"
ENDIF

It seems to solve the challenge for me.

 

capture.png

 

Cheers,


Mark 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels