Search found 10 matches

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

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 ...
by tookei
21 Feb 2019, 16:51
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 39823

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 ...
by tookei
21 Feb 2019, 12:34
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 39823

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: 39823

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 ...
by tookei
18 Feb 2019, 16:52
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 39823

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 ...
by tookei
14 Feb 2019, 07:10
Forum: General Discussion
Topic: Dashboard, KPI & Stats tool
Replies: 23
Views: 39823

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 ...
by tookei
13 Feb 2019, 21:18
Forum: French
Topic: Calcul entre les champs personnalisés
Replies: 5
Views: 11232

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: 7979

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: 39823

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

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