Meeting Title: Looker Data QA Session Date: 2025-07-15 Meeting participants: Demilade Agboola, Emily Giant, felipefaria
WEBVTT
1 00:00:41.740 ⇒ 00:00:43.030 Emily Giant: Hello!
2 00:00:44.300 ⇒ 00:00:45.629 Demilade Agboola: Hi ami! How are you?
3 00:00:46.290 ⇒ 00:00:48.659 Emily Giant: Not bad. How are you?
4 00:00:49.080 ⇒ 00:00:52.760 Demilade Agboola: I’m doing okay, just trying to finish
5 00:00:53.170 ⇒ 00:00:57.739 Demilade Agboola: lunch. I won’t say lunch, because it’s like my 1st one of the day, but it’s like
6 00:00:58.140 ⇒ 00:00:59.400 Demilade Agboola: 3 o’clock. So.
7 00:00:59.740 ⇒ 00:01:02.550 Emily Giant: Oh, my gosh! Do you do that often.
8 00:01:03.370 ⇒ 00:01:04.400 Demilade Agboola: 8 leads, yeah.
9 00:01:06.050 ⇒ 00:01:15.419 Emily Giant: Like eating is what gets me out of bed. So like there is usually food in my mouth before my eyes are like totally open
10 00:01:17.510 ⇒ 00:01:22.390 Emily Giant: motivation. Coffee, does it, too.
11 00:01:22.630 ⇒ 00:01:24.789 Emily Giant: You’ve at least had coffee right.
12 00:01:25.856 ⇒ 00:01:28.710 Demilade Agboola: Probably not. Not- not yet. I I should
13 00:01:29.950 ⇒ 00:01:36.470 Demilade Agboola: so usually right. Food makes me sleepy, so if I have stuff to do, I try not to
14 00:01:37.120 ⇒ 00:01:39.479 Demilade Agboola: eat until I really have to.
15 00:01:40.150 ⇒ 00:01:46.209 Emily Giant: Food also makes me sleepy. So I can sympathize with that. But
16 00:01:46.760 ⇒ 00:01:55.719 Emily Giant: I eat anyway, and I eat so much sugar. I think we were talking about. Like the reasons we don’t do hard drugs is because we’re already like
17 00:01:56.080 ⇒ 00:02:04.739 Emily Giant: too far in with caffeine, etc. My hard drug is sugar, like there’s a candy bar within like 5 feet of me right now. I guarantee
18 00:02:05.180 ⇒ 00:02:06.580 Emily Giant: just to prove a point
19 00:02:10.000 ⇒ 00:02:10.704 Emily Giant: always.
20 00:02:11.890 ⇒ 00:02:12.946 Demilade Agboola: I can see, though.
21 00:02:13.990 ⇒ 00:02:29.619 Emily Giant: Just like like a little rat. It’s like half eaten cookies like all over my desk. It’s just terrible Felipe knows when we went to the facility for Mother’s Day a couple of years ago.
22 00:02:29.620 ⇒ 00:02:48.050 Emily Giant: I like didn’t bring real food, Felipe, but we were talking about like he doesn’t eat until like 3 Pm. And I was like, I don’t really eat either, except for like well, I eat as soon as I wake up, but I eat so much sugar, and like. When Felipe and I were at the facility I brought, like 2 pounds of M. And M’s.
23 00:02:48.750 ⇒ 00:02:59.619 Emily Giant: We were so busy that it’s like all we really had time to eat, and even then I don’t think I od’d I still was like ready to eat more M. And M’s after that, but it was like.
24 00:03:00.630 ⇒ 00:03:04.807 felipefaria: No, I’m with you guys like I. I can skip breakfast easily.
25 00:03:05.140 ⇒ 00:03:05.580 Emily Giant: Really.
26 00:03:05.790 ⇒ 00:03:10.439 felipefaria: Lunch yeah. Sometimes I’ll eat like 1st meal at 2, 3
27 00:03:10.440 ⇒ 00:03:10.820 Demilade Agboola: I tried.
28 00:03:10.820 ⇒ 00:03:17.220 felipefaria: I should have a smoothie in the morning, just to, kinda you know, ingest something, but
29 00:03:18.500 ⇒ 00:03:20.180 felipefaria: I don’t need it. Honestly.
30 00:03:20.640 ⇒ 00:03:22.210 Demilade Agboola: Yeah, mine is coffee.
31 00:03:22.500 ⇒ 00:03:24.039 felipefaria: Yeah. Coffee chew for sure.
32 00:03:24.040 ⇒ 00:03:35.079 Demilade Agboola: Yeah cause, and I’ll say the reason why I don’t eat is cause if I if I have a busy day or I have a lot to do. I’m either too stressed by what I need to do, or if I do eat, I get really sleepy. So.
33 00:03:35.080 ⇒ 00:03:35.640 felipefaria: Yeah.
34 00:03:35.640 ⇒ 00:03:37.650 Demilade Agboola: Just. I just don’t eat that right.
35 00:03:37.650 ⇒ 00:03:40.110 felipefaria: Yeah, yeah, no. I have the same thing.
36 00:03:40.820 ⇒ 00:03:42.320 Demilade Agboola: Exactly the same thing.
37 00:03:43.490 ⇒ 00:03:49.879 Emily Giant: I can’t. I can’t relate. I feel like half the time I eat lunch by like 1030 Am.
38 00:03:50.300 ⇒ 00:03:50.840 felipefaria: And.
39 00:03:50.840 ⇒ 00:03:58.639 Emily Giant: But then I won’t eat until like 10 o’clock at night. And I’m supposed to make breakfast. I have
40 00:03:58.870 ⇒ 00:04:06.749 Emily Giant: agreed to make dinner because I I won’t cook unless somebody’s like starving in front of me. I’ll just eat whatever is like nearby.
41 00:04:06.940 ⇒ 00:04:32.999 Emily Giant: So my partner, he’s a great cook, but feels like I don’t contribute in that way, which I don’t. That’s fair. So I do it on Monday and Tuesday. Those are my nights, and I won’t make dinner till like 9 o’clock at night, I won’t start making dinner, and I need to like get better on the schedule, because just I can eat at midnight and then go right to bed. Doesn’t mean everyone else can. But I think I’m just very European. I don’t know. Maybe I’m giving myself too much credit.
42 00:04:35.412 ⇒ 00:04:40.630 Emily Giant: Okay. So Demo Lauda, I did. I I
43 00:04:42.470 ⇒ 00:04:46.861 Emily Giant: sent through 2 prs, and they weren’t for
44 00:04:48.000 ⇒ 00:04:52.090 Emily Giant: the mart model. But they I did add
45 00:04:52.560 ⇒ 00:05:00.129 Emily Giant: a ton of stuff to looker, and I didn’t know if you wanted to review those because demalade. That’s the Pr that you pushed through.
46 00:05:00.460 ⇒ 00:05:00.930 Demilade Agboola: Yeah.
47 00:05:00.930 ⇒ 00:05:08.549 Emily Giant: Get all like the canceled committed, uncommitted, and thought if you didn’t have anything
48 00:05:08.830 ⇒ 00:05:24.209 Emily Giant: to review first, st we could go into Looker with some of the reports, and add those, and see just Qa. Check in suite to make sure they all line up, etc, with like, especially with canceled and
49 00:05:24.350 ⇒ 00:05:26.440 Emily Giant: committed versus uncommitted.
50 00:05:27.900 ⇒ 00:05:36.270 Demilade Agboola: Yeah. So that’s that’s that was what I wanted to secure today. Cause I pushed through that, hoping that we can like, maybe we can have some access to it in Looker.
51 00:05:36.920 ⇒ 00:05:41.940 Demilade Agboola: and just let us know you know what the numbers look like on his end.
52 00:05:42.570 ⇒ 00:05:51.219 Demilade Agboola: And if, like, there are certain use cases that he has thought of, or he can see that. Don’t you know the numbers are not accurate. That’ll be very helpful feedback for us.
53 00:05:51.530 ⇒ 00:05:52.530 Emily Giant: Okay, great.
54 00:05:53.300 ⇒ 00:06:04.419 Emily Giant: So here, I’ll share screen to get started. Just so I can show, like, what the new fields are
55 00:06:11.030 ⇒ 00:06:12.179 Emily Giant: we go to.
56 00:06:15.620 ⇒ 00:06:25.677 Emily Giant: So I believe all of the new fields are currently in inventory data, not inventory adjustment data. So the like, the lot level table, I call it
57 00:06:26.850 ⇒ 00:06:28.260 Emily Giant: polytonic.
58 00:06:34.760 ⇒ 00:06:37.869 Emily Giant: and we’ve now got
59 00:06:39.830 ⇒ 00:06:52.020 Emily Giant: the canceled well, I don’t know what to call them yet. We can talk through that, but I want to make sure they work. First, st the canceled. There’s redelivery canceled sales, subscription and total canceled
60 00:06:52.720 ⇒ 00:07:01.729 Emily Giant: there’s also uncommitted, so these will be the ones that sent, but did not have a claim.
61 00:07:03.090 ⇒ 00:07:12.819 Emily Giant: And then committed, and then there should be. We’ve always had like the total quantities, but I guess the
62 00:07:14.460 ⇒ 00:07:28.090 Emily Giant: these got kind of lumped in. These were the ones that existed beforehand, and I need to pull those out into a different category, so that it’s not confusing, because those will contain quantity sold redelivery sale and sellable
63 00:07:29.370 ⇒ 00:07:37.380 Emily Giant: those are all gonna contain the confirmed and unconfirmed units. I believe.
64 00:07:37.970 ⇒ 00:07:40.360 felipefaria: The the committed and uncommitted.
65 00:07:40.990 ⇒ 00:07:48.630 Emily Giant: That’s I need to check in the back, because I need to add the word committed so that it’s more obvious like.
66 00:07:49.420 ⇒ 00:08:00.699 Emily Giant: So I can rename these relatively easily committed units sellable quantity to receive so, Demolata, you’d you’d put the word committed in
67 00:08:01.700 ⇒ 00:08:05.900 Emily Giant: the actual field.
68 00:08:06.740 ⇒ 00:08:16.980 Demilade Agboola: Yes, so I committed subscription. Quantity committed redelivery. Yeah.
69 00:08:18.410 ⇒ 00:08:23.259 felipefaria: But the in the quantity sold would also include the cancelled orders. Is that right.
70 00:08:24.780 ⇒ 00:08:28.269 felipefaria: or are we already removing the cancelled orders from it?
71 00:08:29.040 ⇒ 00:08:34.600 Demilade Agboola: No, we’re not. It includes the Council orders, but we can also remove that. So numbers.
72 00:08:34.600 ⇒ 00:08:35.030 felipefaria: So.
73 00:08:35.039 ⇒ 00:08:36.049 Demilade Agboola: By the side.
74 00:08:36.559 ⇒ 00:08:38.669 Demilade Agboola: So it would just be simple subtraction.
75 00:08:39.710 ⇒ 00:08:42.940 felipefaria: Yeah. Yeah. Like.
76 00:08:43.720 ⇒ 00:08:44.215 Demilade Agboola: It.
77 00:08:45.550 ⇒ 00:09:06.680 felipefaria: It would be helpful to have a measure. If if you guys wanna keep the the quantity sold as is because the canceled order was actually sold, but then refunded. I don’t know if there is a scenario that we would want to look at that, but like a measure that is total quantity shipped right, which is essentially everything committed uncommitted
78 00:09:06.980 ⇒ 00:09:15.140 felipefaria: except for canceled orders. So we would have to remove the cancelled order, so that makes sense.
79 00:09:16.207 ⇒ 00:09:20.710 Emily Giant: I’ll add that as a note, and then I’m gonna change.
80 00:09:21.040 ⇒ 00:09:26.810 Emily Giant: I I think I had just done this wrong, and added, the committed units. This should be
81 00:09:28.390 ⇒ 00:09:30.370 Emily Giant: total shipped.
82 00:09:33.820 ⇒ 00:09:39.819 Emily Giant: and I’m just going to put this in the category, for now. Oh, wait!
83 00:09:41.410 ⇒ 00:09:42.870 Emily Giant: Hold on, Looker.
84 00:09:43.050 ⇒ 00:09:55.718 Emily Giant: even when it says like, do you want to change pages? And you say No, it will still change the page. Felipe, can you do me a favor and let me know which of the
85 00:09:57.340 ⇒ 00:10:01.579 Emily Giant: reports on your board we can use, as
86 00:10:02.140 ⇒ 00:10:06.470 Emily Giant: we’re not going to change anything in the report that we save, but which one would be great
87 00:10:06.590 ⇒ 00:10:08.890 Emily Giant: to use as a
88 00:10:09.030 ⇒ 00:10:15.610 Emily Giant: Qa. That we can just add those 2, and it would make sense. So we’ve got like, how old.
89 00:10:15.610 ⇒ 00:10:16.910 Emily Giant: So he’s.
90 00:10:20.650 ⇒ 00:10:26.222 felipefaria: The thing is this, reports like, and I don’t have one that has the measure of
91 00:10:28.010 ⇒ 00:10:41.660 felipefaria: total quantity like, you know, sold or shipped, because that would be the easiest way to Qa. Against the dash, or even add suites, because all of these are like separated by sales subscription, redelivery.
92 00:10:42.704 ⇒ 00:10:45.869 Emily Giant: Okay, we can get a new one. That’s no, no worries.
93 00:10:46.220 ⇒ 00:10:46.740 felipefaria: Yeah.
94 00:10:47.720 ⇒ 00:10:48.440 Emily Giant: Okay.
95 00:10:48.440 ⇒ 00:10:56.060 felipefaria: Therefore targets like it has everything. But the thing is, those are still under the
96 00:10:56.530 ⇒ 00:11:00.230 felipefaria: the delivery date. I haven’t changed it yet. Should the
97 00:11:01.040 ⇒ 00:11:10.380 felipefaria: to the prepped date which is, I’m gonna do it actually, today. Because I’m gonna start building the weekly recaps for for last week today.
98 00:11:11.224 ⇒ 00:11:15.070 felipefaria: Then, my go, my, I have it on my notes. She just
99 00:11:15.370 ⇒ 00:11:19.619 felipefaria: update those reports to have it prep date instead of delivery date
100 00:11:19.890 ⇒ 00:11:23.520 felipefaria: cause. That would be easier to to validate against dash and stuff.
101 00:11:23.870 ⇒ 00:11:28.909 Emily Giant: Yeah, for sure. And then in the polyatomic models.
102 00:11:29.413 ⇒ 00:11:50.649 Emily Giant: There is a Pr for review right now that has. It’s called fulfillment date so it will be like much easier. It’s not scheduled. There’s original prep date and actual. And then there’s like adjustment date. And that’s your fulfillment date. So I did update all of that after our combo yesterday.
103 00:11:51.769 ⇒ 00:11:56.860 Emily Giant: So I don’t know if it’s easier if I build this and then send you the link.
104 00:11:57.120 ⇒ 00:12:08.029 Emily Giant: And that way I can go into look a real quick and update those groupings. So it’s easier to know what we’re qaing, because those are a little funky right now, but I’ll I’ll throw together like a quick and dirty.
105 00:12:08.280 ⇒ 00:12:13.831 felipefaria: Yeah, we can do that like. And and I’m planning to separate, like, you know, an hour block
106 00:12:14.530 ⇒ 00:12:18.710 felipefaria: like a day to do Qa as needed. Essentially so.
107 00:12:21.320 ⇒ 00:12:26.729 felipefaria: if you, if you we can do it now, or you can just put it together and send it to me, and I’ll and I’ll
108 00:12:26.970 ⇒ 00:12:29.940 felipefaria: go through it and and do a Qa. On it.
109 00:12:30.920 ⇒ 00:12:34.529 Emily Giant: Okay, I’m gonna do that. So I’m just gonna start with the totals.
110 00:12:34.660 ⇒ 00:12:43.680 Emily Giant: And then let’s like, choose a skew or a lot, so that we’re not looking at a thousand things from the last, like
111 00:12:43.780 ⇒ 00:12:45.469 Emily Giant: 3 weeks or 2 weeks.
112 00:12:46.635 ⇒ 00:12:47.500 Emily Giant: Product.
113 00:12:53.250 ⇒ 00:12:54.659 Emily Giant: Let’s do
114 00:12:58.820 ⇒ 00:13:04.009 Emily Giant: old reliable. Okay, and then adjustment date.
115 00:13:07.350 ⇒ 00:13:16.160 Emily Giant: But let’s do. Date day is the key date one here last 3 weeks.
116 00:13:17.740 ⇒ 00:13:26.300 felipefaria: This is this is adjustment. Date adjustment. Date is the same as fulfillment date on this one, or we’re doing a different.
117 00:13:26.690 ⇒ 00:13:35.520 Emily Giant: Right? I haven’t. That Pr hasn’t been pushed yet. Is a Monday through Sunday week. So.
118 00:13:35.520 ⇒ 00:13:37.839 Emily Giant: oh, yeah, this is for sales. Okay, yeah.
119 00:13:37.840 ⇒ 00:13:41.530 Emily Giant: Okay. And then, should I add location? That would probably make it easier.
120 00:13:41.610 ⇒ 00:13:46.270 felipefaria: Yeah, it makes it easier to do, Qa, because then we can narrow down to 1 1. i’ve seen.
121 00:13:46.800 ⇒ 00:13:50.380 Emily Giant: Yeah, okay, well, we know it’s the firecracker. So
122 00:13:53.020 ⇒ 00:13:59.599 Emily Giant: and let’s add lot for now, just so it’s easier to like PIN it down. And in netsuite.
123 00:14:03.880 ⇒ 00:14:04.810 Emily Giant: All right.
124 00:14:22.980 ⇒ 00:14:30.350 Emily Giant: Okay, cool. Here. Let me send you all this link. And then I’m gonna go into the back end and change those names real quick. So it isn’t as like convoluted.
125 00:14:34.680 ⇒ 00:14:36.130 Demilade Agboola: Okay. Sounds good.
126 00:14:36.590 ⇒ 00:14:38.770 Emily Giant: Go alright. That’s in the chat.
127 00:14:44.540 ⇒ 00:14:48.979 Emily Giant: I can stop sharing for now, while I change those.
128 00:14:51.180 ⇒ 00:14:54.589 felipefaria: But in order to do the Qa. On this data,
129 00:14:55.690 ⇒ 00:15:05.280 felipefaria: we we can do it against the total quantity sold and check how many canceled orders are in dash, but the committed versus uncommitted.
130 00:15:05.480 ⇒ 00:15:10.509 felipefaria: and that’s is there a way to Qa. That easily like, and how you’re doing.
131 00:15:10.510 ⇒ 00:15:15.281 Emily Giant: Not really what we’re gonna have to do is there shouldn’t be that many?
132 00:15:16.060 ⇒ 00:15:21.829 Emily Giant: I would choose a couple, and we can like, split them up, and then spot, check them in dash, because it will say.
133 00:15:21.830 ⇒ 00:15:22.510 felipefaria: That’s it.
134 00:15:22.510 ⇒ 00:15:23.110 Emily Giant: On the order.
135 00:15:23.110 ⇒ 00:15:30.110 felipefaria: Okay, yeah, okay, you go to that specific order or specific lot and then open all the orders within the lot.
136 00:15:30.360 ⇒ 00:15:38.169 Emily Giant: I didn’t even think about that. I can pull. I can actually pull the suborder numbers. Not in this data set. But
137 00:15:39.030 ⇒ 00:15:43.582 Emily Giant: okay, let me look at that report that I just sent you. That is a good call.
138 00:15:44.020 ⇒ 00:15:46.100 Emily Giant: I’m just gonna pull every order.
139 00:15:47.420 ⇒ 00:15:51.390 Emily Giant: Where’s a good lot? Let’s find one that has a good amount of like everything.
140 00:15:51.530 ⇒ 00:15:53.040 Emily Giant: Alright. So this.
141 00:15:53.040 ⇒ 00:15:54.210 felipefaria: Baltimore would be the.
142 00:15:54.210 ⇒ 00:16:00.709 Emily Giant: On. Yeah, I’m going to pull. Lot 4, dash 1, 6, 3, 6, 4, 1.
143 00:16:02.770 ⇒ 00:16:03.230 felipefaria: Class.
144 00:16:03.230 ⇒ 00:16:05.759 Emily Giant: But at the transaction level.
145 00:16:07.140 ⇒ 00:16:10.520 Emily Giant: Okay, so mark inventory adjustments.
146 00:16:14.160 ⇒ 00:16:15.270 Emily Giant: So I do.
147 00:16:16.710 ⇒ 00:16:17.579 Emily Giant: I don’t know.
148 00:16:23.300 ⇒ 00:16:25.190 Emily Giant: I’m gonna share again while we’re doing this.
149 00:16:32.240 ⇒ 00:16:39.680 Emily Giant: So I’m thinking, if I backtrack like one from the inventory mart, we’re going to get back into like adjustment level sales. So
150 00:16:40.440 ⇒ 00:16:43.530 Emily Giant: yeah, this will do. Int inventory suborder adjustment types.
151 00:17:28.000 ⇒ 00:17:33.990 Emily Giant: I just need to pull the like looker id for this lot. So I can plug that in.
152 00:17:51.770 ⇒ 00:17:52.860 Emily Giant: All right.
153 00:17:53.070 ⇒ 00:17:59.300 Emily Giant: I’m gonna add these to that spreadsheet that I always paste stuff in. I’ll send the link through.
154 00:18:13.660 ⇒ 00:18:19.640 Emily Giant: It’s okay. So then, 15. How’s it already? The 15th of July.
155 00:18:20.790 ⇒ 00:18:21.510 felipefaria: No.
156 00:18:22.830 ⇒ 00:18:27.869 Emily Giant: I think I just love summer so much that like, it just speeds. By.
157 00:18:28.960 ⇒ 00:18:31.059 Emily Giant: Yeah, yeah, it does. It does go.
158 00:18:34.060 ⇒ 00:18:35.669 felipefaria: Almost in August.
159 00:18:37.340 ⇒ 00:18:42.560 Emily Giant: I still sometimes feel like a kid, too, you know, when you know you have to go back to school in August.
160 00:18:43.800 ⇒ 00:18:46.280 felipefaria: I know.
161 00:18:52.680 ⇒ 00:18:55.010 Emily Giant: All right, so it looks like the
162 00:18:55.730 ⇒ 00:18:59.609 Emily Giant: like off the bat. All of these numbers look totally great and normal.
163 00:18:59.730 ⇒ 00:19:08.529 Emily Giant: The canceled order is, I’m going to check this canceled order and make sure that it’s canceled.
164 00:19:19.810 ⇒ 00:19:21.930 Emily Giant: Yeah, yeah.
165 00:19:23.540 ⇒ 00:19:28.499 felipefaria: Then, in the report that you just created, does it have committed and uncommitted as well.
166 00:19:28.770 ⇒ 00:19:31.480 Emily Giant: Yes, so does it.
167 00:19:32.760 ⇒ 00:19:38.640 Emily Giant: What did I just pull? Oh, I see what I did. Okay, it doesn’t.
168 00:19:41.230 ⇒ 00:19:45.630 Emily Giant: So I’m gonna need to. There should be like integration status in here.
169 00:19:46.810 ⇒ 00:19:50.900 Emily Giant: Okay, this one looks weird, right? No, it’s a different item.
170 00:19:51.110 ⇒ 00:19:52.949 Emily Giant: So if I check this.
171 00:19:54.680 ⇒ 00:19:56.190 Demilade Agboola: It should be uncommitted.
172 00:19:56.190 ⇒ 00:19:58.980 Emily Giant: Yep, and it’s for 2.
173 00:20:00.530 ⇒ 00:20:06.980 Emily Giant: So the criteria is, if the item Id does not equal.
174 00:20:08.210 ⇒ 00:20:11.480 Emily Giant: Okay, it’s on hand committed. But
175 00:20:12.460 ⇒ 00:20:15.350 Emily Giant: oh, there it is on order committed for the Margo.
176 00:20:15.680 ⇒ 00:20:21.070 Emily Giant: So somehow this is very odd.
177 00:20:21.330 ⇒ 00:20:23.920 Emily Giant: I don’t understand how the Margo got on that lot.
178 00:20:24.160 ⇒ 00:20:26.890 felipefaria: Why isn’t it a redelivery?
179 00:20:27.080 ⇒ 00:20:29.529 felipefaria: Because if it has the dash 2,
180 00:20:30.840 ⇒ 00:20:34.930 felipefaria: does it say anything? Doesn’t say anything about being redelivery?
181 00:20:34.930 ⇒ 00:20:38.060 Emily Giant: It doesn’t. It’s like they ordered 2 things at once.
182 00:20:38.060 ⇒ 00:20:38.929 felipefaria: Okay. The Rh.
183 00:20:38.930 ⇒ 00:20:41.470 Emily Giant: They just split into separate sub orders.
184 00:20:42.370 ⇒ 00:20:50.130 felipefaria: Yeah, that makes sense. Cause it would be separate suborders, right? Like, it’s 1 suborder per package. Essentially.
185 00:20:50.130 ⇒ 00:20:53.360 Emily Giant: Yeah, cause they wouldn’t. They wouldn’t package those together.
186 00:20:53.360 ⇒ 00:20:54.070 felipefaria: Yeah.
187 00:20:55.760 ⇒ 00:21:00.189 Emily Giant: So that’s the one that stands out to me as strange in this.
188 00:21:00.190 ⇒ 00:21:04.120 felipefaria: Item. Id. Well, I think it’s because it’s pulling
189 00:21:04.280 ⇒ 00:21:13.839 felipefaria: like if if the order number has the firecracker, I think, is gonna show in this report, but if it also has a separate.
190 00:21:14.620 ⇒ 00:21:21.490 felipefaria: like a a second suborder, right, I think, is also pulling into this report. For some reason.
191 00:21:21.490 ⇒ 00:21:22.110 Emily Giant: Yeah.
192 00:21:22.110 ⇒ 00:21:24.964 felipefaria: I don’t know if it’s wrong, it’s just it’s just.
193 00:21:25.830 ⇒ 00:21:36.049 felipefaria: Do we have the dash? One of the same one here 29, one, yeah, 29. Dash one all the way back here. But then it’s repeating the quantities
194 00:21:36.420 ⇒ 00:21:39.510 felipefaria: of the original.
195 00:21:39.790 ⇒ 00:21:40.720 Emily Giant: Right here.
196 00:21:40.720 ⇒ 00:21:51.069 felipefaria: Yeah. Cause you see that one has 2 quantity sold right, and the Margo there also has 2. But I believe that in the subord is only one more goal. There’s not 2 more goals.
197 00:21:52.370 ⇒ 00:21:53.819 Emily Giant: God. Okay.
198 00:21:53.820 ⇒ 00:22:00.649 felipefaria: So it’s something like referencing the the main suborder, the 1st suborder. But then.
199 00:22:01.390 ⇒ 00:22:08.600 felipefaria: including any other suborders that are under the same order. Essentially I don’t know why, but.
200 00:22:09.080 ⇒ 00:22:14.740 Emily Giant: Yeah, that’s really, that’s something we’re gonna have to look into, because that’s a new one. I have not seen it do that.
201 00:22:16.260 ⇒ 00:22:22.690 Emily Giant: All right. What I can do also is, let me figure out first, st where’s that looker report?
202 00:22:23.680 ⇒ 00:22:29.220 Emily Giant: I want to see how many. Okay, so this is the uncommitted right here. So.
203 00:22:29.570 ⇒ 00:22:30.420 felipefaria: It’s.
204 00:22:31.080 ⇒ 00:22:37.629 Emily Giant: If that were the firecracker, that would be totally correct, because it is an uncommitted sale
205 00:22:40.080 ⇒ 00:23:02.160 Emily Giant: that well, it hasn’t delivered yet. So when that changes to on order committed. Alright. So one of the things I’m thinking is that if it’s going to be total shipped, that there has to be additional logic of like and delivery date is in the past, because this hasn’t shipped yet. So there’s some legitimacy
206 00:23:02.300 ⇒ 00:23:07.910 Emily Giant: to this saying on order committed in the event that
207 00:23:08.130 ⇒ 00:23:12.260 Emily Giant: the product isn’t at the Fc. Yet, so.
208 00:23:12.690 ⇒ 00:23:17.480 felipefaria: Yeah. Yeah. And I think that that makes sense. Because.
209 00:23:17.870 ⇒ 00:23:31.100 felipefaria: as of this morning before the meeting, I know that the second inbounds haven’t been. P. Haven’t been received yet at the Hub, so it makes sense should be on order commit. But it’s still committed right? It’s not uncommitted. It’s just on order.
210 00:23:31.640 ⇒ 00:23:32.100 Emily Giant: Right.
211 00:23:32.100 ⇒ 00:23:33.470 felipefaria: Make that distinction.
212 00:23:33.790 ⇒ 00:23:40.330 Emily Giant: Yep, adding logic for uncommitted.
213 00:23:42.470 ⇒ 00:23:51.640 Emily Giant: The delivery date should be in the past, pen
214 00:23:52.490 ⇒ 00:24:06.450 Emily Giant: checking out y dash, 2 suborders, but different products would show up on the wrong lot.
215 00:24:09.100 ⇒ 00:24:11.429 Emily Giant: That is so odd.
216 00:24:12.163 ⇒ 00:24:16.149 Emily Giant: The showing up the margot on that firecracker lot.
217 00:24:16.370 ⇒ 00:24:26.340 Emily Giant: Okay, let’s so it’s like it’s the numbers are quantifying in a way that I totally understand.
218 00:24:26.959 ⇒ 00:24:44.770 Emily Giant: And then the difference, right is going to be those 2 Margo’s that so the total quantity sold versus the total committed like this is correct. The 29, the 31 is counting the 2 Margo’s that are accidentally getting shoved onto that lot, and then the canceled is correct.
219 00:24:45.850 ⇒ 00:24:48.170 Emily Giant: So yeah, but.
220 00:24:48.170 ⇒ 00:24:56.869 felipefaria: Is there a way to to check the suborders under the uncommitted quantity sold or no? And the suborder numbers, like.
221 00:24:56.870 ⇒ 00:24:57.450 Emily Giant: Yeah.
222 00:24:57.450 ⇒ 00:24:58.579 felipefaria: And just do.
223 00:24:59.210 ⇒ 00:25:08.879 Emily Giant: It’s definitely that 2, 9, yeah, it’s cause the what this model is
224 00:25:09.280 ⇒ 00:25:21.250 Emily Giant: is an upstream table that takes the suborders before they’re like aggregated and splits them out so essentially
225 00:25:21.480 ⇒ 00:25:23.895 Emily Giant: without getting, too, in the weeds here.
226 00:25:26.210 ⇒ 00:25:31.869 Emily Giant: if we’re looking at the non Hardgood adjustments in the data lineage.
227 00:25:33.470 ⇒ 00:25:38.530 Emily Giant: It’s taking the different suborder adjustment types. So these are the like sales.
228 00:25:39.450 ⇒ 00:25:51.359 Emily Giant: redeliveries and subscriptions. And these are the other reconciliation types like spoilage, shrinkage, etc. It’s taking the individual suborders and adding them together. And then this is where
229 00:25:51.510 ⇒ 00:26:15.050 Emily Giant: what we’re playing with in looker right now. So it goes. Take the suborders, add them together in this one. And then here’s where we like, add fiscal dates, and, like Afs, logic and stuff. So all of the actual like logic. That we’re pulling is for sales is from the suborder level. We’re just adding them together so that you don’t have to like look at them on that
230 00:26:15.180 ⇒ 00:26:21.610 Emily Giant: like chopped up level when you want to just see the aggregate so.
231 00:26:22.280 ⇒ 00:26:22.840 felipefaria: Okay.
232 00:26:23.320 ⇒ 00:26:25.530 Emily Giant: Yeah, so we can pull from
233 00:26:25.770 ⇒ 00:26:30.970 Emily Giant: that model to get. I wish we had the like commitment statuses, though.
234 00:26:31.480 ⇒ 00:26:35.799 Emily Giant: that would be really helpful. That’s what I was working on this morning. I just I
235 00:26:35.910 ⇒ 00:26:40.009 Emily Giant: I just committed like the second of 3.
236 00:26:41.060 ⇒ 00:26:44.019 felipefaria: Do that American status under each suborder.
237 00:26:44.590 ⇒ 00:26:45.340 Emily Giant: Yeah.
238 00:26:45.340 ⇒ 00:26:46.730 felipefaria: Oh, okay.
239 00:26:47.070 ⇒ 00:26:48.740 Emily Giant: I mean, I don’t think that would be
240 00:26:50.510 ⇒ 00:26:53.579 Emily Giant: that’s difficult, because he already did it.
241 00:26:56.760 ⇒ 00:27:03.210 Emily Giant: So if I just did the aggregate model, and then added, Suborder id!
242 00:27:04.510 ⇒ 00:27:05.549 Emily Giant: It’s like one.
243 00:27:06.000 ⇒ 00:27:07.639 Demilade Agboola: What what are we trying to do here.
244 00:27:08.540 ⇒ 00:27:15.060 Emily Giant: He just wants to see the suborder Id in the grouped adjustment. So I’m just going to compile it and add sub order Id.
245 00:27:15.210 ⇒ 00:27:16.400 Emily Giant: And that way.
246 00:27:16.400 ⇒ 00:27:19.209 felipefaria: Yeah, easier way to to identify
247 00:27:19.360 ⇒ 00:27:25.210 felipefaria: which orders are the ones on uncommitted, or which orders are the ones.
248 00:27:25.686 ⇒ 00:27:29.130 Demilade Agboola: In that case we can do. We can add it to the aggregate model.
249 00:27:29.710 ⇒ 00:27:33.610 Emily Giant: Yeah, that’s what I was thinking. So if I just use sub order id.
250 00:27:34.220 ⇒ 00:27:43.879 Demilade Agboola: Yeah, but I don’t want you to find out. I’ll use something. There’s this thing called array ag, which aggregates like arrays. And you can have, like multiple values all in one row.
251 00:27:44.840 ⇒ 00:28:01.690 Demilade Agboola: And so what we can do is we can add that to the final model. And as, like uncommitted, so border ids the actual numbers like the other Ids, and we can now push it through, and so it will. You’ll be able to just add it to the table, and it’s just be one row.
252 00:28:02.570 ⇒ 00:28:03.570 Emily Giant: Oh, okay.
253 00:28:03.570 ⇒ 00:28:04.370 Demilade Agboola: Yeah.
254 00:28:05.790 ⇒ 00:28:09.595 Emily Giant: I mean, that sounds like super useful oops.
255 00:28:11.720 ⇒ 00:28:17.750 Emily Giant: So for this morning I can just add the suborder id, so that we can check them more easily.
256 00:28:19.200 ⇒ 00:28:27.389 Emily Giant: I think supporter id already exists in all of the upstream models. So you were trying to what?
257 00:28:31.450 ⇒ 00:28:32.220 Emily Giant: Sorry
258 00:28:36.240 ⇒ 00:28:37.869 Emily Giant: gotta be like a group by, yeah.
259 00:28:47.640 ⇒ 00:28:50.310 Emily Giant: So I don’t even need this reconciliation part.
260 00:28:50.850 ⇒ 00:28:52.609 Emily Giant: Oh, whatever we might use it later.
261 00:28:53.380 ⇒ 00:28:54.180 Emily Giant: No.
262 00:29:10.290 ⇒ 00:29:12.709 Emily Giant: Feel like, I need to add it to it. Yeah, there it is. Okay.
263 00:29:18.430 ⇒ 00:29:23.380 felipefaria: Yeah, I think that this would be helpful to just to have a like if I wanna just pull
264 00:29:23.500 ⇒ 00:29:28.020 felipefaria: a whole list of uncommitted supporters.
265 00:29:29.860 ⇒ 00:29:35.439 felipefaria: Because ideally right, we can. We can incorporate into the schedule to
266 00:29:36.660 ⇒ 00:29:52.169 felipefaria: should essentially commit those orders retroactively. And I’ll have to check with that if that’s possible. But ideally, I I would think that we would want that right? So we could check on a weekly basis and see, okay, from last week, which orders are uncommitted.
267 00:29:52.480 ⇒ 00:30:04.449 felipefaria: and then somebody from the scm team could essentially go through and commit those to the correct lots. And if there is an adjustment like a shrinkage adjustment preventing.
268 00:30:05.040 ⇒ 00:30:11.699 felipefaria: like like filling up that lot, and they can remove that, shrink it, adjustment and add the order into it and commit.
269 00:30:12.230 ⇒ 00:30:13.209 Emily Giant: Cause, you think.
270 00:30:13.210 ⇒ 00:30:16.650 felipefaria: Just like like correcting the system for that.
271 00:30:16.780 ⇒ 00:30:17.440 Emily Giant: Yep.
272 00:30:19.570 ⇒ 00:30:26.639 Emily Giant: Okay, yeah, that’d be super helpful. So I’m gonna add oops where inventory?
273 00:30:58.170 ⇒ 00:31:06.179 Emily Giant: Alright. So committed 0 2. And I’m guessing it’s going to be that? 2, 9. Yep, okay.
274 00:31:06.460 ⇒ 00:31:08.330 Emily Giant: So that totally checks out.
275 00:31:13.510 ⇒ 00:31:16.610 Emily Giant: And then, yeah, uncommitted quantity sold.
276 00:31:16.840 ⇒ 00:31:18.620 Emily Giant: And that’s the only one.
277 00:31:24.450 ⇒ 00:31:25.340 Emily Giant: Okay.
278 00:31:26.030 ⇒ 00:31:27.773 felipefaria: Yeah. It’s that one.
279 00:31:29.120 ⇒ 00:31:31.479 Emily Giant: Let’s do the one that has like 8 uncommitted.
280 00:31:34.090 ⇒ 00:31:40.669 Emily Giant: Oh, I’m such a ding, dong! I forgot that I added inventory number id to this so that we don’t have to like struggle.
281 00:31:41.460 ⇒ 00:31:42.140 Emily Giant: Okay.
282 00:31:48.190 ⇒ 00:31:58.950 felipefaria: But Emily, and and is the goal to make that distinction between uncommitted versus on order committed, or it will always show, on order committed under the
283 00:31:59.130 ⇒ 00:32:00.260 felipefaria: uncommitted.
284 00:32:01.630 ⇒ 00:32:11.510 Emily Giant: Yeah, that’s a a good point, because on order committed is only uncommitted if it sends to the customer in that status.
285 00:32:12.050 ⇒ 00:32:20.559 Emily Giant: If it’s on order committed. That’s still not a firm commitment. Once the product arrives. So I need to like specify that in.
286 00:32:21.170 ⇒ 00:32:28.259 felipefaria: What you were saying about like, only if it’s past the the ship date, and something like that.
287 00:32:28.510 ⇒ 00:32:36.890 Emily Giant: Yep, so on. Order and order committed does exist in that table, but it doesn’t mean uncommitted.
288 00:32:37.692 ⇒ 00:32:49.890 Emily Giant: On order committed already exists in the table is not necessarily an uncommond order
289 00:32:50.790 ⇒ 00:32:55.700 Emily Giant: unless it ships to customer, not status.
290 00:32:58.110 ⇒ 00:33:02.889 Emily Giant: That is a a very important distinction. Okay, that makes sense.
291 00:33:05.440 ⇒ 00:33:09.790 Emily Giant: Oh, so this one I wanted to check out.
292 00:33:27.000 ⇒ 00:33:31.750 Emily Giant: Okay, so like off the bat, I’m going to look for like weird. Item, I oh, we don’t have item id in this one?
293 00:33:35.800 ⇒ 00:33:37.680 Emily Giant: Uncommitted.
294 00:33:41.360 ⇒ 00:33:44.580 Emily Giant: Why is it only showing one? Did I run the wrong? Id?
295 00:33:48.570 ⇒ 00:33:50.169 Emily Giant: Oh, 1, 2.
296 00:33:51.170 ⇒ 00:33:53.300 Emily Giant: Wait! How many are we expecting?
297 00:33:53.580 ⇒ 00:33:55.219 Emily Giant: I’m expecting 8.
298 00:33:55.990 ⇒ 00:33:56.570 Demilade Agboola: Oh, okay.
299 00:33:56.570 ⇒ 00:33:58.500 Emily Giant: Oh, I y’all.
300 00:33:58.860 ⇒ 00:34:01.810 Emily Giant: I don’t think I copy pasted the right id.
301 00:34:04.380 ⇒ 00:34:06.519 Emily Giant: yeah, I did. Okay, run it again.
302 00:34:08.380 ⇒ 00:34:11.799 Emily Giant: I’ll pop this in that sheet so that you can actually see it.
303 00:34:12.550 ⇒ 00:34:13.239 felipefaria: Yeah.
304 00:34:16.880 ⇒ 00:34:17.699 Emily Giant: Tough.
305 00:34:18.230 ⇒ 00:34:19.219 Emily Giant: Come on
306 00:34:41.580 ⇒ 00:34:46.769 Emily Giant: one second before I do that. I need to. Preserve this number.
307 00:34:54.090 ⇒ 00:34:55.340 Emily Giant: No.
308 00:35:10.450 ⇒ 00:35:13.500 Emily Giant: Are there any cancellation, no cancels on this slot.
309 00:35:20.390 ⇒ 00:35:22.139 Emily Giant: Where are we getting the 8?
310 00:35:24.900 ⇒ 00:35:26.560 Emily Giant: Oh, that’s redelivery sorry.
311 00:35:33.380 ⇒ 00:35:34.910 felipefaria: 0. There
312 00:35:38.540 ⇒ 00:35:40.679 felipefaria: unlimited subscriptions.
313 00:35:43.160 ⇒ 00:35:43.700 Demilade Agboola: Okay.
314 00:35:48.000 ⇒ 00:35:48.780 Demilade Agboola: you know.
315 00:35:52.280 ⇒ 00:35:54.809 Emily Giant: I’m only seeing 2, really.
316 00:36:05.880 ⇒ 00:36:10.819 Emily Giant: and it’s on hand committed. Okay, this is a forced upgrade.
317 00:36:14.140 ⇒ 00:36:20.479 felipefaria: Yeah, is it? If you go to the top of the dash page, does it say.
318 00:36:21.060 ⇒ 00:36:23.030 felipefaria: Oh, yeah, delivery of.
319 00:36:23.030 ⇒ 00:36:25.010 Emily Giant: Free delivery of a subscription.
320 00:36:26.130 ⇒ 00:36:29.460 felipefaria: But why is it? Oh, okay, yeah. Redelivery. Okay. That makes sense.
321 00:36:35.100 ⇒ 00:36:39.039 Emily Giant: Can y’all hear my cat like letting it rip beside me right now.
322 00:36:40.430 ⇒ 00:36:41.045 Emily Giant: She’s.
323 00:36:42.320 ⇒ 00:36:43.170 Emily Giant: Chatty.
324 00:36:44.210 ⇒ 00:36:45.850 Emily Giant: She wants to go outside.
325 00:36:49.220 ⇒ 00:36:51.830 felipefaria: Do you have just one cat.
326 00:36:52.200 ⇒ 00:37:11.339 Emily Giant: I say I have one and a half she’s my like legitimate cat that we take ownership of, and then we have this cat that hasn’t left our porch in 9 months, who we take to the vet and feed and got neutered and let in the house all the time, but I still don’t claim ownership of him just yet. He’s.
327 00:37:11.340 ⇒ 00:37:11.790 felipefaria: Yeah.
328 00:37:11.790 ⇒ 00:37:14.200 Emily Giant: Pretty sweet, though. Do you have cats?
329 00:37:15.140 ⇒ 00:37:20.729 felipefaria: No, there was one that showed up here. Stayed like a month.
330 00:37:21.020 ⇒ 00:37:24.059 felipefaria: and we were taking care of it, but then it went its way.
331 00:37:25.080 ⇒ 00:37:26.819 Emily Giant: They’re so odd like that.
332 00:37:31.190 ⇒ 00:37:32.220 Emily Giant: So I don’t.
333 00:37:32.370 ⇒ 00:37:33.279 felipefaria: I’m guessing.
334 00:37:34.720 ⇒ 00:37:42.839 Demilade Agboola: But even the committed quantity seems a bit higher in the dash. So it’s 58, but committed 51
335 00:37:43.890 ⇒ 00:37:50.069 Demilade Agboola: that there is, I’m not sure why, that number is much higher.
336 00:37:51.780 ⇒ 00:37:54.340 Emily Giant: And then both of these are forced upgrades.
337 00:37:57.190 ⇒ 00:38:00.489 Emily Giant: So in the case of the uncommitted ones that pulled
338 00:38:01.130 ⇒ 00:38:05.999 Emily Giant: from the upstream model, which that’s good to identify them like.
339 00:38:08.280 ⇒ 00:38:14.663 Emily Giant: But there needs to be. Excuse me, there needs to be some like differentiation there.
340 00:38:15.990 ⇒ 00:38:22.289 Emily Giant: because I mean the one that’s crossed out is indeed not committed, but this is
341 00:38:23.130 ⇒ 00:38:27.020 Emily Giant: when delivery was 7, 8. So it already happened.
342 00:38:31.150 ⇒ 00:38:31.680 felipefaria: Submit.
343 00:38:33.840 ⇒ 00:38:43.479 felipefaria: so why, it would be helpful, and I don’t know exactly how. But if we could just pull the supporters directly in looker right like. If there’s a column uncommitted.
344 00:38:44.775 ⇒ 00:39:00.919 felipefaria: Then just adding kind of field of suborder id, and it will kind of show, because if it’s pulling 8 there. It must be coming from sub order id numbers right like, and there’s no way to to get those suborder ids somehow.
345 00:39:01.320 ⇒ 00:39:08.900 Emily Giant: Yeah, it’s it’s the one. It’s these in the sheet like here.
346 00:39:09.170 ⇒ 00:39:10.389 Emily Giant: And then.
347 00:39:10.390 ⇒ 00:39:21.770 felipefaria: And these are all within the lot, right? Not necessarily distinguish between. Oh, I mean, yeah. Yeah. So if you download the data, it shows one thing, but then, on the aggregate.
348 00:39:21.980 ⇒ 00:39:23.960 Emily Giant: Yeah, that’s what’s really odd
349 00:39:24.230 ⇒ 00:39:32.960 Emily Giant: is that we’re trying to figure out how it came up with these numbers given given the upstream model.
350 00:39:33.320 ⇒ 00:39:37.179 Emily Giant: So let me pull this over uncommitted quantity sold
351 00:39:48.490 ⇒ 00:39:52.995 Emily Giant: alright. I’m gonna check a couple of the ones that look right just to make sure what is right is right.
352 00:39:53.490 ⇒ 00:39:55.509 Emily Giant: or what looks right is right.
353 00:40:01.680 ⇒ 00:40:02.420 Emily Giant: Yep.
354 00:40:27.830 ⇒ 00:40:33.399 Demilade Agboola: To be clear. We only want this order. Id for the uncommitted right.
355 00:40:38.370 ⇒ 00:40:44.770 Emily Giant: So I I think it’s it’s easier to Qa when you have all the suborder ids
356 00:40:45.357 ⇒ 00:40:49.070 Emily Giant: but I think it goes back to that conversation of like
357 00:40:50.080 ⇒ 00:41:09.970 Emily Giant: having one mart where you can roll everything up and unroll it down so like if you wanted to look at it at the inventory number id level. You can. If you want to look at it at the suborder id level you can. And the way we have it split out now is that inventory adjustments? Mart has suborder Ids and inventory mart
358 00:41:10.120 ⇒ 00:41:24.300 Emily Giant: lot table doesn’t, but they all come from the same place so they should match either way, even though it’s not in its like final state of how they’ll be like split apart because we don’t want that in the future. I don’t.
359 00:41:25.020 ⇒ 00:41:33.419 Emily Giant: It doesn’t check out in my brain that they would have any different data unless it was like doing some kind of fan out in looker.
360 00:41:36.510 ⇒ 00:41:41.730 Emily Giant: Now, if I pull. Okay, what I need to do is pull this in mode
361 00:41:42.070 ⇒ 00:41:50.139 Emily Giant: and see if it’s looker that’s doing it and not us cause that happened last time.
362 00:42:03.710 ⇒ 00:42:06.990 Emily Giant: and then I’m going to look in my branch versus demalade’s
363 00:42:07.610 ⇒ 00:42:11.590 Emily Giant: to make sure that because I have commitments
364 00:42:13.270 ⇒ 00:42:20.430 Emily Giant: or some like small changes from what his is, if those are what are causing any discrepancies.
365 00:42:21.270 ⇒ 00:42:24.750 Emily Giant: But they shouldn’t. I didn’t change enough for it to have.
366 00:42:25.320 ⇒ 00:42:26.120 Demilade Agboola: Yeah.
367 00:42:31.310 ⇒ 00:42:33.849 Emily Giant: Uncommitted sale. Quantity is 0
368 00:42:45.000 ⇒ 00:42:51.949 Emily Giant: uncommitted quantity sold to. Is this the right? Yeah, this is the right id. Okay? So it’s looker.
369 00:42:57.030 ⇒ 00:42:58.610 Emily Giant: looker’s messing this up.
370 00:42:59.923 ⇒ 00:43:05.936 Emily Giant: I do not see 8 anywhere. We can even like narrow this down to make it not so crazy to look at.
371 00:43:08.450 ⇒ 00:43:14.360 Demilade Agboola: My question is, are are we doing any join in lookup? Or it’s just directly.
372 00:43:15.660 ⇒ 00:43:19.800 Emily Giant: The only thing it’s joining well before I run my trap.
373 00:43:20.020 ⇒ 00:43:21.259 Emily Giant: But let’s just look.
374 00:43:21.400 ⇒ 00:43:26.284 Emily Giant: I don’t think it’s trying to anything, because Felipe was having such bad
375 00:43:27.520 ⇒ 00:43:34.110 Emily Giant: fan out problems when we were doing the 1st round of Qa. I wound up like just taking it apart and
376 00:43:34.300 ⇒ 00:43:40.440 Emily Giant: disconnecting it from anything that seemed to be causing that fan out.
377 00:43:40.950 ⇒ 00:43:48.479 Emily Giant: But all right. So it’s this, it’s joined to products. Xf.
378 00:43:53.120 ⇒ 00:43:55.219 Emily Giant: what if I just kill that for a second.
379 00:43:56.410 ⇒ 00:43:57.250 Demilade Agboola: Hmm!
380 00:44:03.030 ⇒ 00:44:07.359 Demilade Agboola: Where we had the count of 2 when it was just one.
381 00:44:12.090 ⇒ 00:44:13.300 Emily Giant: What sorry.
382 00:44:13.300 ⇒ 00:44:20.029 Demilade Agboola: The previous example we looked at, we saw that there was something with a count of 2 suborders when it was just one suborder.
383 00:44:21.440 ⇒ 00:44:22.200 Demilade Agboola: Consult.
384 00:44:29.130 ⇒ 00:44:33.150 felipefaria: Yeah, I saw that. I think it’s because it’s when a product is
385 00:44:35.650 ⇒ 00:44:43.509 felipefaria: it’s cancelled or like, I have an example here for us to look at after you. Finish this Emily. From this list.
386 00:44:45.310 ⇒ 00:44:50.868 felipefaria: That shows 2 2 units sold, but I only see one. But
387 00:44:51.940 ⇒ 00:44:55.479 felipefaria: would be interesting to to look at. Look at it on your screen.
388 00:44:57.700 ⇒ 00:44:59.480 Emily Giant: Why is this is being?
389 00:44:59.830 ⇒ 00:45:00.809 Emily Giant: I got it. Okay.
390 00:45:14.750 ⇒ 00:45:18.530 Emily Giant: like, what is it thinking it needs here that it doesn’t have?
391 00:45:28.380 ⇒ 00:45:29.450 Emily Giant: If you go.
392 00:45:29.450 ⇒ 00:45:34.950 Demilade Agboola: Also like without like any joins, and just use the the straight up numbers from the mart.
393 00:45:36.280 ⇒ 00:45:40.289 Emily Giant: That’s what I’m trying to do here. I’m trying to just take away the join.
394 00:45:40.530 ⇒ 00:45:46.329 Emily Giant: But I didn’t. I just wanted to comment it out it. Actually, it doesn’t matter, because I can just like start a new branch with.
395 00:45:47.670 ⇒ 00:45:49.929 Emily Giant: Let me just erase this.
396 00:45:50.670 ⇒ 00:45:52.349 Emily Giant: I’m making this too hard.
397 00:46:04.180 ⇒ 00:46:07.089 Emily Giant: I’m just trying to figure out where I’m supposed to close this off all fields.
398 00:46:09.060 ⇒ 00:46:10.109 Emily Giant: Okay, got it.
399 00:46:10.960 ⇒ 00:46:14.000 Emily Giant: This won’t change anything in your instance, Felipe.
400 00:46:14.540 ⇒ 00:46:17.270 Emily Giant: If you’re running the report. It’s only going to change it in mine.
401 00:46:18.480 ⇒ 00:46:19.489 felipefaria: Or you say it again.
402 00:46:20.270 ⇒ 00:46:27.880 Emily Giant: If you’re running this report on your computer, it’s not gonna change anything, because I’m just erasing stuff branch.
403 00:46:28.450 ⇒ 00:46:29.160 felipefaria: Okay.
404 00:46:35.600 ⇒ 00:46:38.220 Emily Giant: Okay. So rerunning.
405 00:46:45.470 ⇒ 00:46:48.230 Emily Giant: So in.
406 00:46:49.030 ⇒ 00:47:03.889 Emily Giant: I’m just going to copy and paste this again in case some number disappeared, so we would expect to see in mode the exact same numbers here for total committed quantity. Total quantity sold total uncommitted quantity.
407 00:47:04.720 ⇒ 00:47:07.339 Emily Giant: although I don’t think they’re named that in
408 00:47:08.230 ⇒ 00:47:15.650 Emily Giant: in Looker, I think I named them over the uncommitted quantity sold committed
409 00:47:15.870 ⇒ 00:47:18.300 Emily Giant: like I added the word total. So
410 00:47:19.055 ⇒ 00:47:21.029 Emily Giant: if I just run this.
411 00:47:21.920 ⇒ 00:47:24.120 Emily Giant: we should see the exact numbers.
412 00:47:32.300 ⇒ 00:47:33.600 felipefaria: Not really right.
413 00:47:34.430 ⇒ 00:47:38.530 Emily Giant: Not really so committed is 52.
414 00:47:38.640 ⇒ 00:47:42.000 Emily Giant: Uncommitted is 2.
415 00:47:43.730 ⇒ 00:47:47.939 Demilade Agboola: I mean. The sheet committed was 51 uncommitted was.
416 00:47:48.620 ⇒ 00:47:50.520 Demilade Agboola: I mean? I think, so as well.
417 00:47:52.360 ⇒ 00:47:52.950 Emily Giant: So.
418 00:47:52.950 ⇒ 00:47:54.499 felipefaria: 58, 66 right.
419 00:47:54.880 ⇒ 00:47:58.820 Emily Giant: 6. Let me add quantity sold in there, too. Hold on.
420 00:48:03.570 ⇒ 00:48:05.289 Demilade Agboola: Well, there’s total quantity.
421 00:48:06.350 ⇒ 00:48:07.197 Emily Giant: Oh, that’s right.
422 00:48:15.730 ⇒ 00:48:17.070 Emily Giant: pull it up.
423 00:48:37.160 ⇒ 00:48:39.560 Emily Giant: I ain’t seeing No. 66.
424 00:48:41.890 ⇒ 00:48:46.080 Emily Giant: Let me look in the look, ml, and make sure that all of these
425 00:48:48.400 ⇒ 00:49:07.670 Emily Giant: field names are lining up so total sale quantity. Because, Felipe, you can like whatever it’s called in the database, you can change the name and looker, which we try to not do, but because everything is like under renovation. We’ve been a little bit more liberal with it lately, trying to get them like right before we release them to everyone but.
426 00:49:14.860 ⇒ 00:49:15.700 Emily Giant: Okay.
427 00:49:15.850 ⇒ 00:49:25.953 Emily Giant: yeah. So it’s called total quantity sold. So quantity sold. The reason this is still there. I have a note here like, remove this once I’ve done like the mass switch in looker
428 00:49:26.860 ⇒ 00:49:29.860 Emily Giant: and then this is so total quantity sold
429 00:49:30.960 ⇒ 00:49:34.029 Emily Giant: all right. What I need is to see
430 00:49:37.690 ⇒ 00:49:38.900 Emily Giant: Oopsie Daisy.
431 00:49:43.048 ⇒ 00:49:45.599 Emily Giant: Okay, committed subscription quantity
432 00:49:48.780 ⇒ 00:49:58.560 Emily Giant: committed sale quantity uncommitted. So we aren’t using the word total, which is fine. I just added that for consistent like a consistency layer in looker.
433 00:49:58.760 ⇒ 00:50:06.109 Emily Giant: I just wanted to make sure I was pulling the right things to compare. But total sale, quantity, total quantity sold.
434 00:50:12.050 ⇒ 00:50:14.090 Emily Giant: Where’s what are we looking at here?
435 00:50:14.530 ⇒ 00:50:19.090 Emily Giant: Yeah, these just simply like, don’t match right? Like, these are not the right numbers.
436 00:50:19.700 ⇒ 00:50:25.070 Demilade Agboola: Yeah, are we? Are we sure? What point into the I don’t know. I’m just trying to figure out where exactly.
437 00:50:25.070 ⇒ 00:50:25.620 Emily Giant: Beautiful.
438 00:50:25.730 ⇒ 00:50:30.429 Emily Giant: So odd. Okay, I’m going to look at the source table here. So this is called
439 00:50:34.100 ⇒ 00:50:36.190 Emily Giant: Mart inventory lot table.
440 00:50:36.410 ⇒ 00:50:37.485 Demilade Agboola: Yeah, that’s the same table.
441 00:50:37.910 ⇒ 00:50:38.540 Emily Giant: Yeah.
442 00:50:43.080 ⇒ 00:50:46.700 Emily Giant: I feel like I’m being gaslit by looker. Right now.
443 00:50:49.730 ⇒ 00:50:51.879 Emily Giant: what is it aggregating?
444 00:50:54.840 ⇒ 00:50:56.680 Emily Giant: All right, I’m gonna try this one just for
445 00:51:17.110 ⇒ 00:51:19.630 Emily Giant: all right, so total sales should be 53
446 00:51:20.370 ⇒ 00:51:27.380 Emily Giant: quantity sold. 54 uncommitted is 0, and committed is 54, so that totally tracks for me,
447 00:51:30.260 ⇒ 00:51:33.739 Emily Giant: 53, and 54 is what we expect to see in the report.
448 00:51:34.700 ⇒ 00:51:35.710 Emily Giant: Nope.
449 00:51:39.620 ⇒ 00:51:43.990 Demilade Agboola: I think that might also again like I said, there was one example we looked at where we saw
450 00:51:44.415 ⇒ 00:51:49.299 Demilade Agboola: it canceled order of 2, and then we looked in there so canceled of one
451 00:51:50.055 ⇒ 00:51:56.439 Demilade Agboola: potentially. That might be what’s going on here, where, like this report is slightly infleting our numbers.
452 00:51:57.520 ⇒ 00:51:58.480 Emily Giant: Yeah.
453 00:51:58.480 ⇒ 00:51:59.380 felipefaria: You’re right.
454 00:51:59.893 ⇒ 00:52:04.139 felipefaria: There’s a lot of not a lot, but the the ones that I checked
455 00:52:04.560 ⇒ 00:52:14.129 felipefaria: there was either like 2 suborders or one, the original one crossed out, and then a new skew, and I think it’s counting everything.
456 00:52:14.510 ⇒ 00:52:15.740 Emily Giant: Enforced upgrades.
457 00:52:16.590 ⇒ 00:52:24.290 felipefaria: Yeah, like, if you want to take a look at this one, because I don’t know if it’s a forced upgrade or not, it’s and let me put it on the chat here.
458 00:52:25.710 ⇒ 00:52:28.050 felipefaria: So we take a look at this one.
459 00:52:29.000 ⇒ 00:52:34.889 felipefaria: Should you take a look at this one in dash, Emily, in just this order.
460 00:52:37.420 ⇒ 00:52:41.359 felipefaria: You! You’ll see what once you pull it up
461 00:52:45.860 ⇒ 00:52:46.470 felipefaria: alright.
462 00:52:46.700 ⇒ 00:52:46.930 Emily Giant: Yeah.
463 00:52:46.930 ⇒ 00:53:00.469 felipefaria: Well, so this one original unicorn. But then, is the firecracker I’m assuming, and this looks like a forest upgrade, but it doesn’t have any tags. As for forest upgrade, or anything like that on the top.
464 00:53:00.940 ⇒ 00:53:01.920 felipefaria: off it.
465 00:53:02.660 ⇒ 00:53:04.139 felipefaria: But but if you go.
466 00:53:04.140 ⇒ 00:53:07.849 Emily Giant: You’re right, I think what it’s doing is it’s rolling up
467 00:53:08.370 ⇒ 00:53:10.639 Emily Giant: units that have been struck through.
468 00:53:10.770 ⇒ 00:53:15.630 felipefaria: Yeah, because if you go to the session, it has quantity. So true.
469 00:53:15.820 ⇒ 00:53:22.809 felipefaria: And it’s it’s not really that right? It’s like one quantity sold in this in this case.
470 00:53:24.410 ⇒ 00:53:25.874 Demilade Agboola: But it is it?
471 00:53:26.730 ⇒ 00:53:30.780 Demilade Agboola: Do the numbers match when we look at it from like in mode?
472 00:53:31.240 ⇒ 00:53:35.370 Demilade Agboola: And is it only when we switch to look at that the number seems to get higher.
473 00:53:36.390 ⇒ 00:53:43.039 Emily Giant: Yeah, that’s what I’m like. This is so odd. We need to validate that it matches in mode.
474 00:53:43.940 ⇒ 00:53:49.899 Emily Giant: Oh, let me no, Felipe, do you know what
475 00:53:50.360 ⇒ 00:53:55.300 Emily Giant: the in? Where did you pull that order number from? Actually, don’t even worry about it. I can use.
476 00:53:56.067 ⇒ 00:54:01.610 Emily Giant: It’s from the working session document. And so it’s from the same lot that we were looking at.
477 00:54:01.860 ⇒ 00:54:02.540 Emily Giant: Okay.
478 00:54:11.240 ⇒ 00:54:14.259 Emily Giant: what did I do? Oh, Whoopsie, Daisy.
479 00:54:30.010 ⇒ 00:54:32.499 Emily Giant: quantity sold to? No, this is all correct.
480 00:54:36.430 ⇒ 00:54:37.880 felipefaria: Yeah, it should be one, right?
481 00:54:39.280 ⇒ 00:54:44.680 Emily Giant: Oh, committed quantity sold. One.
482 00:54:50.880 ⇒ 00:54:51.780 Emily Giant: Okay.
483 00:54:52.540 ⇒ 00:54:55.310 Emily Giant: So committed is correct.
484 00:54:55.580 ⇒ 00:54:57.570 Emily Giant: Subscription is correct.
485 00:55:00.030 ⇒ 00:55:07.790 Emily Giant: Uncommitted. Is this the unicorn that struck through.
486 00:55:12.380 ⇒ 00:55:14.099 Emily Giant: That’s what’s happening. Okay.
487 00:55:14.100 ⇒ 00:55:14.700 felipefaria: Yeah.
488 00:55:17.480 ⇒ 00:55:22.070 Demilade Agboola: So it’s fine. It looks like it’s fine in mode, but just like look as reports is off.
489 00:55:23.190 ⇒ 00:55:28.890 Emily Giant: It’s not find in mode. So it didn’t. We didn’t sell to
490 00:55:29.639 ⇒ 00:55:33.680 Emily Giant: we only sold the unicorn, which was force upgraded
491 00:55:33.880 ⇒ 00:55:38.549 Emily Giant: to the firecracker. So right now, what’s happening?
492 00:55:38.910 ⇒ 00:55:44.630 Emily Giant: I don’t know why, because Demo Lati’s logic like when you look at it, it says if the item id
493 00:55:44.850 ⇒ 00:55:57.190 Emily Giant: matches the item. Id. Then we’re good. If not, then we’re wrong. So I think it’s the tweaking in that logic of force upgrade versus uncommitted.
494 00:55:57.590 ⇒ 00:56:00.859 Emily Giant: There is a piece of the logic we’re missing.
495 00:56:02.930 ⇒ 00:56:06.539 Demilade Agboola: For quantity sold. I’m not doing anything to the logic.
496 00:56:07.160 ⇒ 00:56:11.660 Demilade Agboola: I’m just literally getting the logic. If you look at it right now. I was getting logic from
497 00:56:13.810 ⇒ 00:56:18.480 Demilade Agboola: the the transaction line table, basically, or like the just what’s happening.
498 00:56:19.800 ⇒ 00:56:24.500 Emily Giant: Okay, so there just needs to be. So this demo lotto, this is all correct.
499 00:56:25.268 ⇒ 00:56:27.621 Emily Giant: The uncommitted versus committed
500 00:56:29.100 ⇒ 00:56:34.749 Emily Giant: although there needs to be a breakout in, uncommitted.
501 00:56:34.900 ⇒ 00:56:48.460 Emily Giant: of forced upgrades versus like legitimately didn’t claim a lot cause. This is the original order, but
502 00:56:50.350 ⇒ 00:56:51.770 Emily Giant: But it was canceled.
503 00:56:51.900 ⇒ 00:57:09.320 Emily Giant: not canceled, as in the order, was canceled, but like a new item, was substituted for this one because we didn’t have it anymore. And there is a difference between like this line item, strike through, and when this gets sent out the door, but
504 00:57:09.530 ⇒ 00:57:16.339 Emily Giant: says like no like on order, lot instead of on hand committed. It’s 1 like this
505 00:57:16.540 ⇒ 00:57:27.560 Emily Giant: is red or yellow, this little flag and dash that we’re trying to pinpoint. This is another thing we’re trying to pinpoint, but it’s a different thing entirely. And I think I know
506 00:57:27.850 ⇒ 00:57:34.560 Emily Giant: a really a potentially easy workaround for this. Let me just there is a
507 00:57:34.690 ⇒ 00:57:44.520 Emily Giant: commitment status and an integration status flag in the transaction line table. I’m wondering if I pulled this suborder directly from there.
508 00:57:45.450 ⇒ 00:57:49.960 Emily Giant: What those say, if it will have a line for the Unicorn and a line for
509 00:57:51.920 ⇒ 00:57:54.229 Emily Giant: so if I do.
510 00:58:06.500 ⇒ 00:58:11.499 Emily Giant: it always seems like an hour is going to be too long, and then it’s just never long enough.
511 00:58:13.010 ⇒ 00:58:13.550 felipefaria: Yeah.
512 00:58:17.640 ⇒ 00:58:20.799 felipefaria: I will have to hop around 10
513 00:58:20.800 ⇒ 00:58:21.630 Emily Giant: You.
514 00:58:23.980 ⇒ 00:58:26.259 felipefaria: Have a meeting at 1030 that I need to prep.
515 00:58:27.520 ⇒ 00:58:32.400 Emily Giant: Okay? And I have my, I have 2 calls at 10, and then 1030 tomorrow.
516 00:58:32.560 ⇒ 00:58:39.427 Emily Giant: Would it be possible? Because Kyle wanted to meet. I haven’t answered him yet, because I’m a terrible communicator.
517 00:58:40.600 ⇒ 00:58:44.710 Emily Giant: I was planning to meet with Kayo tomorrow. Would you still be able to meet with Felipe.
518 00:58:45.250 ⇒ 00:58:46.059 Demilade Agboola: There, sure.
519 00:58:46.060 ⇒ 00:58:49.219 Emily Giant: Okay, cause. Then we can just like split up and
520 00:58:49.410 ⇒ 00:59:02.120 Emily Giant: still 2 birds. But I wanted to confirm that with you before I said yes to Kayo. So okay, one thing I have found out is that the created from Id. If there is a number in here, it has a forced upgrade.
521 00:59:02.756 ⇒ 00:59:12.440 Emily Giant: Something about this id right here means forced upgrade, and then the last thing would be inventory commit.
522 00:59:14.230 ⇒ 00:59:19.439 Emily Giant: I don’t know what these mean. Does this mean anything to you, Felipe. Available versus complete.
523 00:59:20.200 ⇒ 00:59:22.080 felipefaria: I never seen this before.
524 00:59:23.120 ⇒ 00:59:33.510 Emily Giant: I’ll ask ask tastique in my next meeting but that one. And there’s 1 other like integration status column where it has like a 1 or a 3,
525 00:59:33.820 ⇒ 00:59:39.409 Emily Giant: and one of them just means like this was not committed.
526 00:59:41.040 ⇒ 00:59:48.830 Emily Giant: But there’s something there’s something to the like. If created from is populated.
527 00:59:49.460 ⇒ 00:59:55.630 Emily Giant: Then there is something awry with your order, like something was changed. So
528 00:59:56.220 ⇒ 00:59:58.800 Emily Giant: also, what’s going on with this was
529 00:59:59.180 ⇒ 01:00:01.720 Emily Giant: the line that wound up coming through.
530 01:00:17.600 ⇒ 01:00:20.759 felipefaria: Well, okay, anyway. But there’s
531 01:00:20.760 ⇒ 01:00:27.659 felipefaria: and with a way to to do this, because if we’re looking a lot, couldn’t you just filter for that specific skew
532 01:00:28.486 ⇒ 01:00:37.269 felipefaria: and that is for the lot, right? Like, if we’re looking at firecracker, it should only be pulling information for the firecracker versus other.
533 01:00:37.270 ⇒ 01:00:40.509 Emily Giant: Correct, and it’s not doing.
534 01:00:40.510 ⇒ 01:00:47.750 felipefaria: I don’t know if there’s a way to filter. So it just pulls that specific skew, you know, regardless of what else is in the order. Yeah.
535 01:00:47.750 ⇒ 01:00:50.779 Emily Giant: We need. Item, Id somehow worked into all of the
536 01:00:52.570 ⇒ 01:00:54.060 Emily Giant: All of that logic.
537 01:00:54.660 ⇒ 01:00:55.490 Demilade Agboola: Hmm.
538 01:00:56.900 ⇒ 01:01:03.389 Emily Giant: Demo audit. I’ll take a look at that. We can also chat like after the if you have any extra time today. But like this
539 01:01:03.570 ⇒ 01:01:05.700 Emily Giant: inventory number Id. And this
540 01:01:05.980 ⇒ 01:01:12.317 Emily Giant: is not the same as this. What I need to figure out is in a downstream model.
541 01:01:13.080 ⇒ 01:01:17.610 Emily Giant: once it’s ranked, which one comes through because it should only be the one
542 01:01:17.810 ⇒ 01:01:22.590 Emily Giant: that’s most recent, coming through as the actual product that was shipped.
543 01:01:23.860 ⇒ 01:01:24.760 Demilade Agboola: Gotcha.
544 01:01:25.220 ⇒ 01:01:39.320 Emily Giant: But I don’t think I partition transaction line in the model, because it’s like a very specific reason of you’ll lose information about all of the other things that happen to the order. If you don’t partition it just
545 01:01:39.440 ⇒ 01:01:46.119 Emily Giant: in the table where you need to pull the certain information. So the staging model is the is, and should
546 01:01:46.460 ⇒ 01:01:57.470 Emily Giant: let all 4 of those lines through. But, Felipe, if you’re looking at an order like the one we just looked at, and it only has one item and no changes. It should only ever have one line.
547 01:01:57.810 ⇒ 01:01:58.260 felipefaria: Yeah.
548 01:01:58.260 ⇒ 01:02:00.620 Emily Giant: But the fact that this one has 4.
549 01:02:01.520 ⇒ 01:02:01.910 felipefaria: Yeah.
550 01:02:01.910 ⇒ 01:02:03.640 Emily Giant: To begin with, is like.
551 01:02:03.820 ⇒ 01:02:10.430 Emily Giant: okay, something in these 4 lines is getting obscured. Okay, I’ve I’ve got to hop.
552 01:02:11.010 ⇒ 01:02:13.800 Emily Giant: But demalade we can circle up during the
553 01:02:13.950 ⇒ 01:02:17.529 Emily Giant: the stand, up about like next steps. On this.
554 01:02:17.930 ⇒ 01:02:19.230 Demilade Agboola: Alright, sounds good.
555 01:02:19.230 ⇒ 01:02:22.770 Emily Giant: Okay, cool, alright, and you 2 will meet tomorrow.
556 01:02:23.140 ⇒ 01:02:25.540 Emily Giant: and I’ll talk to you both soon.
557 01:02:25.850 ⇒ 01:02:26.410 Demilade Agboola: Alright!
558 01:02:26.810 ⇒ 01:02:27.379 felipefaria: Have a good day.
559 01:02:27.680 ⇒ 01:02:28.889 Emily Giant: You too, bye.