topic Re: charting apdex using USQL in Real User Monitoring

charting apdex using USQL

AndresBrown — Fri, 11 Aug 2023 15:45:28 GMT

hey there!

I wonder if you guys could help me doing this:

but using USQL?

thanks in advance

Andrés.

Re: charting apdex using USQL

AntonioSousa — Fri, 11 Aug 2023 21:47:56 GMT

Yes, you can use USQL to calculate Apdex. Once upon a time, I had a formula that was able to do it. But there were some changes, and it now doesn't give the exact value. It has to do about how errors are accounted for. Anyway, if you are not interested in perfection, it is doable...

Re: charting apdex using USQL

Julius_Loman — Mon, 14 Aug 2023 05:42:08 GMT

@AntonioSousa I believe @AndresBrown wants to show just action counts and not calculate the apdex value (numeric).

@AndresBrown you mean something like this?

select count(*) as "Action Count", datetime(startTime) as "Time", apdexCategory as "Apdex Category" from useraction where application="www.easytravel.com" group by datetime(startTime), apdexCategory

Re: charting apdex using USQL

AndresBrown — Mon, 14 Aug 2023 16:05:03 GMT

Hey Julius_Loman,

exactly what I mean.

thanks!!

Andres