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_95is this what you are looking for?
r. Ismo