Meeting Title: Eden Rev Recon: Planning Communications with Client Date: 2026-04-14 Meeting participants: Jasmin Multani, Amber Lin
WEBVTT
1 00:01:57.380 ⇒ 00:01:58.430 Jasmin Multani: Blue!
2 00:01:59.270 ⇒ 00:02:00.420 Amber Lin: Hello!
3 00:02:01.150 ⇒ 00:02:02.240 Jasmin Multani: How’s it going?
4 00:02:02.670 ⇒ 00:02:05.220 Amber Lin: Very good. My days.
5 00:02:05.500 ⇒ 00:02:07.209 Amber Lin: Getting closer.
6 00:02:07.570 ⇒ 00:02:08.160 Jasmin Multani: So cool.
7 00:02:08.160 ⇒ 00:02:11.140 Amber Lin: So close, so close.
8 00:02:12.720 ⇒ 00:02:19.659 Jasmin Multani: Also… You did not deserve the heat this morning. I apologize for that, but…
9 00:02:19.660 ⇒ 00:02:23.799 Amber Lin: Oh, no, it wasn’t… I think it’s just how, like.
10 00:02:23.930 ⇒ 00:02:31.860 Amber Lin: It’s just how Robert talks, I mean, he’s getting the heat. Like, I understand. He could have been even more stressed, because dealing with
11 00:02:32.090 ⇒ 00:02:35.970 Amber Lin: the ELTX, it’s not… it’s not nice, so…
12 00:02:36.660 ⇒ 00:02:41.049 Amber Lin: He’s the only one getting the heat, and we’re all kind of just behind him.
13 00:02:44.530 ⇒ 00:02:58.529 Jasmin Multani: So I read through the Eden thread, your most recent Eden thread. From what it sounds like, you were able to meet up with Aviation, to land on a solution, and now you and I are just workshopping
14 00:02:58.910 ⇒ 00:03:00.809 Jasmin Multani: A Slack message, is that correct?
15 00:03:01.250 ⇒ 00:03:06.239 Amber Lin: Yeah, I want to confirm with you, cause right now, I have…
16 00:03:06.350 ⇒ 00:03:15.779 Amber Lin: figured out three states of what BAS looks like, what Clicklines looks like, and what our Omni dashboard looks like.
17 00:03:15.910 ⇒ 00:03:25.439 Amber Lin: And then, what data we’re getting from BASC. So I’ve investigated these three things, and there are some, like.
18 00:03:25.950 ⇒ 00:03:34.830 Amber Lin: because we’re limited by the data that comes in from BAS’s API, the Omni dashboard looks different
19 00:03:34.990 ⇒ 00:03:37.149 Amber Lin: Then… bask.
20 00:03:37.400 ⇒ 00:03:45.430 Amber Lin: And… but however, finance from, like, Eden’s side is like, hey, why is there a discrepancy?
21 00:03:46.170 ⇒ 00:03:54.359 Amber Lin: Between that, because they don’t know, they don’t look at the source data, they just look at the Basque Home dashboard, and they’re like, hey, why is this different?
22 00:03:55.860 ⇒ 00:04:05.800 Amber Lin: So… For your quick context, inside Bask…
23 00:04:12.740 ⇒ 00:04:16.109 Amber Lin: Inside Mask, this is what they look at.
24 00:04:16.310 ⇒ 00:04:24.879 Amber Lin: So for example, I’ve changed it to their time zone. So, when I look at this, and I say, okay, the past
25 00:04:25.120 ⇒ 00:04:32.499 Amber Lin: even just yesterday, I look at this, or let’s… let’s use the day that I used to compare, let’s use this one.
26 00:04:32.650 ⇒ 00:04:35.659 Amber Lin: The 11th, right. We have these.
27 00:04:36.690 ⇒ 00:04:45.690 Amber Lin: And… there’s… well, the total orders just declined. There’s total sales, total orders. And…
28 00:04:46.740 ⇒ 00:04:52.780 Amber Lin: the question they have is, hey, why is this different than what we have in Omni?
29 00:04:53.500 ⇒ 00:04:58.019 Amber Lin: For example, for the last 30 complete days.
30 00:04:58.550 ⇒ 00:05:02.710 Amber Lin: Which would be from the 15th to now.
31 00:05:03.970 ⇒ 00:05:05.309 Amber Lin: There’s this.
32 00:05:05.540 ⇒ 00:05:07.880 Amber Lin: This is the total orders they show here.
33 00:05:08.620 ⇒ 00:05:13.720 Amber Lin: This is essentially the dashboard we’ve just been creating, so I think you have some more context here.
34 00:05:15.090 ⇒ 00:05:22.269 Jasmin Multani: Can you send those links to me? Those two, the BAS link, and also the Omni link that they’re referring to?
35 00:05:23.070 ⇒ 00:05:27.239 Amber Lin: Yeah, the OmniLink is just a dashboard you and I have been working on.
36 00:05:27.240 ⇒ 00:05:29.769 Jasmin Multani: What’s the 70-30…
37 00:05:29.770 ⇒ 00:05:30.210 Amber Lin: Yeah.
38 00:05:30.210 ⇒ 00:05:32.020 Jasmin Multani: 7.30, whatever.
39 00:05:32.020 ⇒ 00:05:40.239 Amber Lin: Yeah, that’s the one that has the past 30 days, past 60 days. So let’s say this. I did the same date range. Let me send this to you.
40 00:05:40.630 ⇒ 00:05:45.640 Amber Lin: And you can log in with… with the on one… it’s in one pass.
41 00:05:46.200 ⇒ 00:05:50.664 Amber Lin: So, we have that… Mmm…
42 00:05:52.790 ⇒ 00:05:54.779 Jasmin Multani: Eden? Eden, I’ve been fortunate.
43 00:05:55.540 ⇒ 00:05:58.620 Amber Lin: It should be data at Triaden.
44 00:05:59.110 ⇒ 00:06:00.640 Amber Lin: For basketball.
45 00:06:00.640 ⇒ 00:06:02.650 Jasmin Multani: Okay, data, track…
46 00:06:02.650 ⇒ 00:06:10.460 Amber Lin: Use the drop-down from… from the OnePass options, because I don’t know if I can spell it correctly.
47 00:06:26.070 ⇒ 00:06:27.440 Amber Lin: Yeah.
48 00:06:27.440 ⇒ 00:06:28.470 Jasmin Multani: word, okay.
49 00:06:28.880 ⇒ 00:06:31.339 Jasmin Multani: Okay, I’ll figure it out later.
50 00:06:31.340 ⇒ 00:06:34.390 Amber Lin: And then, so for example, the last 30 days.
51 00:06:34.760 ⇒ 00:06:37.819 Amber Lin: On here, last 30 complete days is this number.
52 00:06:38.170 ⇒ 00:06:38.820 Amber Lin: this…
53 00:06:38.820 ⇒ 00:06:40.770 Jasmin Multani: 25870, okay.
54 00:06:40.770 ⇒ 00:06:44.869 Amber Lin: Right, and then when we look at BASC, This is much higher.
55 00:06:46.250 ⇒ 00:06:51.170 Amber Lin: This 4ID excludes canceled… cancellations and errors.
56 00:06:51.560 ⇒ 00:06:54.009 Jasmin Multani: Wow, so it’s gonna be even, even higher.
57 00:06:54.890 ⇒ 00:07:10.759 Amber Lin: Yeah, what we show here also excludes cancellations and errors. This doesn’t exclude abandoned orders, so we are on even playing field, but my suspicion is that the… the…
58 00:07:11.030 ⇒ 00:07:16.989 Amber Lin: The statuses we use, use the same words, but they’re not the same thing.
59 00:07:17.710 ⇒ 00:07:18.519 Amber Lin: And for example.
60 00:07:18.520 ⇒ 00:07:19.329 Jasmin Multani: Oh, okay.
61 00:07:19.790 ⇒ 00:07:29.169 Amber Lin: Yeah, that’s the… that’s the main issue. So let me show you what the fields in BASC looks like, and then I can show you what it looks like.
62 00:07:29.520 ⇒ 00:07:36.680 Amber Lin: in… in Omni, and in the… the API that we get. So…
63 00:07:36.860 ⇒ 00:07:40.890 Amber Lin: In BASC, there’s a lot of different statuses.
64 00:07:41.170 ⇒ 00:07:47.010 Amber Lin: there’s custom status, the… let’s start here. Order status is the, like, most…
65 00:07:47.760 ⇒ 00:08:02.639 Amber Lin: default one, and there’s these statuses, right? Pending, sent to pharmacy, shipped, completed. Those are the main ones we need to care about, but then you can also see there’s business status.
66 00:08:03.340 ⇒ 00:08:11.460 Amber Lin: there’s… patient status, and there’s pharmacy status. These are all statuses fields.
67 00:08:11.560 ⇒ 00:08:15.280 Amber Lin: So… In BASC,
68 00:08:15.520 ⇒ 00:08:23.899 Amber Lin: When we get the data that BASC sends to us, we get it in two tables. So first.
69 00:08:24.800 ⇒ 00:08:36.289 Amber Lin: First, when the or… it’s based on events. So, BASC sends us first an order-completed table. That just tells us, hey,
70 00:08:36.360 ⇒ 00:08:52.050 Amber Lin: this order completed event has been completed, and then it sends us the data of the table, and whenever updates happen, a new entry happens in the order updated table. For example, oh, it changed from
71 00:08:52.050 ⇒ 00:09:00.940 Amber Lin: Abandoned, which is the default status. Abandoned to sent to pharmacy, or abandoned to cancel, the person canceled the order.
72 00:09:01.540 ⇒ 00:09:06.320 Amber Lin: So… The issue I find here is that
73 00:09:07.250 ⇒ 00:09:17.340 Amber Lin: This is the… this, there’s not a lot of things outside of abandoned and pending in this order completed table.
74 00:09:17.700 ⇒ 00:09:18.770 Amber Lin: So…
75 00:09:19.160 ⇒ 00:09:31.389 Amber Lin: Usually they start out, like, abandoned and pending, and very few of them are, like, canceled or ever. And then when we have these… this table, for example.
76 00:09:31.500 ⇒ 00:09:46.320 Amber Lin: I joined this together, and sometimes they change from pending, they may change from pending to error. Like, that’s kind of how the system works, and in our system, we join this together.
77 00:09:46.920 ⇒ 00:09:49.320 Amber Lin: And…
78 00:09:50.030 ⇒ 00:09:59.320 Amber Lin: I think we take whatever this order updated table has, and we override, so we have the most updated things that we receive from the API.
79 00:10:00.400 ⇒ 00:10:05.450 Amber Lin: But in Omni, let’s say… Let’s go back…
80 00:10:11.570 ⇒ 00:10:17.759 Amber Lin: Anyways, I was working in here. So, this is in Omni, and this is the fact transactions table.
81 00:10:19.030 ⇒ 00:10:22.230 Amber Lin: These are the statuses we have for
82 00:10:22.970 ⇒ 00:10:30.280 Amber Lin: for that date. So this table doesn’t include canceled and errors, sorry.
83 00:10:30.700 ⇒ 00:10:37.320 Amber Lin: Roll it back, ignore this, I think this is a little bit complicated. Let me show you… the…
84 00:10:38.600 ⇒ 00:10:39.880 Amber Lin: the thread.
85 00:10:42.280 ⇒ 00:10:47.290 Amber Lin: So, I downloaded all the orders from BASC that was made that day.
86 00:10:47.370 ⇒ 00:11:03.629 Amber Lin: I downloaded all the orders in Omni that said was made that day. I didn’t exclude any orders, I just said all orders, including, just any orders with order date on, like, April 11th.
87 00:11:04.000 ⇒ 00:11:10.460 Amber Lin: So… on Basque, Or… Let’s see…
88 00:11:10.980 ⇒ 00:11:13.740 Amber Lin: This is the order status fuel in BASC.
89 00:11:13.890 ⇒ 00:11:22.239 Amber Lin: As you can see, I would just highlight this one. Some of these error order statuses are still pending.
90 00:11:22.980 ⇒ 00:11:25.980 Amber Lin: in our current status field.
91 00:11:26.780 ⇒ 00:11:32.230 Amber Lin: And… I think this is because we take…
92 00:11:33.480 ⇒ 00:11:36.559 Amber Lin: Like, it’s either that we don’t get these updates.
93 00:11:37.260 ⇒ 00:11:50.430 Amber Lin: we don’t get all of the updates from APAPI, or we are just getting any update from any of those status fields, not just order status, and calling it an update, and we’re just grouping it into current status.
94 00:11:50.530 ⇒ 00:11:53.190 Amber Lin: Because it could have just updated
95 00:11:54.330 ⇒ 00:11:58.250 Amber Lin: Like, for this order, I think it, let’s see…
96 00:12:00.010 ⇒ 00:12:09.149 Amber Lin: Like, if, for example, maybe it updated here and said pending, while order status might be canceled, and we could have just called it pending, because that’s the latest status.
97 00:12:10.580 ⇒ 00:12:20.310 Amber Lin: Because we only filter by latest, we don’t, like, the API does not tell us what status got updated. That is my suspicion.
98 00:12:21.040 ⇒ 00:12:26.290 Amber Lin: Or I could be wrong, and it does give us order status, then we’re not… we’re just not getting all the data.
99 00:12:26.720 ⇒ 00:12:27.440 Jasmin Multani: Okay.
100 00:12:27.640 ⇒ 00:12:28.190 Amber Lin: Yeah.
101 00:12:28.450 ⇒ 00:12:30.669 Jasmin Multani: So… okay.
102 00:12:30.820 ⇒ 00:12:35.230 Jasmin Multani: I like the hypothesis. I think it’s… It could happen.
103 00:12:35.540 ⇒ 00:12:38.160 Jasmin Multani: But, I think we need to…
104 00:12:38.260 ⇒ 00:12:41.010 Jasmin Multani: Validate it through a different method.
105 00:12:42.120 ⇒ 00:12:44.020 Jasmin Multani: So, I think we should just, like.
106 00:12:44.520 ⇒ 00:12:46.649 Jasmin Multani: Do things a little bit more raw.
107 00:12:46.870 ⇒ 00:12:50.089 Jasmin Multani: I would say go on…
108 00:12:51.880 ⇒ 00:12:55.230 Jasmin Multani: We could do a side-by-side comparison without any joins.
109 00:12:55.370 ⇒ 00:13:01.600 Jasmin Multani: So, let’s pull… the data in BASC,
110 00:13:02.210 ⇒ 00:13:08.240 Jasmin Multani: Over 7 days, but just raw. Like, I want to see each row have an order ID.
111 00:13:10.930 ⇒ 00:13:16.620 Jasmin Multani: If it says, like, there are 28,000 orders, I want to see 28,000 bros.
112 00:13:18.240 ⇒ 00:13:30.899 Amber Lin: What do you mean? Like, in the… do you mean these, like, order completed, order updated tables, or just, like, our base, like, fact transactions, or…
113 00:13:31.330 ⇒ 00:13:34.929 Jasmin Multani: Let’s flip back to the Basque, link that you had sent me.
114 00:13:35.460 ⇒ 00:13:36.010 Amber Lin: Huh.
115 00:13:36.010 ⇒ 00:13:38.909 Jasmin Multani: That one that has the higher order amount.
116 00:13:39.330 ⇒ 00:13:40.060 Amber Lin: Huh.
117 00:13:40.420 ⇒ 00:13:45.580 Jasmin Multani: So, this is the space, from here.
118 00:13:47.150 ⇒ 00:13:54.269 Jasmin Multani: how can we get those, like, the raw information for those 28,000 orders? Is that…
119 00:13:54.630 ⇒ 00:13:59.440 Amber Lin: Yeah, we can filter 28… you mean for the past 30 days?
120 00:13:59.620 ⇒ 00:14:04.639 Jasmin Multani: Yeah, or let’s truncate it to past 7 days, so it’s easier to manage.
121 00:14:05.160 ⇒ 00:14:18.039 Amber Lin: Yeah. Well, one last thing before we flip over. This is, like, this is what we… for example, one last thing. This is what BASC has as an error, but in Omni we have as pending.
122 00:14:18.040 ⇒ 00:14:19.260 Jasmin Multani: And…
123 00:14:19.260 ⇒ 00:14:24.869 Amber Lin: This illustrates what happened, is BASC shows order status equals error.
124 00:14:25.440 ⇒ 00:14:30.309 Amber Lin: got an API saying, oh, pharmacy status got sent to pending.
125 00:14:31.160 ⇒ 00:14:38.169 Amber Lin: This is the latest status we have. So we set our, like, current status field to pending.
126 00:14:38.410 ⇒ 00:14:39.070 Jasmin Multani: Which means…
127 00:14:39.070 ⇒ 00:14:45.059 Amber Lin: we included this order, whereas they, BASC would have excluded this order in their account.
128 00:14:45.170 ⇒ 00:14:51.549 Amber Lin: But anyways, this is just an illustration. So for the past…
129 00:14:51.550 ⇒ 00:14:59.949 Jasmin Multani: Isn’t that so weird? Like, we’re trying to root cause why Basque has a higher count, and this would… this line would have been dropped from that high count.
130 00:15:00.660 ⇒ 00:15:06.210 Amber Lin: Yeah, and then there would be other orders where it would have been the opposite.
131 00:15:06.470 ⇒ 00:15:08.950 Jasmin Multani: Okay, so I see what you’re saying.
132 00:15:08.950 ⇒ 00:15:13.969 Amber Lin: Pending here, but pharmacy had an error, but the order, like, the customer didn’t
133 00:15:14.190 ⇒ 00:15:23.969 Amber Lin: withdraw the… the order’s still there. But pharmacy has an error, so they’re trying to resolve the pharmacy error, but it could be an error field, so we would have dropped it.
134 00:15:24.160 ⇒ 00:15:26.500 Amber Lin: Yeah. But Bass would have still had it.
135 00:15:26.730 ⇒ 00:15:40.019 Jasmin Multani: Yeah, okay, so we’re seeing a lot of noise in different directions, and that noise is because BASC has 3 status columns, and we, can’t figure out which one routes
136 00:15:40.690 ⇒ 00:15:45.499 Jasmin Multani: To our final state, or if it’s, like, overriding certain things.
137 00:15:45.840 ⇒ 00:15:52.080 Amber Lin: Yeah, I think it’s everyth… yeah, we have 1, 2… Three…
138 00:15:52.780 ⇒ 00:15:57.749 Amber Lin: Yeah, three… three statuses that might override. Okay, cool.
139 00:15:57.750 ⇒ 00:16:06.129 Jasmin Multani: And actually, I take that back. Can we actually do the 30-day? Because, they’re gonna… they want the evidence comparing it to…
140 00:16:06.520 ⇒ 00:16:10.649 Jasmin Multani: the Omni tiles, which is only in 30 days and 60 days.
141 00:16:11.420 ⇒ 00:16:12.230 Amber Lin: Yeah.
142 00:16:12.890 ⇒ 00:16:19.060 Amber Lin: We can also, like… do a smaller range in Omni.
143 00:16:19.490 ⇒ 00:16:25.560 Jasmin Multani: Oh, okay, cool, cool, cool. Okay, yeah, then let’s stick to 7 days then. Let’s just do Sunday to Saturday.
144 00:16:27.730 ⇒ 00:16:30.520 Jasmin Multani: So, Sunday the 5th to Saturday the 11th.
145 00:16:38.600 ⇒ 00:16:44.990 Jasmin Multani: Okay, cool. So I see 6,000… okay, cool. Can we get the raw output here?
146 00:16:45.870 ⇒ 00:16:48.010 Amber Lin: That will be a very big…
147 00:16:48.170 ⇒ 00:16:51.159 Amber Lin: like, download, that’s what I did a single day.
148 00:16:54.120 ⇒ 00:16:55.329 Jasmin Multani: Can we do 3 days?
149 00:16:55.550 ⇒ 00:16:56.940 Amber Lin: Yeah, let’s try that.
150 00:17:09.210 ⇒ 00:17:11.370 Amber Lin: Yep, I can send you the file.
151 00:17:11.790 ⇒ 00:17:16.179 Jasmin Multani: And when it says local timestamps, is that local to the pharmacy?
152 00:17:16.180 ⇒ 00:17:18.060 Amber Lin: This one. It’s…
153 00:17:18.630 ⇒ 00:17:19.250 Jasmin Multani: Okay.
154 00:17:19.250 ⇒ 00:17:28.170 Amber Lin: Oh, as in the user, so I… I changed it, changed my computer to EST, because our Basque API is in EST.
155 00:17:28.680 ⇒ 00:17:29.960 Jasmin Multani: Okay, thank you so much.
156 00:17:30.990 ⇒ 00:17:35.820 Jasmin Multani: And now, can we try to export the same range?
157 00:17:37.970 ⇒ 00:17:40.240 Jasmin Multani: date range from Omni.
158 00:17:43.450 ⇒ 00:17:50.660 Jasmin Multani: And same thing, like, each order has its own… data line.
159 00:18:00.320 ⇒ 00:18:03.510 Amber Lin: Let’s say… what do we need?
160 00:18:09.080 ⇒ 00:18:15.110 Jasmin Multani: I would say, like, the full… as much data as we can. Like, the… The most fool.
161 00:18:15.380 ⇒ 00:18:15.920 Amber Lin: Okay.
162 00:18:18.720 ⇒ 00:18:20.599 Jasmin Multani: If we can get everything, that’d be great.
163 00:18:39.130 ⇒ 00:18:43.109 Jasmin Multani: And is this… do you think this is going to be reflected above Eastern as well?
164 00:18:43.500 ⇒ 00:18:44.850 Amber Lin: Yeah. Okay.
165 00:18:46.430 ⇒ 00:18:47.680 Jasmin Multani: Thank you, thank you.
166 00:19:36.980 ⇒ 00:19:40.590 Amber Lin: Hmm, this doesn’t include canceled orders.
167 00:19:49.170 ⇒ 00:19:51.549 Jasmin Multani: It doesn’t… can we ask it to include?
168 00:19:51.740 ⇒ 00:19:56.040 Amber Lin: Yeah, it will be a different… topic, I think. Oops.
169 00:19:58.350 ⇒ 00:20:00.120 Jasmin Multani: Maybe you can ask it for the topic?
170 00:20:01.860 ⇒ 00:20:04.770 Amber Lin: No, it’s in here somewhere.
171 00:20:05.070 ⇒ 00:20:05.620 Jasmin Multani: Okay.
172 00:20:23.640 ⇒ 00:20:25.829 Amber Lin: Send us to you first.
173 00:20:32.640 ⇒ 00:20:34.129 Jasmin Multani: This is the Basque.
174 00:20:34.270 ⇒ 00:20:35.790 Amber Lin: This is the best one.
175 00:23:40.230 ⇒ 00:23:44.079 Amber Lin: I already ran… what type of comparison are you thinking of running?
176 00:23:45.130 ⇒ 00:23:50.619 Jasmin Multani: I’m just gonna, like, concoct… All of the statuses?
177 00:23:51.760 ⇒ 00:23:53.619 Jasmin Multani: BASC into one cell.
178 00:23:54.590 ⇒ 00:24:01.020 Jasmin Multani: at the order level, and then I’m gonna, compare it, pull it into the Omni.
179 00:24:01.130 ⇒ 00:24:08.510 Jasmin Multani: And be like, okay, And then I’ll ask, like, Gmail AI,
180 00:24:09.270 ⇒ 00:24:18.200 Jasmin Multani: hey, there seems to be some sort of conditional formatting between these two information, between these two. Put together…
181 00:24:18.540 ⇒ 00:24:29.720 Jasmin Multani: A conditional formatting that… is… repackaging the BASC data into… the Omni data.
182 00:24:30.870 ⇒ 00:24:34.269 Amber Lin: I see. This is what I found before.
183 00:24:34.570 ⇒ 00:24:42.539 Amber Lin: This is, like, it… if… even if we look… so do you want to look at more than just the order status field?
184 00:24:44.480 ⇒ 00:24:45.250 Jasmin Multani: Yes.
185 00:24:45.590 ⇒ 00:24:54.029 Jasmin Multani: And I want it… I also want to be sure that, like, hey, when we pull from the same dates, is it the same amount as well?
186 00:24:58.860 ⇒ 00:24:59.950 Amber Lin: Cool, yeah.
187 00:25:00.960 ⇒ 00:25:01.720 Amber Lin: Shame.
188 00:25:47.280 ⇒ 00:25:51.400 Amber Lin: I’ll do this on my end, if you want to do it on yours, we can compare.
189 00:25:56.130 ⇒ 00:25:58.700 Jasmin Multani: Let me send you the worksheet I’m working out of.
190 00:26:01.920 ⇒ 00:26:03.320 Jasmin Multani: Here’s the worksheet.
191 00:26:03.440 ⇒ 00:26:08.079 Jasmin Multani: And here’s, like, the RCA notes I’m making up.
192 00:26:09.480 ⇒ 00:26:13.130 Jasmin Multani: In the Google Doc. Yeah.
193 00:26:17.880 ⇒ 00:26:20.990 Jasmin Multani: And…
194 00:26:59.560 ⇒ 00:27:02.680 Jasmin Multani: So, is Omni giving you, like, a CSV?
195 00:27:02.860 ⇒ 00:27:03.860 Jasmin Multani: Go ahead.
196 00:27:05.210 ⇒ 00:27:05.739 Amber Lin: Yeah.
197 00:27:06.960 ⇒ 00:27:08.679 Jasmin Multani: Can you send that over, please?
198 00:27:09.840 ⇒ 00:27:16.170 Amber Lin: Do you have it? I just sent it over, so there’s two… there’s two messages.
199 00:27:16.440 ⇒ 00:27:17.190 Amber Lin: the… the.
200 00:27:17.190 ⇒ 00:27:17.890 Jasmin Multani: Wow.
201 00:27:17.890 ⇒ 00:27:22.280 Amber Lin: The table is not, like, a… not a visual of the other one.
202 00:27:22.510 ⇒ 00:27:24.059 Jasmin Multani: Okay, thank you so much.
203 00:27:24.810 ⇒ 00:27:25.530 Amber Lin: Push.
204 00:27:25.890 ⇒ 00:27:32.349 Jasmin Multani: Yeah, is it okay if I do this analysis live with you?
205 00:27:32.350 ⇒ 00:27:32.929 Amber Lin: I do.
206 00:27:32.930 ⇒ 00:27:35.289 Jasmin Multani: And then you can quietly work on whatever you want.
207 00:27:35.480 ⇒ 00:27:36.690 Amber Lin: Yeah, sounds good.
208 00:27:36.690 ⇒ 00:27:37.120 Jasmin Multani: Thank you.
209 00:27:37.120 ⇒ 00:27:39.079 Amber Lin: Do you want to share screen, or…
210 00:27:39.290 ⇒ 00:27:45.490 Jasmin Multani: Second, let me just upload this.
211 00:28:11.590 ⇒ 00:28:14.749 Jasmin Multani: Hopefully, this is just gonna be a 15-minute sprint.
212 00:28:17.840 ⇒ 00:28:22.430 Jasmin Multani: So, threw in the Basque information here, let me also…
213 00:28:22.710 ⇒ 00:28:28.450 Jasmin Multani: label this, so whenever someone else wants to dip into this, they see what I’m doing.
214 00:28:28.870 ⇒ 00:28:34.610 Jasmin Multani: Insert… swimmer’s…
215 00:29:15.610 ⇒ 00:29:25.779 Jasmin Multani: what I… so, first thing I do is, like, have a… when I’m… whenever I’m doing, like, a cross-comparison, to see which data table… or the drop-off is in the data tables.
216 00:29:26.210 ⇒ 00:29:31.650 Jasmin Multani: this is what I… this is what I do. I just… run…
217 00:29:32.020 ⇒ 00:29:40.159 Jasmin Multani: things from the same date, and make sure the row-by-row level’s meant to be the same. So, order… each… each order ID should be different.
218 00:29:41.560 ⇒ 00:29:47.769 Jasmin Multani: And then… what I end up doing is just doing a quick sum at the highest level.
219 00:29:49.020 ⇒ 00:29:51.070 Jasmin Multani: Let’s see, let’s insert…
220 00:29:54.310 ⇒ 00:29:56.610 Jasmin Multani: Just a… Annapse!
221 00:29:57.290 ⇒ 00:29:58.500 Jasmin Multani: Simple counties.
222 00:30:12.230 ⇒ 00:30:21.820 Jasmin Multani: 2008… 2883. Does that map out to what you saw, or what you see in the… BASC website.
223 00:30:22.540 ⇒ 00:30:23.449 Amber Lin: Yeah.
224 00:30:25.100 ⇒ 00:30:25.969 Jasmin Multani: Okay, cool.
225 00:30:28.990 ⇒ 00:30:31.980 Jasmin Multani: Same thing here… It’s a little home.
226 00:30:35.620 ⇒ 00:30:38.980 Jasmin Multani: So let’s also count what is in here.
227 00:30:47.740 ⇒ 00:30:48.820 Jasmin Multani: Hmm…
228 00:31:01.040 ⇒ 00:31:03.090 Jasmin Multani: So, 2824.
229 00:31:04.550 ⇒ 00:31:06.080 Jasmin Multani: 2883.
230 00:31:07.600 ⇒ 00:31:10.269 Jasmin Multani: So, there is a slight deviance.
231 00:31:12.700 ⇒ 00:31:14.910 Jasmin Multani: But it’s, like, less than…
232 00:31:14.910 ⇒ 00:31:25.479 Amber Lin: Yeah, I checked the deviance for the date, like, April 11th, there were 4 orders missing. Those orders were…
233 00:31:25.570 ⇒ 00:31:43.390 Amber Lin: automatically generated refills, so my hypothesis that is the same case here. We can match by order number, like, order number is what they use, and we can search those order numbers in BASC.
234 00:31:44.120 ⇒ 00:31:44.800 Amber Lin: If we want.
235 00:31:45.210 ⇒ 00:31:52.860 Jasmin Multani: So, we’re gonna go… we’re gonna backtrack from order number, and what’s the similar… Information?
236 00:31:54.450 ⇒ 00:31:55.100 Amber Lin: Mmm…
237 00:31:55.100 ⇒ 00:31:55.980 Jasmin Multani: Which column?
238 00:31:56.830 ⇒ 00:31:58.729 Amber Lin: What do you mean?
239 00:32:00.130 ⇒ 00:32:00.890 Jasmin Multani: So…
240 00:32:02.100 ⇒ 00:32:06.380 Amber Lin: So, oh, current stat, do you mean, like, order number compared to, like…
241 00:32:06.380 ⇒ 00:32:14.350 Jasmin Multani: an order number, where… the, order number column from Omni, where does it map out to in the.
242 00:32:14.350 ⇒ 00:32:17.050 Amber Lin: That will be the order number column back.
243 00:32:20.880 ⇒ 00:32:23.099 Amber Lin: Not the second, the column B.
244 00:32:25.640 ⇒ 00:32:26.500 Jasmin Multani: Okay, thank you.
245 00:32:28.310 ⇒ 00:32:36.760 Jasmin Multani: Okay, so what I want to do is… be like, hey… This is an Omni…
246 00:32:47.810 ⇒ 00:32:50.930 Jasmin Multani: It’s like… VLOOKUP.
247 00:32:51.680 ⇒ 00:32:53.090 Jasmin Multani: search queues.
248 00:32:53.850 ⇒ 00:32:57.420 Jasmin Multani: this… Range…
249 00:33:09.430 ⇒ 00:33:12.160 Jasmin Multani: In yums is gonna be 1, 2…
250 00:33:20.840 ⇒ 00:33:24.270 Jasmin Multani: And this is the status that you’re talking about, right?
251 00:33:25.240 ⇒ 00:33:25.820 Jasmin Multani: Okay, cool.
252 00:33:36.180 ⇒ 00:33:41.670 Jasmin Multani: So, let me just, like, double check this is accurate. This should be pending.
253 00:33:42.180 ⇒ 00:33:42.970 Jasmin Multani: Cool.
254 00:33:43.810 ⇒ 00:33:47.049 Jasmin Multani: And this should be sent to a pharmacy.
255 00:33:49.570 ⇒ 00:33:50.260 Jasmin Multani: Okay.
256 00:33:52.640 ⇒ 00:33:56.620 Jasmin Multani: Let’s collapse. Let’s start collapsing things.
257 00:33:59.020 ⇒ 00:34:00.910 Jasmin Multani: hide this.
258 00:34:01.670 ⇒ 00:34:02.790 Jasmin Multani: the…
259 00:34:23.469 ⇒ 00:34:26.150 Jasmin Multani: How many statuses did we say there were? Three?
260 00:34:28.010 ⇒ 00:34:33.729 Amber Lin: 3, but let’s… we can check the different one. There’s some in the back as well, if you scroll.
261 00:34:35.550 ⇒ 00:34:37.459 Jasmin Multani: Let’s just keep all the statuses.
262 00:36:28.710 ⇒ 00:36:31.580 Jasmin Multani: I’ll let you hop in, like, 3 minutes, I can finish up.
263 00:36:32.050 ⇒ 00:36:34.699 Jasmin Multani: my initial things… when do you need this by?
264 00:36:35.470 ⇒ 00:36:39.570 Amber Lin: Oh… Like, there’s nothing we can do.
265 00:36:40.140 ⇒ 00:36:56.380 Amber Lin: Like, we can’t change what we get from BASC. They don’t specify whatever status we get, so we need to… what we need to do is tell stakeholders, hey, which one is your source of truth? You might see this in BASC, please disregard, here are the reasons why.
266 00:36:58.570 ⇒ 00:37:06.040 Jasmin Multani: So, I’m gonna search for… the exact… data columns.
267 00:37:06.870 ⇒ 00:37:07.630 Amber Lin: Yeah…
268 00:37:08.390 ⇒ 00:37:19.810 Jasmin Multani: I think that’ll be for them to know, and it’s also gonna bowtie our hypothesis. But I feel like your initial, hypothesis was good. We just need to, like.
269 00:37:20.540 ⇒ 00:37:24.690 Jasmin Multani: Point to it and size it out, so they have, like, a numerical answer.
270 00:37:24.890 ⇒ 00:37:27.040 Jasmin Multani: But I also want to call out
271 00:37:27.480 ⇒ 00:37:32.770 Jasmin Multani: You said that there were 4… Four orders missing.
272 00:37:33.580 ⇒ 00:37:39.160 Jasmin Multani: but in Omni, but calling out that this is 2824,
273 00:37:40.660 ⇒ 00:37:46.090 Jasmin Multani: And over here, it was like… 2883.
274 00:37:46.340 ⇒ 00:37:54.180 Amber Lin: Yeah, let me… as you do this, let me go search up… Orders from your…
275 00:37:54.660 ⇒ 00:38:02.409 Amber Lin: Spreadsheet, and then… I can confirm in BAS that that’s the case for everything.
276 00:38:02.800 ⇒ 00:38:05.440 Jasmin Multani: Okay, yeah. You could just be, like, count if.
277 00:38:05.920 ⇒ 00:38:13.239 Jasmin Multani: Is this… which ones are found in, the other? Where is it overlapping? Where is it not overlapping? Just keep it simple.
278 00:38:14.500 ⇒ 00:38:21.600 Jasmin Multani: And then we can be, like, we can start hunting, like, why is there a 60 order difference?
279 00:38:22.820 ⇒ 00:38:26.810 Jasmin Multani: Yeah.
280 00:38:27.890 ⇒ 00:38:28.869 Jasmin Multani: Do y’all sound good?
281 00:38:29.950 ⇒ 00:38:34.749 Amber Lin: Cool, yeah, I can look into the 60 order difference.
282 00:38:36.060 ⇒ 00:38:44.319 Jasmin Multani: Until then, I’ll, like, isolate which columns are the problem, and then, hopefully by 4, I give you a pulse check.
283 00:38:45.250 ⇒ 00:38:46.429 Jasmin Multani: Of what to send them.
284 00:38:46.850 ⇒ 00:38:54.240 Amber Lin: Yeah, I… I’m checking… I ran Kirscher on just orders for the 11th.
285 00:38:57.670 ⇒ 00:39:06.680 Amber Lin: It feels like it’s the case, but I’m… I’m just now reading, like, the specifics, each column, how they match up. It’s essentially what you’re doing, but just…
286 00:39:07.710 ⇒ 00:39:09.919 Amber Lin: Just for that date.
287 00:39:12.830 ⇒ 00:39:14.120 Amber Lin: Mmm…
288 00:39:14.280 ⇒ 00:39:29.340 Amber Lin: Also, sometimes it’ll say sent to pharmacy, sometimes it’ll just say sent in order status, it’ll say sent to pharmacy in pharmacy status, so it’s an approximate name match. The case
289 00:39:29.710 ⇒ 00:39:32.550 Amber Lin: Might not perfectly match up.
290 00:39:34.000 ⇒ 00:39:38.979 Jasmin Multani: As long as we can find a pattern that we can… Numerically 0.2.
291 00:39:38.980 ⇒ 00:39:39.800 Amber Lin: Yeah.
292 00:39:46.950 ⇒ 00:39:49.879 Jasmin Multani: But the idea is that they want to migrate to Eden OS, right?
293 00:39:50.360 ⇒ 00:39:51.200 Amber Lin: Yeah.
294 00:39:51.510 ⇒ 00:39:53.350 Amber Lin: So hopefully that’ll be better.
295 00:40:08.420 ⇒ 00:40:13.080 Jasmin Multani: I’ll let you go, so you can work on it on your own pace, but I’ll touch back again at 4.
296 00:40:13.080 ⇒ 00:40:13.780 Amber Lin: Okay.
297 00:40:13.780 ⇒ 00:40:26.120 Jasmin Multani: And, with your dashboard that you pushed through, I told Robert, hey, I need an answer, and if he doesn’t give me an answer by 10 PM PST, I’m just gonna push forward.
298 00:40:26.380 ⇒ 00:40:32.740 Amber Lin: Okay. I really don’t think there’s anything, like, blocking us, but it’ll be nice to get his eyes.
299 00:40:32.740 ⇒ 00:40:36.369 Jasmin Multani: just so he knows what’s happening. Oh, I see you replied.
300 00:40:36.680 ⇒ 00:40:39.490 Jasmin Multani: Okay, he’s reviewing now as of 4 minutes ago.
301 00:40:39.790 ⇒ 00:40:41.219 Amber Lin: Cool. Sounds good.
302 00:40:41.960 ⇒ 00:40:43.270 Jasmin Multani: Alright, thank you so much for everything.
303 00:40:44.220 ⇒ 00:40:46.899 Amber Lin: Yeah, talk to you in stock. Bye-bye.