Project

General

Profile

Feature #3640

Permintaan Pembuatan Halaman KPI Dashboard

Added by Mr Dhafin about 2 months ago. Updated 6 days ago.

Status:
QA Test
Priority:
Urgent
Assignee:
Start date:
05/26/2025
Due date:
07/15/2025 (6 days late)
% Done:

0%

Estimated time:

Description

Dear Tim Developer,

Tolong bantu buatkan halaman KPI Dashboard sesuai desain terlampir. Menu ini akan ditempatkan di Business Intelligence > Dashboard > KPI Dashboard.
Fitur yang ditampilkan:

1. Kotak atas:
Total Completed KPIs (misal: 25%)
Completed KPIs vs Total Job Positions (Min 2 Months) (misal: 45%)
2. Grafik Pie 1: Number of KPIs With Score (Score A, B, C, D)
3. Grafik Pie 2: Number of KPIs Awaiting Approval (Create, Complete, App Supervisor, App Supervisor Level 2)

Terimakasih.

Port: http://remote.minovais.com:61133/
DB: MinovaES_BankKalteng_BaseServerProd


Files

#1

Updated by Mr Dhafin about 2 months ago

  • File Project Widget BKT KPI Dashboard_page-0001.jpg added
#2

Updated by Mr Dhafin about 2 months ago

  • Status changed from New to Assigned
#3

Updated by Kezia Pawitra Yulianti about 2 months ago

Dhafin,
tolong di jelasin juga yaa di redmine, untuk widget ini ambil datanya dari mana. jelasin nama tabel dan field untuk get datanya.

haykal haykal, tolong dibantu yaa jelasin ke dhafin untuk detail in.
Tks

#4

Updated by Mr Dhafin about 2 months ago

Berikut ya mas, untuk referensi Tablenya:

Referensi Table dan Field untuk Data Performance Management:
1. Performance Management:
- Sumber data: Tabel PHRPA0047
- Field:
• Appraisal Type dengan nilai:
- G = Performance Goal Setting
- P = Performance Review
- F = Performance Final
2. Total Completed KPIs:
- Sumber data: Tabel PHRPA0047
- Field:
• Appraisal Type (G, P, F)
• Appraisal Period
3. Number of KPIs Awaiting Approval:
- Sumber data: Tabel PCMWFRUNTASK
- Field TaskIDRun dengan nilai:
• create = Create
• apv_ds = App Supervisor
• apv_nha = App Supervisor Level 2
4. Number of KPIs With Score:
- Sumber data: Tabel PHRPA0047
- Field: AdjustedIndex

#6

Updated by Mr Dhafin about 2 months ago

  • File deleted (clipboard-202505261541-5hkd7.jpg)
#7

Updated by Mr Dhafin about 2 months ago

  • File deleted (Project Widget BKT KPI Dashboard_page-0001.jpg)
#8

Updated by Kezia Pawitra Yulianti about 1 month ago

  • Due date changed from 06/02/2025 to 06/12/2025
  • Priority changed from Normal to Urgent
#9

Updated by mahlil .. about 1 month ago

  • Status changed from Assigned to QA Test
  • Assignee changed from mahlil .. to Mr Dhafin

bisa di test di demo
penambahan ui diserver demo dengan nama pages KPIDASH
menuid KPIDASH
sp: - [GETKPITOTALAPPROVAL]
- [GETKPISCORECOMPLETE]
- [GETKPISCORE]
untuk di table PCMWFCUSTPARAM dengan id:
-BI_DASHBOARD_KPI_COMPLETE
-BI_DASHBOARD_KPI_SCORE
-BI_DASHBOARD_KPI_WAITING_APPROVAL

#10

Updated by Mr Dhafin 10 days ago

Dear Mas Alwi,

Terkait kolom Status, status yang dianggap Complete mengacu pada referensi dari tabel PCMWFHISTASK, dengan ketentuan berikut:

• WorkFlowStatus = 'F'
• TaskStatus = 'C'
• TaskTo = 'finish'

Kondisi tersebut berlaku untuk seluruh tahapan: Goal, Review, dan Final.
Selain itu, jika data dengan RegID yang diajukan sudah tercatat di tabel PHRPA0047, maka juga dianggap Complete.
Sebagai referensi, berikut terlampir contoh gambar tampilan status yang dimaksud.


Terimakasih.

#11

Updated by mahlil .. 6 days ago

  • Status changed from Assigned to QA Test
  • Assignee changed from mahlil .. to Mr Dhafin

Also available in: Atom PDF