Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rate
Helper III
Helper III

Help with Start/End Rolling Process Visualization

Hello!

 

I am struggling with how to represent a visual to show a rolling representation of the start and end of a process from Today.

 

I have a list of processes that have a start and end date assigned. I would want to show in any way possible a table or any kind of visualization where I had today (in the middle) and previous and post 4 days (these would be moving as today moves), and represent two things:

1. For every process, I woul like to show the number of days that coincide with the time 9 days time interval (today, 4 previous and 4 post). For example:

a) Today is 14/02/20

b) Start date was 10/04/20 (this is, 4 days before today)

c) End date is 16/02/20 (so, 2 days from today)

As such, the table will show marked in some way the period from -4 to +2. I have painted something of the sort in Excel:

 

Example.png

 

 

I have the following data, also attached (Link to Excel File) :

Process IDStart of ProcessEnd of ProcessStart to/From TodayEnd to/from Today
110/02/202016/02/2020-42
225/01/202001/02/2020-20-13
305/02/202013/02/2020-9-1
430/01/202005/02/2020-15-9
510/02/202019/02/2020-45
605/02/202011/02/2020-9-3
711/02/202019/02/2020-35
801/02/202009/02/2020-13-5
911/02/202020/02/2020-36
1027/01/202006/02/2020-18-8
1102/02/202012/02/2020-12-2
1227/01/202002/02/2020-18-12
1309/02/202019/02/2020-55
1401/02/202006/02/2020-13-8
1513/02/202023/02/2020-19
1626/01/202001/02/2020-19-13
1725/01/202031/01/2020-20-14
1811/02/202020/02/2020-36
1926/01/202002/02/2020-19-12

 

Do you have any idea on how I could represent something similar to what I (poorly, I'm afraid) explained?

I Thank you so much for your help!

 

Kind regards, 

Rodrigo.

 

 

1 ACCEPTED SOLUTION
3 REPLIES 3

Hello @stretcharm ,

 

That was just what I was desperately looking for. And really grateful for the visual report, really handy!

 

And just awesome the text to Gannt! Thanks a lot!! You saved me.

No problem. Glad its useful.

 

I wrote it when I had a similar problem trying to do minute based gantts and the visuals didn't do what I needed

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.