Meeting Title: Omni Dashboard Sync for Josh Date: 2026-03-06 Meeting participants: Awaish Kumar, Mustafa Raja, Uttam Kumaran, Demilade Agboola, Brylle Girang
WEBVTT
1 00:02:19.100 ⇒ 00:02:19.970 Mustafa Raja: P.
2 00:02:23.540 ⇒ 00:02:24.140 Awaish Kumar: Hello.
3 00:02:26.910 ⇒ 00:02:31.720 Awaish Kumar: Yeah, I’m just looking at the one more column we need for this dashboard.
4 00:02:32.220 ⇒ 00:02:32.810 Mustafa Raja: Which one?
5 00:02:34.300 ⇒ 00:02:35.479 Mustafa Raja: Which dashboard?
6 00:02:36.200 ⇒ 00:02:38.689 Awaish Kumar: Yeah, that’s what, for Josh.
7 00:02:40.010 ⇒ 00:02:40.700 Mustafa Raja: Oh.
8 00:02:41.340 ⇒ 00:02:43.340 Awaish Kumar: We don’t have this,
9 00:02:43.870 ⇒ 00:02:51.289 Awaish Kumar: So this is like this. We have product group and product. So, you are using correct one, this standardized product name.
10 00:02:51.650 ⇒ 00:02:54.180 Awaish Kumar: But we don’t actually have this thing.
11 00:02:55.290 ⇒ 00:02:59.330 Mustafa Raja: I don’t see… I don’t see it, though, in the…
12 00:02:59.580 ⇒ 00:03:05.180 Awaish Kumar: Yeah, it’s in… not in the table, we have to… this is, like, this is how in Tableau it’s happening.
13 00:03:05.660 ⇒ 00:03:08.169 Awaish Kumar: there is some feature called Group, and…
14 00:03:08.210 ⇒ 00:03:11.420 Mustafa Raja: We might be looking into different dashboards than…
15 00:03:12.440 ⇒ 00:03:13.890 Awaish Kumar: Sorry, which one you’re…
16 00:03:14.260 ⇒ 00:03:19.039 Mustafa Raja: Oh, okay, okay. Sorry, I was, I was in another one, sorry.
17 00:03:24.750 ⇒ 00:03:29.330 Awaish Kumar: Yeah, I’m gonna… let’s see… Here’s the…
18 00:03:31.390 ⇒ 00:03:34.199 Awaish Kumar: How to go back to the dashboard level?
19 00:03:36.080 ⇒ 00:03:39.710 Mustafa Raja: You’ll have to cross it, you know, at the top right.
20 00:03:48.670 ⇒ 00:03:50.679 Awaish Kumar: This, you can see, this is product group.
21 00:03:50.680 ⇒ 00:03:52.439 Mustafa Raja: Yeah, yeah, yeah, I can see it.
22 00:03:52.440 ⇒ 00:03:54.580 Awaish Kumar: sign, then you see the vote.
23 00:03:55.230 ⇒ 00:03:56.410 Mustafa Raja: Okay, okay, good.
24 00:03:56.980 ⇒ 00:04:02.300 Awaish Kumar: So we need to add this field, either… In Omni or in DBT?
25 00:04:03.690 ⇒ 00:04:04.810 Mustafa Raja: Yeah.
26 00:04:07.210 ⇒ 00:04:10.620 Mustafa Raja: I think it’ll ha… what are you thinking?
27 00:04:12.270 ⇒ 00:04:16.600 Awaish Kumar: I’m just thinking to copy this first. I’m not able to copy.
28 00:04:17.610 ⇒ 00:04:23.069 Mustafa Raja: Oh, would this be in, what’s it called, in the describe of product group?
29 00:04:25.300 ⇒ 00:04:27.800 Awaish Kumar: Sorry? No, it’s not in there.
30 00:04:29.250 ⇒ 00:04:32.300 Awaish Kumar: is a UI. I can’t copy values.
31 00:04:32.960 ⇒ 00:04:34.630 Mustafa Raja: Oh, so,
32 00:04:34.880 ⇒ 00:04:42.109 Mustafa Raja: Okay. I mean, if it’s a custom query, then Demi might be able to help us, because he has a Tableau desktop.
33 00:04:43.290 ⇒ 00:04:47.690 Mustafa Raja: And he’s able to, copy queries, if it’s a custom query.
34 00:04:48.810 ⇒ 00:04:55.650 Awaish Kumar: But I don’t know if it is a costume, because if you see here, It’s just,
35 00:04:55.870 ⇒ 00:04:57.010 Awaish Kumar: Or the group.
36 00:04:57.450 ⇒ 00:04:58.919 Awaish Kumar: I don’t know if it is a…
37 00:05:01.630 ⇒ 00:05:05.239 Awaish Kumar: So I don’t know what is… what this thing is.
38 00:05:06.590 ⇒ 00:05:12.239 Mustafa Raja: Oh… And what’s it… what does it say when we ask you to describe?
39 00:05:14.090 ⇒ 00:05:17.859 Awaish Kumar: When you describe it, it will just open the UI for you.
40 00:05:20.010 ⇒ 00:05:20.880 Mustafa Raja: Okay…
41 00:05:20.880 ⇒ 00:05:22.659 Awaish Kumar: It just says the name.
42 00:05:22.800 ⇒ 00:05:28.949 Awaish Kumar: this name, because this is the group on top of this one. But if you click on Edit.
43 00:05:29.530 ⇒ 00:05:32.189 Awaish Kumar: It can… it shows you how it is grouped.
44 00:05:33.740 ⇒ 00:05:41.990 Awaish Kumar: But it does… I just want to copy this so that… Like, a customer can… Create this curry.
45 00:05:46.740 ⇒ 00:05:47.420 Mustafa Raja: Hmm…
46 00:05:50.150 ⇒ 00:05:53.780 Awaish Kumar: Otherwise, I have to write all of this, right? I don’t want to write…
47 00:06:01.210 ⇒ 00:06:08.010 Mustafa Raja: Also, can you, can you help me out, you know, querying this, so I can double-check all of my stuff?
48 00:06:08.160 ⇒ 00:06:11.740 Mustafa Raja: Let me share my screen.
49 00:06:11.740 ⇒ 00:06:18.340 Awaish Kumar: Yeah, yeah, I want to add this first in the same table, so… and finally we do the QA at the end.
50 00:06:18.340 ⇒ 00:06:19.090 Mustafa Raja: Focus.
51 00:06:19.090 ⇒ 00:06:20.649 Awaish Kumar: This is a missing piece, right?
52 00:06:21.220 ⇒ 00:06:22.449 Mustafa Raja: Yeah, this is…
53 00:06:25.830 ⇒ 00:06:29.970 Awaish Kumar: And let’s… maybe then I can take… Teaching short.
54 00:06:37.460 ⇒ 00:06:38.220 Awaish Kumar: Mmm…
55 00:06:43.780 ⇒ 00:06:45.230 Awaish Kumar: We’re cough.
56 00:07:13.970 ⇒ 00:07:18.170 Awaish Kumar: Okay to follow this.
57 00:07:21.600 ⇒ 00:07:25.189 Awaish Kumar: Meanwhile, you can close whatever is pending on the dash.
58 00:07:25.430 ⇒ 00:07:29.500 Awaish Kumar: So… I can basically close this.
59 00:07:30.570 ⇒ 00:07:32.410 Awaish Kumar: And this is the important one.
60 00:07:46.480 ⇒ 00:07:47.013 Awaish Kumar: Thank you.
61 00:09:38.010 ⇒ 00:09:39.220 Awaish Kumar: Okay, let’s…
62 00:11:58.580 ⇒ 00:12:02.030 Awaish Kumar: Yeah, I just pushed a fix on this as well.
63 00:12:04.860 ⇒ 00:12:06.240 Awaish Kumar: I can watch this.
64 00:12:07.300 ⇒ 00:12:13.700 Awaish Kumar: Muswall, let Utam know that we have merged this. Is it… how this will sync with topics?
65 00:12:17.390 ⇒ 00:12:18.380 Awaish Kumar: Mustafa?
66 00:12:18.970 ⇒ 00:12:21.290 Mustafa Raja: Sorry, what, you’re saying something?
67 00:12:21.770 ⇒ 00:12:30.950 Awaish Kumar: Yeah, I have virtual PR. Okay, okay. How they will now reflect in Omni? Do you have to sync, or it will automatically sync in the topics?
68 00:12:31.090 ⇒ 00:12:37.200 Mustafa Raja: I think it automatically syncs, but I can refresh the connection myself.
69 00:12:37.700 ⇒ 00:12:38.090 Awaish Kumar: Okay.
70 00:12:38.090 ⇒ 00:12:40.319 Mustafa Raja: I do have the ability to do that.
71 00:12:40.670 ⇒ 00:12:43.310 Awaish Kumar: Yeah, refresh, maybe, and let Utam know that…
72 00:12:44.160 ⇒ 00:12:48.240 Awaish Kumar: You have merged it, and if you want to… Work on the dashboard.
73 00:12:49.170 ⇒ 00:12:50.550 Mustafa Raja: Yeah, okay.
74 00:12:51.620 ⇒ 00:12:55.400 Awaish Kumar: And then I want to push one more change in the data.
75 00:14:42.510 ⇒ 00:14:48.130 Mustafa Raja: Yeah, I’m wondering, when you’ll be ready to QA… .
76 00:14:48.130 ⇒ 00:14:50.539 Awaish Kumar: Pretty not pushing this change, right?
77 00:14:51.060 ⇒ 00:14:53.120 Mustafa Raja: This is for the dashboard.
78 00:14:54.760 ⇒ 00:14:58.490 Mustafa Raja: Okay, yeah, I’m just… I’m just doing my last things.
79 00:14:59.640 ⇒ 00:15:04.140 Awaish Kumar: Like, we just pushed this, we need to update the dash, and then we get to QA.
80 00:15:05.000 ⇒ 00:15:05.780 Mustafa Raja: Okay.
81 00:20:39.240 ⇒ 00:20:40.180 Awaish Kumar: Hmm.
82 00:20:41.160 ⇒ 00:20:42.649 Awaish Kumar: Okay, are you done?
83 00:20:45.470 ⇒ 00:20:46.680 Mustafa Raja: Yeah.
84 00:20:48.930 ⇒ 00:20:51.690 Awaish Kumar: I still see some of this red sign.
85 00:20:52.290 ⇒ 00:20:53.130 Mustafa Raja: Which one?
86 00:20:53.810 ⇒ 00:20:56.999 Awaish Kumar: Do you have unpublished changes? Yeah, it says red here.
87 00:20:57.180 ⇒ 00:21:04.850 Mustafa Raja: Oh, yeah, I’m just working on something, but we can… So, we can go ahead.
88 00:21:05.750 ⇒ 00:21:10.190 Awaish Kumar: I’m just seeing the different number for… For 60-day total orders.
89 00:21:14.710 ⇒ 00:21:22.460 Mustafa Raja: So, 60-day total order, wait, let me come back to the meeting. 60-day total order with BigQuery, or something else?
90 00:21:22.460 ⇒ 00:21:23.920 Awaish Kumar: Yeah, yeah, with Victory.
91 00:21:24.140 ⇒ 00:21:30.439 Awaish Kumar: We have, this… Right? It says…
92 00:21:33.230 ⇒ 00:21:34.020 Mustafa Raja: Yeah.
93 00:21:34.550 ⇒ 00:21:37.400 Awaish Kumar: 51,407.
94 00:21:38.150 ⇒ 00:21:40.879 Awaish Kumar: And it’s 51,100 self to die.
95 00:21:41.830 ⇒ 00:21:42.770 Mustafa Raja: Okay.
96 00:21:43.890 ⇒ 00:21:47.700 Mustafa Raja: Hmm… 51,470.
97 00:21:48.110 ⇒ 00:21:51.599 Mustafa Raja: And if you don’t delete this one, that’s messing up.
98 00:21:52.910 ⇒ 00:21:53.610 Awaish Kumar: Sorry?
99 00:21:53.990 ⇒ 00:21:56.129 Mustafa Raja: Is it only this one that’s messing up?
100 00:21:56.870 ⇒ 00:22:01.430 Awaish Kumar: Yeah, I don’t know, I just checked the one, it is… Feeling.
101 00:22:01.430 ⇒ 00:22:03.980 Mustafa Raja: The others, because,
102 00:22:04.640 ⇒ 00:22:11.839 Mustafa Raja: Let me, let me… let’s check others while I take a look at this, if I have the right topic for this.
103 00:22:16.290 ⇒ 00:22:18.350 Mustafa Raja: Oh, yeah, the topic is wrong, sorry.
104 00:22:22.750 ⇒ 00:22:24.399 Mustafa Raja: Let me get that.
105 00:23:19.760 ⇒ 00:23:20.430 Awaish Kumar: Hmm.
106 00:23:21.160 ⇒ 00:23:22.490 Awaish Kumar: This one.
107 00:23:22.770 ⇒ 00:23:25.219 Awaish Kumar: For $38 total dollars is also…
108 00:23:26.370 ⇒ 00:23:31.060 Mustafa Raja: Yeah, it could just be the, I might not be using the right topic.
109 00:23:37.890 ⇒ 00:23:39.140 Mustafa Raja: I’m getting that.
110 00:24:25.330 ⇒ 00:24:27.879 Mustafa Raja: Yeah, so 60 days should be good.
111 00:24:28.000 ⇒ 00:24:29.600 Mustafa Raja: If you refresh…
112 00:24:33.010 ⇒ 00:24:37.239 Mustafa Raja: And then you said 30-day was also bad? Let me take a look…
113 00:25:04.910 ⇒ 00:25:09.690 Mustafa Raja: Hmm, 30-day one is actually using the right… Don’t pick.
114 00:25:11.710 ⇒ 00:25:13.800 Awaish Kumar: Hmm, listen, the number is a little bit…
115 00:25:14.090 ⇒ 00:25:19.759 Awaish Kumar: higher than Victory. It is 26,176.
116 00:25:20.180 ⇒ 00:25:28.699 Awaish Kumar: And… I’m actually… Can you compare that dates are correct?
117 00:25:31.360 ⇒ 00:25:32.173 Mustafa Raja: Excuse me.
118 00:25:32.580 ⇒ 00:25:33.140 Awaish Kumar: Feb?
119 00:25:33.310 ⇒ 00:25:35.160 Awaish Kumar: Until yesterday.
120 00:25:38.440 ⇒ 00:25:39.810 Awaish Kumar: It’s a 160.
121 00:25:41.490 ⇒ 00:25:51.460 Mustafa Raja: So it says 26,000, 26,160. It’s 176 over here. Okay, let me… let me see…
122 00:25:53.040 ⇒ 00:25:55.960 Awaish Kumar: Yeah, you can verify the dates and the filters.
123 00:25:56.690 ⇒ 00:25:57.420 Mustafa Raja: Okay.
124 00:26:01.130 ⇒ 00:26:07.959 Mustafa Raja: So, it’s, from… February 4th till March 5th.
125 00:26:10.890 ⇒ 00:26:12.150 Mustafa Raja: And then…
126 00:26:26.410 ⇒ 00:26:29.790 Mustafa Raja: Okay, it’s 1… it should be 160 now.
127 00:26:35.690 ⇒ 00:26:37.900 Mustafa Raja: Yeah, maybe, you know…
128 00:26:38.490 ⇒ 00:26:40.260 Awaish Kumar: Yeah, what is the… what was the issue?
129 00:26:40.800 ⇒ 00:26:43.020 Mustafa Raja: Oh yeah, I was missing some filter.
130 00:26:44.590 ⇒ 00:26:47.199 Awaish Kumar: Okay, let’s see now the revenue.
131 00:27:04.390 ⇒ 00:27:08.449 Mustafa Raja: Which, how, which one are we looking into?
132 00:27:09.650 ⇒ 00:27:11.970 Awaish Kumar: We’re looking at the monthly revenue, right?
133 00:27:12.670 ⇒ 00:27:13.480 Mustafa Raja: Yeah.
134 00:27:14.530 ⇒ 00:27:18.299 Awaish Kumar: It’s a little bit higher in the… In the dashboard.
135 00:27:23.560 ⇒ 00:27:35.639 Mustafa Raja: Wait, yeah, it’s just that, the… what’s it called? The filter, current status does not show canceled and, okay.
136 00:27:36.360 ⇒ 00:27:45.510 Mustafa Raja: And we have to manually write it out, in the filter. So, yeah, yeah, if you remove that, you’ll see that the values would match.
137 00:27:50.350 ⇒ 00:27:51.120 Uttam Kumaran: Yes.
138 00:27:55.100 ⇒ 00:27:56.969 Uttam Kumaran: Okay, so there’s some…
139 00:27:57.540 ⇒ 00:28:02.599 Uttam Kumaran: Visual updates too, so I’m just gonna invite Robert here so we can all work on this.
140 00:28:04.980 ⇒ 00:28:05.610 Mustafa Raja: Yep.
141 00:28:07.140 ⇒ 00:28:08.859 Awaish Kumar: Yeah, can you… it’s…
142 00:28:10.380 ⇒ 00:28:14.339 Mustafa Raja: Yeah, so, which, for which one was it? So, 30-day revenue, right?
143 00:28:14.340 ⇒ 00:28:16.980 Awaish Kumar: Yes, this is 30-day revenue, and…
144 00:28:18.640 ⇒ 00:28:22.060 Awaish Kumar: The revenue is a little bit for now.
145 00:28:23.240 ⇒ 00:28:24.230 Awaish Kumar: In here.
146 00:28:24.860 ⇒ 00:28:26.680 Mustafa Raja: Wait…
147 00:28:30.570 ⇒ 00:28:34.310 Mustafa Raja: This one should have canceled an error too, sorry.
148 00:28:34.440 ⇒ 00:28:37.399 Mustafa Raja: In the filters. Can you do that?
149 00:28:38.120 ⇒ 00:28:40.189 Awaish Kumar: But that’s okay, right? That’s…
150 00:28:41.230 ⇒ 00:28:44.670 Mustafa Raja: No, no, that does, does create some sort of change.
151 00:28:45.210 ⇒ 00:28:52.610 Mustafa Raja: It’s just, I don’t know why it’s not appearing as filters in Omni, but if we do add them, it does create a change.
152 00:28:54.580 ⇒ 00:28:55.680 Mustafa Raja: Can…
153 00:28:56.250 ⇒ 00:28:58.959 Awaish Kumar: It does not even exist in this table.
154 00:29:11.600 ⇒ 00:29:14.930 Awaish Kumar: Cancel the error, not even part of this team.
155 00:29:16.660 ⇒ 00:29:18.130 Awaish Kumar: So we can ignore that.
156 00:29:19.690 ⇒ 00:29:23.050 Mustafa Raja: Okay, so we can ignore one, okay.
157 00:29:25.560 ⇒ 00:29:29.229 Mustafa Raja: Yeah, so, yeah, can I share my screen, actually?
158 00:29:29.740 ⇒ 00:29:30.280 Awaish Kumar: Yep.
159 00:29:35.790 ⇒ 00:29:38.949 Mustafa Raja: Wait, give me a moment… I’m sharing my screen.
160 00:29:40.750 ⇒ 00:29:48.249 Mustafa Raja: So, so you see that, here, the filters wouldn’t, wouldn’t appear, right? For canceled and error, right?
161 00:29:50.220 ⇒ 00:29:51.820 Awaish Kumar: Maybe you’re using the…
162 00:29:52.990 ⇒ 00:29:55.510 Mustafa Raja: But if I remove them, this value is going to change.
163 00:29:56.060 ⇒ 00:29:57.079 Awaish Kumar: No, it’s correct.
164 00:29:57.960 ⇒ 00:30:02.739 Mustafa Raja: Yeah, so I don’t know why it’s not a pairing, but the value does get affected.
165 00:30:06.940 ⇒ 00:30:09.589 Awaish Kumar: Okay, can I click again on current status?
166 00:30:12.000 ⇒ 00:30:14.579 Awaish Kumar: No, it doesn’t appear here, right? So that.
167 00:30:14.580 ⇒ 00:30:15.560 Mustafa Raja: Yeah, so…
168 00:30:15.920 ⇒ 00:30:17.659 Awaish Kumar: Okay, it’s fine, mate.
169 00:30:19.430 ⇒ 00:30:20.469 Awaish Kumar: This is correct.
170 00:30:21.520 ⇒ 00:30:25.099 Mustafa Raja: Okay, yeah, so, what I,
171 00:30:26.220 ⇒ 00:30:33.380 Mustafa Raja: what I’m going to do is… then these ones should also not have the… have these, right?
172 00:30:33.870 ⇒ 00:30:34.440 Awaish Kumar: Yep.
173 00:30:35.040 ⇒ 00:30:37.929 Mustafa Raja: Okay, let me remove from… let me remove this from all.
174 00:30:43.410 ⇒ 00:30:45.599 Mustafa Raja: Let me see what does…
175 00:31:10.760 ⇒ 00:31:11.690 Mustafa Raja: Okay.
176 00:31:12.290 ⇒ 00:31:14.970 Mustafa Raja: Okay, can we… can we… can you check further?
177 00:31:15.320 ⇒ 00:31:17.090 Mustafa Raja: Can we do further QA?
178 00:31:18.250 ⇒ 00:31:18.835 Awaish Kumar: Yes…
179 00:31:28.720 ⇒ 00:31:33.030 Uttam Kumaran: Okay, let’s fix all the structural issues, and then we can do aesthetics.
180 00:31:35.160 ⇒ 00:31:36.110 Mustafa Raja: Okay.
181 00:31:43.810 ⇒ 00:31:44.620 Awaish Kumar: And that’s fine.
182 00:31:44.620 ⇒ 00:31:46.170 Mustafa Raja: Make sure you share your screen?
183 00:31:50.660 ⇒ 00:31:56.799 Awaish Kumar: Okay… Okay, the, the, these ones, revenue and…
184 00:31:57.400 ⇒ 00:32:00.840 Awaish Kumar: Or this looks fine, let’s see the new revenue.
185 00:32:21.790 ⇒ 00:32:22.980 Mustafa Raja: Yeah, this is good, no.
186 00:32:25.600 ⇒ 00:32:27.790 Awaish Kumar: Let’s see, for 30 days.
187 00:32:37.720 ⇒ 00:32:40.740 Awaish Kumar: Oh, this is presumably for me.
188 00:32:41.220 ⇒ 00:32:42.950 Mustafa Raja: Which one is this?
189 00:32:43.210 ⇒ 00:32:48.979 Mustafa Raja: 60-day one, let me, let me take a look what’s happening. 60-day one is…
190 00:32:53.000 ⇒ 00:33:05.649 Mustafa Raja: I don’t know why… so this is a lot lower here in BigQuery. If you would take a look at the one that’s in Tableau, the value that we have is a lot closer to that.
191 00:33:09.050 ⇒ 00:33:12.720 Mustafa Raja: So it’s 2, 2.199, right?
192 00:33:12.860 ⇒ 00:33:16.339 Mustafa Raja: And in Omni, we have two…
193 00:33:17.370 ⇒ 00:33:19.630 Mustafa Raja: Oh, you’re talking about 30 days, sorry.
194 00:33:19.630 ⇒ 00:33:21.860 Awaish Kumar: I thought we were talking about the…
195 00:33:32.360 ⇒ 00:33:35.729 Awaish Kumar: This is 1.13, and we have 1.
196 00:33:36.050 ⇒ 00:33:37.120 Awaish Kumar: 1-5.
197 00:33:42.220 ⇒ 00:33:48.690 Mustafa Raja: Let me look at the dates in the past. Oh, yeah, it’s just, we, I was adding one more day.
198 00:33:49.880 ⇒ 00:33:52.380 Mustafa Raja: It should be 1.15 now.
199 00:33:53.750 ⇒ 00:33:54.950 Mustafa Raja: Not published yet.
200 00:33:59.800 ⇒ 00:34:00.480 Awaish Kumar: Okay.
201 00:34:02.570 ⇒ 00:34:05.729 Awaish Kumar: Okay, that looks fine. Then what is missing?
202 00:34:07.810 ⇒ 00:34:09.479 Awaish Kumar: Couple of the remaining orders.
203 00:34:17.310 ⇒ 00:34:21.009 Awaish Kumar: Okay, let’s, then I’m going to merge this, let’s add this as well.
204 00:34:22.060 ⇒ 00:34:22.830 Mustafa Raja: Okay.
205 00:34:23.219 ⇒ 00:34:26.739 Awaish Kumar: The column name… new column name should be in different products.
206 00:34:26.889 ⇒ 00:34:28.989 Awaish Kumar: And it’s called Product Group.
207 00:34:29.790 ⇒ 00:34:30.610 Mustafa Raja: Okay.
208 00:35:20.210 ⇒ 00:35:26.490 Mustafa Raja: While that’s going on, we could take a look at the bottom one, you know? There are two charts at the bottom.
209 00:35:28.500 ⇒ 00:35:29.310 Awaish Kumar: Okay.
210 00:35:31.380 ⇒ 00:35:37.369 Uttam Kumaran: I’m, I’m gonna work on the unit economics, some of the charting, issues now, so I’ll just be working on that.
211 00:35:41.630 ⇒ 00:35:43.120 Awaish Kumar: Okay,
212 00:35:53.700 ⇒ 00:35:55.510 Awaish Kumar: What is choosing?
213 00:35:57.130 ⇒ 00:35:58.730 Mustafa Raja: conviction on the topic?
214 00:36:00.450 ⇒ 00:36:02.730 Mustafa Raja: Yeah, it’s the same fact transaction.
215 00:36:06.130 ⇒ 00:36:09.019 Mustafa Raja: The table is the same fact transaction table.
216 00:36:11.550 ⇒ 00:36:13.989 Awaish Kumar: 5, and the March 4th.
217 00:36:14.260 ⇒ 00:36:18.410 Mustafa Raja: The past 8 days, excluding today.
218 00:36:19.700 ⇒ 00:36:20.330 Awaish Kumar: Okay.
219 00:37:28.960 ⇒ 00:37:30.500 Awaish Kumar: Man, this is different.
220 00:37:31.330 ⇒ 00:37:33.170 Mustafa Raja: Can you go back to Dent?
221 00:37:33.940 ⇒ 00:37:35.170 Mustafa Raja: Bigquery?
222 00:37:36.580 ⇒ 00:37:39.930 Mustafa Raja: So… it’s 190 there.
223 00:37:51.430 ⇒ 00:37:59.220 Mustafa Raja: Oh, I guess I could add… I could add the photo…
224 00:38:03.750 ⇒ 00:38:07.979 Mustafa Raja: Okay, so, does the query has the filter abandoned orders?
225 00:38:08.160 ⇒ 00:38:14.060 Mustafa Raja: Because I don’t think that we are filtering that in Tableau. Let me confirm that.
226 00:38:14.830 ⇒ 00:38:18.089 Awaish Kumar: I’m not looking at the table, I’m just comparing how many words is this.
227 00:38:18.660 ⇒ 00:38:25.149 Mustafa Raja: Okay, yeah, but I’m wondering if the abandoned filter is there, you know, at all, you know?
228 00:38:26.010 ⇒ 00:38:29.439 Mustafa Raja: Yeah, it’s not in there, so we should remove that and then check, no?
229 00:38:32.330 ⇒ 00:38:34.760 Awaish Kumar: Okay, so you’re saying they don’t use…
230 00:38:35.200 ⇒ 00:38:41.949 Mustafa Raja: Yeah, so in here, yeah, in here, the status filter isn’t there, isn’t in, you know, isn’t in place.
231 00:38:45.570 ⇒ 00:38:46.110 Awaish Kumar: Okay.
232 00:38:54.130 ⇒ 00:38:56.060 Awaish Kumar: Okay, let’s do this.
233 00:39:05.020 ⇒ 00:39:06.130 Awaish Kumar: 9 to the U.
234 00:39:07.870 ⇒ 00:39:09.139 Mustafa Raja: This should be good.
235 00:39:11.630 ⇒ 00:39:12.819 Awaish Kumar: won’t find that.
236 00:39:13.830 ⇒ 00:39:15.539 Awaish Kumar: I can see the…
237 00:39:24.100 ⇒ 00:39:26.549 Mustafa Raja: Each order number, okay, distinct.
238 00:39:38.610 ⇒ 00:39:39.780 Awaish Kumar: That looks funny.
239 00:39:41.860 ⇒ 00:39:47.779 Mustafa Raja: Okay, let me… let me get the… let me get the new column.
240 00:39:48.150 ⇒ 00:39:50.529 Mustafa Raja: Then we can move further.
241 00:39:51.760 ⇒ 00:39:55.160 Awaish Kumar: Okay, actually it’s still running, so it’s not refreshing.
242 00:39:56.320 ⇒ 00:39:57.350 Mustafa Raja: Oh, okay, okay.
243 00:39:58.390 ⇒ 00:40:02.620 Mustafa Raja: And this would go into staging, or… or this would go into the main one?
244 00:40:03.400 ⇒ 00:40:04.150 Awaish Kumar: What?
245 00:40:05.440 ⇒ 00:40:08.559 Mustafa Raja: The model, is it going to…
246 00:40:08.560 ⇒ 00:40:11.780 Awaish Kumar: It’s going to the production, so I just watch the video.
247 00:40:12.580 ⇒ 00:40:13.280 Mustafa Raja: Okay, okay.
248 00:40:31.000 ⇒ 00:40:33.880 Awaish Kumar: Will we be able to help do this?
249 00:40:34.220 ⇒ 00:40:36.599 Awaish Kumar: Like, in this thing in the…
250 00:40:39.110 ⇒ 00:40:44.020 Mustafa Raja: So you’re saying that can we, can we group like this, right?
251 00:40:44.590 ⇒ 00:40:45.240 Awaish Kumar: Yes.
252 00:40:45.510 ⇒ 00:40:46.619 Mustafa Raja: Yeah, I believe we can.
253 00:40:47.170 ⇒ 00:40:51.500 Awaish Kumar: So we have a… I added this product group column, we have a product column.
254 00:40:51.670 ⇒ 00:40:58.349 Awaish Kumar: So, as you see here, We see the one group, and two, these values and different revenue.
255 00:40:58.620 ⇒ 00:41:02.319 Awaish Kumar: Once we close this, it shows the total of both.
256 00:41:02.700 ⇒ 00:41:03.570 Awaish Kumar: Indigo.
257 00:41:04.940 ⇒ 00:41:05.640 Mustafa Raja: Yep.
258 00:41:09.780 ⇒ 00:41:11.300 Awaish Kumar: You don’t make sure that.
259 00:41:19.360 ⇒ 00:41:27.590 Mustafa Raja: Yeah, I believe I did, something similar for… One of the… Chance? So…
260 00:41:29.070 ⇒ 00:41:30.439 Mustafa Raja: Yeah, it should be possible.
261 00:41:38.230 ⇒ 00:41:39.260 Awaish Kumar: Bruce.
262 00:42:17.590 ⇒ 00:42:20.250 Awaish Kumar: Can we rename this to just product?
263 00:42:22.900 ⇒ 00:42:24.840 Awaish Kumar: I’d like to upload.
264 00:42:26.670 ⇒ 00:42:32.529 Mustafa Raja: Oh yeah, we can… we can do that. We can do that within Omni. We don’t have to do it with…
265 00:42:33.500 ⇒ 00:42:35.290 Mustafa Raja: Yeah, let me do that then.
266 00:42:54.840 ⇒ 00:42:56.000 Mustafa Raja: Should be good now.
267 00:45:03.970 ⇒ 00:45:04.660 Awaish Kumar: Thank you.
268 00:45:13.640 ⇒ 00:45:14.620 Awaish Kumar: Okay.
269 00:45:30.600 ⇒ 00:45:32.369 Awaish Kumar: If I’m curious, I’m worse.
270 00:45:34.150 ⇒ 00:45:34.830 Mustafa Raja: Sorry?
271 00:45:35.870 ⇒ 00:45:39.449 Awaish Kumar: I said we can QA the numbers, basically.
272 00:45:40.580 ⇒ 00:45:42.470 Awaish Kumar: And join this…
273 00:47:59.360 ⇒ 00:48:01.580 Awaish Kumar: Something a little bit… different.
274 00:48:03.100 ⇒ 00:48:04.109 Mustafa Raja: Which one?
275 00:48:04.820 ⇒ 00:48:06.429 Awaish Kumar: Injectable seminars yesterday.
276 00:48:06.430 ⇒ 00:48:09.869 Mustafa Raja: What’s, what’s coming up?
277 00:48:10.480 ⇒ 00:48:14.119 Awaish Kumar: The number is 118K.
278 00:48:15.070 ⇒ 00:48:17.440 Mustafa Raja: 118… okay.
279 00:48:18.920 ⇒ 00:48:20.649 Mustafa Raja: 118 in for this.
280 00:48:21.410 ⇒ 00:48:28.910 Mustafa Raja: Okay, I believe, it’s because of the topic. I’m transferring this to… to the… to the new one.
281 00:48:37.140 ⇒ 00:48:38.870 Mustafa Raja: Total revenue…
282 00:48:42.490 ⇒ 00:48:43.530 Mustafa Raja: Alrighty.
283 00:48:51.410 ⇒ 00:48:55.540 Awaish Kumar: Yeah, this one is also… Done. Complete.
284 00:48:55.810 ⇒ 00:48:58.469 Awaish Kumar: You can add the product group as well.
285 00:48:59.580 ⇒ 00:49:04.800 Mustafa Raja: Let me just… And, You know.
286 00:49:05.630 ⇒ 00:49:07.399 Mustafa Raja: Probably been in my day.
287 00:49:12.800 ⇒ 00:49:15.090 Mustafa Raja: Give me a moment, Aranda.
288 00:49:34.040 ⇒ 00:49:36.549 Mustafa Raja: Okay, let me share my screen.
289 00:49:41.950 ⇒ 00:49:52.190 Mustafa Raja: with this new… when I’m transferring this to a new topic, it’s also coming as, you know, 116, whereas it should be 118, right?
290 00:49:53.700 ⇒ 00:49:57.850 Mustafa Raja: This is the query that I’m making.
291 00:50:02.680 ⇒ 00:50:04.100 Awaish Kumar: Oh. Okay.
292 00:50:04.100 ⇒ 00:50:07.100 Mustafa Raja: Maybe let me remove this.
293 00:50:08.760 ⇒ 00:50:11.279 Mustafa Raja: Because this does not exist.
294 00:50:12.390 ⇒ 00:50:17.889 Awaish Kumar: Oh, we are… okay, I’m also… I’m also deleting the…
295 00:50:19.720 ⇒ 00:50:23.560 Awaish Kumar: Is abandoned being used here in Tableau, or not?
296 00:50:24.990 ⇒ 00:50:27.380 Mustafa Raja: Oh, wait, let me see, I didn’t do that.
297 00:50:27.380 ⇒ 00:50:30.020 Awaish Kumar: So I’m using a pin and filter for this.
298 00:50:30.400 ⇒ 00:50:31.800 Mustafa Raja: Let me check, let me check.
299 00:50:33.620 ⇒ 00:50:35.279 Mustafa Raja: I didn’t check that…
300 00:50:36.190 ⇒ 00:50:38.210 Awaish Kumar: Yeah, I can see that.
301 00:50:39.560 ⇒ 00:50:42.599 Mustafa Raja: Oh yeah, they’re not using that. They’re not using that at all.
302 00:50:43.040 ⇒ 00:50:44.200 Awaish Kumar: Can’t wait.
303 00:50:44.860 ⇒ 00:50:54.190 Mustafa Raja: Let me go back to the… Query, and let me remove… Filter… Note in…
304 00:51:12.380 ⇒ 00:51:14.570 Mustafa Raja: Mmm… Event.
305 00:51:21.940 ⇒ 00:51:24.560 Mustafa Raja: Should I, should I just remove all of this?
306 00:51:28.480 ⇒ 00:51:30.040 Awaish Kumar: Yeah, that’s…
307 00:51:38.320 ⇒ 00:51:40.510 Mustafa Raja: Okay, is this it?
308 00:51:41.350 ⇒ 00:51:47.030 Awaish Kumar: Let’s use the same things as Tableau, and we can discuss that internally with Robert afterwards.
309 00:51:50.490 ⇒ 00:51:50.980 Awaish Kumar: Okay.
310 00:51:53.070 ⇒ 00:51:56.709 Mustafa Raja: Wait, so, total revenue ID…
311 00:52:01.570 ⇒ 00:52:04.320 Awaish Kumar: It should be around 118K.
312 00:52:08.810 ⇒ 00:52:12.500 Mustafa Raja: It says that these two, but these two really doesn’t exist, so it doesn’t matter.
313 00:52:12.900 ⇒ 00:52:17.170 Mustafa Raja: It is 118… Kido.
314 00:52:18.900 ⇒ 00:52:21.950 Mustafa Raja: What’s coming up in, record card?
315 00:52:22.170 ⇒ 00:52:23.490 Mustafa Raja: BigQueny?
316 00:52:23.770 ⇒ 00:52:26.269 Awaish Kumar: It’s 118K, that’s what is coming.
317 00:52:27.550 ⇒ 00:52:29.500 Mustafa Raja: Yeah, so I have that in here.
318 00:52:35.020 ⇒ 00:52:36.169 Awaish Kumar: Can I refresh?
319 00:52:37.330 ⇒ 00:52:40.299 Mustafa Raja: Oh, no, no, I haven’t published it, so you would be able to see it.
320 00:52:42.130 ⇒ 00:52:48.210 Demilade Agboola: So data has to match BigQuery, because Tableau is, you know, a morning extract, so it might be out of date.
321 00:52:50.570 ⇒ 00:52:52.879 Awaish Kumar: Let’s publish, and let’s… let me check.
322 00:53:10.710 ⇒ 00:53:17.389 Uttam Kumaran: Demi, is it in… in… in Omni, can you set, like, auto formats? Like, can I all… can I somewhere in the settings be like.
323 00:53:17.810 ⇒ 00:53:20.539 Uttam Kumaran: Never do more than 2 decibels, stuff like that.
324 00:53:20.880 ⇒ 00:53:21.520 Uttam Kumaran: Smalls.
325 00:53:22.920 ⇒ 00:53:25.120 Mustafa Raja: Yeah, we can do that.
326 00:53:26.330 ⇒ 00:53:28.979 Mustafa Raja: Hmm, let me show you a good example of that.
327 00:53:29.820 ⇒ 00:53:32.560 Uttam Kumaran: That’s fine, I can find it, but I just don’t wanna know.
328 00:53:33.050 ⇒ 00:53:36.210 Mustafa Raja: Yeah, so in here, in the labels, we can set the.
329 00:53:36.210 ⇒ 00:53:37.650 Uttam Kumaran: But, like, no, globally.
330 00:53:38.570 ⇒ 00:53:43.560 Mustafa Raja: Globally, oh, yeah, we’ll have to look into the documentation without them.
331 00:53:44.110 ⇒ 00:53:47.050 Demilade Agboola: I’m not sure about globally, but yeah, for the individual ones.
332 00:53:47.670 ⇒ 00:53:48.250 Uttam Kumaran: Okay.
333 00:53:50.030 ⇒ 00:53:52.319 Uttam Kumaran: Because we have a style guide now, so I’m like…
334 00:53:52.440 ⇒ 00:53:53.450 Awaish Kumar: Okay, that’s fine.
335 00:53:53.450 ⇒ 00:53:54.050 Uttam Kumaran: or something.
336 00:53:57.350 ⇒ 00:54:00.309 Awaish Kumar: Okay, can you also include the product group?
337 00:54:02.410 ⇒ 00:54:04.180 Mustafa Raja: Yeah,
338 00:54:13.130 ⇒ 00:54:14.450 Mustafa Raja: Let me refresh…
339 00:54:22.540 ⇒ 00:54:26.349 Mustafa Raja: I think I’ll have to… I’ll have to refresh the connection, let me do that.
340 00:54:33.280 ⇒ 00:54:34.769 Mustafa Raja: Can you change…
341 00:54:39.890 ⇒ 00:54:40.700 Mustafa Raja: Yeah.
342 00:55:01.870 ⇒ 00:55:06.290 Mustafa Raja: Hmm… Yeah, what is… Part of this one.
343 00:55:18.380 ⇒ 00:55:20.370 Mustafa Raja: And then…
344 00:55:25.430 ⇒ 00:55:26.790 Mustafa Raja: What dimensions?
345 00:55:28.860 ⇒ 00:55:30.570 Mustafa Raja: Yeah, so…
346 00:55:33.110 ⇒ 00:55:36.449 Awaish Kumar: That’s also… Yeah, real time.
347 00:55:37.920 ⇒ 00:55:39.490 Mustafa Raja: This becomes then this.
348 00:55:40.120 ⇒ 00:55:41.320 Awaish Kumar: Okay, that’s fine.
349 00:55:42.020 ⇒ 00:55:47.509 Mustafa Raja: Yeah, I’ll just… I’m bringing the other ones now. I’m bringing the other ones in this table.
350 00:55:50.550 ⇒ 00:55:51.510 Mustafa Raja: Okay, just…
351 00:55:54.900 ⇒ 00:55:59.709 Awaish Kumar: Okay, yeah, I just have to hop off for an interview, so…
352 00:55:59.980 ⇒ 00:56:00.760 Mustafa Raja: Okay.
353 00:56:02.320 ⇒ 00:56:03.200 Uttam Kumaran: Okay.