Advanced Reporting (RepTool, Visualizations)
Report Visualizations
The .CSV structure of reports is intended to make merging easy. If you merge multiple (.csv) reports together, you can create some really interesting aggregate visuals via ChatGPT (see graphics below) or your favorite spreadsheet software. I developed a little command-line utility to make it very easy to merge lots of reports. Just copy all your reports to a single directory and give reptool the path to the directory and it will make a MERGED.csv file for you.
If your club has multiple nets, merge all their files together with the tool in order to report on the aggregate. Maybe you want a monthly report across all nets, etc...
How It Works
Drop all your .csv
files into the same folder.
reptool merge <path-to-directory>
MERGED.csv
ready to go.
Downloads
Linux x86 64bit (Be sure to click on "Download Raw File") - Don't forget to make the file executable MacOs x86 64bit (Be sure to click on "Download Raw File") - Don't forget to make the file executable
Eye Candy
Merged reports for "Let's Talk Digital - KC Wide" (Aug–Dec 2024) and uploaded the results to ChatGPT for insights:
*Note - I used the paid (~$25/mo plan) with ChatGPT to make these. The free product might work too, not sure.*Note - Most recent code release gives the .csv files unique names--making things even faster (so you don't need to rename files in the same dir)