using a base query i am able to create a table with various fields like this.
field1 field2
32 | 63.68 |
90 | 449.1 |
75 | 149.25 |
60 | 299.4 |
56 | 167.44 |
27 | 539.73 |
36 | 179.64 |
Now i need to find various stats operations by each field in efficient way as base query is quite heavy.
need output something like -
average | 90thpercentile | 95thpercentile | |
field1 | 50 | 60.6 | 80.2 |
field2 | 150.2 | 190.3 | 210.2 |
....
| stats avg(field1) as avg1 avg(field2) as avg2 p90(field1) as per1_90 p90(field2) as per2_90 p95(field1) as per1_95 p95(field2) as per2_95
is this what you are looking for?
r. Ismo