charting apdex using USQL

[AndresBrown]

hey there!

I wonder if you guys could help me doing this:

 but using USQL? 

thanks in advance

Andrés.

[AntonioSousa]

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...

[Julius_Loman · Accepted solution]

@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

[AndresBrown]

Hey Julius_Loman, 

exactly what I mean.

thanks!!

Andres