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

Be ready to discover what your data is hiding

Kind Regards,
Tookei