Skip to main content
Problem Solver I
December 11, 2022
Solved

Segment placed order over all time vs before/after a date

  • December 11, 2022
  • 2 replies
  • 230 views

Hi, 

 

I need some help. I do not understand why this first segment is smaller than two below. Shouldn't it be the sum of the two below? 
Isn’t over all time the sum of everything?

 

    This topic has been closed for replies.
    Best answer by SeanMcC

    I think when dealing with zero order the logic is different ie if you were to try a different logic to test;

    a total order over all time

    b orders after 21

    c orders before 21

     

    then in this a should = b+c

     

    When you are looking at zero orders the same profile will have ordered zero before 21 and after 21..

     

    I’m probably not explaining this very well but hope it helps.

     

    Out of interest what was the purpose of creating these different segments?

     

    Sean

     

    2 replies

    SeanMcCAnswer
    Problem Solver III
    December 11, 2022

    I think when dealing with zero order the logic is different ie if you were to try a different logic to test;

    a total order over all time

    b orders after 21

    c orders before 21

     

    then in this a should = b+c

     

    When you are looking at zero orders the same profile will have ordered zero before 21 and after 21..

     

    I’m probably not explaining this very well but hope it helps.

     

    Out of interest what was the purpose of creating these different segments?

     

    Sean

     

    KatePobiAuthor
    Problem Solver I
    December 11, 2022

    Oh right, thanks! I get it now. Sometimes my logic messes up with me. Thank you so much, I totally get it now :)