Forum Discussion

Aimeeclaird's avatar
Aimeeclaird
Helper IV
6 years ago
Solved

Count Calls (Inbound and Outbound) Yesterday

Hi, hopefully someone can help!   I want to include a visual in my report that shows the percetage of inbound vs outbound calls yesterday (thinking a pie or doughnut chart?)   I am struggling how...
  • az38's avatar
    az38
    6 years ago

    Hi Aimeeclaird 

    try more easy

    Inbound Calls Yday = calculate(
counta(Inbound_Calls[StartDate]),
Inbound_Calls[StartDate] = (TODAY()-1)
)

    or

    Inbound Calls Yday = calculate(
counta(Inbound_Calls[StartDate]),
Inbound_Calls[StartDate].[Date] = (TODAY()-1)
)
az38's avatar
az38
Community Champion
6 years ago

Hi Aimeeclaird 

try more easy

Inbound Calls Yday = calculate(
counta(Inbound_Calls[StartDate]),
Inbound_Calls[StartDate] = (TODAY()-1)
)

or

Inbound Calls Yday = calculate(
counta(Inbound_Calls[StartDate]),
Inbound_Calls[StartDate].[Date] = (TODAY()-1)
)
Aimeeclaird's avatar
Aimeeclaird
Helper IV
6 years ago

Thanks for your help - appreciate you taking the time. Can I ask where I was going wrong please?