07 Apr 2026 06:03 PM
How do we get the user action duration metric data filter by page name and user type like below
I could see data in multidimensional analysis but not in the user session query or data explorer metric
I tried in user session query, data explorer there i don't see required filters.
Refer attached screenshot for more details
Please help me to get this data.
Solved! Go to Solution.
07 Apr 2026 10:12 PM
Hi,
you mixing different data models:
So, data visible in Multidimensional analysis won’t appear in USQL, especially for userType = SYNTHETIC
additionally, filtering on userevent.* in USQL works on session level, which can be misleading
The simplest and most accurate solution is to create a custom metric directly from Multidimensional analysis.
You already have there:
Just use “Create metric” and then use it in Data Explorer or dashboards.
08 Apr 2026 09:51 AM
Could you please guide me how to create custom metrics for this?
08 Apr 2026 11:29 AM
Sure,
the best approach here is to create a custom metric directly from Multidimensional analysis.
1. First, apply the correct filters in Multidimensional analysis
(e.g. page, user type, action type, etc.)
This is important, if the dataset is too broad, you won’t be able to create the metric.
2. Click “Create metric”
3. Go to Advanced options and:
Additionally:
Summary:
Multidimensional → filter → Create metric → Advanced options → done
Featured Posts