Hi,
I got a table data with 3 fields (Time, Method, Return)
Time | Method | Return |
28/10/2022 | Method 1 | KO |
28/10/2022 | Method 2 | KO |
28/10/2022 | Method 1 | OK |
28/10/2022 | Method 1 | OK |
28/10/2022 | Method 1 | OK |
28/10/2022 | Method 1 | OK |
... | ... | ... |
29/10/2022 | Method 2 | OK |
29/10/2022 | Method 2 | OK |
29/10/2022 | Method 2 | OK |
29/10/2022 | Method 2 | OK |
29/10/2022 | Method 2 | OK |
29/10/2022 | Method 2 | OK |
29/10/2022 | Method 2 | OK |
I'd like to make a timechart with double agregation (one per Method, then one per Return) to get this kind of chart
The only thing I can do for the moment is this chart with this request
| timechart count(eval(Return="KO")) as KO count(eval(Return="OK")) as OK by Method
Do you know how I can get the first timechart ?
Thanks