Project

General

Profile

Feature #2529

NA indicators dashboard - part 1 only tables

Added by Oleksii Kurasov about 8 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Urgent
Start date:
03/09/2017
Due date:
03/23/2017
% Done:

0%


Description

AAA) Indicators needed at NMRC
1. Average number of days taken to evaluate and approve regulatory applications, ( may need for break down days for screening and evaluation by reviewers)

2. % of Nemlist medicines out the total registered medicines (Note that this is from medicines not from all registered products. All registered products include human medicines, veterinary medicines and Complementary medicines). NEMLIST is only for HUMAN MEDICINES

3. % of applications approved

<<< SOLUTION
For Registrar Introduce feature Dashboard accessible from new Dashboard menu
Place each indicator to a separate menu item
For any given indicator tab provide:
possibility to select year from first registration until current
possibility to select type of medicine (Human, Veterinary, Both)
table with quarterly values and yearly value (rows are type of medicine + total row!)

averageExample2.sql (810 Bytes) Oleksii Kurasov, 03/20/2017 09:04 AM

History

#1 Updated by Oleksii Kurasov about 8 years ago

  • Due date changed from 03/10/2017 to 03/15/2017

#2 Updated by Oleksii Kurasov about 8 years ago

  • Due date changed from 03/15/2017 to 03/16/2017

#3 Updated by Oleksii Kurasov about 8 years ago

  • Status changed from New to In Progress

#4 Updated by Oleksii Kurasov about 8 years ago

  • Description updated (diff)

#5 Updated by Oleksii Kurasov about 8 years ago

Average days between two states

see Attachment

#6 Updated by Oleksii Kurasov about 8 years ago

  • File averageExample.sql added

#7 Updated by Oleksii Kurasov about 8 years ago

Please, ignore previous example. More advanced script is is the second attachment

#8 Updated by Oleksii Kurasov about 8 years ago

  • Due date changed from 03/16/2017 to 03/23/2017

#9 Updated by Oleksii Kurasov about 8 years ago

  • File deleted (averageExample.sql)

#10 Updated by Oleksii Kurasov about 8 years ago

  • Status changed from In Progress to Resolved

#11 Updated by Oleksii Kurasov about 8 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF