Meeting Title: Eden Health Dashboard QA Sync Date: 2026-04-15 Meeting participants: Jasmin Multani, Amber Lin
WEBVTT
1 00:01:07.090 ⇒ 00:01:08.250 Amber Lin: Hello!
2 00:01:08.650 ⇒ 00:01:10.160 Jasmin Multani: Hey, how’s it going?
3 00:01:10.730 ⇒ 00:01:13.990 Amber Lin: Pretty good. Just had a client call.
4 00:01:14.670 ⇒ 00:01:20.620 Amber Lin: Let’s see… Oh, first, let me show you how to look at historicals.
5 00:01:20.890 ⇒ 00:01:22.640 Amber Lin: Before I forget.
6 00:01:23.000 ⇒ 00:01:26.279 Amber Lin: So… Can you see my screen?
7 00:01:26.570 ⇒ 00:01:27.150 Jasmin Multani: Oop.
8 00:01:27.350 ⇒ 00:01:29.850 Amber Lin: Cool. So let’s go…
9 00:01:33.360 ⇒ 00:01:38.059 Amber Lin: Anyways, let’s go… so if you go into edit of a dashboard.
10 00:01:38.260 ⇒ 00:01:40.999 Jasmin Multani: Yeah, and I’ll follow all the mice away, too.
11 00:01:41.000 ⇒ 00:01:45.050 Amber Lin: You’ll see this… View workbook changes.
12 00:01:45.990 ⇒ 00:01:47.380 Amber Lin: You’ll see this.
13 00:01:47.900 ⇒ 00:01:51.079 Amber Lin: So you can… I think you can go back.
14 00:01:52.010 ⇒ 00:01:54.090 Jasmin Multani: Wait, can you go back again? Sorry, whoop.
15 00:01:54.690 ⇒ 00:01:57.209 Amber Lin: This is just a tab, so if you…
16 00:01:57.940 ⇒ 00:02:02.100 Amber Lin: Can you share your screen so I can walk you through on your side?
17 00:02:02.100 ⇒ 00:02:04.210 Jasmin Multani: Yeah, good idea.
18 00:02:13.480 ⇒ 00:02:14.950 Jasmin Multani: Trying to find that tab.
19 00:02:17.010 ⇒ 00:02:18.890 Amber Lin: So, go into Workbook.
20 00:02:24.070 ⇒ 00:02:27.589 Amber Lin: And then you’ll see… On the left.
21 00:02:38.190 ⇒ 00:02:42.989 Amber Lin: I think this is the draft modification… oh, sorry, go… go on top.
22 00:02:43.750 ⇒ 00:02:45.289 Amber Lin: Right here.
23 00:02:46.520 ⇒ 00:02:47.850 Jasmin Multani: And…
24 00:02:52.840 ⇒ 00:02:53.730 Amber Lin: Oh.
25 00:02:54.670 ⇒ 00:02:55.650 Amber Lin: Hmm.
26 00:02:58.400 ⇒ 00:03:00.910 Jasmin Multani: We’re logged in the same thing, right? Eden Health?
27 00:03:03.190 ⇒ 00:03:05.830 Amber Lin: Yeah, I see the same things as you, one sec.
28 00:03:10.980 ⇒ 00:03:13.239 Amber Lin: Let me say leave draft.
29 00:03:15.430 ⇒ 00:03:16.330 Amber Lin: Oh.
30 00:03:18.310 ⇒ 00:03:21.099 Amber Lin: Click Leave Draft on the upper right.
31 00:03:25.230 ⇒ 00:03:30.000 Amber Lin: And You’ll see the version history, because if we’re in the draft.
32 00:03:30.120 ⇒ 00:03:32.689 Amber Lin: You only see what’s inside the draft.
33 00:03:32.880 ⇒ 00:03:40.400 Amber Lin: But here, now, you can… you can revert things back to the previous version. If you scroll down, like, there’s a…
34 00:03:42.060 ⇒ 00:03:44.750 Amber Lin: Different version, different updates made.
35 00:03:45.270 ⇒ 00:03:48.840 Jasmin Multani: Yeah, I just want to look at the product snapshot and see…
36 00:03:50.690 ⇒ 00:03:53.240 Jasmin Multani: Or how the pending orders changed?
37 00:03:55.260 ⇒ 00:03:56.920 Jasmin Multani: Yeah. So.
38 00:03:56.920 ⇒ 00:04:04.610 Amber Lin: Let me pull up… Yeah.
39 00:04:04.990 ⇒ 00:04:10.739 Amber Lin: I’m gonna look at… Go look at what it is for just, like, just a bask.
40 00:04:11.660 ⇒ 00:04:13.700 Amber Lin: table,
41 00:04:17.610 ⇒ 00:04:18.680 Amber Lin: Okay.
42 00:04:18.940 ⇒ 00:04:25.630 Amber Lin: So, Basque’s table shows… That’s so weird. Let me order this.
43 00:04:27.890 ⇒ 00:04:29.390 Jasmin Multani: Can you share a screen, please?
44 00:04:29.390 ⇒ 00:04:30.140 Amber Lin: Yeah.
45 00:04:38.780 ⇒ 00:04:42.289 Amber Lin: So I’m here. This is the old one.
46 00:04:42.540 ⇒ 00:04:44.380 Amber Lin: It’s kind of in the back.
47 00:04:44.670 ⇒ 00:04:54.230 Amber Lin: I think when we generated this, it was kind of messy, so, like, once we make sure we revert over, I’m gonna rename or delete these tabs, just so, like…
48 00:04:54.680 ⇒ 00:05:05.800 Amber Lin: unorganized. Anyways… So, I’m gonna go… And… Oh.
49 00:05:07.890 ⇒ 00:05:17.610 Amber Lin: I just wanna check if BASC is the issue, so I’m just gonna… short descending… Alright.
50 00:05:18.380 ⇒ 00:05:23.040 Amber Lin: Well, seems like… Pending customers really low.
51 00:05:24.190 ⇒ 00:05:26.650 Amber Lin: Injectable semi is, like, 2.
52 00:05:29.160 ⇒ 00:05:32.090 Amber Lin: Polar revenue, new order revenue.
53 00:05:32.220 ⇒ 00:05:37.659 Amber Lin: Okay, let’s remember these numbers, and I’m gonna go compare.
54 00:05:38.210 ⇒ 00:05:53.920 Amber Lin: what it looks like right now. So, 125-19592… 1, 2, 5, 19, 592… Okay.
55 00:05:53.920 ⇒ 00:05:57.190 Jasmin Multani: Pending orders is 277. Do we see pending customers?
56 00:05:59.130 ⇒ 00:06:03.500 Amber Lin: One sec… Thank you, kind of question.
57 00:06:03.500 ⇒ 00:06:04.210 Jasmin Multani: Orders.
58 00:06:04.210 ⇒ 00:06:10.839 Amber Lin: I think new customers… Yesterday, this was 85, what is this?
59 00:06:12.670 ⇒ 00:06:13.880 Amber Lin: 83.
60 00:06:14.360 ⇒ 00:06:19.590 Amber Lin: Total orders is, like, one more. There’s 2 more.
61 00:06:20.890 ⇒ 00:06:22.810 Jasmin Multani: Do you want to just, like, drag them?
62 00:06:23.120 ⇒ 00:06:34.079 Amber Lin: This is pending customers, minus pending orders. Is that what’s different? It shouldn’t be, because the customer should have placed, like, 80-something orders. That should have just… it shouldn’t be the issue.
63 00:06:43.990 ⇒ 00:06:57.429 Amber Lin: Yeah, that is… that is weird. Let’s go look at… Pending orders… Where is it?
64 00:07:04.700 ⇒ 00:07:06.210 Amber Lin: Okay.
65 00:07:07.090 ⇒ 00:07:12.180 Amber Lin: Let’s see… What we did there…
66 00:07:12.600 ⇒ 00:07:15.260 Amber Lin: I think it’s a filter issue.
67 00:07:19.830 ⇒ 00:07:20.780 Amber Lin: What?
68 00:07:20.930 ⇒ 00:07:22.260 Amber Lin: This is weird.
69 00:07:22.500 ⇒ 00:07:27.169 Amber Lin: is… I think it’s the filter. Let me check. I hope it is the filter.
70 00:07:27.280 ⇒ 00:07:31.540 Amber Lin: In the one. Past one complete day.
71 00:07:33.750 ⇒ 00:07:35.089 Amber Lin: is pending.
72 00:07:39.180 ⇒ 00:07:41.190 Amber Lin: Okay, please work.
73 00:07:42.480 ⇒ 00:07:44.430 Amber Lin: Nope. Okay.
74 00:07:44.660 ⇒ 00:07:49.450 Amber Lin: We can check pending customers.
75 00:08:00.500 ⇒ 00:08:02.089 Jasmin Multani: Where are the columns different?
76 00:08:03.490 ⇒ 00:08:04.170 Amber Lin: Huh?
77 00:08:05.710 ⇒ 00:08:12.150 Amber Lin: Because it’s… like, these are generated, and I also created mine.
78 00:08:12.590 ⇒ 00:08:16.730 Amber Lin: Let’s see, pending customers…
79 00:08:29.670 ⇒ 00:08:30.660 Amber Lin: What?
80 00:08:34.270 ⇒ 00:08:35.650 Amber Lin: Order date.
81 00:08:36.200 ⇒ 00:08:39.690 Amber Lin: And… What?
82 00:08:40.000 ⇒ 00:08:42.360 Amber Lin: This is abandoned orders.
83 00:08:43.309 ⇒ 00:08:45.820 Amber Lin: Early Oh, God.
84 00:08:49.810 ⇒ 00:08:51.049 Jasmin Multani: Where should it be?
85 00:08:52.800 ⇒ 00:08:59.029 Amber Lin: We were looking at pending. I think the person who created this, and my fault for not checking.
86 00:08:59.210 ⇒ 00:09:02.740 Amber Lin: used to abandoned… filter.
87 00:09:03.700 ⇒ 00:09:04.690 Amber Lin: Bone.
88 00:09:05.720 ⇒ 00:09:06.740 Amber Lin: Okay.
89 00:09:06.890 ⇒ 00:09:09.329 Amber Lin: Let’s… let’s… I’m gonna do this.
90 00:09:09.330 ⇒ 00:09:11.730 Jasmin Multani: I don’t fully understand how that happened.
91 00:09:12.050 ⇒ 00:09:19.560 Amber Lin: Because they generated the charts and never QA’d it, and I never went into the definitions and checked.
92 00:09:19.710 ⇒ 00:09:21.930 Jasmin Multani: So who, who was that person?
93 00:09:21.930 ⇒ 00:09:25.840 Amber Lin: Mustafa did the… chart generation.
94 00:09:26.730 ⇒ 00:09:36.090 Amber Lin: So anyways, it’s not his fault. Let’s go, because he, like, he didn’t work on Eden. He’s an AI engineer, and he just helped, like, been on me before.
95 00:09:36.090 ⇒ 00:09:36.590 Jasmin Multani: Yeah.
96 00:09:36.590 ⇒ 00:09:44.739 Amber Lin: But there was no, like, when we did the Omni migration, there was no QA. It was just like, hey, we have this now, and it was done.
97 00:09:45.680 ⇒ 00:09:51.389 Amber Lin: I’m doing this in Explorer, so it doesn’t affect the…
98 00:09:52.180 ⇒ 00:10:05.260 Amber Lin: my previous ones, but I’m going to go… Here, I’ll try to recreate… what they had… So…
99 00:10:05.630 ⇒ 00:10:11.170 Jasmin Multani: So how are you referring… what’s your source of truth to being like, hey, how are you…
100 00:10:11.600 ⇒ 00:10:13.120 Jasmin Multani: Recreating what they had.
101 00:10:15.820 ⇒ 00:10:33.410 Amber Lin: For them. We had Tableau before, so what Mustafa did is just trying to replicate what the Tableau reports had, so he just needed to… like, the queries weren’t always the same, but they were similar enough.
102 00:10:36.100 ⇒ 00:10:42.760 Amber Lin: And did… So they did…
103 00:10:49.810 ⇒ 00:10:59.670 Amber Lin: Use our first wardrobe counter… They also did… Status is…
104 00:11:14.840 ⇒ 00:11:15.570 Amber Lin: Hmm.
105 00:11:19.440 ⇒ 00:11:21.360 Amber Lin: Oh, and filter.
106 00:11:48.900 ⇒ 00:11:51.830 Amber Lin: Okay, yeah, that’s the reason why.
107 00:11:53.530 ⇒ 00:11:55.500 Jasmin Multani: Can you state it?
108 00:11:55.500 ⇒ 00:11:59.160 Amber Lin: Now the number matches. Let me move this right here, so…
109 00:11:59.780 ⇒ 00:12:07.600 Amber Lin: This is not, this is not actually pending orders, this is, like, customer…
110 00:12:10.300 ⇒ 00:12:17.760 Amber Lin: customer count for yesterday that is abandoned. Like, the previous one is just not accurate.
111 00:12:19.440 ⇒ 00:12:21.510 Jasmin Multani: I think we’re gonna have to go column by column.
112 00:12:22.480 ⇒ 00:12:24.200 Jasmin Multani: And checking things are correct.
113 00:12:24.200 ⇒ 00:12:28.220 Amber Lin: Yeah, yeah, we’ll have to check this and check the previous report.
114 00:12:28.850 ⇒ 00:12:36.120 Amber Lin: Overall, I think the other one should be fine, but we’ll… I’ll check, we can check the columns one by one, but…
115 00:12:36.120 ⇒ 00:12:37.990 Jasmin Multani: I think we should document those, too.
116 00:12:38.000 ⇒ 00:12:38.830 Amber Lin: Beautiful.
117 00:12:38.830 ⇒ 00:12:42.079 Jasmin Multani: Open up a spreadsheet, being like, hey, this is the previous.
118 00:12:43.510 ⇒ 00:12:52.119 Jasmin Multani: literally, if we have to take screenshots, I think we have to do that, but I think at this point, we have to prove that we’ve checked column by column.
119 00:12:55.710 ⇒ 00:13:02.550 Amber Lin: Yeah, let me… Wait, starting with me…
120 00:13:06.790 ⇒ 00:13:10.520 Amber Lin: Let me create… Like, a pending…
121 00:13:13.660 ⇒ 00:13:15.680 Amber Lin: Just to check this number.
122 00:13:43.070 ⇒ 00:13:43.890 Amber Lin: So…
123 00:13:48.620 ⇒ 00:13:54.080 Amber Lin: This is… Customers yesterday who are still pending.
124 00:13:54.620 ⇒ 00:13:57.110 Amber Lin: This is abandoned.
125 00:13:57.620 ⇒ 00:14:08.299 Amber Lin: And… I think that makes sense, because they need to take action on the orders from yesterday.
126 00:14:08.790 ⇒ 00:14:10.140 Amber Lin: For it, too.
127 00:14:11.100 ⇒ 00:14:12.980 Amber Lin: Go out of pending.
128 00:14:13.840 ⇒ 00:14:14.535 Jasmin Multani: Mmm…
129 00:14:16.800 ⇒ 00:14:18.680 Amber Lin: These are new customers.
130 00:14:20.480 ⇒ 00:14:31.390 Jasmin Multani: New customers yesterday was 85, but then… Or… the one… Let’s just… okay, let’s see.
131 00:14:32.160 ⇒ 00:14:34.280 Amber Lin: I think this would make more sense.
132 00:14:34.460 ⇒ 00:14:35.929 Amber Lin: New customers.
133 00:14:37.290 ⇒ 00:14:44.180 Jasmin Multani: Can you, which one’s the… can you clean up the tabs and say, like, which one is archived and which one is live?
134 00:14:44.470 ⇒ 00:14:46.080 Amber Lin: Yeah, we can do that.
135 00:14:46.230 ⇒ 00:14:55.640 Jasmin Multani: Let’s do that first, and then, I really would like… I’ll help out too, but I want to go, like, column by column and sanity check.
136 00:14:55.740 ⇒ 00:15:00.209 Jasmin Multani: But first things first, can we write this as, like, this is the live tab, and then…
137 00:15:00.460 ⇒ 00:15:02.190 Jasmin Multani: The previous one is…
138 00:15:02.190 ⇒ 00:15:09.250 Amber Lin: If you want to read the sequel as I do that, you can just… you can read it here, it might be faster.
139 00:15:11.130 ⇒ 00:15:19.679 Jasmin Multani: Yeah, I think the first thing I want to do is, like, make sure the numbers match column by column, and if there’s a discrepancy, then I’ll dig into.
140 00:15:20.200 ⇒ 00:15:30.240 Amber Lin: What do you mean, match column by column? They’re not going to match, because this also has, mask. This also has Health OS data.
141 00:15:30.240 ⇒ 00:15:35.860 Jasmin Multani: But it should still be directional too, right? Like, in terms of ranking, is the first
142 00:15:36.720 ⇒ 00:15:40.859 Jasmin Multani: Product, still the first product, that has the highest revenue.
143 00:15:42.240 ⇒ 00:15:49.110 Jasmin Multani: So stuff like that, like, we just need to look directionally if it’s accurate, like… pending orders.
144 00:15:49.670 ⇒ 00:15:54.789 Jasmin Multani: On the published dashboard this morning was 5, like, in the hundreds.
145 00:15:54.910 ⇒ 00:15:59.449 Jasmin Multani: Whereas, when we cleaned it up again, it wasn’t, like, a single-digit number, right?
146 00:16:02.430 ⇒ 00:16:07.910 Amber Lin: That’s not pending orders. They named it wrong in the previous table.
147 00:16:08.430 ⇒ 00:16:11.980 Jasmin Multani: Hmm… okay, so it has to stay abandoned?
148 00:16:14.190 ⇒ 00:16:22.070 Amber Lin: When you say stay abandoned, do you mean our naming of the column, or, like, just you’re talking about the order status?
149 00:16:23.540 ⇒ 00:16:27.609 Jasmin Multani: Do you see where it says, in the sequel, equals abandoned?
150 00:16:31.610 ⇒ 00:16:35.759 Amber Lin: I’m gonna clean up the tabs in the back. Do you want to share a screen so I can…
151 00:16:35.890 ⇒ 00:16:37.690 Amber Lin: Know what you’re talking about?
152 00:16:40.170 ⇒ 00:16:44.380 Jasmin Multani: Let’s see,
153 00:17:10.960 ⇒ 00:17:15.359 Jasmin Multani: So he said that pending orders yesterday was 277.
154 00:17:16.660 ⇒ 00:17:22.859 Amber Lin: Yes, because the naming wasn’t… I think pending orders are still the same.
155 00:17:23.010 ⇒ 00:17:26.690 Amber Lin: Like, pending orders is not pending, like, customers.
156 00:17:27.170 ⇒ 00:17:29.670 Amber Lin: What he’s used to seeing is…
157 00:17:30.260 ⇒ 00:17:38.260 Amber Lin: pending customers, which we also named it wrong, it was actually abandoned. Customers, new customers, still in abandoned status.
158 00:17:40.690 ⇒ 00:17:44.639 Jasmin Multani: So, what has to happen? The naming convention has to change, or the.
159 00:17:44.640 ⇒ 00:17:53.830 Amber Lin: Yeah, we need to change, one, we need to change the name to reflect accurately. Two, we need to confirm with the client, hey, do you want to see
160 00:17:53.940 ⇒ 00:17:59.089 Amber Lin: Pending or abandoned orders, or pending or abandoned new customers.
161 00:18:03.610 ⇒ 00:18:04.320 Jasmin Multani: Okay.
162 00:18:05.650 ⇒ 00:18:09.800 Jasmin Multani: Is this the… do you think this is the only con that has this issue?
163 00:18:10.250 ⇒ 00:18:14.660 Amber Lin: We’re checking the other columns.
164 00:18:14.840 ⇒ 00:18:16.090 Amber Lin: Next, right?
165 00:18:17.640 ⇒ 00:18:20.999 Amber Lin: That will let us know. I’m just changing the…
166 00:18:27.840 ⇒ 00:18:30.310 Jasmin Multani: Can we download this into a CSV?
167 00:18:31.340 ⇒ 00:18:32.869 Amber Lin: Yeah, you can.
168 00:18:32.870 ⇒ 00:18:33.810 Jasmin Multani: Download.
169 00:19:31.670 ⇒ 00:19:34.460 Jasmin Multani: And this should be searched…
170 00:19:44.090 ⇒ 00:19:44.770 Jasmin Multani: 8.
171 00:20:08.350 ⇒ 00:20:09.950 Jasmin Multani: It’s the newest version.
172 00:20:11.170 ⇒ 00:20:15.819 Jasmin Multani: U.S. So this is gonna be BAS plus Eden OS.
173 00:20:41.490 ⇒ 00:20:42.820 Jasmin Multani: There’s that.
174 00:21:06.960 ⇒ 00:21:09.820 Jasmin Multani: And then the previous one was just Basque?
175 00:21:12.240 ⇒ 00:21:12.870 Amber Lin: Huh?
176 00:21:14.020 ⇒ 00:21:14.850 Amber Lin: Yeah.
177 00:21:26.900 ⇒ 00:21:32.840 Jasmin Multani: Mmm… How would I… okay, so how can I download that data?
178 00:21:34.800 ⇒ 00:21:41.070 Amber Lin: You would click… Do you want this table that you’re seeing right now?
179 00:21:41.070 ⇒ 00:21:43.230 Jasmin Multani: Just the product revenue snapshot.
180 00:21:43.230 ⇒ 00:21:48.720 Amber Lin: I would go on… go click the three dots on the right-hand side and click download.
181 00:21:50.800 ⇒ 00:21:52.449 Jasmin Multani: Is this the newest version?
182 00:21:54.490 ⇒ 00:21:57.210 Jasmin Multani: Old version.
183 00:21:57.210 ⇒ 00:22:00.480 Amber Lin: If you want the old version, you’ll have to go into Workbooks.
184 00:22:00.590 ⇒ 00:22:05.600 Amber Lin: And go to that specific tab, and then go download it.
185 00:22:06.530 ⇒ 00:22:10.309 Amber Lin: So that would now… it’s called BASC.
186 00:22:11.130 ⇒ 00:22:12.650 Amber Lin: Let me move this.
187 00:22:16.020 ⇒ 00:22:20.960 Amber Lin: Bask Product Revenue Snapshot, and then you would download that table.
188 00:22:22.010 ⇒ 00:22:25.729 Jasmin Multani: So, it’s gonna be…
189 00:22:28.700 ⇒ 00:22:34.819 Amber Lin: Oh, one sec, can I publish this change so you get the updated column names, the tab names?
190 00:22:38.740 ⇒ 00:22:43.290 Amber Lin: Cool. Refresh now, it should be… Should be updated.
191 00:22:54.480 ⇒ 00:22:56.030 Jasmin Multani: I’m gonna share again.
192 00:22:58.100 ⇒ 00:23:01.309 Jasmin Multani: Okay, so you’re telling me to look through the tabs?
193 00:23:01.650 ⇒ 00:23:02.870 Jasmin Multani: Down here.
194 00:23:03.310 ⇒ 00:23:08.490 Amber Lin: Yes, it will be in BAS Product Revenue Snapshot.
195 00:23:09.310 ⇒ 00:23:10.470 Jasmin Multani: Gas…
196 00:23:14.170 ⇒ 00:23:19.510 Jasmin Multani: Okay, so here, and then I want to get to results, and these results are…
197 00:23:19.650 ⇒ 00:23:22.280 Jasmin Multani: Gonna be fresh, right, today?
198 00:23:22.460 ⇒ 00:23:27.660 Amber Lin: Yeah, and then you can download it, fear.
199 00:23:34.180 ⇒ 00:23:35.270 Jasmin Multani: Download…
200 00:23:38.600 ⇒ 00:23:39.610 Jasmin Multani: Okay.
201 00:23:41.690 ⇒ 00:23:44.680 Jasmin Multani: What’s your bandwidth look like for the rest of the day?
202 00:23:44.680 ⇒ 00:23:51.270 Amber Lin: I have time for this. I just want to respond to Robert first, of what I’ve… what we found.
203 00:23:54.110 ⇒ 00:23:57.819 Jasmin Multani: And, like, also respond, like, how we’re gonna…
204 00:23:58.080 ⇒ 00:23:59.979 Jasmin Multani: Make sure to catch this again.
205 00:24:01.750 ⇒ 00:24:03.240 Jasmin Multani: So it doesn’t happen again.
206 00:24:03.690 ⇒ 00:24:08.389 Jasmin Multani: And it’s basically, like, we’re gonna go through this type of QAing sprint, in the future.
207 00:32:27.790 ⇒ 00:32:29.819 Jasmin Multani: Were you able to type that up for him?
208 00:32:30.450 ⇒ 00:32:39.579 Amber Lin: I haven’t sent him how we plan to do the QA, because I am also not 100% sure, so I would like your help there.
209 00:32:39.990 ⇒ 00:32:40.570 Jasmin Multani: Okay.
210 00:32:43.170 ⇒ 00:32:46.399 Jasmin Multani: Let me read this message. So you…
211 00:32:46.520 ⇒ 00:32:48.339 Jasmin Multani: New table pending, I think this…
212 00:32:48.570 ⇒ 00:32:56.740 Jasmin Multani: It is normal for orders to be in pending for a bid. They usually get So…
213 00:32:58.040 ⇒ 00:33:02.670 Jasmin Multani: This findings is good context, but it doesn’t,
214 00:33:02.990 ⇒ 00:33:07.660 Jasmin Multani: give an action item. It doesn’t let Robert know what he should do.
215 00:33:08.330 ⇒ 00:33:14.510 Jasmin Multani: So, what would you… what would… whether he should be doing something, or if we’re gonna be doing something?
216 00:33:15.050 ⇒ 00:33:18.689 Amber Lin: Oh, I thought that was what we’re gonna write right now.
217 00:33:19.080 ⇒ 00:33:23.149 Jasmin Multani: Okay, let’s do it together.
218 00:33:23.280 ⇒ 00:33:34.270 Jasmin Multani: Wow… Items… So let’s do the problem statement again.
219 00:33:35.530 ⇒ 00:33:40.440 Jasmin Multani: Problem statement… is…
220 00:33:44.970 ⇒ 00:33:49.329 Jasmin Multani: the old… okay, so the old SQL is using abandoned instead of pending.
221 00:33:49.870 ⇒ 00:34:04.989 Jasmin Multani: So… Newest dashboard shows that, a higher amount of pending orders than what was previously shown.
222 00:34:06.300 ⇒ 00:34:08.409 Jasmin Multani: So, why did this happen?
223 00:34:09.679 ⇒ 00:34:10.810 Jasmin Multani: pop in.
224 00:34:20.440 ⇒ 00:34:26.350 Jasmin Multani: And then… What should, what is expected?
225 00:34:26.480 ⇒ 00:34:30.540 Jasmin Multani: So… Which data is expected?
226 00:34:35.110 ⇒ 00:34:39.669 Jasmin Multani: So I’m asking you that. Is the old data expected, or is the new data expected?
227 00:34:43.709 ⇒ 00:34:56.759 Amber Lin: the data is not wrong. I think what we’re asking is, what do they want? Like, do they want to see customers? Do they want to see orders? Do they want to see pending? Do they want to see abandoned? I don’t know.
228 00:34:56.779 ⇒ 00:35:06.979 Amber Lin: I didn’t create… they didn’t… like, I wasn’t the person that created the dashboard requirements, so I think we need to ask them the question of… or Robert, the question of…
229 00:35:07.269 ⇒ 00:35:14.139 Amber Lin: Do we want… want pending customers? Or… pending orders.
230 00:35:16.880 ⇒ 00:35:18.880 Jasmin Multani: So the information isn’t…
231 00:35:23.300 ⇒ 00:35:30.740 Jasmin Multani: But why… why is it showing, like, 200? Wait, sorry, I don’t think I fully understand what’s happening.
232 00:35:31.510 ⇒ 00:35:39.160 Jasmin Multani: Yes, we can go here. So the new orders, pending orders is… 277.
233 00:35:40.440 ⇒ 00:35:47.769 Jasmin Multani: Is that ac… and that’s… we should expect that, it’s like… Pending means it’s abandoned, or…
234 00:35:48.590 ⇒ 00:35:57.709 Amber Lin: Abandoned is its own status. Pending just means that it hasn’t been sent to the pharmacy yet.
235 00:35:57.890 ⇒ 00:36:00.070 Jasmin Multani: But it has been requested.
236 00:36:00.560 ⇒ 00:36:13.119 Amber Lin: Yes. We can confirm with, say, a way for demlade on what BASC uses as pending’s definition. This is the definition that we get.
237 00:36:13.560 ⇒ 00:36:14.600 Amber Lin: From last.
238 00:36:14.900 ⇒ 00:36:16.959 Amber Lin: I mean, this is the field they gave us.
239 00:36:17.460 ⇒ 00:36:20.969 Jasmin Multani: And then over here, pending customers was abandoned.
240 00:36:22.970 ⇒ 00:36:26.919 Amber Lin: Yes, previously, this actually is abandoned customers.
241 00:36:27.500 ⇒ 00:36:31.740 Jasmin Multani: Okay. And so…
242 00:36:31.740 ⇒ 00:36:45.099 Amber Lin: Abandoned is, like, their default status. So, like, this just means that nothing has been done on those orders. Like, maybe… I think payment hasn’t gone through. If it’s still in abandoned, I’m not 100% sure.
243 00:36:45.750 ⇒ 00:36:49.909 Jasmin Multani: Let’s double check if this is, and this is not…
244 00:36:50.180 ⇒ 00:36:54.059 Jasmin Multani: I want to see if the backend sequel says abandoned or pending.
245 00:36:54.190 ⇒ 00:36:55.700 Jasmin Multani: Just a sanity check.
246 00:37:20.720 ⇒ 00:37:26.099 Jasmin Multani: Okay, so we want to track…
247 00:37:26.960 ⇒ 00:37:30.969 Jasmin Multani: Whether this says pending or abandoned, just to, like, be paranoid.
248 00:37:31.220 ⇒ 00:37:34.810 Jasmin Multani: So, I’m gonna go into this in SQL.
249 00:37:42.940 ⇒ 00:37:47.900 Jasmin Multani: And this was… which one? Which number? So it’s…
250 00:37:47.900 ⇒ 00:37:54.690 Amber Lin: You can go on the left, so if you scroll on the left, right here…
251 00:37:55.230 ⇒ 00:38:01.430 Amber Lin: Scroll here, and then go to that one, click that one, click on the dots here.
252 00:38:04.330 ⇒ 00:38:04.860 Jasmin Multani: Here.
253 00:38:05.290 ⇒ 00:38:06.720 Amber Lin: You can go edit.
254 00:38:14.660 ⇒ 00:38:15.850 Jasmin Multani: Okay, cool.
255 00:38:16.270 ⇒ 00:38:22.090 Jasmin Multani: So the current one does not have… Bose filtering.
256 00:38:22.090 ⇒ 00:38:25.580 Amber Lin: So you can see that in the filter, it says it’s pending.
257 00:38:29.260 ⇒ 00:38:30.949 Amber Lin: So, right… right here.
258 00:38:33.670 ⇒ 00:38:35.379 Jasmin Multani: If I wanted to select more…
259 00:38:36.210 ⇒ 00:38:38.730 Jasmin Multani: This week, let’s send him this screenshot.
260 00:38:41.740 ⇒ 00:38:47.010 Jasmin Multani: So we’re saying the dashboard that we have today is a better representation.
261 00:38:47.010 ⇒ 00:38:50.629 Amber Lin: It’s an accurate definition. The previous one’s wrong.
262 00:38:51.370 ⇒ 00:38:52.860 Jasmin Multani: Perfect, that’s what we want.
263 00:38:53.890 ⇒ 00:38:55.140 Jasmin Multani: Sorry, Mustafo.
264 00:38:59.760 ⇒ 00:39:11.149 Jasmin Multani: I think what we’ll say is that, like, in our previous run, in our previous Omni dashboarding run, we wanted… the goal was to mirror the metrics to what was seen in the tableau.
265 00:39:11.640 ⇒ 00:39:12.969 Jasmin Multani: Line by line.
266 00:39:13.320 ⇒ 00:39:17.829 Jasmin Multani: Over here in our most recent, run, we are trying to match
267 00:39:18.050 ⇒ 00:39:26.349 Jasmin Multani: like, update the columns to fit the needs of the use cases. That’s why we changed the definitions and the backend SQL.
268 00:39:29.650 ⇒ 00:39:45.519 Amber Lin: Do you think that’s the case? I mean, the only thing we found is that we were wrong in our first creation. Like, we’re not necessarily changing what they want to see. They still want to see the same thing. It just, we found an error, and then we corrected it.
269 00:39:45.610 ⇒ 00:39:50.530 Amber Lin: Like, ultimately, we’re still replicating what they saw before, right?
270 00:39:52.230 ⇒ 00:39:57.649 Jasmin Multani: I guess that’s a Greg question. Like, he was in charge of QAing
271 00:39:57.940 ⇒ 00:40:05.039 Jasmin Multani: whether those initial Omni dashboards were reflective of Tableau, Like, and what that meant.
272 00:40:06.060 ⇒ 00:40:10.709 Jasmin Multani: did that mean they did… went, like, went through a line-by-line analysis, or…
273 00:40:10.710 ⇒ 00:40:13.340 Amber Lin: they did not do a QA.
274 00:40:13.510 ⇒ 00:40:14.040 Jasmin Multani: Okay.
275 00:40:14.370 ⇒ 00:40:21.830 Amber Lin: Or at least their QA was just looking at it, it looks fine, but things like this, where it’s in the back, not the actual
276 00:40:22.100 ⇒ 00:40:27.250 Amber Lin: like… name on the dashboard, they probably did not QA that.
277 00:40:28.440 ⇒ 00:40:30.599 Jasmin Multani: Okay, cool, cool, cool. And…
278 00:40:30.740 ⇒ 00:40:37.350 Jasmin Multani: That’s… that’s really fine. So, we’ve captured that. Now, let’s… let’s write that out.
279 00:40:41.320 ⇒ 00:40:43.449 Jasmin Multani: Also, thank you for always being, like.
280 00:40:44.020 ⇒ 00:40:47.539 Jasmin Multani: willing and able to, like, hop on a call. I really appreciate it.
281 00:40:47.540 ⇒ 00:40:54.960 Amber Lin: Of course. It… this will not… this will never resolve over, squack.
282 00:40:56.880 ⇒ 00:40:58.850 Jasmin Multani: Okay, so why did this happen?
283 00:41:00.300 ⇒ 00:41:02.370 Jasmin Multani: What is expected?
284 00:41:05.120 ⇒ 00:41:06.450 Jasmin Multani: Studying institution.
285 00:41:16.990 ⇒ 00:41:17.690 Jasmin Multani: Thank you.
286 00:41:19.780 ⇒ 00:41:21.089 Jasmin Multani: beginning of theology.
287 00:41:28.360 ⇒ 00:41:31.620 Jasmin Multani: And, turn…
288 00:41:35.850 ⇒ 00:41:40.129 Jasmin Multani: Which was filtering them back, and
289 00:41:53.750 ⇒ 00:42:06.670 Jasmin Multani: The current dashboard mirrors both types, I do, and both the title and the…
290 00:42:39.750 ⇒ 00:42:42.410 Amber Lin: I sent the four fields for context.
291 00:43:17.490 ⇒ 00:43:18.240 Jasmin Multani: Excuse me.
292 00:43:33.530 ⇒ 00:43:34.919 Jasmin Multani: If you’re all here.
293 00:43:35.730 ⇒ 00:43:39.770 Jasmin Multani: From… steps.
294 00:43:40.350 ⇒ 00:43:41.140 Jasmin Multani: Wow.
295 00:44:12.630 ⇒ 00:44:14.280 Jasmin Multani: Next up’s,
296 00:44:32.040 ⇒ 00:44:34.400 Jasmin Multani: And then…
297 00:45:11.760 ⇒ 00:45:12.820 Jasmin Multani: Care…
298 00:45:15.230 ⇒ 00:45:23.920 Amber Lin: And I’ll go screenshot some, some orders to show how they… how they progress.
299 00:45:35.150 ⇒ 00:45:41.480 Jasmin Multani: No… And then she gets to the dashboard.
300 00:46:01.720 ⇒ 00:46:11.680 Amber Lin: Can you… can we also confirm with him, like, what they actually want to see? Do they still want to see pending customers?
301 00:46:20.700 ⇒ 00:46:21.430 Jasmin Multani: Officially.
302 00:46:22.910 ⇒ 00:46:25.430 Amber Lin: And I think as part of…
303 00:46:25.700 ⇒ 00:46:34.969 Amber Lin: Our next steps, we need to reset expectations with them of what pe… what a normal number for pending
304 00:46:35.160 ⇒ 00:46:42.840 Amber Lin: Customers looks like, because they were looking at abandoned customers before, which is a lot lower.
305 00:46:43.230 ⇒ 00:46:48.890 Jasmin Multani: Yeah, additionally, can you, pass.
306 00:46:49.790 ⇒ 00:46:52.710 Jasmin Multani: What other did they want?
307 00:46:53.460 ⇒ 00:47:02.160 Jasmin Multani: Pending orders, and pending… Customers…
308 00:47:07.800 ⇒ 00:47:08.490 Jasmin Multani: Cute.
309 00:47:21.240 ⇒ 00:47:34.059 Jasmin Multani: Which source of truth should you now use to, understand what a normalized treatment?
310 00:47:34.620 ⇒ 00:47:37.249 Jasmin Multani: Pending orders…
311 00:47:40.410 ⇒ 00:47:44.339 Jasmin Multani: Would this be BASC API, or something else?
312 00:47:48.030 ⇒ 00:47:58.330 Amber Lin: Wait, which… What a normalized… Wait, I don’t really understand the last sentence.
313 00:47:58.950 ⇒ 00:48:01.609 Amber Lin: Which SOT?
314 00:48:01.610 ⇒ 00:48:08.929 Jasmin Multani: Truth, so how do we… how, how do they… how do they validate whether
315 00:48:11.290 ⇒ 00:48:17.289 Jasmin Multani: How… how do they validate, whether their numbers are…
316 00:48:20.590 ⇒ 00:48:23.440 Jasmin Multani: benchmarked directionally.
317 00:48:25.280 ⇒ 00:48:27.920 Jasmin Multani: I feel like that’s gonna fall back on us, but…
318 00:48:29.020 ⇒ 00:48:48.719 Amber Lin: That, that will. And this is going to fall upon… I think this will also touch on what we’re doing yesterday, because what the status we have is not exactly the status they see in VASC, so they’re going to come back and say, hey, I found these orders that you said was impending, that’s not actually impending, so this is going to be an issue again.
319 00:49:03.600 ⇒ 00:49:04.610 Jasmin Multani: Yes.
320 00:49:05.760 ⇒ 00:49:08.440 Jasmin Multani: Russian words…
321 00:49:15.590 ⇒ 00:49:16.390 Jasmin Multani: True.
322 00:49:34.280 ⇒ 00:49:37.920 Amber Lin: And then, I also checked in BASC,
323 00:49:38.340 ⇒ 00:49:45.270 Amber Lin: Yesterday’s, there’s… there is still, like, 355 pending.
324 00:49:45.390 ⇒ 00:49:48.230 Amber Lin: And order status equals pending, so…
325 00:49:48.230 ⇒ 00:49:48.710 Jasmin Multani: -
326 00:49:48.710 ⇒ 00:49:50.250 Amber Lin: We’re not that far off.
327 00:49:51.390 ⇒ 00:49:52.240 Jasmin Multani: Okay, cool, cool.
328 00:49:52.240 ⇒ 00:49:55.749 Amber Lin: We’re actually lower, because I think we have some other statuses.
329 00:49:55.750 ⇒ 00:50:03.679 Jasmin Multani: Yeah, yeah, cool, cool, cool. So, Amber was able to check, and you used their BASC?
330 00:50:04.150 ⇒ 00:50:11.230 Amber Lin: Yeah, I can, yeah, and I checked on BASC’s order page,
331 00:50:11.830 ⇒ 00:50:18.200 Amber Lin: There is, indeed, there’s 300 plus, like, pending orders from yesterday.
332 00:50:29.710 ⇒ 00:50:32.290 Amber Lin: Let me check what the total order is.
333 00:50:36.010 ⇒ 00:50:42.190 Amber Lin: Huh. Wait, why is there, like… Oh.
334 00:50:54.280 ⇒ 00:50:59.110 Amber Lin: Oh, man, why is our total order number low?
335 00:51:00.480 ⇒ 00:51:01.869 Jasmin Multani: Where do you see that?
336 00:51:02.730 ⇒ 00:51:10.010 Amber Lin: I’m just checking in Basque. I’m checking in Basque, because you see how we say total orders yesterday?
337 00:51:10.600 ⇒ 00:51:16.560 Amber Lin: Is… is about, like, 590…
338 00:51:20.370 ⇒ 00:51:22.329 Jasmin Multani: Total orders yesterday.
339 00:51:22.810 ⇒ 00:51:23.760 Amber Lin: Yum.
340 00:51:24.600 ⇒ 00:51:26.850 Jasmin Multani: Where do you see that? This one? 593?
341 00:51:26.850 ⇒ 00:51:28.410 Amber Lin: Yeah.
342 00:51:29.410 ⇒ 00:51:34.009 Amber Lin: Just like that. Oh, sorry, that was just for Semma. Oh, silly.
343 00:51:34.170 ⇒ 00:51:37.739 Amber Lin: Okay, let me filter by STEMA.
344 00:51:39.030 ⇒ 00:51:46.360 Jasmin Multani: Even yesterday, you know how yesterday we were like, oh, this summary number is very different from this total number?
345 00:51:47.130 ⇒ 00:51:50.959 Jasmin Multani: I think… I think that must change…
346 00:51:51.280 ⇒ 00:51:53.810 Jasmin Multani: From… by the time you get to the end of the day.
347 00:51:54.990 ⇒ 00:51:55.520 Amber Lin: I think.
348 00:51:55.520 ⇒ 00:51:58.490 Jasmin Multani: There’s, there’s probably, like, a…
349 00:51:58.490 ⇒ 00:52:14.640 Amber Lin: I do use, like, completed days, though, so it shouldn’t affect as time goes through, but it’s… like, right now, it matches, right? It’s so weird. In the morning, it matches, in the afternoon, it’s different.
350 00:52:14.820 ⇒ 00:52:21.389 Amber Lin: Maybe… Maybe the Eden OS one is… data comes in a little bit later?
351 00:52:21.390 ⇒ 00:52:24.999 Jasmin Multani: we should probably get, yeah, refresh rates and…
352 00:52:25.000 ⇒ 00:52:25.790 Amber Lin: Yeah.
353 00:52:26.230 ⇒ 00:52:29.169 Amber Lin: Okay, that will be… I’ll write that down for later.
354 00:52:32.610 ⇒ 00:52:35.589 Jasmin Multani: So, do you feel… Do we feel good here?
355 00:52:37.570 ⇒ 00:52:38.530 Amber Lin: One sick…
356 00:52:42.520 ⇒ 00:52:44.820 Amber Lin: Premise…
357 00:52:51.970 ⇒ 00:52:55.020 Amber Lin: I’m reading the next steps now…
358 00:52:58.780 ⇒ 00:53:08.530 Amber Lin: Scroll down a little bit… Additionally… Pose, current process…
359 00:53:12.870 ⇒ 00:53:14.220 Amber Lin: Oh…
360 00:53:17.840 ⇒ 00:53:28.269 Amber Lin: I think in the should communicate this out, I think we should say, like, should communicate it out and, like, reset their expectations of what the number should be.
361 00:53:29.470 ⇒ 00:53:34.549 Amber Lin: Because they’re… they’re expecting something that’s… that’s not actually true.
362 00:54:20.120 ⇒ 00:54:22.409 Amber Lin: I don’t know if we need that bullet point.
363 00:54:30.840 ⇒ 00:54:32.340 Jasmin Multani: Everything else good here?
364 00:54:32.340 ⇒ 00:54:32.910 Amber Lin: Yeah.
365 00:54:54.890 ⇒ 00:54:57.540 Jasmin Multani: Well, thank you for walking me through this.
366 00:54:58.070 ⇒ 00:55:02.880 Jasmin Multani: In the meantime, I’m gonna finish the sprint and just literally be like.
367 00:55:03.180 ⇒ 00:55:05.980 Jasmin Multani: What is the difference in averages?
368 00:55:06.270 ⇒ 00:55:10.300 Jasmin Multani: Is there, like, a huge difference, or is there… is it minor?
369 00:55:12.200 ⇒ 00:55:15.300 Amber Lin: Yeah, let’s… let’s check that.
370 00:55:19.120 ⇒ 00:55:28.540 Amber Lin: I can read… here, how about I can read out the, the BASC numbers, or I can read out the combined numbers, and we.
371 00:55:28.540 ⇒ 00:55:36.029 Jasmin Multani: Yeah, it’s okay, I’ll be able to do this on my own. I’m gonna be heads down for 10 minutes… 15 minutes, and then I’ll share what I did.
372 00:55:36.230 ⇒ 00:55:37.360 Amber Lin: Okay. Alright.
373 00:55:37.360 ⇒ 00:55:38.190 Jasmin Multani: That’s good.
374 00:55:38.190 ⇒ 00:55:39.549 Amber Lin: Sounds good. Talk to you soon.
375 00:55:39.550 ⇒ 00:55:40.160 Jasmin Multani: Bye.