Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

vince2020
Community profile vince2020 Level 1
Job title here
Location here
1 BADGE
Level 1

Level 1

Learn more
Joined the community 07-11-2019 2:51:41 AM
Offline
Top badges earned by vince2020
Customize the badges you want to showcase on your profile
Application complete time measure with clickstream query
Avatar
Ignite 1
Level 1
vince2020
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Ignite 1
View profile
vince2020
- Adobe Analytics
I want to get the same result from clickstream query with workspace "Application Time To Complete"Ran below query but found there's big gap between them. please review my code whether it's correctly written.SELECT a.as_of_dt, a.category, a.product, a.product1, sum(a.complete_time) AS complete_time, count(*) AS complete_cntFROM (SELECT as_of_dt, split_part(product_list, ';', 1) AS category, CASE WHEN split_part(product_list, ';', 1) IN ('ABC', 'DEF', 'XYZ') THEN split_part(product_list, ';', 1) E...

Views

67

Likes

0

Replies

0