Meeting Title: Data QA and Issue Resolution Sync Date: 2025-08-06 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:00:29.640 ⇒ 00:00:31.610 Emily Giant: Hi, sorry about that.
2 00:00:35.980 ⇒ 00:00:37.359 Demilade Agboola: Hello! How are you?
3 00:00:37.810 ⇒ 00:00:39.760 Emily Giant: I’m good. How are you feeling.
4 00:00:40.190 ⇒ 00:00:46.159 Demilade Agboola: No, I’m pretty good. I’m fine. It was really just that day, so I’m much better now.
5 00:00:46.720 ⇒ 00:00:52.620 Emily Giant: That’s good. I was just on with Pk doing some like
6 00:00:53.120 ⇒ 00:01:16.789 Emily Giant: looking into like a marketing table that is not working right now, and I’m excited to like have him start joining us 1st of all, like he’s running a 10 k. Right now, so we can also chat about like soccer swimming, running. We can do stuff that it has nothing to do with work, but he’s he’s gonna be helpful with like getting things done faster.
7 00:01:17.310 ⇒ 00:01:17.630 Demilade Agboola: Okay.
8 00:01:17.890 ⇒ 00:01:23.760 Emily Giant: I don’t have anything specific to go over today. Was there anything specific that you wanted to do.
9 00:01:25.487 ⇒ 00:01:31.060 Demilade Agboola: I just 1st wanted us to figure out why, like, how to get the numbers across to the business team.
10 00:01:31.060 ⇒ 00:01:33.310 Demilade Agboola: Yeah, that’s a good idea.
11 00:01:33.930 ⇒ 00:01:37.960 Emily Giant: All right. So one of the
12 00:01:39.280 ⇒ 00:01:43.069 Emily Giant: issues is that I need to deploy
13 00:01:43.310 ⇒ 00:01:48.140 Emily Giant: some changes that I made for the numbers to be correct.
14 00:01:48.300 ⇒ 00:01:54.889 Emily Giant: But do you wanna just do some Qa with how it is right now in production, with like
15 00:01:55.540 ⇒ 00:02:02.030 Emily Giant: the uncommitted and committed because those were really the only things that we had hidden from stakeholders.
16 00:02:03.823 ⇒ 00:02:05.440 Demilade Agboola: What about shrinkage and stuff?
17 00:02:06.230 ⇒ 00:02:10.990 Emily Giant: That should all be in there. Let’s see. I’ll share my screen.
18 00:02:11.120 ⇒ 00:02:11.940 Demilade Agboola: Okay.
19 00:02:19.720 ⇒ 00:02:20.755 Emily Giant: Okay.
20 00:02:26.380 ⇒ 00:02:27.210 Emily Giant: okay.
21 00:02:29.860 ⇒ 00:02:35.229 Emily Giant: let me turn my camera off so that I can use all of my various screens and not get it in the way of like
22 00:02:37.070 ⇒ 00:02:37.959 Emily Giant: my face.
23 00:02:38.310 ⇒ 00:02:41.820 Emily Giant: Okay, looker.
24 00:03:12.880 ⇒ 00:03:17.660 Emily Giant: yeah. So these are all I mean, this is my development mode.
25 00:03:17.820 ⇒ 00:03:21.160 Emily Giant: But if I
26 00:03:23.660 ⇒ 00:03:30.700 Emily Giant: I’m pretty sure I don’t have any like pending changes in looker like this should all be live to stakeholders.
27 00:03:31.090 ⇒ 00:03:36.287 Emily Giant: So it’s just like doing some Qa like we did hide
28 00:03:38.630 ⇒ 00:03:43.769 Emily Giant: yep, that’s not hidden. We hit uncommitted versus committed. But that’s not in this.
29 00:03:44.070 ⇒ 00:03:46.440 Emily Giant: Yep, yeah, these are hidden still.
30 00:03:49.600 ⇒ 00:03:52.410 Emily Giant: But I can unhide. And we can do some. Qa.
31 00:03:53.080 ⇒ 00:03:54.460 Emily Giant: See if that’s.
32 00:04:03.770 ⇒ 00:04:06.569 Demilade Agboola: Okay, let’s try looking at them and seeing if the numbers match.
33 00:04:06.910 ⇒ 00:04:10.160 Emily Giant: Yeah, all right.
34 00:04:10.850 ⇒ 00:04:14.582 Emily Giant: So let’s I’m gonna pull up. Dash 2, because we’re gonna need that.
35 00:04:33.970 ⇒ 00:04:34.670 Emily Giant: Okay.
36 00:04:38.180 ⇒ 00:04:41.800 Emily Giant: I’m gonna go back to last week. And that way.
37 00:04:42.434 ⇒ 00:04:47.290 Emily Giant: They should be adjusted out, and there should be like shrink numbers.
38 00:04:49.180 ⇒ 00:04:50.739 Emily Giant: If you all
39 00:05:03.670 ⇒ 00:05:07.600 Emily Giant: all right, we usually order a ton of the Unicorn.
40 00:05:07.930 ⇒ 00:05:12.369 Emily Giant: So listen, a strong possibility that
41 00:05:13.190 ⇒ 00:05:15.739 Emily Giant: that will have some other adjustment types.
42 00:05:20.860 ⇒ 00:05:26.620 Emily Giant: And I’m just gonna add all of the adjustment details.
43 00:05:26.830 ⇒ 00:05:27.550 Demilade Agboola: Okay.
44 00:05:28.210 ⇒ 00:05:30.329 Emily Giant: So they’re under reconciliations.
45 00:05:37.740 ⇒ 00:05:44.500 Emily Giant: And then lot Balance. This is the one, we added with Felipe. That should
46 00:05:46.270 ⇒ 00:05:50.350 Emily Giant: be 0, or it should like. Subtract
47 00:05:51.270 ⇒ 00:05:55.509 Emily Giant: the quantity. I’m not making any sense. I’m sorry.
48 00:05:56.840 ⇒ 00:06:03.760 Emily Giant: I’ll show you in the Dbt. Because that will make more sense, but active inventory
49 00:06:04.470 ⇒ 00:06:07.400 Emily Giant: quantity on hand, quantity on order.
50 00:06:12.910 ⇒ 00:06:14.859 Emily Giant: What I want is quantity sold?
51 00:06:21.710 ⇒ 00:06:23.930 Emily Giant: Oh, I spelled quantity wrong. That’s why
52 00:06:33.690 ⇒ 00:06:37.490 Emily Giant: this is a bit confusing, that there’s quantity sold and total quantity sold.
53 00:06:37.700 ⇒ 00:06:42.920 Emily Giant: Yeah, okay, let me run this.
54 00:07:01.670 ⇒ 00:07:02.370 Emily Giant: Okay.
55 00:07:03.110 ⇒ 00:07:08.180 Emily Giant: The total quantity sold is 66, and it looks like there are no other
56 00:07:08.610 ⇒ 00:07:13.860 Emily Giant: adjustment types associated. So if I check netsuite
57 00:07:27.940 ⇒ 00:07:29.239 Emily Giant: hold on, I’m gonna
58 00:07:29.680 ⇒ 00:07:36.319 Emily Giant: share on my big screen instead of my small screen, because it’s I don’t like how it’s cutting off what I’m showing you.
59 00:07:36.620 ⇒ 00:07:37.110 Demilade Agboola: Okay.
60 00:08:02.040 ⇒ 00:08:07.610 Emily Giant: So believe they did send me a couple of things that we can look into that we’re like
61 00:08:07.810 ⇒ 00:08:10.662 Emily Giant: also sticking points. He said that, like
62 00:08:12.290 ⇒ 00:08:15.470 Emily Giant: Subscriptions were a bit off this week.
63 00:08:17.270 ⇒ 00:08:18.170 Demilade Agboola: Households.
64 00:08:19.000 ⇒ 00:08:22.190 Emily Giant: Let me pull up the message, he said they were showing
65 00:08:23.140 ⇒ 00:08:26.650 Emily Giant: I’ll just pull up the message, so I don’t misrepresent.
66 00:08:32.080 ⇒ 00:08:40.750 Emily Giant: Wanted to flag that I’m seeing some farm choice skews categorized as sales instead of subscriptions. Here, I’ll send you this link that he sent
67 00:08:42.340 ⇒ 00:08:47.090 Emily Giant: so essentially farmers. Choice is only ever a subscription, so
68 00:08:48.000 ⇒ 00:08:51.199 Emily Giant: it shouldn’t be showing in the sale category.
69 00:08:51.880 ⇒ 00:08:53.030 Demilade Agboola: Oh!
70 00:08:53.030 ⇒ 00:09:02.069 Emily Giant: Let me see, which makes me think potentially, it is a dev issue since we pull that from Oms. But
71 00:09:04.310 ⇒ 00:09:05.230 Emily Giant: there we go.
72 00:09:09.330 ⇒ 00:09:11.819 Emily Giant: Okay. 66 is correct here.
73 00:09:12.278 ⇒ 00:09:16.760 Emily Giant: With that one that we checked. I do want to find one that has other
74 00:09:17.430 ⇒ 00:09:20.140 Emily Giant: adjustment types besides sales.
75 00:10:13.148 ⇒ 00:10:14.821 Demilade Agboola: For the farmers choice, it appears.
76 00:10:15.310 ⇒ 00:10:17.610 Demilade Agboola: Where are the skills?
77 00:10:21.260 ⇒ 00:10:22.690 Demilade Agboola: Cause I’m seeing
78 00:10:34.310 ⇒ 00:10:35.820 Demilade Agboola: for the dashboard you shared.
79 00:10:41.190 ⇒ 00:10:49.490 Demilade Agboola: Is it? Is this show? Is it? Cause? It’s showing 1, 69 in Argo. Whatever that is.
80 00:10:49.980 ⇒ 00:10:50.730 Demilade Agboola: is it cause.
81 00:10:50.730 ⇒ 00:10:51.125 Emily Giant: Yeah.
82 00:10:51.520 ⇒ 00:10:53.759 Demilade Agboola: 7, 1, 69, and 1 0, 6.
83 00:10:55.900 ⇒ 00:11:04.490 Emily Giant: Yes, yeah, that should be showing as subscription units, not sale units.
84 00:11:04.490 ⇒ 00:11:05.540 Demilade Agboola: Oh, gotcha!
85 00:11:05.540 ⇒ 00:11:06.530 Emily Giant: Me too.
86 00:11:08.440 ⇒ 00:11:10.580 Demilade Agboola: The couple more. Okay, yeah.
87 00:11:11.340 ⇒ 00:11:14.179 Emily Giant: That’s weird. I have never seen that problem before.
88 00:11:15.940 ⇒ 00:11:16.840 Emily Giant: Hmm.
89 00:11:17.970 ⇒ 00:11:25.380 Emily Giant: okay. What I’m gonna do is pull some sub orders and see what’s up in Oms to make sure it’s not an Oms problem.
90 00:12:14.950 ⇒ 00:12:17.890 Emily Giant: Meanwhile no results. Okay.
91 00:12:22.580 ⇒ 00:12:24.680 Emily Giant: that seems not right.
92 00:12:34.490 ⇒ 00:12:36.919 Demilade Agboola: Spoilage, quantity.
93 00:12:37.300 ⇒ 00:12:43.770 Emily Giant: Let me check my, that just seems so. Not correct.
94 00:13:04.810 ⇒ 00:13:06.490 Emily Giant: All right, let’s try this.
95 00:13:28.790 ⇒ 00:13:30.310 Emily Giant: Well, that’s running.
96 00:13:34.230 ⇒ 00:13:35.099 Emily Giant: It’s this.
97 00:13:43.590 ⇒ 00:13:56.270 Emily Giant: -Oh, it doesn’t have a subscription associated with it like it says it’s supposed to say like
98 00:13:56.400 ⇒ 00:14:01.309 Emily Giant: subscription id on the page.
99 00:14:01.460 ⇒ 00:14:04.420 Emily Giant: Let me see if there’s a subscription number here, because
100 00:14:04.660 ⇒ 00:14:10.279 Emily Giant: if it’s ingested from shopify without that, then, like there’s nothing we can do about it. But that’s a
101 00:14:10.500 ⇒ 00:14:12.040 Emily Giant: tech issue.
102 00:14:24.330 ⇒ 00:14:26.900 Emily Giant: why, the F, though like this is.
103 00:14:37.280 ⇒ 00:14:41.270 Emily Giant: there should be a subscription number in it, like in this audit log.
104 00:14:41.610 ⇒ 00:14:44.460 Emily Giant: This does not look normal at all to me.
105 00:14:50.550 ⇒ 00:14:56.189 Emily Giant: and also like it was delivered on order committed. So that’s not good, either.
106 00:14:56.360 ⇒ 00:14:57.350 Emily Giant: But
107 00:14:58.310 ⇒ 00:15:04.109 Emily Giant: yeah, I mean, if it’s not coming through as a subscription in the data, then there’s nothing we can do about it.
108 00:15:05.390 ⇒ 00:15:09.729 Emily Giant: Let me check like 2 more, and then I’m gonna send this to Alex.
109 00:15:10.400 ⇒ 00:15:15.160 Emily Giant: And I did talk to Alex about the forced upgrade thing, and he he needs to continue like tweaking it.
110 00:15:15.440 ⇒ 00:15:17.079 Demilade Agboola: Okay. Sounds good.
111 00:15:17.480 ⇒ 00:15:22.799 Emily Giant: Yeah, I mean, it sounds shitty, but there’s nothing we can do about it.
112 00:15:27.470 ⇒ 00:15:28.930 Emily Giant: Yep, same problem.
113 00:15:39.820 ⇒ 00:15:40.590 Emily Giant: what?
114 00:15:40.980 ⇒ 00:15:42.270 Emily Giant: So weird?
115 00:15:42.780 ⇒ 00:15:43.590 Emily Giant: Okay.
116 00:15:47.430 ⇒ 00:15:55.359 Emily Giant: like, how I have questions. But whatever? Okay, I’m gonna save this.
117 00:15:57.950 ⇒ 00:16:01.249 Emily Giant: Actually, I’m going to add the subscription number to it. Real quick
118 00:16:01.800 ⇒ 00:16:09.789 Emily Giant: or subscription quantity. So it’s more obvious to Alex, what he’s looking at.
119 00:16:22.630 ⇒ 00:16:30.680 Emily Giant: See if this is done running. Okay. So spoilage or shrinkage, on the other hand, seems to be
120 00:16:31.020 ⇒ 00:16:32.199 Emily Giant: up and running.
121 00:16:32.820 ⇒ 00:16:34.640 Emily Giant: So let’s find a lot.
122 00:16:37.160 ⇒ 00:16:43.410 Emily Giant: Alright. So if there’s no lot, start or arrival date, it’s going to be unlotted oops.
123 00:16:50.400 ⇒ 00:16:54.889 Emily Giant: and then, if it is lotted it.
124 00:16:56.650 ⇒ 00:17:02.159 Emily Giant: We’ll have a record in dash that we can check. But basically those are hard goods that don’t have lots.
125 00:17:02.870 ⇒ 00:17:03.510 Demilade Agboola: And.
126 00:17:07.639 ⇒ 00:17:12.279 Emily Giant: And then it’s saying in netsuite.
127 00:17:13.319 ⇒ 00:17:16.939 Emily Giant: I need to change the criteria that we’re searching here.
128 00:17:50.359 ⇒ 00:17:55.719 Emily Giant: Oh, I hate Netsuite. Whatever we’re just gonna get rid of this filter and look at everything.
129 00:18:02.519 ⇒ 00:18:03.559 Emily Giant: And then
130 00:18:20.459 ⇒ 00:18:22.289 Emily Giant: the mode is showing.
131 00:18:24.409 ⇒ 00:18:37.899 Emily Giant: I’m gonna search just for this lot because the way that I have it. It won’t aggregate every inventory adjustment because this is the adjustment table. So it’s gonna show each individual inventory adjustment instead of in the
132 00:18:38.179 ⇒ 00:18:48.459 Emily Giant: lot balance table. It aggregates all of them into one. But this is the equivalent of like a sub order. So this might more than one does that make sense.
133 00:18:48.940 ⇒ 00:18:49.900 Demilade Agboola: Yeah.
134 00:18:50.230 ⇒ 00:18:52.339 Emily Giant: Okay. So if I just do where?
135 00:19:02.400 ⇒ 00:19:13.670 Emily Giant: Okay, wow, well, I’m seeing some stuff I shouldn’t. Oh, Nope, that’s totally that’s totally correct.
136 00:19:16.250 ⇒ 00:19:21.860 Emily Giant: And so this is interesting, like the way the adjustment table is now.
137 00:19:22.400 ⇒ 00:19:23.140 Demilade Agboola: Yeah.
138 00:19:24.850 ⇒ 00:19:32.910 Emily Giant: The source shows. This is my instance, like these are the changes that I need to push. But I allotted
139 00:19:33.440 ⇒ 00:19:37.869 Emily Giant: is like indicative of what table
140 00:19:38.470 ⇒ 00:19:46.060 Emily Giant: it’s pulling from slash where the shipment actually is it physically? So
141 00:19:47.380 ⇒ 00:19:58.579 Emily Giant: if it’s pulling from the on hand table, it’s going to be a suborder. If it’s anything but like the on hand or on order table, it’s going to be an adjustment.
142 00:19:59.171 ⇒ 00:20:03.410 Emily Giant: But there’s I allotted, and Ia unlotted, but
143 00:20:03.860 ⇒ 00:20:13.260 Emily Giant: that will be useful, more than likely, for only Felipe. But okay, adjustment type equals
144 00:20:29.530 ⇒ 00:20:36.600 Emily Giant: alright. So there are 2 different inventory adjustments, one on the 7, th one on the 25, th and
145 00:20:37.450 ⇒ 00:20:44.999 Emily Giant: one was for 14. One was for one, so there should be 15 total in netsuite of shrinkage.
146 00:20:45.820 ⇒ 00:20:47.911 Emily Giant: That’s a lot. What happened.
147 00:20:49.400 ⇒ 00:20:50.360 Emily Giant: Alright.
148 00:21:17.590 ⇒ 00:21:18.560 Emily Giant: Right?
149 00:21:22.800 ⇒ 00:21:24.840 Emily Giant: Inventory adjustment for one.
150 00:21:27.330 ⇒ 00:21:28.020 Emily Giant: Hold on.
151 00:21:33.080 ⇒ 00:21:36.760 Emily Giant: we should be seeing. Yep, and then
152 00:21:39.800 ⇒ 00:21:41.470 Emily Giant: negative. 14.
153 00:21:41.870 ⇒ 00:21:43.600 Emily Giant: Item, fulfillment.
154 00:21:44.040 ⇒ 00:21:46.480 Emily Giant: That’s not an inventory adjustment, though.
155 00:21:49.410 ⇒ 00:21:50.880 Emily Giant: 28.
156 00:21:53.920 ⇒ 00:22:03.920 Emily Giant: Oh, okay, this is something. So this is an inventory adjustment.
157 00:22:04.210 ⇒ 00:22:12.119 Emily Giant: To send stuff to another Fc. Is what it looks like. Like. They sent some to Manhattan from the Md. Hub.
158 00:22:12.550 ⇒ 00:22:13.060 Demilade Agboola: Okay.
159 00:22:13.210 ⇒ 00:22:20.309 Emily Giant: It’s counting it. Yep, here at 14. So when it sent it from the warehouse to
160 00:22:20.870 ⇒ 00:22:37.110 Emily Giant: Manhattan, it’s counting this as an inventory adjustment. So what I stupidly did not do is consider the hub and spoke logic. So we don’t want to see those. We don’t see those inventory adjustments. So I just have to like.
161 00:22:37.230 ⇒ 00:22:42.750 Emily Giant: Now, if I look at it, the 14 should be an Md. Hub, and I need to filter that out of
162 00:22:43.050 ⇒ 00:22:44.160 Emily Giant: the final.
163 00:22:44.160 ⇒ 00:22:45.149 Demilade Agboola: Send them to help.
164 00:22:48.780 ⇒ 00:22:57.340 Emily Giant: Where is the locate above? Am? Yep, that’s easy easy to fix. But
165 00:22:58.760 ⇒ 00:23:04.110 Emily Giant: okay, so let me add a note for myself in linear.
166 00:23:19.720 ⇒ 00:23:21.580 Emily Giant: I do not know how to use this.
167 00:23:33.370 ⇒ 00:23:39.280 Emily Giant: I’ve like lost my brain on how to do literally anything in this platform. I’m clicking on issues.
168 00:23:39.750 ⇒ 00:23:41.549 Emily Giant: I want to add a new issue.
169 00:23:43.300 ⇒ 00:23:45.310 Emily Giant: Am I not allowed to? Here we go.
170 00:23:45.660 ⇒ 00:23:46.330 Demilade Agboola: Okay.
171 00:23:46.740 ⇒ 00:23:53.660 Emily Giant: Remove inventory adjustments.
172 00:24:14.800 ⇒ 00:24:16.090 Emily Giant: Cool, alright.
173 00:24:17.830 ⇒ 00:24:20.430 Emily Giant: So we know that that’s 1 issue.
174 00:24:21.210 ⇒ 00:24:29.650 Emily Giant: I’m really unsure about spoilage being 0 for the last 15 days. That sounds like.
175 00:24:29.770 ⇒ 00:24:33.199 Emily Giant: not true. So I’ll go back a little further
176 00:24:34.520 ⇒ 00:24:36.940 Emily Giant: to like beginning of July, I guess.
177 00:25:19.440 ⇒ 00:25:21.060 Emily Giant: Okay, it works.
178 00:25:25.290 ⇒ 00:25:29.369 Emily Giant: But spoilage quantity is that empty? Because that’s not right.
179 00:25:32.250 ⇒ 00:25:34.529 Demilade Agboola: Spoilage, quantity.
180 00:25:41.960 ⇒ 00:25:43.360 Emily Giant: No, it’s correct.
181 00:25:48.340 ⇒ 00:25:51.048 Emily Giant: Okay, well, let’s let’s check
182 00:25:53.450 ⇒ 00:25:56.630 Emily Giant: So this should be minus 7.
183 00:25:59.960 ⇒ 00:26:07.329 Emily Giant: I must have just written something in the query that it didn’t like when it said there weren’t any, because this was like today or 2 days ago.
184 00:26:30.260 ⇒ 00:26:32.350 Emily Giant: Nope, not that one.
185 00:26:47.260 ⇒ 00:26:50.950 Emily Giant: We’re gonna do type inventory adjustment.
186 00:27:13.090 ⇒ 00:27:15.579 Emily Giant: Yes, sir. Negative. 7.
187 00:27:17.280 ⇒ 00:27:18.220 Demilade Agboola: Nice.
188 00:27:19.380 ⇒ 00:27:21.160 Emily Giant: All right.
189 00:27:27.910 ⇒ 00:27:29.450 Emily Giant: happy about that.
190 00:27:29.640 ⇒ 00:27:32.800 Emily Giant: So we did spoilage shrinkage.
191 00:27:35.460 ⇒ 00:27:45.860 Emily Giant: there’s a lot of other adjustment types. It seems like the the problems we’re having with subscriptions have nothing to do with us.
192 00:27:46.020 ⇒ 00:27:48.830 Emily Giant: That’s a dev problem. And I’m going to open a ticket.
193 00:27:51.920 ⇒ 00:27:56.310 Emily Giant: So let me make sure they’re aggregating correctly in. Looker.
194 00:27:57.890 ⇒ 00:27:59.500 Emily Giant: Okay, save
195 00:28:06.190 ⇒ 00:28:10.239 Emily Giant: sorry. Just keeping track of that query. So I can send it to Alex in a little bit.
196 00:28:15.910 ⇒ 00:28:16.700 Emily Giant: Alright.
197 00:28:28.350 ⇒ 00:28:29.060 Emily Giant: Nope.
198 00:28:32.030 ⇒ 00:28:40.570 Emily Giant: so if we pull this in. Looker. Now, my, this is my production instance, and I have made some improvements on
199 00:28:40.720 ⇒ 00:28:44.599 Emily Giant: the lot since we last deployed something. So
200 00:28:44.740 ⇒ 00:28:47.629 Emily Giant: I’m guessing it’s gonna be the same. But
201 00:28:50.370 ⇒ 00:29:00.420 Emily Giant: the issue is, I can always like plug my instance into looker instead of like, and we can just make sure that, like, it’s not doing some weird aggregation thing.
202 00:29:02.000 ⇒ 00:29:05.979 Emily Giant: So my question is also this should say, Nope, perfect. Okay.
203 00:29:06.820 ⇒ 00:29:12.729 Emily Giant: Total quantity. Sold 2, 7, only 2 sold.
204 00:29:14.830 ⇒ 00:29:18.150 Emily Giant: Let’s checked Schnetsuite.
205 00:29:21.470 ⇒ 00:29:22.250 Emily Giant: Shit.
206 00:29:51.670 ⇒ 00:29:52.740 Emily Giant: Hmm!
207 00:29:55.150 ⇒ 00:29:56.709 Demilade Agboola: There’s only one sold on.
208 00:29:56.710 ⇒ 00:29:59.705 Emily Giant: Yeah, I’m gonna see what’s up with that.
209 00:30:04.950 ⇒ 00:30:05.920 Emily Giant: -Oh!
210 00:30:07.380 ⇒ 00:30:08.929 Emily Giant: Think it’s counting the base?
211 00:30:09.450 ⇒ 00:30:12.030 Emily Giant: Let me pull it in mode and see what’s going on.
212 00:30:25.470 ⇒ 00:30:30.209 Emily Giant: Actually, I mean, it shouldn’t show it on the lot, though. That’s the thing I was. Gonna say, it’s
213 00:30:32.320 ⇒ 00:30:34.850 Emily Giant: it might be a filter issue in Looker, but
214 00:30:35.050 ⇒ 00:30:38.941 Emily Giant: that they should straight up, not be associated with that lot. So
215 00:30:43.700 ⇒ 00:30:46.979 Emily Giant: Oh, I’m gonna be so annoyed. If that’s still happening.
216 00:30:47.200 ⇒ 00:30:51.489 Emily Giant: I feel like sometimes we fix things and then like it undoes itself.
217 00:30:54.320 ⇒ 00:30:58.239 Emily Giant: Okay? So when I pull it, it’s definitely pulling.
218 00:31:00.850 ⇒ 00:31:04.440 Emily Giant: Okay. So there’s no lot associated with it.
219 00:31:04.660 ⇒ 00:31:08.110 Demilade Agboola: Yes, I think you just filter out where notes with lots ids is not
220 00:31:11.260 ⇒ 00:31:17.280 Demilade Agboola: so like that would be how we ensure that it’s counting only the appropriate sales for each lot.
221 00:31:22.870 ⇒ 00:31:25.169 Demilade Agboola: Oh, like it’s not no sorry like.
222 00:31:25.170 ⇒ 00:31:30.750 Emily Giant: Oh, yep, yep, you’re right sorry my brain is not. No.
223 00:31:55.880 ⇒ 00:31:58.209 Emily Giant: okay. Where are our units?
224 00:31:59.890 ⇒ 00:32:04.199 Emily Giant: Okay, so what? The F, it’s correct. Why is it showing that.
225 00:32:05.500 ⇒ 00:32:09.439 Demilade Agboola: Yeah, cause I think we’re aggregating the as well.
226 00:32:11.370 ⇒ 00:32:12.430 Emily Giant: Hold on.
227 00:32:12.680 ⇒ 00:32:18.399 Emily Giant: Yeah, looker’s doing something I need to pull the lot. Id, and not the order. Id. However.
228 00:32:19.010 ⇒ 00:32:22.670 Emily Giant: is that not what I, whatever. Let me just try it with.
229 00:32:22.970 ⇒ 00:32:27.609 Emily Giant: See what may have pulled. That is wrong by pulling the lot instead of the order
230 00:32:29.960 ⇒ 00:32:32.970 Emily Giant: which I should have done from the get.
231 00:32:49.780 ⇒ 00:32:52.090 Emily Giant: Oh, yeah.
232 00:33:00.230 ⇒ 00:33:02.340 Emily Giant: we’re going to have a line for negative 7,
233 00:33:02.900 ⇒ 00:33:07.970 Emily Giant: and then we should only have one sail line should be 2 lines returned.
234 00:33:19.420 ⇒ 00:33:27.060 Emily Giant: Okay, I expected this sale sail.
235 00:33:28.170 ⇒ 00:33:31.440 Emily Giant: Okay, this is a totally different suborder than what we looked up.
236 00:33:31.910 ⇒ 00:33:33.580 Emily Giant: How about is canceled?
237 00:33:39.580 ⇒ 00:33:41.360 Emily Giant: I bet you one of these is canceled
238 00:33:42.940 ⇒ 00:33:48.959 Emily Giant: is cancel. It’s correct. We’re correct. It said it was canceled.
239 00:33:50.220 ⇒ 00:33:54.320 Emily Giant: So what needs to happen in this report is where?
240 00:33:57.340 ⇒ 00:34:03.149 Emily Giant: Okay? So that is not currently in looker wait, total canceled.
241 00:34:05.130 ⇒ 00:34:10.360 Emily Giant: I need to add that as a filter, though that should be like a a standard thing that can be.
242 00:34:11.000 ⇒ 00:34:11.930 Demilade Agboola: So I’ll go down enough.
243 00:34:12.409 ⇒ 00:34:13.289 Emily Giant: Yeah. Yeah.
244 00:34:22.329 ⇒ 00:34:26.229 Emily Giant: Hmm, okay. See it?
245 00:34:32.949 ⇒ 00:34:39.808 Emily Giant: oh, this is the inventory table. This isn’t the adjustment table. But I could do just to check the
246 00:34:54.949 ⇒ 00:34:56.329 Emily Giant: Yep, it’s correct.
247 00:34:59.629 ⇒ 00:35:04.289 Emily Giant: So the lot balance is negative one. So I also need to fix whatever is going on with this
248 00:35:05.529 ⇒ 00:35:07.679 Emily Giant: calculation. It shouldn’t be negative one.
249 00:35:13.409 ⇒ 00:35:16.069 Emily Giant: But anyway, that’s low on the list.
250 00:35:16.799 ⇒ 00:35:25.559 Emily Giant: okay, so this is all looking correct to me. However, I’m wondering. Like, should quantity sold have
251 00:35:25.979 ⇒ 00:35:31.449 Emily Giant: the canceled units removed from it always.
252 00:35:32.099 ⇒ 00:35:36.169 Emily Giant: so that it doesn’t need to be filtered out every single time.
253 00:35:37.479 ⇒ 00:35:38.089 Demilade Agboola: Hour.
254 00:35:38.432 ⇒ 00:35:47.669 Demilade Agboola: I don’t know how the the business stakeholders are used to seeing their data, so I can’t like I I think it should be removed. But again.
255 00:35:47.950 ⇒ 00:35:51.460 Demilade Agboola: I don’t know if they’re used to seeing it that week.
256 00:35:52.930 ⇒ 00:35:55.519 Emily Giant: Let’s ask them tomorrow on the call.
257 00:35:55.520 ⇒ 00:35:59.249 Demilade Agboola: Especially since there’s a column for cancelled quantity. So I’m not.
258 00:35:59.650 ⇒ 00:36:00.420 Emily Giant: Right.
259 00:36:00.570 ⇒ 00:36:02.590 Demilade Agboola: Yeah, it’s needed as well.
260 00:36:03.160 ⇒ 00:36:09.759 Emily Giant: I think it’s confusing to have the cancelled quantity confee like combined personally.
261 00:36:12.230 ⇒ 00:36:19.849 Emily Giant: So I’m we can ask the stakeholders. But I agree with you that like, since there’s a column for it.
262 00:36:20.200 ⇒ 00:36:23.349 Emily Giant: I don’t really see a need for including it.
263 00:36:33.900 ⇒ 00:36:38.849 Emily Giant: Alright, let me turn off my development mode and make sure that I can see everything.
264 00:36:58.320 ⇒ 00:37:01.300 Emily Giant: Yeah, okay. So these are all available to stakeholders.
265 00:37:01.890 ⇒ 00:37:04.531 Demilade Agboola: Okay? And is it currently
266 00:37:05.930 ⇒ 00:37:10.500 Demilade Agboola: in the dashboards they all like, look looks they use? Or is it just.
267 00:37:10.500 ⇒ 00:37:10.930 Emily Giant: No.
268 00:37:10.930 ⇒ 00:37:14.099 Demilade Agboola: Available to them for them to potentially use.
269 00:37:14.560 ⇒ 00:37:24.287 Emily Giant: It’s available, and it’s not in the dashboards. These reconciliation quantities. One thing we also need to check is the
270 00:37:25.670 ⇒ 00:37:32.030 Emily Giant: spoilage date thing to make sure that it’s like giving the week
271 00:37:32.960 ⇒ 00:37:39.400 Emily Giant: that the spoilage is associated with. Remember that conversation with Felipe. I made a thing in Looker.
272 00:37:40.200 ⇒ 00:37:41.240 Demilade Agboola: Okay.
273 00:37:41.240 ⇒ 00:37:43.939 Emily Giant: It might be in the wrong, it might be in the other data set
274 00:37:44.500 ⇒ 00:37:49.120 Emily Giant: next. Oh, same week. Spoilage next week. Spoilage. Let me see.
275 00:37:49.780 ⇒ 00:37:51.250 Emily Giant: So it’s
276 00:37:54.830 ⇒ 00:37:56.640 Emily Giant: yeah. So this is what I
277 00:37:58.180 ⇒ 00:38:03.769 Emily Giant: I added. Instead of doing it in Dbt, and I can move it to Dbt.
278 00:38:04.250 ⇒ 00:38:12.600 Emily Giant: but I wanted to get something fast. So it takes the expiration date
279 00:38:14.400 ⇒ 00:38:17.169 Emily Giant: and the date of the adjustment.
280 00:38:18.080 ⇒ 00:38:20.120 Emily Giant: Then it’s 10.
281 00:38:22.010 ⇒ 00:38:25.419 Emily Giant: Wait same week, spoilage, date trunk week. Add.
282 00:38:32.980 ⇒ 00:38:37.940 Emily Giant: let’s just test it on some of the spoilage lots that we know.
283 00:38:38.370 ⇒ 00:38:42.280 Emily Giant: The adjustment date was not
284 00:38:45.120 ⇒ 00:38:52.490 Emily Giant: within the expiration date, so his issue was like he wanted to make sure that if somebody finds like random units
285 00:38:52.680 ⇒ 00:38:57.629 Emily Giant: from an expired lot and they’re they’re like taken out of the system after the fact
286 00:38:58.100 ⇒ 00:39:03.869 Emily Giant: that that spoilage is attributed to the week that they were sellable, not the week they were adjusted.
287 00:39:04.420 ⇒ 00:39:05.510 Demilade Agboola: Oh, okay.
288 00:39:06.530 ⇒ 00:39:09.940 Emily Giant: So if I were to pull that in mode.
289 00:39:10.940 ⇒ 00:39:13.740 Emily Giant: it would be select everything where
290 00:39:16.510 ⇒ 00:39:23.640 Emily Giant: expiration, date. I would need to do like date trunk of the expiration date right.
291 00:39:24.590 ⇒ 00:39:30.360 Emily Giant: and say that that date is them. The adjustment date, week.
292 00:39:33.260 ⇒ 00:39:37.570 Demilade Agboola: So we’re trying to see where, what, when he expires.
293 00:39:40.920 ⇒ 00:39:46.529 Demilade Agboola: But that the dates should be associated with.
294 00:39:47.090 ⇒ 00:39:50.259 Demilade Agboola: Try, try and think of it.
295 00:39:51.470 ⇒ 00:39:53.540 Demilade Agboola: So the the.
296 00:39:57.700 ⇒ 00:40:01.389 Emily Giant: So it’s this, it’s pull or pull examples
297 00:40:01.550 ⇒ 00:40:07.639 Emily Giant: of spoilage where the adjustment date is not in the same week as the expiration date.
298 00:40:08.530 ⇒ 00:40:09.420 Demilade Agboola: That’s awesome.
299 00:40:09.420 ⇒ 00:40:11.620 Emily Giant: I should call it like the spoilage adjustment date
300 00:40:15.920 ⇒ 00:40:20.920 Emily Giant: is, I should say, in a later week.
301 00:40:21.290 ⇒ 00:40:26.190 Emily Giant: Then the Lot expiration date.
302 00:40:26.750 ⇒ 00:40:29.740 Demilade Agboola: So do we want to pull that out, or do we want to?
303 00:40:31.805 ⇒ 00:40:32.990 Demilade Agboola: Just flag it.
304 00:40:35.680 ⇒ 00:40:43.540 Emily Giant: I think we want to pull it out. We always want spoilage to be attributed to the week that
305 00:40:43.740 ⇒ 00:40:46.399 Emily Giant: the product was sellable.
306 00:40:47.080 ⇒ 00:40:47.819 Demilade Agboola: Oh, okay.
307 00:40:47.820 ⇒ 00:40:52.370 Emily Giant: Another way to write it. We want spoilage counts.
308 00:40:53.250 ⇒ 00:40:54.170 Demilade Agboola: Oof.
309 00:40:55.230 ⇒ 00:41:05.750 Emily Giant: 2 be attributed to the week, not the product was sellable regardless.
310 00:41:06.140 ⇒ 00:41:07.660 Demilade Agboola: Up to date.
311 00:41:08.820 ⇒ 00:41:13.120 Emily Giant: That the spoilage adjustment was made.
312 00:41:16.040 ⇒ 00:41:19.207 Emily Giant: So what I was trying to figure out is
313 00:41:21.030 ⇒ 00:41:28.049 Emily Giant: pulling examples where that happened, and then plugging that into Looker to see what the spoilage week is
314 00:41:28.490 ⇒ 00:41:35.410 Emily Giant: because it should be pulling the expiration week.
315 00:41:36.450 ⇒ 00:41:41.670 Emily Giant: and then he also gave an example, like if it’s done on
316 00:41:42.130 ⇒ 00:41:46.420 Emily Giant: Monday. It should still go back a week.
317 00:41:47.050 ⇒ 00:41:52.590 Emily Giant: because nobody was working on Sunday to adjust it out, and Monday is our fiscal week start.
318 00:41:55.910 ⇒ 00:42:01.190 Emily Giant: But this is literally exactly what Steven had written for him that he was using in the past.
319 00:42:01.590 ⇒ 00:42:05.530 Emily Giant: So, having replaced it with like
320 00:42:06.990 ⇒ 00:42:14.190 Emily Giant: the updated field names it should work. I just want to pull an example to make sure that it actually works.
321 00:42:14.190 ⇒ 00:42:15.640 Demilade Agboola: Oh, okay. Gotcha gotcha.
322 00:42:15.640 ⇒ 00:42:23.910 Emily Giant: Yeah. So I’m trying to think of like, what can I write to pull an example where that happened? To just validate that it works.
323 00:42:26.894 ⇒ 00:42:30.580 Demilade Agboola: The columns are adjustment dates and.
324 00:42:34.490 ⇒ 00:42:39.020 Emily Giant: So like, what would is it like? Week like date, trunk, week.
325 00:42:41.500 ⇒ 00:42:42.850 Demilade Agboola: You could do this part.
326 00:42:43.120 ⇒ 00:42:47.509 Emily Giant: Date. Part. Yeah, is it underscore for datepart.
327 00:42:47.510 ⇒ 00:42:48.200 Demilade Agboola: Yeah.
328 00:42:49.100 ⇒ 00:42:53.340 Demilade Agboola: So day part jeremy?
329 00:42:55.475 ⇒ 00:42:56.020 Demilade Agboola: P.
330 00:43:01.180 ⇒ 00:43:03.070 Demilade Agboola: I mean, I’m dropping in chat.
331 00:43:03.360 ⇒ 00:43:04.560 Emily Giant: Oh, thanks!
332 00:43:04.560 ⇒ 00:43:06.800 Demilade Agboola: It will look something like this.
333 00:43:09.560 ⇒ 00:43:14.809 Demilade Agboola: So basically, just want to be sure that it’s the same year. So you’re not comparing different years. But then.
334 00:43:18.110 ⇒ 00:43:18.770 Emily Giant: Yep.
335 00:43:19.940 ⇒ 00:43:26.319 Emily Giant: okay. So date, part week adjustment date is greater than date park week. Yep, yep, yep, that’s exactly right.
336 00:43:38.610 ⇒ 00:43:39.640 Emily Giant: Looking for them.
337 00:43:40.160 ⇒ 00:43:41.329 Emily Giant: Be part week.
338 00:43:41.890 ⇒ 00:43:50.159 Emily Giant: Well, let’s just see what this pulls. I was gonna try to make sure the examples are recent expiration date that does exist.
339 00:43:50.900 ⇒ 00:43:53.510 Demilade Agboola: Maybe it’s a spelling thing, I call it.
340 00:43:53.630 ⇒ 00:43:55.219 Demilade Agboola: Oh, it’s referenced.
341 00:43:56.540 ⇒ 00:43:57.790 Emily Giant: Oh, I know what it is!
342 00:43:58.190 ⇒ 00:43:59.850 Emily Giant: Wait! No, I don’t hold on!
343 00:44:17.050 ⇒ 00:44:24.210 Emily Giant: Earned one, I’m like.
344 00:44:31.070 ⇒ 00:44:33.820 Emily Giant: oh, expiration! Did we.
345 00:44:38.540 ⇒ 00:44:40.150 Demilade Agboola: Is it in there?
346 00:44:41.430 ⇒ 00:44:42.470 Emily Giant: Hold on.
347 00:44:42.960 ⇒ 00:44:47.190 Emily Giant: It’s called something else, I guess. But I haven’t.
348 00:44:48.030 ⇒ 00:44:53.300 Emily Giant: I think that it’s in my okay, essentially, the lot data
349 00:44:54.690 ⇒ 00:45:01.080 Emily Giant: and the suborder data should be exactly the same cause. That’s what you and I were after was like making them one thing, but
350 00:45:01.890 ⇒ 00:45:07.260 Emily Giant: not deployed yet. So I look in mine
351 00:45:10.660 ⇒ 00:45:12.559 Emily Giant: lot. Arrival, lot expiration.
352 00:45:36.527 ⇒ 00:45:40.960 Emily Giant: Yeah, I’m gonna definitely have to add another filter, one sec.
353 00:45:43.780 ⇒ 00:45:44.940 Emily Giant: And
354 00:46:20.190 ⇒ 00:46:27.680 Emily Giant: and we want oh, and it needs to be spoilage and adjustment type.
355 00:46:47.150 ⇒ 00:46:48.450 Emily Giant: Okie Dokie.
356 00:46:56.000 ⇒ 00:46:56.830 Emily Giant: all right.
357 00:46:57.890 ⇒ 00:47:07.239 Emily Giant: So what we’re checking now is to see what week this is showing as the spoilage week.
358 00:47:08.110 ⇒ 00:47:09.060 Demilade Agboola: Yeah.
359 00:47:10.060 ⇒ 00:47:17.240 Emily Giant: So, looking back, it says, it expired on 7, 30,
360 00:47:17.970 ⇒ 00:47:20.589 Emily Giant: and the adjustment was on 8, 4.
361 00:47:22.260 ⇒ 00:47:26.489 Emily Giant: Okay, so we want to make sure that that falls into
362 00:47:26.730 ⇒ 00:47:31.199 Emily Giant: is that really a different week? Whatever? Let’s
363 00:47:43.240 ⇒ 00:47:49.450 Emily Giant: foilage quantity. And then we what is this called?
364 00:47:50.620 ⇒ 00:47:52.720 Emily Giant: It’s called same week spoilage.
365 00:47:56.880 ⇒ 00:48:00.200 Emily Giant: and then next week’s spoilage.
366 00:48:04.380 ⇒ 00:48:05.670 Emily Giant: Hmm.
367 00:48:20.760 ⇒ 00:48:23.930 Emily Giant: so this is what they use. They use date date.
368 00:48:48.350 ⇒ 00:48:51.449 Emily Giant: I mean, that looks correct to me
369 00:48:53.780 ⇒ 00:48:56.620 Emily Giant: that it would be in this week, and not the week of 8, 4.
370 00:48:56.940 ⇒ 00:48:57.740 Demilade Agboola: Yeah.
371 00:48:59.650 ⇒ 00:49:01.519 Emily Giant: So where’s the expiration date?
372 00:49:18.950 ⇒ 00:49:22.590 Emily Giant: Oh, well, that was in no way helpful. Sorry.
373 00:49:29.220 ⇒ 00:49:38.660 Emily Giant: arrival it really. You’re gonna give me a number here. Sorry expiration date week.
374 00:49:50.490 ⇒ 00:49:57.430 Emily Giant: Alright, I’ve got to clean up this like sidebar, because that’s super annoying.
375 00:49:58.200 ⇒ 00:50:00.560 Emily Giant: Alright date day.
376 00:50:08.110 ⇒ 00:50:10.520 Emily Giant: That’s dated date. I need date day week.
377 00:50:10.970 ⇒ 00:50:14.739 Emily Giant: but 22 plus 7 is 9. So this is the same.
378 00:50:17.400 ⇒ 00:50:21.019 Emily Giant: No, okay, this needs work.
379 00:50:21.310 ⇒ 00:50:26.490 Emily Giant: I need to fix that. It does. It’s not working because the 28, th
380 00:50:29.630 ⇒ 00:50:32.660 Emily Giant: and it was done here. So it should have been in this week.
381 00:50:35.340 ⇒ 00:50:42.709 Emily Giant: because, even though the product expired here, it was for sale during this week.
382 00:50:43.380 ⇒ 00:50:44.060 Demilade Agboola: Okay.
383 00:50:44.060 ⇒ 00:50:46.350 Emily Giant: I wanted the spoilage numbers to count
384 00:50:46.460 ⇒ 00:50:48.359 Emily Giant: here. You want to count here.
385 00:50:49.350 ⇒ 00:50:53.170 Demilade Agboola: Oh, okay, so it seems like.
386 00:50:54.230 ⇒ 00:51:00.320 Demilade Agboola: because it so it expired on 28.th But is it because things that expire on Mondays count for the previous week.
387 00:51:02.790 ⇒ 00:51:07.550 Emily Giant: This is a weird one, because this is probably a midweek transfer, so I’m sure it arrived.
388 00:51:07.750 ⇒ 00:51:13.579 Emily Giant: Well, it would have arrived or started on the 21st had this entire week to sell.
389 00:51:14.090 ⇒ 00:51:29.560 Emily Giant: and then was not any longer for sale on this date, so the spoilage would be counted against week 21, not the week that it wasn’t for sale, because this is to tell stakeholders like you ordered too many on this week.
390 00:51:29.890 ⇒ 00:51:39.176 Emily Giant: because this spoiled. So yeah, the wait. That’s correct. Then, right?
391 00:51:41.170 ⇒ 00:51:52.349 Emily Giant: Because even though it expired here in this week, it’s saying that it was adjusted in this week. So that actually is correct. I’m like talking myself out of the correctness there. Yeah, this is actually correct.
392 00:51:52.510 ⇒ 00:51:56.309 Emily Giant: Let me date day week just in case
393 00:51:56.930 ⇒ 00:52:00.750 Emily Giant: because it should say the 21st date day week.
394 00:52:15.810 ⇒ 00:52:19.970 Emily Giant: Yeah, see? Okay, yep, that’s correct. It works.
395 00:52:20.610 ⇒ 00:52:21.630 Demilade Agboola: Nice.
396 00:52:21.630 ⇒ 00:52:23.990 Emily Giant: Yay, okay.
397 00:52:26.430 ⇒ 00:52:40.649 Emily Giant: alright. Well, so it looks like the one issue that we still have, and it’ll I’ll make it my ticket, since I’m deploying like those little tweaks, anyway. Was what that ticket we just made for something that I don’t remember.
398 00:52:41.240 ⇒ 00:52:43.590 Emily Giant: Oh, Nope, I don’t remember. Do you.
399 00:52:46.310 ⇒ 00:52:51.460 Demilade Agboola: I move adjustment types that I can’t remember. It was some of them.
400 00:52:51.940 ⇒ 00:52:52.330 Emily Giant: Yeah.
401 00:52:52.330 ⇒ 00:52:53.229 Demilade Agboola: Oh, actually.
402 00:52:53.600 ⇒ 00:52:54.550 Emily Giant: Md hub.
403 00:52:55.140 ⇒ 00:53:05.860 Demilade Agboola: Yeah, the hub and spoke logic. And also, I think, go about counting the non.
404 00:53:07.340 ⇒ 00:53:11.910 Demilade Agboola: the non-lotted items like filter them out.
405 00:53:13.363 ⇒ 00:53:15.129 Emily Giant: Okay, so
406 00:53:19.920 ⇒ 00:53:21.040 Emily Giant: where am I?
407 00:53:28.610 ⇒ 00:53:33.930 Emily Giant: I’m trying to find to the cycle
408 00:53:40.590 ⇒ 00:53:47.290 Emily Giant: for some reason, the search isn’t pulling up, remove, yeah.
409 00:53:51.990 ⇒ 00:53:54.220 Emily Giant: i’ll find it. It’s in here.
410 00:54:01.170 ⇒ 00:54:05.300 Emily Giant: Okay, nice.
411 00:54:06.530 ⇒ 00:54:10.960 Emily Giant: There we go. Okay, I’m moving that into this cycle.
412 00:54:23.480 ⇒ 00:54:28.989 Emily Giant: And then it was remove canceled orders from sale. Count.
413 00:54:34.110 ⇒ 00:54:37.914 Demilade Agboola: So yeah, there’s canceled orders from sale counts
414 00:54:39.370 ⇒ 00:54:47.289 Demilade Agboola: And then there’s also, I think we’re also counting the non-lotted ids, which is why, when we filter by
415 00:54:47.880 ⇒ 00:54:51.740 Demilade Agboola: lot, Id is not null, we, overseeing the appropriate rows.
416 00:54:52.690 ⇒ 00:54:54.479 Emily Giant: I thought that that was correct.
417 00:54:54.780 ⇒ 00:54:57.300 Emily Giant: Are you let me?
418 00:54:57.680 ⇒ 00:55:02.480 Emily Giant: It was, we thought that that was the issue, but it was the. It was actually the cancelled.
419 00:55:02.480 ⇒ 00:55:03.980 Demilade Agboola: Oh, gotcha! Gotcha!
420 00:55:03.980 ⇒ 00:55:05.689 Emily Giant: It was just the cancelled issue.
421 00:55:06.270 ⇒ 00:55:13.849 Emily Giant: That’s it. Like those will be done. I can do that today. That’s not too much. It’s like adding one line of
422 00:55:14.640 ⇒ 00:55:19.252 Emily Giant: code so that we can like, show the stakeholders tomorrow.
423 00:55:19.990 ⇒ 00:55:25.870 Emily Giant: I do want to do a little bit more testing on the spoilage date to make sure it works for Felipe. But
424 00:55:26.000 ⇒ 00:55:31.953 Emily Giant: us, that’s exactly what I expected to see when I pulled that so we can just
425 00:55:32.970 ⇒ 00:55:36.650 Emily Giant: I can have him do Qa. Async, and let us know if it works.
426 00:55:36.980 ⇒ 00:55:49.590 Demilade Agboola: Okay. And also we need to start like moving the numbers into their dashboards. I really want us to like, but have them have those numbers in their dashboards, because that’s ultimately what
427 00:55:52.420 ⇒ 00:55:55.940 Demilade Agboola: what they need to do to to power through the day.
428 00:55:56.450 ⇒ 00:55:57.200 Emily Giant: Blame.
429 00:55:57.200 ⇒ 00:56:02.350 Demilade Agboola: Whatever errors it’s easier for us to be able to then troubleshoot and Qa.
430 00:56:03.930 ⇒ 00:56:09.779 Emily Giant: Should we take time during the meeting tomorrow to like update one of Felipe’s reports.
431 00:56:10.120 ⇒ 00:56:15.200 Emily Giant: or like, do it in real time? I’m just trying to think of what would be
432 00:56:15.910 ⇒ 00:56:19.539 Emily Giant: the best way for them to feel comfortable, using all of these.
433 00:56:20.637 ⇒ 00:56:27.052 Demilade Agboola: Sure. I think we could maybe do a couple add some numbers before slightly before the report.
434 00:56:28.150 ⇒ 00:56:33.099 Demilade Agboola: I’m just kind of show them what the numbers look like, and just kind of
435 00:56:33.450 ⇒ 00:56:35.880 Demilade Agboola: ensure that they have access to it.
436 00:56:36.750 ⇒ 00:56:49.969 Emily Giant: Okay, yeah. And then, we can always work on it tomorrow. During the working session, like putting some looker stuff together before the meeting, so that we have examples on hand. If you want to, just to make it easier.
437 00:56:50.110 ⇒ 00:56:51.490 Demilade Agboola: Yeah, sounds good.
438 00:56:51.490 ⇒ 00:56:55.865 Emily Giant: Okay, cool. Alright. Well, I’ve got my marching orders.
439 00:56:56.470 ⇒ 00:56:58.710 Emily Giant: It looks like everything’s pretty good, though.
440 00:56:59.500 ⇒ 00:57:00.410 Demilade Agboola: Yes.
441 00:57:00.690 ⇒ 00:57:01.730 Emily Giant: Yes.
442 00:57:01.730 ⇒ 00:57:02.510 Demilade Agboola: Probably not.
443 00:57:02.510 ⇒ 00:57:03.070 Emily Giant: Oh.
444 00:57:04.340 ⇒ 00:57:11.160 Emily Giant: yeah, I love when it’s a deaf problem and not my fault. This is great. Gonna go open some tickets with Alex.
445 00:57:11.320 ⇒ 00:57:15.650 Demilade Agboola: Yeah, just to flag the subscriptions issues with Alex.
446 00:57:15.810 ⇒ 00:57:19.040 Emily Giant: Alright, and I’ll let Felipe know, too, just to keep an eye on that.
447 00:57:19.040 ⇒ 00:57:19.900 Demilade Agboola: Pardon me.
448 00:57:20.230 ⇒ 00:57:24.199 Emily Giant: Alright cool. Well, I will talk to you. Go to bed. It’s like the middle of the night, so.
449 00:57:24.200 ⇒ 00:57:26.339 Demilade Agboola: It’s just 10 o’clock. It’s not the worst.
450 00:57:26.340 ⇒ 00:57:31.040 Emily Giant: This is not that bad, but go, go, live your life, and don’t work anymore.
451 00:57:31.790 ⇒ 00:57:33.429 Demilade Agboola: I’ll try. I’ll try.
452 00:57:33.930 ⇒ 00:57:35.860 Emily Giant: Cool. Alright. I’ll talk to you tomorrow.
453 00:57:36.150 ⇒ 00:57:37.349 Demilade Agboola: Talk to you tomorrow. Bye.