Bar Graph for time between dates of stages/steps in process

[shaboo]

Good morning and thanks for revieiwng my question!

I have a set of data where a date is entered when each step of serial process is completed for each order.
So for example, Order number 1 was placed on 1/5/2022, then they sent the order to the warehouse on 1/6/2022, then it took the warehouse 6 days to packed the order (they entered the date of 1/12/2022 in the order packed by warehouse column), the shipping company picked up the order on 1/13/2022, then the order was shipped on 1/25/2022, and finally the customer recieved their order on 1/30/2022.

I would like to have  a bar graph that shows the number of days spent at each step and have it stacked so that you can see the total number of days it took for each order. (see the "Desired graph" I drew in the picture below)

Can anyone advise on how to achieve this?
Is there a visual plug in that I can easily use?

Thank you for taking the time to stop by!!

[shaboo]

One more question MahyarTF ...

I'm sure this is a simple thing....(sorry, I'm fairly new)

I was able to recreate what you have shown here.....
my chart appears as such (they are all displying the same values):

I set the graph up using those 4 fields as the x-axis, based on the fields you see (the yellow checkboxes right above). I don't have the option to NOT summarize/count the fields (shown in this drop down here:

For those fields, I used a simple DATEDIFF formula:

On the table of data, I can choose to not summarize and I get the correct numbers for each order:

[shaboo]

Thank you MahyarTF!!

I was also having problems figuring out how to layer the graph....but THANK YOU FOR INCLUDING A DETAILED PICTURE, because I was able to figure it out based on that!!

Thank you so much!!

[MahyarTF · Accepted solution]

Hi,

In my opinion, you need to create separate columns to calculate the difference between each step from the before one, like :

1-2 = if( not(ISBLANK( Sheet227[Order Placed] )) && not(ISBLANK( Sheet227[Order sent to Warehouse] )),

          DATEDIFF( Sheet227[Order Placed],

                    Sheet227[Order sent to Warehouse],

                    DAY

                )

           , 0

        )

Then you could develop the particular visual :

Thanks for your Kudos,

please mark it as a solution if it helps you

[shaboo]

I'm sure this is a simple thing....(sorry, I'm fairly new)

I was able to recreate what you have shown .....
my chart appears as such (they are all displying the same values):

I set the graph up using those 4 fields as the x-axis, based on the fields you see (the yellow checkboxes right above). I don't have the option to NOT summarize/count the fields (shown in this drop down here:

For those fields, I used a simple DATEDIFF formula (which created a calculated column):

On the table of data, I can choose to not summarize and I get the correct numbers for each order: