Forum Discussion
Nuubles
Mar 18, 2023Copper Contributor
Filter data from table to create multiple charts and combined totals
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 |