Search found 10 matches

by tookei
27 Feb 2019, 20:35
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 28208

Re: Dashboard, KPI & Stats tool

I'm really interested in this sort of reporting. We use mantis for general project management much more than software projects. I'm happy to provide mock-ups of the sort of thing we're interested in. feel free to get in touch. :D Hi jolyon.tidmarsh, I have set up many Mantis to manage everything el...
by tookei
21 Feb 2019, 16:51
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 28208

Re: Dashboard, KPI & Stats tool

The story is that users are experts in asking just that report which is not available It seems that our users share the same skill :lol: I did a lot of daily EXCEL, users were happy to compute their KPI on it. But I were not fully satisfied, because the data was consumed only day by day, and it req...
by tookei
21 Feb 2019, 12:34
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 28208

Re: Dashboard, KPI & Stats tool

@cas
In others words, we need to have a tool :D

By the way, it seems that you are a mantis veteran user, it would be great to have you feedback on this topic.
Are the built-in stats enough ? Or do you use something else to highlight more interesting KPI ?
by tookei
21 Feb 2019, 12:00
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 28208

Re: Dashboard, KPI & Stats tool

Why so cumbersome? All could be done in a PHP script..... By experience, PHP script is a hack way when you want to do something one shot, fast to deploy and regardless maintainability. When you need to deal with stats and history, it's better to use right technology which allow you to scale your ap...
by tookei
18 Feb 2019, 16:52
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 28208

Re: Dashboard, KPI & Stats tool

Hi Gltrsc, Do you want to track the efficiency of your team ? Sure, in my ex-company, we tried to understand the nature of our bugs and find out who is the best for this or for that. There are many solutions for you ;) Computing script directly connected to your database Computing script based on Ma...
by tookei
14 Feb 2019, 07:10
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 28208

Re: Dashboard, KPI & Stats tool

Can you provide some more information how to reproduce it? Hi Atrol, As the fields old_value and new_value of the table mantis_bug_history_table are both VARCHAR, the value will be the label/text of the field_name. For example, at Day1, the status labels are NEW, ASSIGNED, DONE, CLOSED. During the ...
by tookei
13 Feb 2019, 21:18
Forum: French
Topic: Calcul entre les champs personnalisés
Replies: 5
Views: 9402

Re: Calcul entre les champs personnalisés

Ou alors tu peux passer par une custom_function qui te fait ce calcul ;)
by tookei
13 Feb 2019, 21:16
Forum: French
Topic: Archivage de la base de données!!! urgent
Replies: 2
Views: 6689

Re: Archivage de la base de données!!! urgent

Je pense que ça pourrait t'aider à plus saturer ton disque ;)

https://dev.mysql.com/doc/mysql-enterpr ... ental.html
by tookei
13 Feb 2019, 21:04
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 28208

Dashboard, KPI & Stats tool

Hello folks, 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 co...
by tookei
05 Feb 2019, 12:53
Forum: General Discussion
Topic: REST API vs SQL INJECTION
Replies: 2
Views: 4129

Re: REST API vs SQL INJECTION

IMO, REST API should do the job. If you go for SQL Injection, you would need to clean your data