HCO All Base
To‘liq HCO database ichidagi healthcare organizations umumiy sonini ko‘rsatadi.
Biznes qiymati
Kengaytirilgan coverage analysis uchun to‘liq HCO universe taqdim etadi.
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_hco_all_base_csv[Organization id])
)Hisoblash mantiqi
Employee responsibility assignment mavjudligidan qat’i nazar, to‘liq HCO base ichidagi unique organizations sonini hisoblaydi.
HCO All Base Coverage
To‘liq HCO database ichida so‘nggi oyda kamida bitta visit bo‘lgan healthcare organizations sonini ko‘rsatadi.
Biznes qiymati
To‘liq HCO database bo‘yicha recent coverage ko‘rsatadi.
DAX Formula
VAR FilteredTasks =
FILTER(
crm_hco_all_base_tasklastmonth_csv,
NOT ISBLANK(crm_hco_all_base_tasklastmonth_csv[task_last_month])
)
RETURN
CALCULATE(
DISTINCTCOUNT(crm_hco_all_base_csv[Organization id]),
FilteredTasks
)Hisoblash mantiqi
task_last_month bo‘sh bo‘lmagan to‘liq HCO database ichidagi unique healthcare organizations sonini hisoblaydi.
HCO All Base Uncovered
To‘liq HCO database ichida so‘nggi oyda covered bo‘lmagan healthcare organizations sonini ko‘rsatadi.
Biznes qiymati
To‘liq HCO universe ichidagi uncovered organizations aniqlashga yordam beradi.
DAX Formula
[HCO All Base] - [HCO All Base Cov]Hisoblash mantiqi
Complete HCO base va complete base ichidagi covered HCOs o‘rtasidagi farqni hisoblaydi.
HCO All Base Coverage %
To‘liq HCO database ichidagi covered organizations foizini ko‘rsatadi.
Biznes qiymati
Butun database bo‘yicha overall HCO engagement o‘lchaydi.
DAX Formula
DIVIDE([HCO All Base Cov], [HCO All Base], 0)Hisoblash mantiqi
Covered organizations sonining full HCO base’ga nisbatini hisoblaydi.
Denominator nolga teng bo‘lsa, 0 qaytaradi.