HCP Base Dashboard KPI ko‘rsatkichlarini hisobotning markaziy qismida va barcha vizualizatsiyalarda ko‘rsatadi.

• HCP Base
• HCP Covered
• HCP Covered Owner
• HCP Covered %
• HCP Not Covered
• HCP Calls
• HCP Frequency

HCP Base

Xodimlarning mas’uliyat hududlariga biriktirilgan tibbiyot mutaxassislari sonini ko‘rsatadi.

DAX formulasi

CALCULATE(
    DISTINCTCOUNT(crm_owner_v2_csv[key_cleint_id]),
    crm_owner_v2_csv[flag_name] = "contact"
)

Hisoblash mantiqi
Xodimlarga biriktirilgan noyob tibbiyot mutaxassislari sonini hisoblaydi.

HCP Covered

Kamida bitta yakunlangan tashrif olgan tibbiyot mutaxassislari sonini ko‘rsatadi.

DAX formulasi

CALCULATE(
    DISTINCTCOUNT(crm_task_fact_v2_csv[key_cleint_id]),
    crm_task_fact_v2_csv[key_flag] = "contact"
        && crm_task_fact_v2_csv[key_task_isfinish] = 1
)

Hisoblash mantiqi
Kamida bitta yakunlangan tashrifga ega noyob tibbiyot mutaxassislarini hisoblaydi.

HCP Covered Owner

O‘ziga biriktirilgan xodim tomonidan qamrab olingan tibbiyot mutaxassislari sonini ko‘rsatadi.

DAX formulasi

CALCULATE(
    DISTINCTCOUNT(crm_task_fact_v2_csv[key_cleint_id]),
    crm_task_fact_v2_csv[key_owner_flag] = 1
        && crm_task_fact_v2_csv[key_task_isfinish] = 1
        && crm_task_fact_v2_csv[key_flag] = "contact"
)

Hisoblash mantiqi
Mas’ul vakili tomonidan qamrab olingan noyob tibbiyot mutaxassislarini hisoblaydi.

HCP Covered %

DAX formulasi

DIVIDE(
    [HCP Covered owner],
    [HCP Base],
    0
)

Hisoblash mantiqi
Biriktirilgan HCP bazasi uchun qamrov foizini hisoblaydi.

HCP Not Covered

DAX formulasi

[HCP Base] - [HCP Covered owner]

Hisoblash mantiqi
Xodimlarga biriktirilgan, ammo hali tashrif buyurilmagan tibbiyot mutaxassislarini hisoblaydi.

HCP Calls

DAX formulasi

CALCULATE(
    DISTINCTCOUNT(crm_task_fact_v2_csv[key_task_id]),
    crm_task_fact_v2_csv[key_flag] = "contact"
        && crm_task_fact_v2_csv[key_task_isfinish] = 1
)

Hisoblash mantiqi
Tibbiyot mutaxassislariga qilingan yakunlangan tashriflar sonini hisoblaydi.

HCP Frequency

DAX formulasi

DIVIDE(
    [HCP Calls],
    [HCP Covered],
    0
)

Hisoblash mantiqi
Qamrab olingan bitta tibbiyot mutaxassisiga to‘g‘ri keladigan o‘rtacha tashriflar sonini hisoblaydi.

Biznes qiymati
O‘zaro aloqa intensivligi va tashriflar chastotasini baholashga yordam beradi.