Forum Discussion

POSPOS's avatar
POSPOS
Icon for Post Partisan rankPost Partisan
2 years ago

How to show outliers with multiple date fields

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.

Need Help

8 Replies

  • gadielsolis's avatar
    gadielsolis
    Icon for Resolver III rankResolver III
    2 years ago

    Hello,

     

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

     

     

    • POSPOS's avatar
      POSPOS
      Icon for Post Partisan rankPost Partisan
      2 years ago

      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



       

  • gadielsolis's avatar
    gadielsolis
    Icon for Resolver III rankResolver III
    2 years ago

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

    • POSPOS's avatar
      POSPOS
      Icon for Post Partisan rankPost Partisan
      2 years ago

      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.

    • POSPOS's avatar
      POSPOS
      Icon for Post Partisan rankPost Partisan
      2 years ago

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