How to show outliers with multiple date fields

[POSPOS]

Hi all,

I have a requirement to know the outliers for orders i.e, how may days a order has taken
for submission,
for firstreview,
for final review,
for activation.

We would like to use a scatter chart to plot all the orders and show the days taken for each step in bubbles. Basically to understand which step has taken the most amount of time.

Could someone provide suggestions on how I could plot all of these in a scatter chart?
We are open to any sort of suggstions/alternatives to represent this data.

Sample data:

The same is available in pbix here.

days for submission -- Days between intake and submit

days for first review-- Days between submit and review

days for final review-- days between review and final

days for activation -- days between final and processed

Thank you.

[gadielsolis]

What about final? Should be blank or the days between final and intake?

[POSPOS]

@gadielsolis  - Basically by the outliers, we are trying to see which step are taken the most amount of time.

[gadielsolis]

Is this the desired outcome?

[POSPOS]

@gadielsolis  - Thanks for this but we are looking to plot all the orders in the visual and not just the summary information.
Basically an overview of all the orders which will help understand which  step has taken the longest time for an order.

[gadielsolis]

In that case my suggestion would be creating a clustered column chart so you can see a single bar per order and this bar will be splitted in colors based on the steps, something like this:

If this works and you need more information on how to create this I'd be more than happy to help

[POSPOS]

@gadielsolis  - 
These are the 4 steps to be represented. We do not have a step which has to show days between final and intake.

days for submission -- Days between intake and submit

days for first review-- Days between submit and review

days for final review-- days between review and final

days for activation -- days between final and processed

If you were referring to final and processed , then yes, the values should be the difference between the two dates and should not be blank.

Irrespective of whether the previous step has a date or does not have a date, the current step should still be the days between the steps based on the formula.

[gadielsolis]

Hello,

What about the orders that don't have one or many of the fields?

[POSPOS]

@gadielsolis  - If the order does not have a date , then that step is blank,

For the below order, as the submit and review fields does not have a date, then the 

days for submission -- Days between intake and submit is blank

days for first review-- Days between submit and review is blank