Appt Queue Dashboard for multiple stages and avg times

[chrisx]

I am trying to build a daily appointment queue. There are 5 stages in this queue. I am tasked with reporting the average time between each stage, and the average time of the appointment in total.

I am having the most trouble with reporting the count of records in each stage, as a record cant exist in muliple stages at a a time. I do not know where to start in my calculations.

Each stage is timestamped. 

[v-yingjl · Accepted solution]

Hi @chrisx ,
Sorry for replying late. You can create two measures to calculate:

Avg for stage =
CONVERT (
    CALCULATE (
        AVERAGE ( 'Table'[Timestamped] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Stages] IN DISTINCT ( 'Table'[Stages] ) )
    ),
    DATETIME
)

Total avg = CONVERT(AVERAGE('Table'[Timestamped]),DATETIME)

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chrisx]

Thank you!