Need to create a visual that displays data from the current day and the from three historical days

[Anonymous]

Help,

I am trying to display Contact Center data on a visual, preferably a bar graph of clustered bar graph. The fields contain DateTime and CallsHandled. What I would like to display is the data for Today's Date and times (interval) and then the historical data from the previous 3 days with the same DOW. For example, display Today's datetimes of 10/13/2020 07:00:00 AM... 10/13/2020 06:00:00 PM, 10/6/2020 07:00:00 AM... 10/6/2020 06:00:00 PM, 09/29/2020 07:00:00 AM... 09/29/2020 06:00:00 PM and 09/22/2020 07:00:00 AM... 09/22/2020 06:00:00 PM.

The data is in one table and contains 6 months of historical data.

Any help with this would be greatly appreciated.

Mark

[wdx223_Daniel · Accepted solution]

TTL_Display =
VAR _CurrenctDate =
    TODAY ()
VAR _CurrenctWeekDay =
    WEEKDAY ( _CurrenctDate )
VAR DaysSelected =
    TOPN (
        3,
        FILTER (
            ALL ( ContactData[Date] ),
            WEEKDAY ( ContactData[Date] ) = _CurrenctWeekDay
                && ContactData[Date] <= _CurrenctDate
        ),
        ContactData[Date]
    )
RETURN
    CALCULATE ( [TTL], KEEPFILTERS ( ContactData[Date] IN DaysSelected ) )

hope this can help you!!

[Anonymous]

Thanks for your response...

I am taking a look at the measure you sent and have a newbe question. What is TTL in the calculate?

I set it up to use my data and ran into this question.

Thanks... Mark

[wdx223_Daniel]

the code of TTL measure is =SUM(ContactData[CallsHandled])