Skip to main content
Solved

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

  • December 11, 2022
  • 2 replies
  • 147 views

Forum|alt.badge.img+2

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?

 

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

 

View original
Did this topic or the replies in the thread help you find an answer to your question?

2 replies

Forum|alt.badge.img+8
  • Problem Solver III
  • 79 replies
  • Answer
  • 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

 


Forum|alt.badge.img+2
  • Author
  • Problem Solver I
  • 3 replies
  • 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 :) 
 


Reply