cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

API - Filter values

dajunki
Frequent Guest

I am interested in filtering the result by the value, not by the dimension.  For example.  I want a count of the number of a service where the visually complete is greater than 3 seconds.  I have tried using the partition to segment the data, but to do this i need the aggregation to be avg.  I then tried to use the IN predicate to filter out the dimension i don't want and try and do a count after.  But i am suspecting i am not counting the number of results.  I can't find anywhere in the documentation that you can filter by the value other than the "series" predicate.  but this will hide or show the entire series.  This seems like such a simple and logical thing that many people would want.  Any help is appreciated.

1 REPLY 1

dajunki
Frequent Guest

Here is something i was trying for synthetic browser times....

 

(builtin:synthetic.browser.event.actionDuration.load:(avg)

:filter(and(in("dt.entity.synthetic_test_step",entitySelector("type(synthetic_test_step),entityName(~"05: Select Claims and Spending Tab~")"))))

:default(0):partition("Actionduration",value("slow",gt(4000)),value("fast",otherwise ))

:splitBy("Actionduration"):count:default(0)

:filter(eq("Actionduration","fast")):merge("Actionduration")):rollup(avg,1h)