I have the following query which gives me per second average results for the events.
Is there a way I can modify it to produce the individual average results for each CLIENT? Thanks.
index=some_some2_idx ns=something app_name=my-api
CLIENT IN (Apple, Orange, Banan) API IN (R_GET, T_GET)
| timechart span=1s count as requests_per_second | stats avg(requests_per_second)
This is currently outputting:
avg(requests_per_second)
18.39494
I looking to get results as follows:
Apple Orange Banana
5.1 5.9 7.39
Add a BY CLIENT at the end of the time chart and stats line
Tried following and no results:
index=some_some2_idx ns=something app_name=my-api
CLIENT IN (A, B, C) API IN (R_GET, T_GET)
| timechart span=1s count as requests_per_second by CLIENT | stats avg(requests_per_second) by CLIENT
Also tried By Client only at one spot as above for both places and same results.