Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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!!
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!!
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
the code of TTL measure is =SUM(ContactData[CallsHandled])
User | Count |
---|---|
57 | |
21 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |