A twbx file is essentially just a zip file that contains both the workbook (twb) and the data (in your case, a hyper extract). And a twb is just an xml file. My guess was that the xml was somehow corrupt. I extract the twb and hyper file from the twbx, then opened the twb with a text editor. I searched for "analysis-fields" in the XML and removed the entry referring to it. I saved and reopened and got a few additional errors. In the end, I removed the following highlighted text:
After doing that, I was able to open the twb file. I reconnected it to the extract, saved it as a packaged workbook, and attached it here.
Please note that this hacking of the XML could cause other problems down the road, but I hope that's not the case.
If this addresses your issue, please be sure to mark this answer as correct. Thanks!
New Collision Data Profiler.twbx 26.8 MB
Thanks for this Ken.
This solution didn't work within Tableau Public itself (when opening your modified workbook, it says "A newer version is available on Tableau Public, do you want to load it now -- Yes or Cancel?") which just looped the error so what I did was use my school credentials to get an academic license of Tableau Desktop -- this allowed me to open the file like you say and save it on top of the existing, buggy workbook on Tableau Public (in the cloud).
Awesome. I thought about that after posting because Tableau Public will always try to open the version that is on public, but glad you found a solution.