# USQL query on action order

**URL:** <https://community.dynatrace.com/t/usql-query-on-action-order/20012>\
**Category:** Real User Monitoring\
**Tags:** user-sessions, dynatrace-api\
**Created:** [March 14, 2019, 12:46pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012 "2019-03-14T12:46:00Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Julius\_Loman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/julius_loman/32/51_2.png) [@Julius\_Loman](https://community.dynatrace.com/u/Julius_Loman)\
**Post date:** [March 14, 2019, 12:46pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/1 "2019-03-14T12:46:00Z")

</div>

Is there any option to query user sessions that have actions in some consecutive order?

For example - an application has 3 actions - “action1”, “action2”, “action3”. These may appear in any order in a user session and they can also repeat. I need to have a list of sessions in which actions are in exact order - such as “action1” is followed by “action2” which is followed by “action3”.

It seems this cannot be achieved using USQL - can anyone confirm that? We can only filter sessions having particular actions, but regardless of their order.

---

<div class="post-metadata">

**Author:** ![AlexanderSommer](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/alexandersommer/32/2501_2.png) [@AlexanderSommer](https://community.dynatrace.com/u/AlexanderSommer)\
**Post date:** [March 18, 2019, 8:43am UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/2 "2019-03-18T08:43:40Z")

</div>

Not at this point in time. This is on the roadmap.

---

<div class="post-metadata">

**Author:** ![Julius\_Loman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/julius_loman/32/51_2.png) [@Julius\_Loman](https://community.dynatrace.com/u/Julius_Loman)\
**Post date:** [March 18, 2019, 8:49am UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/3 "2019-03-18T08:49:30Z")

</div>

Good to know… Any ideas when this might be available?

Are also conversion goals based to action order on the roadmap? (see my idea [here](https://answers.dynatrace.com/spaces/483/dynatrace-product-ideas/idea/209761/user-action-flow-based-conversion-goals.html))

---

<div class="post-metadata">

**Author:** ![vladislav\_samoy](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/vladislav_samoy/32/27470_2.png) [@vladislav\_samoy](https://community.dynatrace.com/u/vladislav_samoy)\
**Post date:** [December 6, 2019, 3:21pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/4 "2019-12-06T15:21:12Z")

</div>

+ to Julius

[@Alexander S.](https://answers.dynatrace.com/users/12024/view.html) any visible timeframe for this feature?

---

<div class="post-metadata">

**Author:** ![joshua\_dtrace](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/joshua_dtrace/32/20014_2.png) [@joshua\_dtrace](https://community.dynatrace.com/u/joshua_dtrace)\
**Post date:** [December 6, 2019, 4:06pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/5 "2019-12-06T16:06:16Z")

</div>

Are you by chance asking about a Funnel for User Sessions? If so, in v1.182 of Dynatrace we’re launching USQL Funnels!

Here’s an example USQL query that provided the examples below:

- `SELECT FUNNEL(useraction.name="AppStart (easyTravel)" AS 'Open easytravel', useraction.name = "searchJourney" AS 'Search journey', useraction.name = "bookJourney" AS 'Book journey') FROM usersession`

 ![22832-usql-funnels1.png](https://global.discourse-cdn.com/dynatrace/original/3X/f/b/fbeb54be64b2df0ee1e10013b8b73c02b2876cc4.png)

Kind regards,  
Joshua P.

---

<div class="post-metadata">

**Author:** ![Julius\_Loman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/julius_loman/32/51_2.png) [@Julius\_Loman](https://community.dynatrace.com/u/Julius_Loman)\
**Post date:** [December 9, 2019, 8:02pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/6 "2019-12-09T20:02:19Z")

</div>

Exactly! I’m looking forward to see this feature.  
If we could get USQL running on live sessions, then it would be awesome.

---

<div class="post-metadata">

**Author:** ![joshua\_dtrace](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/joshua_dtrace/32/20014_2.png) [@joshua\_dtrace](https://community.dynatrace.com/u/joshua_dtrace)\
**Post date:** [December 9, 2019, 8:07pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/7 "2019-12-09T20:07:09Z")

</div>

Awesome to hear! 🙂

I’m not sure about USQL on live sessions, but we did just release a blog about new USQL functionality that should be live on v1.180 and later!

> **[Find the user session data you need and better understand customer experience...](https://www.dynatrace.com/news/blog/find-the-user-session-data-you-need-and-better-understand-customer-experience-with-new-usql-functions/)**
>
> Dynatrace announces improvements to User session queries that provide you with even more meaningful analytics and help widen your USQL usage.

Kind regards,  
Joshua P.

---

<div class="post-metadata">

**Author:** ![Julius\_Loman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/julius_loman/32/51_2.png) [@Julius\_Loman](https://community.dynatrace.com/u/Julius_Loman)\
**Post date:** [December 9, 2019, 8:11pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/8 "2019-12-09T20:11:40Z")

</div>

Well, until we get USQL working on live sessions, the usage will still be mostly for business analytics. It’s not very useful for realtime or near-real-time monitoring of user experience - live session may take up to several hours to finalize and included in USQL results.

---

<div class="post-metadata">

**Author:** ![rastislav\_danis](https://avatars.discourse-cdn.com/v4/letter/r/b9bd4f/32.png) [@rastislav\_danis](https://community.dynatrace.com/u/rastislav_danis)\
**Post date:** [January 17, 2020, 9:36am UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/9 "2020-01-17T09:36:44Z")

</div>

Hi Joshua, why your mentioned blog doesn’t contain info about FUNNEL functionality ? I have already tried it and it looks nice. Even dynatrace documentation is extended with info about this functionality so i wonder why it’s so “hidden” in news.

---

<div class="post-metadata">

**Author:** ![joshua\_dtrace](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/joshua_dtrace/32/20014_2.png) [@joshua\_dtrace](https://community.dynatrace.com/u/joshua_dtrace)\
**Post date:** [January 17, 2020, 6:58pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/10 "2020-01-17T18:58:09Z")

</div>

Hi Rastislav D.!

That didn’t make it into the blog as it released later, but here’s some documentation below if you search for “FUNNEL”: [Custom queries, segmentation, and aggregation of session data in RUM Classic — Dynatrace Docs](https://www.dynatrace.com/support/help/shortlink/usql-info#frequently-used-keywords)

Kind regards,  
Joshua P.

---

<div class="post-metadata">

**Author:** ![mohanasivapras1](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@mohanasivapras1](https://community.dynatrace.com/u/mohanasivapras1)\
**Post date:** [February 13, 2020, 9:39pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/11 "2020-02-13T21:39:02Z")

</div>

Hi,

Once we write the USQL query using Funnel, it is not showing in Dashboard as “Y” shape of Funnel details like user action name details with count and % of completion?

Showing above Funnel look is not good to see in dashboards.

Let us know your thoughts?

Regards,

M.Mohana

---

<div class="post-metadata">

**Author:** ![joshua\_dtrace](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/joshua_dtrace/32/20014_2.png) [@joshua\_dtrace](https://community.dynatrace.com/u/joshua_dtrace)\
**Post date:** [February 13, 2020, 10:11pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/12 "2020-02-13T22:11:57Z")

</div>

Hello, M.Mohana!

Can you please reach out over Dynatrace Live Chat so that our Product Specialists can help you troubleshoot your issue? Thank you!

> **[Home | Dynatrace Support Portal](https://support.dynatrace.com/)**

Kind regards,  
Joshua P.

---

<div class="post-metadata">

**Author:** ![Malaik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/malaik/32/32673_2.png) [@Malaik](https://community.dynatrace.com/u/Malaik)\
**Post date:** [November 9, 2020, 3:59pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/13 "2020-11-09T15:59:05Z")

</div>

Hi all,

I have a question about funnel Dashboards,

I have a user journey but 2 diffrent ways to access :

1 - actionA actionB actionC actionD

for many reasons, some users cannot perform ActionC and I want that user to appear in the same FUNNEL.

Is it possible ?

---

<div class="post-metadata">

**Author:** ![Malaik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/malaik/32/32673_2.png) [@Malaik](https://community.dynatrace.com/u/Malaik)\
**Post date:** [November 9, 2020, 3:59pm UTC](https://community.dynatrace.com/t/usql-query-on-action-order/20012/14 "2020-11-09T15:59:25Z")

</div>

Hi all,

I have a question about funnel Dashboards,

I have a user journey but 2 diffrent ways to access :

1 - actionA actionB actionC actionD

for many reasons, some users cannot perform ActionC and I want that user to appear in the same FUNNEL.

Is it possible ?
