What tools do you use ?
I've been developing a lot of mantis plugins for my ex-company, and all the projects around stats were totally awful.
Below, some examples:
- Calcule KPI based on history: the badest way, because an update of a label (i.e. status) won't update history table and could provide wrong results
- Daily export in EXCEL files: the short-term limited solution which will bring some frustration later (trust me, I have deal with it )
- Cron task for KPI processing: the geekest way, it could work for few KPIs, but this solution is unscalable
And MantisBT will be my first target for sure I would be happy to read your expectations for a such king of tool!
Be ready to discover what your data is hiding