Weekly chart for on hold status

Power BI
1

Dear all,
I hope you’re doing well! :blush:

I need your assistance in resolving an issue. Specifically, I’d like to create a weekly chart to track cases that are on hold at the end of the week, specifically on the 5th day (Friday).

Here are the scenarios I’d like your help with:
1st
In the first scenario, if the status is ‘On Hold’ on Tuesday but changes to a different status within the same week, it should not be included in the count.
image

2nd scenario
In the second scenario, a case may have been on hold multiple times within the same week, but if its final status at the end of the week is ‘On Hold,’ it should be counted for that week.

image
image721×412 33.2 KB

3rd scenario
In the third scenario, if a case has been on hold during the same week (week 46) and remains ‘On Hold’ in the subsequent week (week 47), it should be counted for both weeks (46 and 47).
image

Could you please help me here? :blush:

I have attached the file below
onhold weekly chart.pbix (118.6 KB)

I appreciate your assistance with this matter

Regards
Kate

2

any help/suggestion? :slight_smile:

Thank you
Kate

3

just wondering if you have searched the forum for something like. I kinda remember something similar example but I can’t find it.

did you search youtube? did you try EDNA Data mentor or Chatgtp or another AI tool for a solution

thanks
Keith

4

This is an interesting scenario and I am very interested to add this to my watch list. The answer could be very useful in a call support center. Thanks for posting and detailing the scenario.

5

I tried it but couldn’t find any :pensive:

6

Sure!! If i will have something, I will keep you updated here.
Thanks
Kate

7

Have you had a chance to work through this in data mentor?

Some really helpful solutions

I’ve found going step by step you usually get to a solution

The above I put through the Power BI tools advisor