2/13/2020
6042
255798
MJ SPICY CRAB ROLL
54
2/12/2020
6042
255798
MJ SPICY CRAB ROLL
25
2/11/2020
6042
255798
MJ SPICY CRAB ROLL
4
2/10/2020
6042
255798
MJ SPICY CRAB ROLL
0
2/13/2020
6042
144971145
MJ PHILLY ROLL
3
2/12/2020
6042
144971145
MJ PHILLY ROLL
0
2/11/2020
6042
144971145
MJ PHILLY ROLL
0
2/10/2020
6042
144971145
MJ PHILLY ROLL
1
2/13/2020
6042
54487
CJ POPEYE
0
2/12/2020
6042
54487
CJ POPEYE
0
2/11/2020
6042
54487
CJ POPEYE
0
2/10/2020
6042
54487
CJ POPEYE
5
BUSINESS_DATE
Count
Int32
4
Empty
if [Cases_Out]>0
then 1+[Row-1:Count]
else 0
endif
if [Cases_Out]>0
then 1+[Row-1:Count]
else 0
endif
DateTimeDiff(DateTimeToday(),[BUSINESS_DATE_FORMATTED],'DAY')=1
and [Count]=1
Custom
Checking if yesterday the count is equal to 1
DateTimeDiff(DateTimeToday(),[BUSINESS_DATE_FORMATTED],'DAY')=1
and [Count]=1
BUSINESS_DATE
MM/dd/yyyy
BUSINESS_DATE_FORMATTED
Convert BUSINESS_DATE From:
MM/dd/yyyy
C:\Users\FERNAN~1.VIZ\AppData\Local\Temp\Engine_16752_503f394f84184a9490be0b8a55008cd4_\Engine_12356_959c53309bcd4d6d97f38d70d7a8426a_.yxdb
C:\Users\FERNAN~1.VIZ\AppData\Local\Temp\Engine_16752_503f394f84184a9490be0b8a55008cd4_\Engine_12356_28dba33602b04319a9cea762bf1f7ee6_.yxdb
Single
Profile
C:\Users\FERNAN~1.VIZ\AppData\Local\Temp\Engine_16752_503f394f84184a9490be0b8a55008cd4_\Engine_12356_c8d0910bf2b7400bbfcb7bee85981a0b_.yxdb
Single
Profile
Horizontal
2020-02-14 removing rows based off criteria in other rows