Meeting Title: Merge Retail Renaming changes - working session Date: 2026-04-29 Meeting participants: Awaish Kumar, Advait Nandakumar Menon, Jasmin Multani
WEBVTT
1 00:02:48.930 ⇒ 00:02:50.619 Advait Nandakumar Menon: Yeah, Vish, how’s it going?
2 00:02:50.620 ⇒ 00:02:52.990 Awaish Kumar: I… I’m good, how about you?
3 00:02:53.860 ⇒ 00:02:56.219 Advait Nandakumar Menon: I’m doing good as well, thanks for asking.
4 00:02:57.250 ⇒ 00:02:58.280 Awaish Kumar: Yeah, it’s alright.
5 00:03:39.590 ⇒ 00:03:41.800 Awaish Kumar: Okay, Advil, I think we can…
6 00:03:42.580 ⇒ 00:03:45.740 Awaish Kumar: Both go up… go ahead and merge it.
7 00:03:46.310 ⇒ 00:03:49.319 Awaish Kumar: So… Basically, what I…
8 00:03:50.610 ⇒ 00:03:56.780 Awaish Kumar: what we want to do in this session is that I… we are going to just merge this renaming PR.
9 00:03:57.640 ⇒ 00:03:58.280 Advait Nandakumar Menon: Yeah.
10 00:03:58.900 ⇒ 00:04:01.759 Awaish Kumar: And it will run… it will trigger a run in production.
11 00:04:02.260 ⇒ 00:04:07.710 Awaish Kumar: Once that’s done, We are basically…
12 00:04:08.580 ⇒ 00:04:11.099 Awaish Kumar: We are going to verify that
13 00:04:11.490 ⇒ 00:04:16.570 Awaish Kumar: The dash… all the retail dashboards, are working fine.
14 00:04:16.760 ⇒ 00:04:18.810 Awaish Kumar: And if there is any…
15 00:04:21.820 ⇒ 00:04:25.679 Awaish Kumar: Failure, like, if a dashboard is failing, or some…
16 00:04:25.790 ⇒ 00:04:31.539 Awaish Kumar: feel is failing, and we just adopt it in this meeting. So, once we leave this, like, we should be good.
17 00:04:32.020 ⇒ 00:04:35.460 Awaish Kumar: To share that renaming is successful.
18 00:04:37.240 ⇒ 00:04:40.380 Awaish Kumar: Second thing is, looking at the… Come on.
19 00:04:41.710 ⇒ 00:04:46.940 Awaish Kumar: looking at the polyatomic, like, oh, sorry, the Google Sheets as well.
20 00:04:47.210 ⇒ 00:04:47.880 Awaish Kumar: So.
21 00:04:47.880 ⇒ 00:04:48.449 Advait Nandakumar Menon: Huh.
22 00:04:48.450 ⇒ 00:04:50.970 Awaish Kumar: I don’t know if… are you familiar with the…
23 00:04:51.130 ⇒ 00:04:54.180 Awaish Kumar: Google Sheet, or should I ask Amber to join?
24 00:04:55.420 ⇒ 00:05:12.009 Advait Nandakumar Menon: I’m familiar… Amber gave us a small session to me and Jasmine, last Friday, and I’ve used the Google Sheet to basically migrate it to Omni as well, like, there is something called OmniSheets, so we might have migrated to it.
25 00:05:12.020 ⇒ 00:05:20.389 Advait Nandakumar Menon: But for the change, to handle the change, I think Jasmine is handling the Google Sheet part, and I’ll be handling whatever is…
26 00:05:20.510 ⇒ 00:05:26.110 Advait Nandakumar Menon: changing in Omni, so… I think that’s… What the plan was.
27 00:05:36.080 ⇒ 00:05:37.500 Advait Nandakumar Menon: Does it make sense?
28 00:05:41.670 ⇒ 00:05:43.660 Awaish Kumar: Yes, I was just pinged.
29 00:05:44.460 ⇒ 00:05:45.190 Awaish Kumar: Yasmin.
30 00:05:45.190 ⇒ 00:05:45.910 Advait Nandakumar Menon: Okay.
31 00:06:35.640 ⇒ 00:06:36.230 Awaish Kumar: Hi.
32 00:06:36.870 ⇒ 00:06:39.530 Jasmin Multani: Hey, sorry, in a meeting without them.
33 00:06:41.010 ⇒ 00:06:41.760 Awaish Kumar: Okay, no worries.
34 00:06:41.760 ⇒ 00:06:42.569 Advait Nandakumar Menon: They’re listening.
35 00:06:42.790 ⇒ 00:06:43.660 Jasmin Multani: Yay!
36 00:06:49.400 ⇒ 00:06:54.339 Jasmin Multani: Okay, so… this meeting… What are we doing?
37 00:06:56.760 ⇒ 00:06:59.050 Awaish Kumar: Okay, so in this meeting, what I…
38 00:07:00.050 ⇒ 00:07:02.549 Awaish Kumar: what I’m trying to do is, like.
39 00:07:02.920 ⇒ 00:07:05.820 Awaish Kumar: we have this PR for renaming, right?
40 00:07:07.980 ⇒ 00:07:10.710 Awaish Kumar: And I’m going to merge it right now.
41 00:07:11.150 ⇒ 00:07:11.900 Jasmin Multani: Okay.
42 00:07:12.260 ⇒ 00:07:15.839 Awaish Kumar: For the… and it has all the changes for the retail.
43 00:07:17.470 ⇒ 00:07:20.510 Awaish Kumar: But what I want… You to look at the…
44 00:07:21.380 ⇒ 00:07:28.140 Awaish Kumar: Like, they’ll look at the description and understand, like, what things might change, because,
45 00:07:28.380 ⇒ 00:07:32.650 Awaish Kumar: Jasmine, I think if you are handling Google Sheets updates.
46 00:07:32.650 ⇒ 00:07:34.120 Jasmin Multani: Yeah. And…
47 00:07:34.120 ⇒ 00:07:37.679 Awaish Kumar: metric names and things like that might be relevant for you, like, if
48 00:07:38.000 ⇒ 00:07:43.779 Awaish Kumar: Because, yeah, so if a formatic name change, you just have to adopt that in the formula.
49 00:07:43.980 ⇒ 00:07:45.470 Awaish Kumar: Yeah.
50 00:07:46.370 ⇒ 00:07:51.439 Awaish Kumar: Same for Edway, like, if the name has changed for the model, or if the name has changed for
51 00:07:54.690 ⇒ 00:07:58.180 Awaish Kumar: Or the metric, then you have to adopt it.
52 00:07:58.650 ⇒ 00:08:00.420 Awaish Kumar: in the dashboards.
53 00:08:03.730 ⇒ 00:08:06.480 Awaish Kumar: And I’m… I’m going to look at…
54 00:08:06.650 ⇒ 00:08:13.309 Awaish Kumar: The production runs, that they are successfully executed, and then at the polytomic, That reversed…
55 00:08:13.660 ⇒ 00:08:15.480 Awaish Kumar: is happening correctly.
56 00:08:17.500 ⇒ 00:08:18.450 Awaish Kumar: Okay?
57 00:08:18.680 ⇒ 00:08:21.930 Awaish Kumar: Yep. Okay. Yep, yep, yep. Let’s merge it.
58 00:08:22.600 ⇒ 00:08:23.890 Awaish Kumar: And click in.
59 00:08:24.160 ⇒ 00:08:29.889 Awaish Kumar: We have to wait for a few minutes, because after our merge, it will take some time to…
60 00:08:31.280 ⇒ 00:08:35.659 Awaish Kumar: Run, like… For it to get deployed on production.
61 00:08:38.720 ⇒ 00:08:43.239 Awaish Kumar: Let me just go ahead here and… merge it,
62 00:08:46.360 ⇒ 00:08:49.520 Awaish Kumar: I can lie… I can share my screen for visibility.
63 00:08:51.570 ⇒ 00:08:52.979 Awaish Kumar: So I’ve merged it.
64 00:08:55.780 ⇒ 00:08:56.640 Awaish Kumar: Okay.
65 00:08:59.440 ⇒ 00:09:04.350 Awaish Kumar: You can look at the… Prescription, if you want.
66 00:09:08.520 ⇒ 00:09:11.040 Awaish Kumar: These are the main changes.
67 00:09:16.750 ⇒ 00:09:21.420 Awaish Kumar: Yeah, and I’m waiting for… This run to finish.
68 00:09:22.740 ⇒ 00:09:27.519 Awaish Kumar: Once it is done, we’ll have the changes in production, and then we can…
69 00:09:31.780 ⇒ 00:09:33.770 Awaish Kumar: Basically, Edwin, you can start.
70 00:09:34.130 ⇒ 00:09:35.369 Awaish Kumar: But then I…
71 00:09:36.050 ⇒ 00:09:41.470 Awaish Kumar: confirm the changes in polyatomic, and then, Jasmine, you have to look after that.
72 00:09:43.560 ⇒ 00:09:45.929 Jasmin Multani: So that’s gonna be in…
73 00:09:46.070 ⇒ 00:09:49.109 Jasmin Multani: Is that just the retail spreadsheets, right?
74 00:09:49.110 ⇒ 00:09:50.830 Awaish Kumar: Only the retail one.
75 00:09:51.110 ⇒ 00:09:57.960 Awaish Kumar: And basically, what is happening here is, like, this is creating tables in Slow fake right now.
76 00:09:58.130 ⇒ 00:09:59.680 Awaish Kumar: Once that is done.
77 00:09:59.980 ⇒ 00:10:03.209 Awaish Kumar: Basically, I have also made changes for…
78 00:10:03.520 ⇒ 00:10:11.390 Awaish Kumar: Omni topics. So hopefully that goes away for you, and then you can just go in and change your dashboards in Omni.
79 00:10:11.620 ⇒ 00:10:16.490 Awaish Kumar: But for Jasmine, for you to actually work, we…
80 00:10:17.010 ⇒ 00:10:20.550 Awaish Kumar: have to bring these changes into Google Sheet. So for that.
81 00:10:20.550 ⇒ 00:10:21.000 Jasmin Multani: What about?
82 00:10:21.000 ⇒ 00:10:24.230 Awaish Kumar: So I have to go into the polytomic and make some changes.
83 00:10:25.510 ⇒ 00:10:31.040 Awaish Kumar: And I will do that right now. After that, you can go into the sheet and basically
84 00:10:31.180 ⇒ 00:10:34.909 Awaish Kumar: Make those similar… make those similar changes, and…
85 00:10:36.630 ⇒ 00:10:41.139 Awaish Kumar: Relevant for, retailer sheet. Oh, sorry, retail sheet.
86 00:10:41.830 ⇒ 00:10:47.610 Jasmin Multani: Yeah, should we, re-dump? Once you’re done with Polytomic, should we re-dump the raw data?
87 00:10:49.600 ⇒ 00:10:51.640 Awaish Kumar: What, what that means?
88 00:10:52.060 ⇒ 00:11:00.160 Jasmin Multani: So… Right now, the raw data, like, this… this… the formulas,
89 00:11:00.380 ⇒ 00:11:04.240 Jasmin Multani: are focused on the raw data files, right? On the spreadsheets?
90 00:11:04.240 ⇒ 00:11:07.679 Awaish Kumar: The raw sheets needs to be updated. That’s what I’m going to do after.
91 00:11:07.680 ⇒ 00:11:08.400 Jasmin Multani: Okay.
92 00:11:08.400 ⇒ 00:11:10.440 Awaish Kumar: Yes, so what’s in this space?
93 00:11:10.960 ⇒ 00:11:13.700 Awaish Kumar: I’m going to… like…
94 00:11:14.130 ⇒ 00:11:22.849 Awaish Kumar: freedom the data for those row sheets, and then after that, you can basically work on it. Right now, you obviously can’t… you are blogged on me.
95 00:11:23.100 ⇒ 00:11:27.200 Jasmin Multani: Yeah, no worries. I’ll be around, I’m just, like, drinking coffee.
96 00:11:29.830 ⇒ 00:11:36.380 Jasmin Multani: I’m not gonna do, like, double work right now, because I think this is, like, important needs for attention.
97 00:11:46.060 ⇒ 00:11:50.739 Advait Nandakumar Menon: So, Avesh, within Omni, the only change I need to do is the…
98 00:11:51.060 ⇒ 00:11:54.710 Advait Nandakumar Menon: References within the dashboards to the new fields, right?
99 00:11:55.890 ⇒ 00:12:00.420 Advait Nandakumar Menon: The topics and views will automatically get updated, is that what you…
100 00:12:00.900 ⇒ 00:12:06.389 Awaish Kumar: I’m saying I’m hoping that, because I tried to do that. I tried to change the names in the topic.
101 00:12:06.590 ⇒ 00:12:11.880 Awaish Kumar: And, like, along with the DBT, sorry, the…
102 00:12:12.000 ⇒ 00:12:18.390 Awaish Kumar: Along with… when I’m making DVD changes, I did… made changes for Omni, and I’m hoping that…
103 00:12:18.580 ⇒ 00:12:21.069 Awaish Kumar: If it goes smooth, you just have to…
104 00:12:21.370 ⇒ 00:12:23.650 Awaish Kumar: Make the changes for your,
105 00:12:24.620 ⇒ 00:12:30.999 Awaish Kumar: Like, after topics, you have to go into what? You have to create… you have to make the changes for dashboards, right?
106 00:12:31.760 ⇒ 00:12:34.020 Advait Nandakumar Menon: Right, yeah. My…
107 00:12:34.170 ⇒ 00:12:39.169 Advait Nandakumar Menon: The only concern is I just checked the files within Omni that you’re modifying, and I think
108 00:12:39.920 ⇒ 00:12:43.079 Advait Nandakumar Menon: A couple of the retail topics…
109 00:12:44.000 ⇒ 00:12:47.169 Advait Nandakumar Menon: You’re not… I think it’s not covered, isn’t it?
110 00:12:49.280 ⇒ 00:12:52.009 Advait Nandakumar Menon: Because in Omni, we currently have…
111 00:12:52.210 ⇒ 00:13:01.010 Advait Nandakumar Menon: 3, I mean, yeah, five retail topics, but I think the…
112 00:13:01.640 ⇒ 00:13:06.549 Awaish Kumar: Yeah, but anyway, it is also possible that other topics might not need this thing, right? This is… this is…
113 00:13:06.550 ⇒ 00:13:07.399 Advait Nandakumar Menon: Oh, okay.
114 00:13:07.890 ⇒ 00:13:12.700 Awaish Kumar: This is relevant for this, like, Naming for point of sale.
115 00:13:13.820 ⇒ 00:13:18.589 Awaish Kumar: And one of the units, so it’s… Just might be the one
116 00:13:18.920 ⇒ 00:13:22.860 Awaish Kumar: That need, like… but we can see it. Once you go in.
117 00:13:22.990 ⇒ 00:13:25.949 Awaish Kumar: And see something is broke, then we know, right?
118 00:13:26.610 ⇒ 00:13:27.660 Advait Nandakumar Menon: Yeah, okay.
119 00:13:31.360 ⇒ 00:13:32.539 Awaish Kumar: Where is my PR?
120 00:13:33.690 ⇒ 00:13:34.510 Awaish Kumar: This one.
121 00:13:35.930 ⇒ 00:13:37.330 Advait Nandakumar Menon: 85, yeah.
122 00:13:38.490 ⇒ 00:13:38.859 Awaish Kumar: It’s weird.
123 00:13:38.860 ⇒ 00:13:40.330 Advait Nandakumar Menon: No, 80…
124 00:13:42.010 ⇒ 00:13:42.960 Awaish Kumar: But.
125 00:13:46.370 ⇒ 00:13:47.410 Advait Nandakumar Menon: 83.
126 00:13:47.730 ⇒ 00:13:48.869 Advait Nandakumar Menon: So you’re good three.
127 00:13:51.920 ⇒ 00:13:53.229 Awaish Kumar: Okay, it’s you, okay.
128 00:13:55.870 ⇒ 00:14:00.019 Advait Nandakumar Menon: Yeah, USS ATG. That one was something else I merged this morning.
129 00:14:10.520 ⇒ 00:14:11.460 Awaish Kumar: So it’s…
130 00:14:19.800 ⇒ 00:14:23.339 Awaish Kumar: Okay, this needs to also fix to me.
131 00:14:25.430 ⇒ 00:14:32.120 Awaish Kumar: I’m… we made change for retail, and it’s running… kind of everything. I just…
132 00:14:32.750 ⇒ 00:14:35.959 Awaish Kumar: To speed it up, I will just go in the actions.
133 00:14:37.010 ⇒ 00:14:38.120 Awaish Kumar: Retail.
134 00:15:27.240 ⇒ 00:15:28.629 Awaish Kumar: Okay, destination.
135 00:16:18.730 ⇒ 00:16:24.390 Awaish Kumar: So these are four views, which… We’re traveling.
136 00:16:24.550 ⇒ 00:16:26.930 Awaish Kumar: For the retail reporting.
137 00:16:33.500 ⇒ 00:16:37.900 Jasmin Multani: But we have to update those sheets… those tabs?
138 00:16:39.490 ⇒ 00:16:46.480 Awaish Kumar: Yeah, so basically, I just have to figure out which…
139 00:16:47.670 ⇒ 00:16:52.600 Awaish Kumar: column is changed as part of this VR, and I’ve updated that in polyatomic.
140 00:16:53.660 ⇒ 00:16:54.290 Jasmin Multani: Sweet.
141 00:16:56.460 ⇒ 00:17:08.490 Advait Nandakumar Menon: I think within those four, it’s not the column, but Aesh, if you remember, it’s pre-aggregated summary table, so it’s the metric, and within the metric, we have the data.
142 00:17:08.680 ⇒ 00:17:14.340 Advait Nandakumar Menon: Where it’s POS sales, or whatever, and the actual data that’s getting changed.
143 00:17:14.750 ⇒ 00:17:20.069 Advait Nandakumar Menon: So, I think within Google Sheet, on…
144 00:17:20.319 ⇒ 00:17:27.400 Advait Nandakumar Menon: I don’t think we have column level changes. It’s the lookups that we have to change, Jasmine, because.
145 00:17:27.400 ⇒ 00:17:28.250 Awaish Kumar: Yeah.
146 00:17:28.490 ⇒ 00:17:28.820 Advait Nandakumar Menon: with the.
147 00:17:29.190 ⇒ 00:17:36.649 Advait Nandakumar Menon: Yeah, within those tabs, under the metric column, within the data, it’ll be, like, point of sales now, and on the.
148 00:17:36.650 ⇒ 00:17:37.520 Jasmin Multani: Yes.
149 00:17:37.520 ⇒ 00:17:40.669 Advait Nandakumar Menon: just referencing it. We need to make sure
150 00:17:40.800 ⇒ 00:17:44.909 Advait Nandakumar Menon: It’s looking at point of sales and not pure sales, or whatever.
151 00:17:45.100 ⇒ 00:17:50.199 Jasmin Multani: Yeah, this view is very helpful. It literally tells me what gets updated to what.
152 00:17:53.190 ⇒ 00:17:55.360 Jasmin Multani: Can you send me the link for this?
153 00:17:55.880 ⇒ 00:17:57.029 Jasmin Multani: the changes?
154 00:17:57.400 ⇒ 00:17:58.680 Awaish Kumar: Just PR? Okay.
155 00:17:58.940 ⇒ 00:18:04.509 Jasmin Multani: Yep, thank you, cause that’s gonna help me quality check what… what to look up.
156 00:18:07.560 ⇒ 00:18:09.170 Awaish Kumar: Why I’m not able…
157 00:18:10.720 ⇒ 00:18:13.100 Jasmin Multani: You can Slack it to… I think it’s better if you Slack it to me.
158 00:18:17.010 ⇒ 00:18:17.850 Awaish Kumar: I’m sorry.
159 00:18:18.140 ⇒ 00:18:18.640 Awaish Kumar: You’re…
160 00:18:18.640 ⇒ 00:18:19.170 Jasmin Multani: Good.
161 00:18:24.880 ⇒ 00:18:26.119 Awaish Kumar: Just drop here.
162 00:18:31.710 ⇒ 00:18:33.200 Awaish Kumar: What’s going on? I don’t…
163 00:18:35.280 ⇒ 00:18:36.350 Jasmin Multani: Connect.
164 00:18:37.430 ⇒ 00:18:42.040 Awaish Kumar: Let’s… Go back here, and
165 00:18:50.720 ⇒ 00:18:52.880 Awaish Kumar: So this is what is updated.
166 00:18:55.100 ⇒ 00:18:55.810 Jasmin Multani: Yes.
167 00:18:55.810 ⇒ 00:18:58.419 Awaish Kumar: File called Retail Monthly Sales Summary.
168 00:18:58.420 ⇒ 00:19:00.950 Jasmin Multani: Yeah, from, and the green is the 2.
169 00:19:01.200 ⇒ 00:19:01.840 Awaish Kumar: Yes.
170 00:19:06.370 ⇒ 00:19:10.160 Jasmin Multani: So I can just do, like, a find all on the Excel spreadsheet.
171 00:19:10.670 ⇒ 00:19:13.239 Jasmin Multani: And replace it with this. Let’s find out.
172 00:19:14.070 ⇒ 00:19:15.849 Awaish Kumar: But right now, it will be…
173 00:19:16.120 ⇒ 00:19:20.800 Awaish Kumar: It won’t make any change, because the new data hasn’t been…
174 00:19:20.800 ⇒ 00:19:24.000 Jasmin Multani: Yeah. No worries, no worries. Yeah, I appreciate it.
175 00:19:25.750 ⇒ 00:19:27.350 Awaish Kumar: 3, 10…
176 00:19:31.610 ⇒ 00:19:37.480 Awaish Kumar: Model name is trained, so I will just… Gobwanda.
177 00:19:37.790 ⇒ 00:19:38.890 Awaish Kumar: Take that.
178 00:19:41.030 ⇒ 00:19:45.710 Awaish Kumar: And then we have, apart from Summary viewers, we also have…
179 00:19:52.600 ⇒ 00:19:57.110 Awaish Kumar: a view for film, I don’t know if that is… yeah, this one.
180 00:20:04.000 ⇒ 00:20:08.960 Awaish Kumar: So, for the Phil’s view, we actually have Change it to column names.
181 00:20:09.970 ⇒ 00:20:10.760 Advait Nandakumar Menon: Oh, okay.
182 00:20:10.890 ⇒ 00:20:12.890 Advait Nandakumar Menon: Yeah, okay, okay.
183 00:20:12.920 ⇒ 00:20:18.379 Jasmin Multani: Okay, yeah. Yeah, I think this’ll… This view is helpful.
184 00:20:21.550 ⇒ 00:20:28.420 Advait Nandakumar Menon: Avesh, just to confirm, so there are, like, 3 levels of changes. So, sales will be renamed to Point of Sales.
185 00:20:28.720 ⇒ 00:20:37.550 Advait Nandakumar Menon: POS sales will be just called point of sales, and wherever it’s just POS will again be expanded to point of sales, right?
186 00:20:39.160 ⇒ 00:20:40.080 Awaish Kumar: Yes, yes.
187 00:20:40.910 ⇒ 00:20:42.050 Advait Nandakumar Menon: Okay, okay.
188 00:20:44.220 ⇒ 00:20:46.939 Awaish Kumar: And there is also a table name change.
189 00:20:47.540 ⇒ 00:20:48.760 Awaish Kumar: fake sales.
190 00:20:49.150 ⇒ 00:20:53.710 Awaish Kumar: So, previously, we had re… Retail fact sales, right?
191 00:20:54.100 ⇒ 00:21:08.470 Advait Nandakumar Menon: Right, yeah, that’s what… wherever it’s called sales will be point of sales now, wherever it’s called POS sales will be point of sales now, and wherever it’s called POS will be expanded to point of sales. So, that’s what I meant by the three law of changes.
192 00:21:09.190 ⇒ 00:21:13.510 Awaish Kumar: Yeah, but not every sales word is changed to point of sale, I’m saying that.
193 00:21:14.450 ⇒ 00:21:15.280 Advait Nandakumar Menon: Oh.
194 00:21:15.280 ⇒ 00:21:19.359 Awaish Kumar: Yeah, it has changed because this table only has point-of-sales data.
195 00:21:23.100 ⇒ 00:21:26.819 Advait Nandakumar Menon: Okay, and retail only has point-of-sales data at the moment, right?
196 00:21:26.820 ⇒ 00:21:29.460 Awaish Kumar: This table, not the retail.
197 00:21:29.790 ⇒ 00:21:32.839 Awaish Kumar: Retail does have other data, right?
198 00:21:33.480 ⇒ 00:21:37.610 Awaish Kumar: It does have… Omni-channel data.
199 00:21:37.770 ⇒ 00:21:42.739 Awaish Kumar: And what I What I mean by that is, there is a table in retail mart.
200 00:21:42.930 ⇒ 00:21:45.399 Awaish Kumar: Which gives you the data for…
201 00:21:45.530 ⇒ 00:21:51.969 Awaish Kumar: Like, the revenue numbers for the… for the retail data, but that is, like,
202 00:21:53.130 ⇒ 00:22:00.060 Awaish Kumar: also includes Omni sales, and OmniSales in that context is… Sales that are…
203 00:22:00.570 ⇒ 00:22:06.679 Awaish Kumar: not happen… not entirely happening in the store. It’s like you ordered online and picked up in the store.
204 00:22:06.680 ⇒ 00:22:07.870 Jasmin Multani: Yeah,
205 00:22:11.290 ⇒ 00:22:18.480 Awaish Kumar: Yeah, sometimes you just pay it through their order management system, like, through some links, or… yeah, things like that.
206 00:22:19.010 ⇒ 00:22:23.399 Jasmin Multani: So those are not going to be captured in point of sales, is that what you’re saying?
207 00:22:23.400 ⇒ 00:22:25.199 Awaish Kumar: Yes, yes, that’s what I’m saying.
208 00:22:25.400 ⇒ 00:22:27.459 Jasmin Multani: Where did they get captured instead?
209 00:22:27.890 ⇒ 00:22:34.040 Awaish Kumar: There is another table, I… Don’t remember the name right now, but I can open it here right now.
210 00:22:34.610 ⇒ 00:22:38.369 Jasmin Multani: Yeah, this is helpful. This is gonna be helpful for us, in case she asks.
211 00:22:40.250 ⇒ 00:22:47.550 Awaish Kumar: Models… but… and why it’s not in there? Because it’s not in the same grain as point of sales.
212 00:22:47.680 ⇒ 00:22:50.099 Awaish Kumar: So, we have… it’s called a…
213 00:22:50.510 ⇒ 00:22:57.049 Awaish Kumar: Yeah, Omni… it’s for Walmart mainly, and it is called Retail Faked Walmart Omni Sales.
214 00:22:57.280 ⇒ 00:22:59.580 Jasmin Multani: Okay, yeah. It includes… Yes.
215 00:22:59.850 ⇒ 00:23:02.399 Awaish Kumar: It includes both. It includes,
216 00:23:03.030 ⇒ 00:23:10.380 Awaish Kumar: like, the… all other channels, and it also includes the numbers for POS. So it’s basically the full Walmart revenue.
217 00:23:10.540 ⇒ 00:23:11.240 Awaish Kumar: Perfect.
218 00:23:11.240 ⇒ 00:23:19.919 Jasmin Multani: Yeah. I think, Shivani is aware about this difference, because she also pointed to the spreadsheet, and she’s like.
219 00:23:20.460 ⇒ 00:23:27.130 Jasmin Multani: She talked about how there’s a blank space next to Omni Sales, and she knows that that data is about to come in, right?
220 00:23:29.070 ⇒ 00:23:37.260 Awaish Kumar: I don’t… yeah, I’m not, like, sure what we have committed, but I did make sure that everybody knows that, because…
221 00:23:37.380 ⇒ 00:23:45.449 Awaish Kumar: In the, in the sheet… in the Google sheet, you see the metrics exactly say the retail point of sales.
222 00:23:46.260 ⇒ 00:23:47.350 Jasmin Multani: Yeah.
223 00:23:47.650 ⇒ 00:23:53.260 Awaish Kumar: Because I know that they might be ex… looking at different numbers at some other place.
224 00:23:54.220 ⇒ 00:23:57.980 Awaish Kumar: We need to make sure that we are only bringing in point of sale.
225 00:23:58.330 ⇒ 00:23:59.380 Awaish Kumar: Okay.
226 00:23:59.800 ⇒ 00:24:01.410 Jasmin Multani: Yeah, that’s good, that’s good.
227 00:24:01.950 ⇒ 00:24:05.469 Awaish Kumar: But there is this, like, flag in this table.
228 00:24:05.790 ⇒ 00:24:07.529 Awaish Kumar: This can say store sale.
229 00:24:07.930 ⇒ 00:24:12.760 Awaish Kumar: If it is inside the store, like, when it says in the store, that is kind of point of sale.
230 00:24:14.330 ⇒ 00:24:21.490 Awaish Kumar: When it says Ecom, then it is, any sale.
231 00:24:21.800 ⇒ 00:24:28.180 Awaish Kumar: in e-com, but it is e-commerce for… e-commerce for Walmart, like, we…
232 00:24:31.290 ⇒ 00:24:33.840 Awaish Kumar: In context of element.
233 00:24:34.150 ⇒ 00:24:43.200 Awaish Kumar: we consider e-commerce, if the revenue is directly coming from Shopify, Amazon or Walmart.com.
234 00:24:44.440 ⇒ 00:24:50.500 Awaish Kumar: But Walmart have its own website as well, right? They sell on their website as well.
235 00:24:51.290 ⇒ 00:24:53.919 Awaish Kumar: And this is going… that number is going in here.
236 00:25:06.320 ⇒ 00:25:07.280 Awaish Kumar: Okay.
237 00:25:07.380 ⇒ 00:25:18.010 Awaish Kumar: Still running… It’s finished, okay. Okay, are they
238 00:25:18.450 ⇒ 00:25:22.480 Awaish Kumar: You can go in and refresh the Omni…
239 00:25:22.480 ⇒ 00:25:24.559 Advait Nandakumar Menon: That’s a schema, yeah, okay.
240 00:25:42.720 ⇒ 00:25:49.850 Awaish Kumar: or the… report view, I… Can go in and…
241 00:25:55.010 ⇒ 00:25:57.399 Awaish Kumar: written excluded somewhere.
242 00:26:00.620 ⇒ 00:26:01.360 Awaish Kumar: Okay.
243 00:26:10.380 ⇒ 00:26:14.449 Awaish Kumar: So, we have now point of sales and conference units.
244 00:27:05.730 ⇒ 00:27:10.429 Advait Nandakumar Menon: I refreshed the schema in Omnia, and a change has come through.
245 00:27:11.920 ⇒ 00:27:18.059 Advait Nandakumar Menon: I… I’m going through the content validator within the model.
246 00:27:18.810 ⇒ 00:27:23.539 Advait Nandakumar Menon: And it looks like only a couple of dashboards are affected, so maybe I can just fix that.
247 00:27:24.740 ⇒ 00:27:25.510 Awaish Kumar: Okay.
248 00:27:28.080 ⇒ 00:27:29.090 Awaish Kumar: Why…
249 00:28:54.550 ⇒ 00:28:55.260 Awaish Kumar: Thank you.
250 00:29:05.790 ⇒ 00:29:11.319 Awaish Kumar: Okay, so… Jasmine, I’m syncing it here, and…
251 00:29:12.280 ⇒ 00:29:16.520 Awaish Kumar: For the Finn’s view, you can start Making changes.
252 00:29:17.250 ⇒ 00:29:20.130 Jasmin Multani: Okay, I’ll wait for you to confirm.
253 00:29:20.520 ⇒ 00:29:26.690 Awaish Kumar: So, yeah, now the change for you will be really… for this, it will be really… Simple.
254 00:29:27.400 ⇒ 00:29:34.999 Awaish Kumar: Because, I’m sending this data into these two columns.
255 00:29:35.670 ⇒ 00:29:40.369 Awaish Kumar: So, I think you just have to do the renaming of the columns itself.
256 00:29:40.710 ⇒ 00:29:42.550 Jasmin Multani: Oh, not the formulas?
257 00:29:46.720 ⇒ 00:29:51.959 Advait Nandakumar Menon: The fields report alone, it’s in the column format, Jasmine, it’s not within the data, so that’s the reason.
258 00:29:53.470 ⇒ 00:29:56.999 Awaish Kumar: I don’t know, let’s… let’s… Look at this spreadsheet.
259 00:30:00.410 ⇒ 00:30:07.119 Jasmin Multani: I guess, like, if we update the columns, then the formulas will self-update, maybe?
260 00:30:07.550 ⇒ 00:30:10.280 Awaish Kumar: Retail…
261 00:30:19.470 ⇒ 00:30:24.179 Advait Nandakumar Menon: So, I know the first tab, the summary report, is populated by…
262 00:30:24.530 ⇒ 00:30:34.130 Advait Nandakumar Menon: The weekly raw data point of sales, and the monthly raw data point of sales tabs. And within those
263 00:30:34.690 ⇒ 00:30:37.869 Advait Nandakumar Menon: There is only the formula change, Jasmine, for the lookup.
264 00:30:38.270 ⇒ 00:30:45.760 Advait Nandakumar Menon: Because the data is actually populated within the metric column, if you look at the weekly raw data, Avish.
265 00:30:47.080 ⇒ 00:30:48.130 Jasmin Multani: metric.
266 00:30:49.310 ⇒ 00:30:54.629 Awaish Kumar: That I understand, I’m just saying about, you know, Phil’s report. Are we doing anything
267 00:30:55.380 ⇒ 00:30:57.430 Awaish Kumar: Apart from this tabular view.
268 00:30:59.180 ⇒ 00:31:05.850 Advait Nandakumar Menon: I think… This is the only tab which references the fields report data.
269 00:31:06.480 ⇒ 00:31:09.500 Awaish Kumar: this… Okay.
270 00:31:10.530 ⇒ 00:31:13.520 Advait Nandakumar Menon: Yeah, I, I think so. I need to confirm.
271 00:31:14.300 ⇒ 00:31:15.970 Awaish Kumar: Yeah, this one. You might…
272 00:31:15.970 ⇒ 00:31:16.740 Advait Nandakumar Menon: Yeah.
273 00:31:16.740 ⇒ 00:31:20.759 Awaish Kumar: Yeah, it is… see, it is not referencing the column names.
274 00:31:21.020 ⇒ 00:31:23.330 Awaish Kumar: Just the column itself, so…
275 00:31:23.330 ⇒ 00:31:24.830 Advait Nandakumar Menon: Yeah.
276 00:31:25.070 ⇒ 00:31:28.649 Awaish Kumar: I don’t think it… It will have to do any…
277 00:31:29.100 ⇒ 00:31:32.410 Awaish Kumar: We don’t… we don’t… I don’t think we have to do any changing here.
278 00:31:33.070 ⇒ 00:31:36.790 Jasmin Multani: I think on the retail summary report, It’s…
279 00:31:37.200 ⇒ 00:31:38.800 Jasmin Multani: We have to double check that.
280 00:31:39.740 ⇒ 00:31:40.430 Awaish Kumar: Yeah.
281 00:31:40.930 ⇒ 00:31:41.650 Awaish Kumar: Cardin.
282 00:31:41.980 ⇒ 00:31:45.900 Jasmin Multani: I think it’s hard-coded the actual value name, rather than.
283 00:31:46.370 ⇒ 00:31:47.030 Advait Nandakumar Menon: Yeah.
284 00:31:47.690 ⇒ 00:31:49.330 Jasmin Multani: These cells.
285 00:31:51.150 ⇒ 00:31:54.389 Awaish Kumar: Exactly. So, for the raw, I don’t know if we are also…
286 00:31:54.990 ⇒ 00:32:01.090 Awaish Kumar: So the naming… this naming convention is not following what, would…
287 00:32:01.490 ⇒ 00:32:08.580 Awaish Kumar: Shivani told us. I’m not sure if we are concerned about Naming convention for raw sheets.
288 00:32:08.780 ⇒ 00:32:11.199 Awaish Kumar: If she’s looking at the raw sheets, I don’t know.
289 00:32:12.560 ⇒ 00:32:17.099 Jasmin Multani: I’m assuming she’s not looking at the raw sheets.
290 00:32:20.570 ⇒ 00:32:28.690 Jasmin Multani: But, actually, I guess she… because she’s getting a… she wants us to hire an analytics engineer.
291 00:32:28.960 ⇒ 00:32:33.260 Jasmin Multani: So… He might end up being…
292 00:32:33.850 ⇒ 00:32:36.159 Jasmin Multani: The person who tells her about these things.
293 00:32:36.360 ⇒ 00:32:41.430 Jasmin Multani: What would be the lift to change the POS sales to…
294 00:32:41.650 ⇒ 00:32:49.360 Awaish Kumar: Yeah, I don’t… like, it’s just the column names in this raw sheet. If you update that, I have to, like, I’m… I have to update it here as well.
295 00:32:49.710 ⇒ 00:32:52.060 Jasmin Multani: Okay, so can we just say…
296 00:32:52.660 ⇒ 00:32:57.700 Jasmin Multani: Point of sales with underscores in between, and then… What should we do for…
297 00:32:59.370 ⇒ 00:33:04.230 Awaish Kumar: Yeah, you can just say point of sale’s… With underscores, and then,
298 00:33:04.950 ⇒ 00:33:10.480 Awaish Kumar: NPOS units, and then I can update it here, and… my sink.
299 00:33:11.220 ⇒ 00:33:18.929 Jasmin Multani: Which tab is it in? Do we… does it say which tab?
300 00:33:20.650 ⇒ 00:33:22.060 Awaish Kumar: This is the terminal.
301 00:33:25.590 ⇒ 00:33:33.950 Jasmin Multani: Okay, Phil’s report, and then I’ll go in there, and then change the call. Okay. I’m gonna do it right now, just in case anything breaks.
302 00:33:37.010 ⇒ 00:33:38.120 Jasmin Multani: POS…
303 00:33:51.730 ⇒ 00:33:53.890 Jasmin Multani: I’m just scrolling and looking.
304 00:34:18.949 ⇒ 00:34:21.989 Jasmin Multani: Okay, I found it… just changing it right now.
305 00:34:22.989 ⇒ 00:34:25.609 Jasmin Multani: Oh, do I even have editing access?
306 00:34:29.429 ⇒ 00:34:31.229 Jasmin Multani: Yeah, I don’t think I have.
307 00:34:32.590 ⇒ 00:34:33.420 Awaish Kumar: Okay.
308 00:34:33.420 ⇒ 00:34:38.069 Jasmin Multani: This is locked. This tab is locked. Yeah, yeah, thank you.
309 00:34:41.570 ⇒ 00:34:43.999 Awaish Kumar: And what… what about this?
310 00:34:47.980 ⇒ 00:34:55.110 Jasmin Multani: Yeah, point of sales units, yeah, because, her analytics engineer might be… might be hired through us.
311 00:34:55.440 ⇒ 00:34:59.459 Jasmin Multani: But it sounds like she wants… she literally was like, I want someone on the end.
312 00:34:59.590 ⇒ 00:35:02.089 Jasmin Multani: to tell me about the raw data, and I’m like, okay.
313 00:35:02.400 ⇒ 00:35:03.879 Jasmin Multani: So he might catch this.
314 00:35:04.250 ⇒ 00:35:09.149 Jasmin Multani: So yeah, I think those are the two ones, right?
315 00:35:10.170 ⇒ 00:35:12.029 Awaish Kumar: Yeah, no, I have to change…
316 00:35:15.070 ⇒ 00:35:16.679 Jasmin Multani: Oh, sweet, easy.
317 00:35:18.200 ⇒ 00:35:19.429 Awaish Kumar: Okay, good picked up.
318 00:35:19.920 ⇒ 00:35:20.510 Jasmin Multani: Great.
319 00:35:20.940 ⇒ 00:35:31.399 Jasmin Multani: Okay, so from now, we have to… do we have to change the… Hard-coded names.
320 00:35:31.700 ⇒ 00:35:37.710 Awaish Kumar: Yeah, I don’t know, if anywhere it is using the names in formulas, then we have to change that.
321 00:35:38.120 ⇒ 00:35:40.699 Jasmin Multani: Okay, so let’s look that up.
322 00:35:46.730 ⇒ 00:35:51.410 Jasmin Multani: So that was called… Rock Phil’s report view model.
323 00:35:51.740 ⇒ 00:35:58.790 Jasmin Multani: Which tab is… is there a way to see, like, What are the downstream dependencies?
324 00:36:00.190 ⇒ 00:36:02.969 Awaish Kumar: Yeah, not easy to do that in Google Sheets.
325 00:36:04.290 ⇒ 00:36:07.919 Advait Nandakumar Menon: Yeah, in Excel, Microsoft Excel, it’s possible, but in Google Sheet, it’s…
326 00:36:08.930 ⇒ 00:36:11.490 Jasmin Multani: Chris, we have to manually do it, alright.
327 00:36:11.600 ⇒ 00:36:16.029 Jasmin Multani: Okay, fine, I’ll just go tab by tab.
328 00:36:19.170 ⇒ 00:36:20.630 Jasmin Multani: POS…
329 00:36:20.930 ⇒ 00:36:21.630 Awaish Kumar: Hmm.
330 00:36:34.530 ⇒ 00:36:35.810 Jasmin Multani: Those weren’t…
331 00:37:05.210 ⇒ 00:37:06.870 Jasmin Multani: Okay, yeah, view model…
332 00:37:24.520 ⇒ 00:37:25.410 Jasmin Multani: Hmm.
333 00:37:25.630 ⇒ 00:37:30.739 Jasmin Multani: Everything in the POS Retail Weekly Report just got changed to zero.
334 00:37:32.550 ⇒ 00:37:33.689 Awaish Kumar: So they… in which?
335 00:37:35.240 ⇒ 00:37:38.570 Jasmin Multani: The POS… look in the… oh, okay, now it’s fine.
336 00:37:39.540 ⇒ 00:37:41.080 Jasmin Multani: Is someone making edits?
337 00:37:42.170 ⇒ 00:37:42.960 Jasmin Multani: Okay.
338 00:37:44.180 ⇒ 00:37:47.540 Jasmin Multani: The POS Retail Weekly Report, now it looks fine.
339 00:37:52.930 ⇒ 00:37:56.080 Jasmin Multani: I’m just gonna go cell by cell to see if…
340 00:37:57.450 ⇒ 00:38:04.470 Jasmin Multani: Things are hard-coded, or if they’re just… dynamic.
341 00:38:26.660 ⇒ 00:38:31.409 Jasmin Multani: You know what we should have done? We should have saved a CV file before the change.
342 00:38:31.720 ⇒ 00:38:33.600 Jasmin Multani: And then compared the numbers.
343 00:38:34.740 ⇒ 00:38:35.469 Jasmin Multani: Got it.
344 00:38:39.340 ⇒ 00:38:39.970 Awaish Kumar: Yeah.
345 00:38:40.320 ⇒ 00:38:46.700 Awaish Kumar: POS Retail Daily Report and POS Retail Weekly Report. These two are the…
346 00:38:47.150 ⇒ 00:38:51.490 Awaish Kumar: sheets that I was using in the report.
347 00:38:51.490 ⇒ 00:38:59.450 Jasmin Multani: Now I’m just, like, checking cell by cell if there’s anything hard-coded.
348 00:38:59.830 ⇒ 00:39:02.970 Jasmin Multani: That relies on that POS labeling.
349 00:39:03.090 ⇒ 00:39:05.530 Jasmin Multani: I’m just trying to make sure things are dynamic.
350 00:39:05.680 ⇒ 00:39:12.820 Jasmin Multani: On this view, because I know that on the summary report, things aren’t… not everything is dynamic.
351 00:39:14.600 ⇒ 00:39:19.530 Jasmin Multani: And some things have to… we have to manually update them.
352 00:39:30.230 ⇒ 00:39:31.620 Jasmin Multani: That’s good.
353 00:39:42.560 ⇒ 00:39:43.440 Awaish Kumar: Okay.
354 00:39:46.610 ⇒ 00:39:54.149 Jasmin Multani: Yeah, Phil’s Retail Weekly Report looks good, or the POS Retail Weekly looks good. I’m gonna check the daily.
355 00:40:08.660 ⇒ 00:40:15.210 Advait Nandakumar Menon: Just confirming this, we don’t have revenue data of any kind within retail, right?
356 00:40:17.670 ⇒ 00:40:21.119 Jasmin Multani: Let me look it up on the data documentation.
357 00:40:21.840 ⇒ 00:40:25.409 Awaish Kumar: We don’t have revenue data, like, what that means?
358 00:40:25.790 ⇒ 00:40:26.740 Awaish Kumar: You mean.
359 00:40:27.770 ⇒ 00:40:28.600 Awaish Kumar: Do you know what I mean?
360 00:40:28.600 ⇒ 00:40:33.130 Advait Nandakumar Menon: Looking through your… I’m just looking through your changes, and…
361 00:40:33.730 ⇒ 00:40:40.860 Advait Nandakumar Menon: This is within the dbt project repository. It’s a validation SQL, and…
362 00:40:41.090 ⇒ 00:40:50.999 Advait Nandakumar Menon: I can see some lines where it says, basically, gross point of sales revenue. Does that make sense? Maybe I can.
363 00:40:51.900 ⇒ 00:40:53.620 Advait Nandakumar Menon: Send a screenshot.
364 00:40:53.800 ⇒ 00:40:59.280 Awaish Kumar: Yeah, that is just, like, the validation file, you can ignore that, like, we just added…
365 00:40:59.610 ⇒ 00:41:04.170 Awaish Kumar: We run that… we run these for tests, while developing.
366 00:41:04.170 ⇒ 00:41:04.760 Advait Nandakumar Menon: Mocha.
367 00:41:04.910 ⇒ 00:41:13.270 Awaish Kumar: not… it’s the… validations file. They don’t make any… Effect in our world.
368 00:41:13.900 ⇒ 00:41:16.429 Awaish Kumar: workflow. So, only the…
369 00:41:16.430 ⇒ 00:41:17.410 Advait Nandakumar Menon: Okay, okay.
370 00:41:17.410 ⇒ 00:41:19.380 Awaish Kumar: They are. They are really the…
371 00:41:19.830 ⇒ 00:41:21.790 Awaish Kumar: Ones we want to care about.
372 00:41:22.930 ⇒ 00:41:24.820 Advait Nandakumar Menon: Okay, just making sure, fine.
373 00:41:25.240 ⇒ 00:41:28.570 Jasmin Multani: Wait, so we should ignore growth revenue, is that what you’re saying?
374 00:41:32.030 ⇒ 00:41:38.860 Awaish Kumar: No, no, I’m just saying that anything which is not in dbt models, Is out of scope.
375 00:41:39.240 ⇒ 00:41:41.239 Awaish Kumar: For our project.
376 00:41:42.350 ⇒ 00:41:43.120 Jasmin Multani: Okay.
377 00:41:57.260 ⇒ 00:41:59.809 Jasmin Multani: dynamic on the daily report.
378 00:42:00.400 ⇒ 00:42:02.310 Jasmin Multani: Let me check the summary…
379 00:42:19.980 ⇒ 00:42:26.010 Jasmin Multani: Okay, so Phil’s… the raw data for Phil, Phil’s report
380 00:42:26.180 ⇒ 00:42:32.790 Jasmin Multani: the changes we made, I verified there. Now I want to verify the, the data value changes, right?
381 00:42:38.100 ⇒ 00:42:44.300 Awaish Kumar: Yeah, that is for… Retail, weekly.
382 00:42:44.830 ⇒ 00:42:54.160 Awaish Kumar: raw data point of sale, and retail monthly raw data point of sale. So these two tabs now have the updated data, with updated names for the
383 00:42:55.010 ⇒ 00:42:57.360 Awaish Kumar: metrics. POS metrics.
384 00:42:57.990 ⇒ 00:43:00.229 Awaish Kumar: You have to adopt that in the summary view.
385 00:43:00.870 ⇒ 00:43:09.229 Jasmin Multani: Yeah, I see that happening for, yeah, point-of-sales drinks, point of sales… Sparkling… let me,
386 00:43:10.760 ⇒ 00:43:16.150 Jasmin Multani: Okay, let me track the changes, so… FCT sales…
387 00:43:16.330 ⇒ 00:43:23.050 Jasmin Multani: now is FCT Point of Sales, and that’s the data table name. We should not expect that.
388 00:43:23.780 ⇒ 00:43:25.790 Jasmin Multani: Right? In the spreadsheets?
389 00:43:26.970 ⇒ 00:43:32.570 Awaish Kumar: Yeah, table names… table name changes might be relevant in Omni, not in Sheets.
390 00:43:32.870 ⇒ 00:43:38.479 Jasmin Multani: Okay, cool, cool, cool. So, I did just a point out there. And now I want to look at…
391 00:43:38.620 ⇒ 00:43:41.119 Jasmin Multani: I want to track for POS.
392 00:43:41.260 ⇒ 00:43:46.180 Jasmin Multani: revenue, that should now be gross PO… point of sales revenue.
393 00:43:46.760 ⇒ 00:43:51.979 Awaish Kumar: So, we are going away from revenue naming, right? Now it says point of sales.
394 00:43:52.910 ⇒ 00:43:58.880 Awaish Kumar: This is all… So yeah, we are not calling anything revenue, right? It’s all point of sales.
395 00:43:59.510 ⇒ 00:44:05.350 Awaish Kumar: It’s point of sales for drink mix, point of sales for sparkling, and overall point of sale.
396 00:44:07.390 ⇒ 00:44:09.709 Jasmin Multani: Okay, and that’s what… okay, no, it’s on.
397 00:44:09.990 ⇒ 00:44:12.740 Awaish Kumar: This is what made the change, right? Previously, it had…
398 00:44:13.560 ⇒ 00:44:19.720 Awaish Kumar: like, POS sales. Before that, it has… it had a name, like, POS Avenue, so it’s…
399 00:44:19.720 ⇒ 00:44:20.390 Advait Nandakumar Menon: Yeah.
400 00:44:20.560 ⇒ 00:44:21.380 Advait Nandakumar Menon: Yeah.
401 00:44:24.730 ⇒ 00:44:27.759 Advait Nandakumar Menon: Did you say… did you see revenue anywhere, Jasmine? I think…
402 00:44:29.480 ⇒ 00:44:34.559 Advait Nandakumar Menon: Whatever we saw last week or the week before you changed that row 16, that was the only…
403 00:44:34.560 ⇒ 00:44:37.040 Jasmin Multani: Yeah, I changed that. Yeah.
404 00:44:37.420 ⇒ 00:44:39.120 Jasmin Multani: I’m just, like, gone.
405 00:44:39.240 ⇒ 00:44:43.179 Jasmin Multani: the PR changes, and just making sure…
406 00:44:44.890 ⇒ 00:44:47.789 Jasmin Multani: With the names, like, what about this?
407 00:44:49.570 ⇒ 00:44:52.579 Jasmin Multani: retail FCT point of sales.
408 00:44:54.930 ⇒ 00:44:55.830 Awaish Kumar: Yeah.
409 00:44:55.830 ⇒ 00:44:56.630 Advait Nandakumar Menon: message.
410 00:44:56.630 ⇒ 00:44:59.010 Awaish Kumar: table name, right? This is the table name.
411 00:44:59.010 ⇒ 00:44:59.830 Jasmin Multani: Okay.
412 00:44:59.830 ⇒ 00:45:02.570 Awaish Kumar: In Sheets, it doesn’t, affect anything.
413 00:45:05.810 ⇒ 00:45:07.650 Jasmin Multani: Point of sales units…
414 00:45:08.690 ⇒ 00:45:09.950 Awaish Kumar: the… m.
415 00:45:10.410 ⇒ 00:45:11.539 Awaish Kumar: In the sheet.
416 00:45:12.580 ⇒ 00:45:14.210 Awaish Kumar: Unaffected.
417 00:45:14.680 ⇒ 00:45:18.540 Awaish Kumar: So… For example, like, in this state.
418 00:45:18.900 ⇒ 00:45:23.420 Awaish Kumar: This is affected, and in turn, it will affect your formulas.
419 00:45:23.710 ⇒ 00:45:28.680 Awaish Kumar: Similarly, this is affected, and then this name is affected, these three names.
420 00:45:29.210 ⇒ 00:45:37.460 Jasmin Multani: Retail gross point of sales… okay, cool, cool, cool. Yeah, let me check the… Summary, weekly summary.
421 00:45:39.270 ⇒ 00:45:41.610 Jasmin Multani: Report… just once more.
422 00:45:50.430 ⇒ 00:45:54.930 Jasmin Multani: Sorry, guys, I’m just a little paranoid, and I want to make sure things make sense.
423 00:45:55.420 ⇒ 00:46:02.960 Jasmin Multani: Okay, so… I’m looking at column EW, and I’m just gonna go down to make sure everything’s dynamic.
424 00:46:08.840 ⇒ 00:46:14.279 Jasmin Multani: Oh, yeah, retail? Look, yeah, so… If you look at Cell.
425 00:46:14.610 ⇒ 00:46:20.670 Jasmin Multani: EW15, that’s hard-coded. So, retail gross POS sales.
426 00:46:21.730 ⇒ 00:46:23.299 Awaish Kumar: Yeah, that’s what it is.
427 00:46:25.290 ⇒ 00:46:25.640 Jasmin Multani: So that.
428 00:46:25.640 ⇒ 00:46:29.789 Advait Nandakumar Menon: I would say on this tab, you have to find and replace.
429 00:46:30.020 ⇒ 00:46:30.900 Jasmin Multani: Yeah.
430 00:46:31.310 ⇒ 00:46:32.400 Advait Nandakumar Menon: Yeah, yeah.
431 00:46:32.830 ⇒ 00:46:35.880 Jasmin Multani: Let me… let me see on the slide.
432 00:46:36.850 ⇒ 00:46:42.280 Advait Nandakumar Menon: On the daily report and the weekly report tabs, it references Fields View, which is just the column
433 00:46:42.520 ⇒ 00:46:46.940 Advait Nandakumar Menon: Yeah. A column numbers that’s getting referenced, so that doesn’t matter.
434 00:46:47.670 ⇒ 00:46:51.089 Jasmin Multani: I’m gonna share screen. Yeah. I just wanted to make sure that, like.
435 00:46:52.190 ⇒ 00:47:01.700 Jasmin Multani: whether I should be seeing things when I hit the control, Okay, so let’s see… Do-do.
436 00:47:03.100 ⇒ 00:47:07.370 Jasmin Multani: find this, and I want to replace it with…
437 00:47:08.170 ⇒ 00:47:12.659 Advait Nandakumar Menon: The other annoying thing within Google Sheets is you can’t do a find all as well.
438 00:47:15.460 ⇒ 00:47:18.300 Jasmin Multani: No. What about replace all?
439 00:47:19.640 ⇒ 00:47:25.629 Advait Nandakumar Menon: Yeah, if you’re confident, like, just replacing it without just looking through it first, yeah, you can…
440 00:47:28.240 ⇒ 00:47:30.720 Jasmin Multani: Okay, let’s just try it.
441 00:47:33.080 ⇒ 00:47:39.280 Advait Nandakumar Menon: Yeah, I think you should search within formulas… Not sure about links.
442 00:47:41.140 ⇒ 00:47:42.350 Jasmin Multani: reviews…
443 00:47:45.830 ⇒ 00:47:47.779 Jasmin Multani: I won’t do a match case.
444 00:47:48.270 ⇒ 00:47:49.030 Awaish Kumar: Yeah, do that.
445 00:47:49.030 ⇒ 00:47:51.179 Advait Nandakumar Menon: I think just within formulas.
446 00:47:51.180 ⇒ 00:47:56.959 Awaish Kumar: Or what names are… Sca-sensitive, you can use that, and you can also use within formulas, and that’s all.
447 00:47:57.580 ⇒ 00:48:01.760 Jasmin Multani: Yeah, I’m just gonna do… Okay, I’m gonna hit place all.
448 00:48:07.500 ⇒ 00:48:09.030 Jasmin Multani: Oh, I’m just gonna wait.
449 00:48:11.700 ⇒ 00:48:15.380 Advait Nandakumar Menon: So, was the… all the rows, was it zero?
450 00:48:15.760 ⇒ 00:48:19.149 Advait Nandakumar Menon: Before, Jasmine, like, before you did this replay, sir?
451 00:48:19.510 ⇒ 00:48:23.649 Jasmin Multani: No, they weren’t. Some of them, had numbers in it. That was the thing.
452 00:48:23.960 ⇒ 00:48:30.280 Awaish Kumar: No, no, I mean, this sales became zero, because… It did not find that.
453 00:48:30.810 ⇒ 00:48:32.890 Awaish Kumar: metric in the raw data.
454 00:48:33.070 ⇒ 00:48:35.800 Advait Nandakumar Menon: Oh, yeah, the other ones might not be even referenced.
455 00:48:35.800 ⇒ 00:48:36.120 Awaish Kumar: Yeah.
456 00:48:36.120 ⇒ 00:48:39.460 Advait Nandakumar Menon: to sales, point of sales, that’s why, yeah. Okay, makes sense.
457 00:48:45.500 ⇒ 00:48:52.249 Jasmin Multani: Point of sales… Ring… Oh, so it updated all the sparkling stuff, too.
458 00:48:55.000 ⇒ 00:49:00.909 Advait Nandakumar Menon: Yeah, because… The point of sales, it’s hyphenated, right? So…
459 00:49:01.090 ⇒ 00:49:02.950 Awaish Kumar: No, no, don’t look at it.
460 00:49:03.220 ⇒ 00:49:06.299 Awaish Kumar: So we don’t need… Okay, yeah. Anything we don’t.
461 00:49:06.300 ⇒ 00:49:07.310 Jasmin Multani: Oh, sorry.
462 00:49:07.310 ⇒ 00:49:12.409 Awaish Kumar: But if you go to the sheet back… go back to the sheet, and you can see the…
463 00:49:12.600 ⇒ 00:49:13.919 Awaish Kumar: In the raw data?
464 00:49:15.000 ⇒ 00:49:18.600 Awaish Kumar: You can see the metric name for Sparkling Nentric Mix.
465 00:49:18.900 ⇒ 00:49:20.230 Awaish Kumar: That is a different name.
466 00:49:20.550 ⇒ 00:49:22.219 Awaish Kumar: Road number 17.
467 00:49:23.500 ⇒ 00:49:26.669 Jasmin Multani: Yeah, and because I just did a replacement.
468 00:49:26.670 ⇒ 00:49:29.510 Advait Nandakumar Menon: Search for point of sales, yeah, it replaced
469 00:49:29.910 ⇒ 00:49:33.699 Advait Nandakumar Menon: Row 15, as well as 17 and 18, yeah, whatever’s the…
470 00:49:35.080 ⇒ 00:49:38.709 Jasmin Multani: Let me just sanity check this one more time.
471 00:49:41.420 ⇒ 00:49:43.519 Jasmin Multani: No POS stuff.
472 00:49:45.160 ⇒ 00:49:48.490 Jasmin Multani: Gross prompt sales, gross prompt sales, cool.
473 00:49:50.430 ⇒ 00:49:52.950 Jasmin Multani: Scrum sales, awesome.
474 00:49:53.320 ⇒ 00:49:57.480 Jasmin Multani: So that was for weekly, I want to check it for quarterly.
475 00:49:57.910 ⇒ 00:49:59.549 Jasmin Multani: Just in case.
476 00:50:00.780 ⇒ 00:50:05.219 Jasmin Multani: Okay, so this is not hard-coded. I guess this relies on weekly.
477 00:50:05.990 ⇒ 00:50:11.940 Jasmin Multani: And then let’s… This one…
478 00:50:12.370 ⇒ 00:50:15.950 Jasmin Multani: Okay, cool, gross point of sales, gross point of sales, perfect.
479 00:50:16.240 ⇒ 00:50:16.760 Awaish Kumar: Correct.
480 00:50:17.620 ⇒ 00:50:24.770 Jasmin Multani: Gross pump sales, to-do-do… 1, 2, and 3. Perfect! Okay.
481 00:50:25.240 ⇒ 00:50:28.399 Jasmin Multani: Let me… Go to the sign, yeah?
482 00:50:28.530 ⇒ 00:50:31.040 Jasmin Multani: Things should look good, right?
483 00:50:34.070 ⇒ 00:50:34.700 Advait Nandakumar Menon: Yep.
484 00:50:35.840 ⇒ 00:50:38.400 Awaish Kumar: Is everything in Omni find?
485 00:50:39.800 ⇒ 00:50:47.609 Advait Nandakumar Menon: Yeah, I am doing the changes in Omni, so… Once I’m done with it, I’ll let you guys know.
486 00:50:47.610 ⇒ 00:50:48.330 Awaish Kumar: As for…
487 00:50:48.330 ⇒ 00:50:51.320 Advait Nandakumar Menon: The changes you’ve pushed yet, it looks… Bye.
488 00:50:51.320 ⇒ 00:50:54.529 Awaish Kumar: Okay, so, like, the topic changes that I did for…
489 00:50:54.860 ⇒ 00:51:00.089 Awaish Kumar: Did they normally, like, are they… they’re fine, or are you making more changes in the topics?
490 00:51:00.740 ⇒ 00:51:10.610 Advait Nandakumar Menon: There are some wherein it shows POS… like, that’s one of the files which wasn’t in the PR. I can probably do that change. It says…
491 00:51:10.770 ⇒ 00:51:15.679 Advait Nandakumar Menon: POS or whatever, and POS sales, I can do the… I can do the change. That’s fine.
492 00:51:24.250 ⇒ 00:51:25.909 Jasmin Multani: Was there a linear ticket for this?
493 00:51:29.560 ⇒ 00:51:30.300 Awaish Kumar: Good photo.
494 00:51:30.300 ⇒ 00:51:36.070 Advait Nandakumar Menon: I think it was one, you created for Avesh, I think, Justin, I think you assigned it to him.
495 00:51:37.370 ⇒ 00:51:38.030 Awaish Kumar: Yeah.
496 00:51:39.090 ⇒ 00:51:39.730 Awaish Kumar: So…
497 00:51:39.730 ⇒ 00:51:42.209 Advait Nandakumar Menon: I think it was 371, top of my head.
498 00:51:43.930 ⇒ 00:51:47.799 Awaish Kumar: So renaming is… there was a ticket for that, but yeah, not for this.
499 00:51:48.000 ⇒ 00:51:49.130 Awaish Kumar: Session.
500 00:51:50.110 ⇒ 00:51:53.100 Jasmin Multani: No worries, Dorian. I can just close that out.
501 00:52:03.690 ⇒ 00:52:07.969 Advait Nandakumar Menon: And the other thing, I think, Jasmine, like, I have to do is, so once…
502 00:52:08.120 ⇒ 00:52:12.950 Advait Nandakumar Menon: the retail reporting in Google Sheet is confirmed, the changes, I have to do the…
503 00:52:13.490 ⇒ 00:52:18.199 Advait Nandakumar Menon: Same within Omni, like, I have to re-import the new one, and…
504 00:52:22.000 ⇒ 00:52:24.600 Advait Nandakumar Menon: Maybe it’s worth creating tickets, yeah.
505 00:52:24.600 ⇒ 00:52:25.440 Jasmin Multani: Yeah.
506 00:52:27.030 ⇒ 00:52:29.610 Jasmin Multani: I mean, here’s a ticket that should be… oop!
507 00:52:30.740 ⇒ 00:52:36.209 Jasmin Multani: Here’s a ticket that should be cascading all of these, all of our changes. Yeah, that’s threesome.
508 00:52:36.210 ⇒ 00:52:37.030 Advait Nandakumar Menon: on the earth.
509 00:52:37.490 ⇒ 00:52:39.679 Jasmin Multani: Let me also share a screen.
510 00:52:41.080 ⇒ 00:52:43.439 Jasmin Multani: There’s one thing that was… I thought I was missing.
511 00:52:43.440 ⇒ 00:52:44.390 Awaish Kumar: won’t be here.
512 00:52:46.880 ⇒ 00:52:51.790 Awaish Kumar: Jasmine, like, you got access to Amazon? Can you see the orders?
513 00:52:53.340 ⇒ 00:53:03.330 Jasmin Multani: I was able to enter the portal, but, like, I didn’t know where else to go from there. But real quickly, I just wanted to double check.
514 00:53:03.960 ⇒ 00:53:09.990 Jasmin Multani: She also asked for… I think… These, specifically.
515 00:53:11.570 ⇒ 00:53:13.600 Jasmin Multani: This is… I think this is a separate ask.
516 00:53:16.380 ⇒ 00:53:20.889 Jasmin Multani: So, instead of this hyphen, I think she wanted it to be underscore.
517 00:53:23.490 ⇒ 00:53:23.790 Advait Nandakumar Menon: Oh.
518 00:53:26.370 ⇒ 00:53:28.890 Awaish Kumar: Okay.
519 00:53:29.780 ⇒ 00:53:36.339 Jasmin Multani: This should be a doable fix, right? But, like, for anything that’s unknown and other.
520 00:53:37.160 ⇒ 00:53:40.329 Awaish Kumar: Yeah, but these are not column names, I don’t understand, like…
521 00:53:40.330 ⇒ 00:53:41.530 Jasmin Multani: Conditions…
522 00:53:41.530 ⇒ 00:53:48.960 Awaish Kumar: Unknown is not a unknown. Like, if it is unknown, unknown, like, we just leave it… it is obviously calculated in…
523 00:53:49.640 ⇒ 00:53:51.130 Awaish Kumar: The final formula.
524 00:53:52.950 ⇒ 00:53:56.610 Jasmin Multani: Let’s see, she made a note on this.
525 00:54:08.760 ⇒ 00:54:09.920 Jasmin Multani: Yeah, these ones.
526 00:54:20.230 ⇒ 00:54:21.680 Jasmin Multani: That’s why I was like.
527 00:54:22.460 ⇒ 00:54:23.640 Awaish Kumar: in the metric.
528 00:54:24.470 ⇒ 00:54:26.400 Advait Nandakumar Menon: It comes within the metrics, yeah.
529 00:54:28.620 ⇒ 00:54:29.990 Awaish Kumar: Yeah, it’s…
530 00:54:29.990 ⇒ 00:54:35.439 Advait Nandakumar Menon: Within the metric… the data within the metric column in the summary tables is where this comes into me.
531 00:54:38.180 ⇒ 00:54:39.919 Jasmin Multani: Can I say data value?
532 00:54:39.920 ⇒ 00:54:43.619 Awaish Kumar: Yeah, it’s not… these are not column names, these are data values, basically.
533 00:54:43.620 ⇒ 00:54:47.980 Jasmin Multani: Yeah. Sorry, I cut this, like, last week, and I wasn’t sure what anything was.
534 00:54:47.980 ⇒ 00:54:51.390 Awaish Kumar: And for… in Omni, I don’t think we even need that, right?
535 00:54:55.450 ⇒ 00:54:57.629 Jasmin Multani: We’re gonna need that on the Omni sheets.
536 00:55:00.860 ⇒ 00:55:05.329 Awaish Kumar: But, like, in Omni, you can basically grab the…
537 00:55:05.490 ⇒ 00:55:09.910 Awaish Kumar: The raw data and do all this manipulation on top of it, right?
538 00:55:12.650 ⇒ 00:55:15.620 Jasmin Multani: You could, but not all the… but not all the…
539 00:55:16.080 ⇒ 00:55:25.300 Jasmin Multani: formulas roll over from Google Sheets to Omni, so it would be cleaner if we just went in and edited the same way we did.
540 00:55:26.520 ⇒ 00:55:28.579 Awaish Kumar: Okay, but, like…
541 00:55:29.070 ⇒ 00:55:38.549 Awaish Kumar: It is… it will be cleaner in terms of, like, making the change, but then, like, it will be hard to maintain those similar to…
542 00:55:38.670 ⇒ 00:55:40.850 Awaish Kumar: What we are maintaining in the spreadsheets.
543 00:55:44.100 ⇒ 00:55:48.929 Awaish Kumar: So why we are moving from spreadsheets to Omni is we want to…
544 00:55:51.620 ⇒ 00:55:52.370 Jasmin Multani: So, this.
545 00:55:52.370 ⇒ 00:55:54.209 Awaish Kumar: Oh, that’s a maintenance is…
546 00:55:54.930 ⇒ 00:56:02.580 Jasmin Multani: this is, like, even though we’re moving from Google Sheets to Omni, we’re… she hasn’t adopted Omni Sheets yet.
547 00:56:04.430 ⇒ 00:56:10.359 Awaish Kumar: Yeah, yeah, but what I’m trying to say is, like, when we are building in the OmniSheets.
548 00:56:10.570 ⇒ 00:56:14.559 Awaish Kumar: We can try to… Do some of the…
549 00:56:15.680 ⇒ 00:56:22.760 Awaish Kumar: Some of things in a better way, so that, like, it doesn’t break… it does not depend on the metric name and things.
550 00:56:22.760 ⇒ 00:56:24.020 Jasmin Multani: Oh, okay.
551 00:56:24.020 ⇒ 00:56:26.120 Awaish Kumar: thing to do in Google Sheet, like, it should be…
552 00:56:26.560 ⇒ 00:56:27.470 Jasmin Multani: dynamic.
553 00:56:27.470 ⇒ 00:56:29.299 Awaish Kumar: Dynamic, or something like that.
554 00:56:31.510 ⇒ 00:56:33.360 Jasmin Multani: Oh yeah, we can edit that.
555 00:56:34.020 ⇒ 00:56:35.090 Jasmin Multani: That’s fine.
556 00:56:35.520 ⇒ 00:56:36.200 Jasmin Multani: But…
557 00:56:36.200 ⇒ 00:56:40.379 Advait Nandakumar Menon: We are using the pre-aggregated tables in Omni for…
558 00:56:40.710 ⇒ 00:56:44.140 Advait Nandakumar Menon: The sheet and the visuals she requested, right?
559 00:56:44.430 ⇒ 00:56:49.210 Advait Nandakumar Menon: Jasmine, we are using the summary tables as the source, and that’s the one we are using in
560 00:56:49.650 ⇒ 00:56:51.250 Advait Nandakumar Menon: The topics as well.
561 00:56:52.550 ⇒ 00:56:57.400 Jasmin Multani: Yeah, we wanna… are you asking if we’re only rolling over the weekly?
562 00:56:57.700 ⇒ 00:57:01.349 Jasmin Multani: the… The summary report tab?
563 00:57:05.810 ⇒ 00:57:06.820 Advait Nandakumar Menon: No.
564 00:57:06.820 ⇒ 00:57:08.550 Jasmin Multani: Raise your question, my bad.
565 00:57:09.140 ⇒ 00:57:10.890 Advait Nandakumar Menon: Yeah, so…
566 00:57:11.620 ⇒ 00:57:20.429 Advait Nandakumar Menon: The metric names you see over here, it’s populated within the metric column of the summary tables, be it weekly, monthly, whatever.
567 00:57:22.510 ⇒ 00:57:32.089 Advait Nandakumar Menon: That summary table is what we are relying on right now, with an Omni as well, to build the Omni sheet, to build any visual of sorts.
568 00:57:32.950 ⇒ 00:57:33.590 Jasmin Multani: Yeah.
569 00:57:36.990 ⇒ 00:57:40.300 Jasmin Multani: This is correct. So what is the ask?
570 00:57:41.780 ⇒ 00:57:52.220 Advait Nandakumar Menon: So, the ask is that if you’re doing the change, like, the metric data should reflect this change, is what I’m trying to say. So, the metric…
571 00:57:52.540 ⇒ 00:57:55.759 Advait Nandakumar Menon: column is dependent for the Omni sheet to work.
572 00:57:57.380 ⇒ 00:58:04.129 Jasmin Multani: Yeah, so the, that’s what I was saying, I was like, oh, I’m gonna go in. It’s easier if I just go in and clean.
573 00:58:04.310 ⇒ 00:58:12.320 Jasmin Multani: the Omni sheets, row by row, like we just did, rather than, like, downloading XLS.
574 00:58:12.430 ⇒ 00:58:15.479 Jasmin Multani: Because not everything rolls over correctly.
575 00:58:17.350 ⇒ 00:58:18.050 Advait Nandakumar Menon: Okay.
576 00:58:18.400 ⇒ 00:58:20.889 Jasmin Multani: Yeah, mmm… let me do that right now.
577 00:58:22.990 ⇒ 00:58:26.539 Awaish Kumar: Okay, so this redone and renaming, she requested.
578 00:58:26.740 ⇒ 00:58:29.490 Awaish Kumar: Then it needs to be a separate ticket again.
579 00:58:30.140 ⇒ 00:58:32.589 Jasmin Multani: Yeah, so this ticket is cut.
580 00:58:36.340 ⇒ 00:58:38.890 Awaish Kumar: Like, okay, this… Okay.
581 00:58:38.890 ⇒ 00:58:41.729 Jasmin Multani: But, like, these ones are, I guess, done, because…
582 00:58:42.000 ⇒ 00:58:46.139 Awaish Kumar: No, like, this drink mix is parting these… these values.
583 00:58:46.260 ⇒ 00:58:48.580 Awaish Kumar: I’m not in this format, right?
584 00:58:49.180 ⇒ 00:58:53.949 Jasmin Multani: Yeah, it’s just these two that need to get redone, so I’ll just delete these, right?
585 00:58:53.950 ⇒ 00:58:54.550 Awaish Kumar: Yeah.
586 00:58:55.010 ⇒ 00:58:56.180 Jasmin Multani: I’ll delete this.
587 00:58:56.590 ⇒ 00:58:57.979 Jasmin Multani: And I’ll delete this.
588 00:59:02.310 ⇒ 00:59:04.779 Jasmin Multani: Should we do that right now, or separate time?
589 00:59:05.930 ⇒ 00:59:07.920 Awaish Kumar: I think we can do that right now.
590 00:59:08.380 ⇒ 00:59:14.520 Jasmin Multani: Okay, cool. I have to drop, because I need to talk to… Ashwini.
591 00:59:17.540 ⇒ 00:59:18.540 Jasmin Multani: Oh my god.
592 00:59:19.450 ⇒ 00:59:20.270 Awaish Kumar: Okay.
593 00:59:20.630 ⇒ 00:59:21.660 Awaish Kumar: They’re not.
594 00:59:22.750 ⇒ 00:59:26.410 Awaish Kumar: But if I make changes, it will fail the sheets.
595 00:59:28.350 ⇒ 00:59:30.699 Jasmin Multani: Okay, so should we set up another time, then?
596 00:59:31.430 ⇒ 00:59:32.840 Awaish Kumar: Yeah, sure.
597 00:59:32.840 ⇒ 00:59:34.850 Jasmin Multani: Okay, cool. Let’s set up another time.
598 00:59:35.400 ⇒ 00:59:36.580 Awaish Kumar: Okay, thank you.
599 00:59:37.550 ⇒ 00:59:40.329 Jasmin Multani: I need a drop, but yeah.
600 00:59:41.160 ⇒ 00:59:46.140 Awaish Kumar: Like, let us know if… if you… let me know if you’re stuck somewhere or need help.
601 00:59:46.820 ⇒ 00:59:47.940 Jasmin Multani: Oh, yeah.
602 00:59:47.940 ⇒ 00:59:50.049 Awaish Kumar: Let us know when it is done.
603 00:59:50.660 ⇒ 00:59:51.940 Jasmin Multani: Yeah, sounds good.
604 00:59:52.280 ⇒ 00:59:55.300 Jasmin Multani: I’ll find another time. Alright, take care. Bye.
605 00:59:55.770 ⇒ 00:59:56.610 Advait Nandakumar Menon: Thank goodness.