Dashboard, KPI & Stats tool

General discussion of Mantis.

Moderators: Contributor, Developer

Post Reply
tookei
Posts: 5
Joined: Feb 02, 2019 3:37 pm
Contact:

Dashboard, KPI & Stats tool

Post by tookei » Feb 13, 2019 4:04 pm

    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:
    1. 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
    2. Daily export in EXCEL files: the short-term limited solution which will bring some frustration later (trust me, I have deal with it :oops: )
    3. Cron task for KPI processing: the geekest way, it could work for few KPIs, but this solution is unscalable
    Now, I think I have a better idea of how to figure out all of that. So I'm really excited to announce you that I'm working a cool app on my own.

    And MantisBT will be my first target for sure ;)
    mantis dashboard.png
    mantis dashboard.png (239.59 KiB) Viewed 55 times
    I would be happy to read your expectations for a such king of tool!

    Be ready to discover what your data is hiding :lol:

    Kind Regards,
    Tookei

    atrol
    Site Admin
    Posts: 7477
    Joined: Mar 26, 2008 4:37 pm
    Location: Germany

    Re: Dashboard, KPI & Stats tool

    Post by atrol » Feb 13, 2019 4:54 pm

    tookei wrote:
    Feb 13, 2019 4:04 pm
    Calcule KPI based on history: the badest way, because an update of a label (i.e. status) won't update history table
    I can't reproduce this. Updating status updates the history table. Can you provide some more information how to reproduce it?
    Please use Search before posting and read the Manual

    tookei
    Posts: 5
    Joined: Feb 02, 2019 3:37 pm
    Contact:

    Re: Dashboard, KPI & Stats tool

    Post by tookei » Feb 14, 2019 2:10 am

    atrol wrote:
    Feb 13, 2019 4:54 pm
    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 next days, for an issue, its history could be :
    NEW => ASSIGNED
    ASSIGNED => DONE
    DONE => CLOSED

    At Day100, the status labels are updated to NEW, IN PROGRESS, DONE, CLOSED. The ASSIGNED status value in the history won't be updated to IN PROGRESS. So if we would like to count the number of issues per day for each current status, we might lost all X issues during Day1 to Day100 for IN PROGRESS status.

    Post Reply