The CLM Presentation Overview dashboard displays key KPI indicators that help users evaluate how actively CLM presentations are used during visits and how much time is spent viewing presentation content.
Total view
Business Description
Displays the total number of CLM presentation views for the selected reporting period.
In the example, the value is 616.
Calculation Logic
The KPI is based on the CLM Fact measure, which counts unique CLM tasks.
DAX Formula
CLM Fact =
DISTINCTCOUNT(crm_clm_fact_csv[clm_task_id])Calculation Logic
Calculates the distinct number of CLM tasks where CLM presentation activity was recorded.
Total time
Business Description
Displays the total time spent viewing CLM presentations during the selected reporting period.
In the example, the value is 03d 10h 04m 45s.
DAX Formula
CLM Totl time =
VAR TotalTime = SUM(crm_clm_fact_csv[clm_numofsec])
VAR Days = INT(TotalTime / 86400)
VAR Hours = INT(MOD(TotalTime, 86400) / 3600)
VAR Minutes = INT(MOD(TotalTime, 3600) / 60)
VAR Seconds = MOD(TotalTime, 60)
RETURN
FORMAT(Days, "00") & "d " &
FORMAT(Hours, "00") & "h " &
FORMAT(Minutes, "00") & "m " &
FORMAT(Seconds, "00") & "s"Calculation Logic
Sums the total number of seconds from crm_clm_fact_csv[clm_numofsec] and converts the result into the format:
DDd HHh MMm SSs
AVG time (CLM)
Business Description
Displays the average viewing time of one CLM presentation.
In the example, the value is 00h 07m 59s.
DAX Formula
CLM AVG Presentation Time =
VAR PresentationDurations =
ADDCOLUMNS(
SUMMARIZE(
crm_clm_fact_csv,
crm_clm_fact_csv[clm_task_id],
crm_clm_fact_csv[clm_presentation_id]
),
"PresentationDuration",
CALCULATE(SUM(crm_clm_fact_csv[clm_numofsec]))
)
VAR AvgSeconds = AVERAGEX(PresentationDurations, [PresentationDuration])
VAR TotalMinutes = DIVIDE(AvgSeconds, 60)
VAR Hours = INT(DIVIDE(TotalMinutes, 60))
VAR Minutes = INT(MOD(TotalMinutes, 60))
VAR Seconds = INT(MOD(AvgSeconds, 60))
RETURN
IF(
NOT ISBLANK(AvgSeconds),
FORMAT(Hours, "00") & "h " &
FORMAT(Minutes, "00") & "m " &
FORMAT(Seconds, "00") & "s",
BLANK()
)Calculation Logic
First, the measure groups data by CLM task and CLM presentation. Then it calculates the total presentation duration for each task-presentation combination and returns the average duration in the format:
HHh MMm SSs
AVG time (Slide)
Business Description
Displays the average viewing time of one CLM slide.
In the example, the value is 00h 00m 51s.
DAX Formula
CLM AVG Slide Time =
VAR AvgSeconds =
AVERAGEX(
VALUES(crm_clm_fact_csv[clm_slide_id]),
CALCULATE(
AVERAGE(crm_clm_fact_csv[clm_numofsec])
)
)
VAR TotalMinutes = DIVIDE(AvgSeconds, 60)
VAR Hours = INT(DIVIDE(TotalMinutes, 60))
VAR Minutes = INT(MOD(TotalMinutes, 60))
VAR Seconds = INT(MOD(AvgSeconds, 60))
RETURN
IF(
NOT ISBLANK(AvgSeconds),
FORMAT(Hours, "00") & "h " &
FORMAT(Minutes, "00") & "m " &
FORMAT(Seconds, "00") & "s",
BLANK()
)Calculation Logic
Calculates the average number of seconds for each unique CLM slide and converts the result into the format:
HHh MMm SSs
CLM Fact task
Business Description
Displays the number of completed tasks that can be used as the base for CLM activity analysis.
DAX Formula
CLM Fact task =
CALCULATE(
DISTINCTCOUNT(crm_task_fact_v2_csv[key_task_id]),
'crm_task_fact_v2_csv'[key_task_isfinish] = 1
)Calculation Logic
Counts the distinct number of completed tasks where key_task_isfinish = 1.
CLM Fact
Business Description
Displays the number of tasks where CLM presentation activity was recorded.
DAX Formula
CLM Fact =
DISTINCTCOUNT(crm_clm_fact_csv[clm_task_id])Calculation Logic
Counts the distinct number of CLM task IDs from the CLM fact table.
CLM %
Business Description
Displays the share of completed tasks that included CLM presentation activity.
In the example chart, the value is 34.32%.
DAX Formula
CLM % =
[CLM Fact] / [CLM Fact task]Calculation Logic
Divides the number of tasks with CLM activity by the total number of completed tasks.
A higher value means that CLM presentations are used more actively during completed visits.