Filter data from table to create multiple charts and combined totals

Copper Contributor

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

typetestRepeatCounttestCountperformanceResulterrorCountframework
ws1519.8070999979972840FastAPI
ws2518.189700007438660FastAPI
ws4518.408199995756150FastAPI
ws8524.4680000096559520FastAPI
ws16529.4248999953269960FastAPI
ws325257.524899989366530FastAPI
ws645505.42260000109670FastAPI
ws1285989.46909999847410FastAPI
ws25651506.52470000088210FastAPI
ws51251912.21279999613769FastAPI
ws102452834.26729999482630FastAPI
ws204853592.1726999878883125FastAPI
ws409657158.047100007534896FastAPI
fetch1522191.6706999987360FastAPI
fetch2518684.3630999922750FastAPI
fetch4518750.0198000073430FastAPI
fetch8518211.715499997140FastAPI
fetch16510064.5065000057221893FastAPI
fetch32516596.03869999945285FastAPI
fetch64517441.9803000092551FastAPI
fetch12859624.8752999901771894FastAPI
fetch256517135.10909999907300FastAPI
fetch512518449.2272000014816FastAPI
fetch1024520075.2877000123261952FastAPI
fetch2048520182.05229999125525FastAPI
fetch4096520397.890700012445773FastAPI
ws1512.8533000051975250NodeJS
ws2512.0289000123739240NodeJS
ws4513.1579999923706050NodeJS

 

1 Reply

@Nuubles 

Perhaps a pivot table with a pivot chart and some slicers...