Mar 18 2023 01:33 AM
I have a table that contains different performance evaluations that are categorized by framework and type of action being evaluated. The data consists of total time the performance evaluation took, how many errors it produced, and how many times the test was repeated in parallel.
From this I'd need the following:
1. Multiple tables with the X-axis being test repeat count, and two Y labels being error count and performance result. A table is generated for each test + framework combination in the table. (basically a line and bars in each table)
2. A table that'd combine the previous performance result data. X&Y are the same. (basically multiple framework lines with performanceResult height)
3. A table that'd combine the previous error count data. X&Y are the same. (basically multiple framework lines with errorCount height)
After trying everything I know about excel and not getting this to work, I'd appreciate any help, as everything I did used either wrong data or placed data in incorrect places.
For clarity I've underlined the data rows and italicized the columns according to which the data should be filtered.
A sample set from the table:
Columns: A,B,C,D,E,F
type | testRepeatCount | testCount | performanceResult | errorCount | framework |
ws | 1 | 5 | 19.807099997997284 | 0 | FastAPI |
ws | 2 | 5 | 18.18970000743866 | 0 | FastAPI |
ws | 4 | 5 | 18.40819999575615 | 0 | FastAPI |
ws | 8 | 5 | 24.468000009655952 | 0 | FastAPI |
ws | 16 | 5 | 29.424899995326996 | 0 | FastAPI |
ws | 32 | 5 | 257.52489998936653 | 0 | FastAPI |
ws | 64 | 5 | 505.4226000010967 | 0 | FastAPI |
ws | 128 | 5 | 989.4690999984741 | 0 | FastAPI |
ws | 256 | 5 | 1506.5247000008821 | 0 | FastAPI |
ws | 512 | 5 | 1912.2127999961376 | 9 | FastAPI |
ws | 1024 | 5 | 2834.2672999948263 | 0 | FastAPI |
ws | 2048 | 5 | 3592.1726999878883 | 125 | FastAPI |
ws | 4096 | 5 | 7158.047100007534 | 896 | FastAPI |
fetch | 1 | 5 | 22191.670699998736 | 0 | FastAPI |
fetch | 2 | 5 | 18684.363099992275 | 0 | FastAPI |
fetch | 4 | 5 | 18750.019800007343 | 0 | FastAPI |
fetch | 8 | 5 | 18211.71549999714 | 0 | FastAPI |
fetch | 16 | 5 | 10064.506500005722 | 1893 | FastAPI |
fetch | 32 | 5 | 16596.03869999945 | 285 | FastAPI |
fetch | 64 | 5 | 17441.98030000925 | 51 | FastAPI |
fetch | 128 | 5 | 9624.875299990177 | 1894 | FastAPI |
fetch | 256 | 5 | 17135.10909999907 | 300 | FastAPI |
fetch | 512 | 5 | 18449.22720000148 | 16 | FastAPI |
fetch | 1024 | 5 | 20075.287700012326 | 1952 | FastAPI |
fetch | 2048 | 5 | 20182.05229999125 | 525 | FastAPI |
fetch | 4096 | 5 | 20397.890700012445 | 773 | FastAPI |
ws | 1 | 5 | 12.853300005197525 | 0 | NodeJS |
ws | 2 | 5 | 12.028900012373924 | 0 | NodeJS |
ws | 4 | 5 | 13.157999992370605 | 0 | NodeJS |
Mar 18 2023 02:41 AM
Perhaps a pivot table with a pivot chart and some slicers...