Meeting Title: Eden Dashboard Projected Revenue Discussion Date: 2026-03-06 Meeting participants: Demilade Agboola, Uttam Kumaran, Mustafa Raja, Awaish Kumar
WEBVTT
1 00:00:15.980 ⇒ 00:00:18.170 Uttam Kumaran: Nice. Okay, so I cleaned up…
2 00:00:19.530 ⇒ 00:00:24.460 Uttam Kumaran: a good amount of the things. I’m looking at the projected revenue thing now.
3 00:00:24.680 ⇒ 00:00:28.270 Mustafa Raja: It should be a targeted line,
4 00:00:28.590 ⇒ 00:00:36.510 Mustafa Raja: Because we cannot do the exact same implementation that’s in, that’s in, Tableau, so it has to be a projected or target line.
5 00:00:37.210 ⇒ 00:00:39.389 Demilade Agboola: So, like, across all the bars.
6 00:00:40.910 ⇒ 00:00:41.800 Mustafa Raja: Sorry?
7 00:00:42.010 ⇒ 00:00:43.079 Uttam Kumaran: Across all the bars.
8 00:00:43.780 ⇒ 00:00:44.990 Demilade Agboola: Up on top.
9 00:00:46.530 ⇒ 00:00:51.120 Uttam Kumaran: Yeah, let me see if I can play around with it, I can think about another way, maybe.
10 00:00:51.500 ⇒ 00:00:55.700 Demilade Agboola: Yeah, because, like, with Tableau, it’s just right over the only, like, the month, the current month.
11 00:00:55.950 ⇒ 00:00:56.800 Uttam Kumaran: Yeah…
12 00:00:57.750 ⇒ 00:01:01.620 Demilade Agboola: I mean, I think if that’s what we can do for now, we’ll… we can do it, but yeah.
13 00:01:01.620 ⇒ 00:01:05.060 Uttam Kumaran: I can think of something creative later. What dashboard is that?
14 00:01:05.720 ⇒ 00:01:08.589 Demilade Agboola: the, give me one second…
15 00:02:03.130 ⇒ 00:02:08.169 Demilade Agboola: I’m not sure if it was the retention, but I’ll bring up the retention dashboard, give me one second…
16 00:03:35.990 ⇒ 00:03:39.409 Demilade Agboola: Yeah, so it’s the Eden Unit Economics and Profitability View.
17 00:03:40.710 ⇒ 00:03:41.390 Demilade Agboola: Right?
18 00:03:41.830 ⇒ 00:03:42.609 Demilade Agboola: Aren’t you know.
19 00:03:50.950 ⇒ 00:03:53.289 Uttam Kumaran: Oh, unit… yeah, I don’t see it in there.
20 00:03:54.950 ⇒ 00:03:57.429 Demilade Agboola: No, sorry, it’s Executive Financial Overview.
21 00:04:00.140 ⇒ 00:04:02.220 Uttam Kumaran: Oh, I said, thank you, thank you.
22 00:04:03.660 ⇒ 00:04:04.510 Uttam Kumaran: Alright.
23 00:04:05.700 ⇒ 00:04:08.629 Uttam Kumaran: I’ll work on this. Mustafa, what else?
24 00:04:11.040 ⇒ 00:04:11.990 Uttam Kumaran: What else?
25 00:04:19.290 ⇒ 00:04:21.930 Mustafa Raja: Then there, there would be the tickets?
26 00:04:22.580 ⇒ 00:04:23.420 Mustafa Raja: You know?
27 00:04:26.280 ⇒ 00:04:29.680 Mustafa Raja: I think Avish has two, which he’ll be working on.
28 00:04:30.470 ⇒ 00:04:38.740 Mustafa Raja: And I will be, creating PRs for the… For the ones that.
29 00:04:40.450 ⇒ 00:04:42.349 Uttam Kumaran: Do you want to make those? Demi can review.
30 00:04:43.760 ⇒ 00:04:49.509 Mustafa Raja: Yeah, I think, I, one of them got approved. Let me make the other one.
31 00:04:54.380 ⇒ 00:04:57.380 Mustafa Raja: Let me go back to the linear…
32 00:05:02.950 ⇒ 00:05:04.096 Mustafa Raja: Hmm…
33 00:05:36.660 ⇒ 00:05:41.380 Uttam Kumaran: How the hell we do this? So what is… Rejected?
34 00:05:42.090 ⇒ 00:05:44.510 Uttam Kumaran: Is there even a thing here for projected?
35 00:05:46.110 ⇒ 00:05:47.740 Mustafa Raja: some cancellation in Tableau.
36 00:05:47.990 ⇒ 00:05:53.410 Demilade Agboola: Yeah, so basically what it is, is how much has been… bought so far.
37 00:05:54.940 ⇒ 00:05:58.710 Demilade Agboola: Multiplied by the number of days left in the month.
38 00:05:59.650 ⇒ 00:06:04.419 Demilade Agboola: Like, basically, the ratio of how much has been bought per day so far, multiplied by the rest of the month.
39 00:06:05.580 ⇒ 00:06:08.559 Uttam Kumaran: So why can’t we just do,
40 00:06:11.740 ⇒ 00:06:23.309 Uttam Kumaran: I guess my question is, one of the things that I’m finding is we shouldn’t do, new customer, returning customer, and then put it in these categories.
41 00:06:23.580 ⇒ 00:06:25.539 Uttam Kumaran: We should just have a flag.
42 00:06:25.800 ⇒ 00:06:29.899 Uttam Kumaran: New versus… new or returning, or customer type.
43 00:06:30.050 ⇒ 00:06:31.519 Uttam Kumaran: And put it into color.
44 00:06:34.220 ⇒ 00:06:38.770 Uttam Kumaran: Put into color, what will happen is it will automatically split it up.
45 00:06:39.340 ⇒ 00:06:42.119 Uttam Kumaran: And so what you can do, Demi, is you can add
46 00:06:43.470 ⇒ 00:06:47.450 Uttam Kumaran: New, returning, and you can add projected as a type.
47 00:06:47.590 ⇒ 00:06:57.800 Uttam Kumaran: So you could say revenue type, new returning projected. Projected only exists for… the… current month.
48 00:06:58.490 ⇒ 00:06:59.320 Uttam Kumaran: And…
49 00:07:00.110 ⇒ 00:07:06.299 Uttam Kumaran: it’ll just be, like, this third category, and we can… I can basically change the color to, like, transparent or something. Or white.
50 00:07:08.410 ⇒ 00:07:10.230 Demilade Agboola: So, what we can do, like…
51 00:07:10.970 ⇒ 00:07:14.849 Demilade Agboola: If we’re going to do that, that would require, like, remodeling everything, which might be a bit too much.
52 00:07:14.850 ⇒ 00:07:17.060 Uttam Kumaran: Why, why, why? What remodeling what?
53 00:07:17.890 ⇒ 00:07:21.900 Demilade Agboola: Because right now, what we’re doing is, this is this… I believe this is a summary table.
54 00:07:22.320 ⇒ 00:07:22.940 Uttam Kumaran: Yeah.
55 00:07:23.100 ⇒ 00:07:27.000 Demilade Agboola: It will be… Having to… because it’s just based off…
56 00:07:27.000 ⇒ 00:07:27.560 Uttam Kumaran: Oh…
57 00:07:28.120 ⇒ 00:07:29.880 Demilade Agboola: Yeah, so it’s a summary table.
58 00:07:29.980 ⇒ 00:07:37.369 Demilade Agboola: It’s spread out, and then we… that’s why we have the flag for new and returning, so it’s not exactly, like, all…
59 00:07:37.770 ⇒ 00:07:40.920 Demilade Agboola: We can break it down, can’t we? I’m trying to think.
60 00:07:41.630 ⇒ 00:07:44.470 Uttam Kumaran: You would add, you would add rows.
61 00:07:44.830 ⇒ 00:07:51.439 Demilade Agboola: Yeah. What I was thinking that, and what came to my mind right now, is with Omni, we can create a custom calculation.
62 00:07:51.720 ⇒ 00:07:54.969 Demilade Agboola: That when it is the current month, and then we now add… we now.
63 00:07:55.810 ⇒ 00:07:58.380 Demilade Agboola: Some of the revenue, new patients and returning.
64 00:07:59.110 ⇒ 00:08:10.060 Demilade Agboola: And then do, like, we can do the entire calculation, but since it’s… since the case went for when it’s only the current month, the others will be null, and then we can overlay that, and it would be there.
65 00:08:10.770 ⇒ 00:08:13.160 Uttam Kumaran: You wanna walk me through it? You wanna, should we try it now?
66 00:08:13.530 ⇒ 00:08:14.930 Demilade Agboola: Yeah, sure, let’s try it.
67 00:08:16.350 ⇒ 00:08:19.530 Demilade Agboola: So we’ll be basically creating a new column.
68 00:08:21.750 ⇒ 00:08:23.780 Uttam Kumaran: Can I just do duplicate of this?
69 00:08:25.140 ⇒ 00:08:26.860 Demilade Agboola: I’m not exactly sure.
70 00:08:27.220 ⇒ 00:08:27.930 Uttam Kumaran: Let’s see…
71 00:08:29.280 ⇒ 00:08:31.179 Mustafa Raja: We want to create a calculation.
72 00:08:31.180 ⇒ 00:08:32.340 Demilade Agboola: Yes. Column?
73 00:08:32.460 ⇒ 00:08:37.369 Mustafa Raja: So let’s go into the results, rather than chart, and then we’ll be able to do that from there, no?
74 00:08:39.840 ⇒ 00:08:40.150 Uttam Kumaran: Oh.
75 00:08:42.740 ⇒ 00:08:44.450 Mustafa Raja: Here.
76 00:08:44.870 ⇒ 00:08:46.350 Demilade Agboola: Like, results up top.
77 00:08:47.240 ⇒ 00:08:47.640 Mustafa Raja: Here?
78 00:08:49.280 ⇒ 00:08:50.919 Mustafa Raja: And then this button.
79 00:08:54.220 ⇒ 00:08:55.410 Mustafa Raja: this, yeah.
80 00:08:56.380 ⇒ 00:08:59.160 Mustafa Raja: And then they should be able to add a new column.
81 00:08:59.460 ⇒ 00:09:01.249 Mustafa Raja: We can do whatever we want.
82 00:09:02.710 ⇒ 00:09:05.300 Mustafa Raja: So, and this actually accepts as,
83 00:09:05.300 ⇒ 00:09:05.810 Demilade Agboola: If you want to.
84 00:09:05.810 ⇒ 00:09:06.860 Mustafa Raja: That’s also true.
85 00:09:07.120 ⇒ 00:09:08.739 Demilade Agboola: If we want to do sequel, right?
86 00:09:11.670 ⇒ 00:09:14.010 Demilade Agboola: Can we do it in SQL? Can we do it in SQL?
87 00:09:14.010 ⇒ 00:09:17.020 Mustafa Raja: For SQL, yeah, we’ll have to do the…
88 00:09:17.660 ⇒ 00:09:28.660 Mustafa Raja: So, at the, yeah, bottom… wait. At the bottom here, you’d see the new field. There, yeah, there we can do SQL.
89 00:09:29.180 ⇒ 00:09:33.270 Uttam Kumaran: So here, this is like a what? This is like a… Excel.
90 00:09:33.760 ⇒ 00:09:34.460 Mustafa Raja: Yeah.
91 00:09:37.150 ⇒ 00:09:41.449 Demilade Agboola: Actually, maybe we could, like, basically, because what we need to just do is…
92 00:09:41.450 ⇒ 00:09:43.379 Uttam Kumaran: Yeah, tell me again what it is.
93 00:09:43.660 ⇒ 00:09:48.170 Demilade Agboola: Okay, so what we’re trying to do is… so, create a field, Where?
94 00:09:49.170 ⇒ 00:09:55.769 Demilade Agboola: the case when it is the current month, so, like, it will ensure that it’s only that current month. So, case when it’s the current month.
95 00:09:55.910 ⇒ 00:10:01.950 Demilade Agboola: We will add The returning patient revenue and the new patient revenue together.
96 00:10:03.030 ⇒ 00:10:07.110 Demilade Agboola: Divided by the number of days.
97 00:10:07.210 ⇒ 00:10:10.509 Demilade Agboola: And multiply by the number of days left in the… like, number of days.
98 00:10:10.510 ⇒ 00:10:14.839 Uttam Kumaran: Oh, so you’re basically getting your… it’s a crude forecast, it’s like…
99 00:10:15.380 ⇒ 00:10:18.230 Uttam Kumaran: You’re just taking the average…
100 00:10:20.280 ⇒ 00:10:36.460 Demilade Agboola: Yeah, they’re taking the revenue per day so far. That’s basically what it is in the projected revenue right now, by the way. It’s basically the revenue per day, average revenue per day, multiplied by the number of days in the month. So it’s like, oh, if we continue at this rate, we will get to 3 million this month.
101 00:10:38.630 ⇒ 00:10:52.349 Demilade Agboola: So what I’m saying, like, so if we do, like, a case one statement, it will be null for every month that is in the current month, but we will get the value we need for that month, and then when we overlay it, it will just be, like, a… you can have a bar chart where it’s zero for everything, but the current month has a…
102 00:10:53.170 ⇒ 00:10:55.069 Demilade Agboola: Like, a target.
103 00:11:00.670 ⇒ 00:11:02.089 Uttam Kumaran: Let me write the formula.
104 00:11:05.280 ⇒ 00:11:07.980 Demilade Agboola: So, I was thinking sickle might just be easier, but if…
105 00:11:08.140 ⇒ 00:11:10.140 Demilade Agboola: Excel could do something like that, sure.
106 00:11:10.570 ⇒ 00:11:12.229 Demilade Agboola: I probably can.
107 00:11:13.050 ⇒ 00:11:14.639 Demilade Agboola: Not necessarily an Excel warrior.
108 00:11:17.940 ⇒ 00:11:19.090 Uttam Kumaran: Let’s see…
109 00:13:00.580 ⇒ 00:13:01.640 Uttam Kumaran: What the hell?
110 00:13:03.080 ⇒ 00:13:04.430 Uttam Kumaran: Why is this working?
111 00:13:11.530 ⇒ 00:13:12.570 Uttam Kumaran: Hello?
112 00:13:14.190 ⇒ 00:13:14.860 Uttam Kumaran: Oh.
113 00:13:20.850 ⇒ 00:13:23.679 Mustafa Raja: I think you need to press enter or something, no? Did you press that?
114 00:13:30.450 ⇒ 00:13:31.560 Uttam Kumaran: Okay, hold on.
115 00:14:07.440 ⇒ 00:14:11.840 Uttam Kumaran: This is the formula, if month… Oh.
116 00:14:33.440 ⇒ 00:14:36.510 Uttam Kumaran: Okay, I don’t know why this isn’t working, but…
117 00:14:44.080 ⇒ 00:14:45.350 Uttam Kumaran: Okay, how about this?
118 00:14:50.410 ⇒ 00:14:54.020 Demilade Agboola: Yeah, but the problem is it should be zero for everything that is not the current month.
119 00:14:55.010 ⇒ 00:14:56.039 Uttam Kumaran: I think it is.
120 00:14:57.260 ⇒ 00:15:00.589 Demilade Agboola: But it’s… October 2025 is what?
121 00:15:00.590 ⇒ 00:15:02.370 Uttam Kumaran: Oh, shit, sorry, sorry, sorry.
122 00:15:03.230 ⇒ 00:15:05.000 Uttam Kumaran: But, oh, but why?
123 00:15:05.310 ⇒ 00:15:08.149 Uttam Kumaran: I can’t, like, edit the… the thing again, though.
124 00:15:09.140 ⇒ 00:15:10.719 Mustafa Raja: You should be able to, though.
125 00:15:12.860 ⇒ 00:15:20.429 Uttam Kumaran: I guess it’s here, but… Okay, I feel like maybe it’s gonna be easier in SQL.
126 00:15:22.290 ⇒ 00:15:23.900 Uttam Kumaran: Go out of field.
127 00:17:34.700 ⇒ 00:17:36.060 Demilade Agboola: What’s the error?
128 00:17:38.420 ⇒ 00:17:40.299 Demilade Agboola: It’s not only, fish trade.
129 00:17:40.300 ⇒ 00:17:42.809 Uttam Kumaran: Oh, I don’t think it supports interval.
130 00:17:44.820 ⇒ 00:17:45.400 Uttam Kumaran: Okay.
131 00:17:45.400 ⇒ 00:17:52.140 Demilade Agboola: There’s an unexpected… Close of the bracket. I think it’s… At the interval…
132 00:17:52.140 ⇒ 00:17:53.730 Uttam Kumaran: Yeah, let’s try this.
133 00:17:58.210 ⇒ 00:17:59.890 Uttam Kumaran: Unrecognized… oh.
134 00:18:04.920 ⇒ 00:18:07.299 Uttam Kumaran: It’s just month or date month?
135 00:18:07.300 ⇒ 00:18:08.359 Demilade Agboola: I think it’s date.
136 00:18:09.430 ⇒ 00:18:10.770 Demilade Agboola: Or dates, maybe statement.
137 00:18:10.770 ⇒ 00:18:13.089 Uttam Kumaran: Unrecognized name date month.
138 00:18:19.180 ⇒ 00:18:20.200 Uttam Kumaran: What does that mean?
139 00:18:21.840 ⇒ 00:18:23.270 Demilade Agboola: I think it’s date that we need.
140 00:18:24.150 ⇒ 00:18:25.070 Demilade Agboola: Going for a huh?
141 00:18:34.650 ⇒ 00:18:35.400 Demilade Agboola: Alright.
142 00:18:35.400 ⇒ 00:18:36.190 Uttam Kumaran: loading.
143 00:18:37.530 ⇒ 00:18:38.460 Uttam Kumaran: Okay.
144 00:18:39.620 ⇒ 00:18:47.120 Uttam Kumaran: Where… where did I go? Oh, I did project, remember, project… Shit, where is it?
145 00:18:48.080 ⇒ 00:18:49.309 Demilade Agboola: It will be P…
146 00:18:49.310 ⇒ 00:18:50.619 Uttam Kumaran: Oh, here we go, okay.
147 00:18:55.570 ⇒ 00:18:58.130 Uttam Kumaran: Okay, didn’t exactly work.
148 00:19:02.720 ⇒ 00:19:04.670 Demilade Agboola: I think it needs to be measured, though.
149 00:19:06.840 ⇒ 00:19:07.640 Demilade Agboola: Right?
150 00:19:08.340 ⇒ 00:19:12.259 Demilade Agboola: Oh, shit, yeah, it’s different things than in here, like, technically.
151 00:19:14.680 ⇒ 00:19:17.330 Demilade Agboola: So it’s not a measure, it’s a dimension, so for each…
152 00:19:19.190 ⇒ 00:19:20.110 Uttam Kumaran: Oh…
153 00:19:20.110 ⇒ 00:19:24.970 Demilade Agboola: So that’s why it’s split out like this, because there are multiple, like, categories, and I think that’s why it’s doing this.
154 00:19:26.510 ⇒ 00:19:29.760 Demilade Agboola: So, need to summit per month.
155 00:19:33.100 ⇒ 00:19:34.150 Uttam Kumaran: Oh, I see.
156 00:19:40.120 ⇒ 00:19:41.550 Uttam Kumaran: Mmm, there it is.
157 00:19:42.930 ⇒ 00:19:43.710 Uttam Kumaran: Alright?
158 00:19:43.960 ⇒ 00:19:47.399 Demilade Agboola: Yeah, so that’s it. So now when we put it into the…
159 00:19:48.100 ⇒ 00:19:54.710 Demilade Agboola: Chart, it will be known for every other column, and then we would have a bar for the current month we’re in.
160 00:20:25.080 ⇒ 00:20:27.820 Uttam Kumaran: Alright… In there…
161 00:20:30.850 ⇒ 00:20:32.330 Uttam Kumaran: How the hell do I, like…
162 00:20:32.800 ⇒ 00:20:37.429 Demilade Agboola: Market, yeah. We have those ways to make the bar dark, like the edge of the bar.
163 00:20:49.100 ⇒ 00:20:52.429 Demilade Agboola: Or can we make it, like, not necessarily white? Maybe we can make it off.
164 00:20:52.650 ⇒ 00:20:57.630 Demilade Agboola: Off-light, like… Is there anything close to that?
165 00:21:01.740 ⇒ 00:21:03.260 Demilade Agboola: Yeah, I think this is… yeah.
166 00:21:06.650 ⇒ 00:21:11.010 Uttam Kumaran: And then… but how do I… I can’t put the name of it here.
167 00:21:14.640 ⇒ 00:21:17.410 Uttam Kumaran: Oh, I guess this is fine, actually.
168 00:21:17.810 ⇒ 00:21:23.270 Uttam Kumaran: And then what we can do is I can put a chart above this that says, like, projected revenue.
169 00:21:23.850 ⇒ 00:21:25.060 Demilade Agboola: Yeah. He’s here.
170 00:21:27.920 ⇒ 00:21:31.149 Uttam Kumaran: Now, why are there zeros here? Oh, shit.
171 00:21:31.590 ⇒ 00:21:33.950 Mustafa Raja: I think that’s what the bottom series is saying, no?
172 00:21:34.440 ⇒ 00:21:38.349 Uttam Kumaran: Yeah, but I can’t… these will be zero, because you can’t do a label…
173 00:21:38.490 ⇒ 00:21:39.940 Uttam Kumaran: I have to null it out.
174 00:21:40.110 ⇒ 00:21:43.719 Uttam Kumaran: Hold on. Well, it’s null,
175 00:21:45.850 ⇒ 00:21:48.749 Uttam Kumaran: I guess let’s see if there’s any options on the metric.
176 00:21:51.550 ⇒ 00:21:54.829 Uttam Kumaran: Like, can I just null it instead of zero?
177 00:22:04.830 ⇒ 00:22:06.380 Mustafa Raja: Also,
178 00:22:07.090 ⇒ 00:22:14.930 Mustafa Raja: Demilade, would you… would you be able to take a look at this? So this says that we need first-time product users, right?
179 00:22:16.670 ⇒ 00:22:17.550 Demilade Agboola: Yes.
180 00:22:18.900 ⇒ 00:22:23.540 Mustafa Raja: But over here, I can only see summary for that, you know?
181 00:22:25.810 ⇒ 00:22:30.389 Demilade Agboola: I believe that’s the same table. They probably, like, renamed it in.
182 00:22:31.130 ⇒ 00:22:39.100 Demilade Agboola: It’s the same way, like, product sales summary is usually product sales summary by transaction, but, like, I think it’s just renamed in there. So if… have you downloaded the workbook?
183 00:22:39.530 ⇒ 00:22:44.170 Demilade Agboola: If you really want to confirm, you can just download the workbook and look at it in Tableau.
184 00:22:45.080 ⇒ 00:22:45.640 Demilade Agboola: Do you have time?
185 00:22:45.640 ⇒ 00:22:47.240 Mustafa Raja: Oh, I don’t have the Apple desktop.
186 00:22:48.030 ⇒ 00:22:51.399 Demilade Agboola: Oh, okay. Let me… let me try and just confirm for you.
187 00:22:51.830 ⇒ 00:22:53.899 Mustafa Raja: Okay, okay,
188 00:22:54.290 ⇒ 00:23:00.760 Mustafa Raja: So the issue is… the issue was, we needed this, new product usage, right? Which is,
189 00:23:01.460 ⇒ 00:23:07.909 Mustafa Raja: Which is this. So it created a new, whole new view for that. Do you think this is how it should be done?
190 00:23:11.050 ⇒ 00:23:15.570 Demilade Agboola: Some of those things will break, like, in dbt.
191 00:23:16.200 ⇒ 00:23:16.780 Mustafa Raja: Okay.
192 00:23:16.780 ⇒ 00:23:21.490 Demilade Agboola: you have, like, Tableau formula there. I think that… Because that’s not…
193 00:23:22.000 ⇒ 00:23:23.839 Demilade Agboola: Can you go up, like, to…
194 00:23:24.980 ⇒ 00:23:34.669 Mustafa Raja: Yeah, but this, this sort of formula isn’t… I’m unable to reflect this as is in, in Omni itself, you know.
195 00:23:34.670 ⇒ 00:23:37.110 Demilade Agboola: Yeah, go back, please. Go back to DMT.
196 00:23:38.470 ⇒ 00:23:43.289 Demilade Agboola: So that will be reflected by a group by, and then a max statement.
197 00:23:43.820 ⇒ 00:23:45.679 Demilade Agboola: So, can you go up, please?
198 00:23:46.250 ⇒ 00:23:47.399 Demilade Agboola: Can you go, please?
199 00:23:51.940 ⇒ 00:23:56.790 Demilade Agboola: So, like, lines 11 to… Okay, yeah, he hashed it out.
200 00:23:57.110 ⇒ 00:24:00.439 Demilade Agboola: Okay… Rejoined as this…
201 00:24:09.150 ⇒ 00:24:10.560 Demilade Agboola: Okay, you know what, let’s try this.
202 00:24:11.410 ⇒ 00:24:13.789 Demilade Agboola: Looks decent, so let’s try it.
203 00:24:14.910 ⇒ 00:24:19.749 Demilade Agboola: Can you… can you do a… what’s that thing called? Can you either do a dbt run?
204 00:24:20.500 ⇒ 00:24:26.009 Mustafa Raja: Oh, I don’t think that I have the… what’s it called, the ENV, you know?
205 00:24:26.850 ⇒ 00:24:28.119 Demilade Agboola: You don’t have the envy?
206 00:24:28.560 ⇒ 00:24:29.180 Mustafa Raja: Nope.
207 00:24:31.930 ⇒ 00:24:35.129 Demilade Agboola: Goki, can you copy the query and send it to me? Let me try and test it.
208 00:24:35.580 ⇒ 00:24:36.620 Mustafa Raja: Yep.
209 00:24:36.620 ⇒ 00:24:41.750 Demilade Agboola: Oh, you have access… you have access to… con- the… BigQuery, right?
210 00:24:44.500 ⇒ 00:24:45.850 Mustafa Raja: I believe I do.
211 00:24:46.020 ⇒ 00:24:46.930 Mustafa Raja: Awesome.
212 00:24:46.980 ⇒ 00:24:50.310 Demilade Agboola: Yeah, because… But don’t run it.
213 00:24:51.280 ⇒ 00:24:52.090 Mustafa Raja: Okay.
214 00:24:53.500 ⇒ 00:24:54.820 Mustafa Raja: Yeah, I’m sending it to you.
215 00:25:02.760 ⇒ 00:25:03.490 Demilade Agboola: Hmm…
216 00:25:03.490 ⇒ 00:25:10.240 Mustafa Raja: But then I’m also wondering if, you know, if we are going to create a whole new table for this, how’s the join going to look like and stuff, you know?
217 00:25:13.810 ⇒ 00:25:14.990 Demilade Agboola: Does that make sense?
218 00:25:15.640 ⇒ 00:25:17.089 Demilade Agboola: And holding the table for a touring?
219 00:25:18.800 ⇒ 00:25:21.249 Mustafa Raja: A whole new table for this new product uses.
220 00:25:23.150 ⇒ 00:25:25.679 Mustafa Raja: This is a new table, right? This is a view itself, no?
221 00:25:25.680 ⇒ 00:25:26.470 Demilade Agboola: It’s okay, yeah, it’s.
222 00:25:26.470 ⇒ 00:25:27.640 Mustafa Raja: This becomes a table.
223 00:25:29.020 ⇒ 00:25:34.019 Demilade Agboola: So the logic will be added to a table, not necessarily becomes a table.
224 00:25:34.650 ⇒ 00:25:38.399 Mustafa Raja: Oh, so, so it’s not a table, but… oh, okay, okay.
225 00:25:38.600 ⇒ 00:25:39.100 Demilade Agboola: It will be…
226 00:25:39.100 ⇒ 00:25:39.570 Mustafa Raja: for this one.
227 00:25:39.570 ⇒ 00:25:45.610 Demilade Agboola: The new table, but, like, the logic that you need will be added to a table so that when you do the sum, you don’t have to do the max first.
228 00:25:46.760 ⇒ 00:25:48.940 Demilade Agboola: When you have to do a max and then a sum.
229 00:25:49.280 ⇒ 00:25:52.089 Demilade Agboola: Omni starts to be… starts to act out.
230 00:25:53.380 ⇒ 00:25:54.400 Mustafa Raja: Okay.
231 00:27:12.960 ⇒ 00:27:17.750 Demilade Agboola: So I’m trying to run it in BigQuery so you can kind of see the numbers and see if it works for you.
232 00:28:05.580 ⇒ 00:28:08.050 Uttam Kumaran: Okay, well, I did the projected, but…
233 00:28:10.220 ⇒ 00:28:15.490 Uttam Kumaran: Because it’s… it’s doing an aggregation, It’s always gonna be zero.
234 00:28:16.410 ⇒ 00:28:24.280 Uttam Kumaran: So I’m, like, thinking about how to do the reference line, but… Can’t do dynamic reference line.
235 00:28:24.580 ⇒ 00:28:27.750 Uttam Kumaran: And the reference line will go across the whole thing.
236 00:28:28.170 ⇒ 00:28:29.400 Uttam Kumaran: Does that matter?
237 00:28:31.520 ⇒ 00:28:33.290 Mustafa Raja: The target line, right?
238 00:28:33.670 ⇒ 00:28:37.960 Mustafa Raja: That was… that was my initial understanding that we should do it like that.
239 00:28:38.190 ⇒ 00:28:40.579 Uttam Kumaran: Oh, I was gonna just make this… this…
240 00:28:40.720 ⇒ 00:28:45.569 Uttam Kumaran: I was gonna change it so it’s gonna be $5 million for every month.
241 00:28:45.700 ⇒ 00:28:47.520 Uttam Kumaran: And there’s just one line.
242 00:28:49.840 ⇒ 00:28:51.559 Demilade Agboola: Turn it to a line instead of a…
243 00:28:51.560 ⇒ 00:28:52.690 Mustafa Raja: I think if we want to get.
244 00:28:52.690 ⇒ 00:28:55.630 Uttam Kumaran: Horizontal line, though, but it’ll be across everything.
245 00:28:56.420 ⇒ 00:29:06.579 Mustafa Raja: If we want to get rid of zeros, what we could do is we could, make the, make the label go in the middle, and that might remove this.
246 00:29:06.870 ⇒ 00:29:10.600 Mustafa Raja: Because it does that for some of the… Wand.
247 00:29:10.960 ⇒ 00:29:15.060 Mustafa Raja: So, the label would have… If you go to the label…
248 00:29:15.990 ⇒ 00:29:17.270 Uttam Kumaran: What the hell did I do?
249 00:29:24.270 ⇒ 00:29:25.740 Uttam Kumaran: Wait, go to which label?
250 00:29:27.500 ⇒ 00:29:29.920 Mustafa Raja: For the projected one, no?
251 00:29:33.340 ⇒ 00:29:41.279 Mustafa Raja: So rather than having the label on top, we could ask it to be in the middle, and that way not all of them show up.
252 00:29:42.270 ⇒ 00:29:49.949 Mustafa Raja: Sometimes it does that. Yeah, go into the labels, and then in the position, rather than auto, we say middle, or below.
253 00:29:53.340 ⇒ 00:29:56.089 Mustafa Raja: And oh, no, it overlaps.
254 00:29:56.670 ⇒ 00:30:01.460 Uttam Kumaran: Where’s zero, though? Where’s the zero? Oh. Yeah.
255 00:30:02.460 ⇒ 00:30:05.759 Mustafa Raja: What are the options? It’s below…
256 00:30:05.980 ⇒ 00:30:16.139 Mustafa Raja: Wait, wait, wait, there’s one more thing we could try. So if you go… if you would go… if you would go over here, there might be a way to turn off all the…
257 00:30:16.520 ⇒ 00:30:17.759 Mustafa Raja: all labels.
258 00:30:18.810 ⇒ 00:30:20.469 Mustafa Raja: Also, labels?
259 00:30:22.620 ⇒ 00:30:28.840 Mustafa Raja: show labels. There is… hmm… I cannot this one.
260 00:30:32.980 ⇒ 00:30:38.149 Mustafa Raja: Maybe go back, in the label of, label of what,
261 00:30:38.540 ⇒ 00:30:44.369 Mustafa Raja: Label of projected, and there should be a… there should be a toggle button for all data labels.
262 00:30:48.400 ⇒ 00:30:52.900 Mustafa Raja: There usually is. For this one, I don’t think that there is.
263 00:31:06.100 ⇒ 00:31:07.040 Mustafa Raja: Nope.
264 00:31:08.550 ⇒ 00:31:09.200 Uttam Kumaran: Oops.
265 00:31:10.610 ⇒ 00:31:14.319 Mustafa Raja: Yeah, I think the other solution that you were suggesting might be the way to go.
266 00:31:28.810 ⇒ 00:31:33.909 Demilade Agboola: Sorry, can we try the other ways in which we can put the labels? Let me see, like…
267 00:31:34.180 ⇒ 00:31:38.339 Uttam Kumaran: Oh, well, yeah, that’s… well, that’s the thing, this label, I don’t know.
268 00:31:39.530 ⇒ 00:31:41.730 Demilade Agboola: And so, like, we tried below, can we try.
269 00:31:41.730 ⇒ 00:31:45.940 Uttam Kumaran: No, no, the problem is I can’t… the zeros are here, right?
270 00:31:47.100 ⇒ 00:31:48.130 Demilade Agboola: Let’s see…
271 00:31:49.020 ⇒ 00:31:54.339 Demilade Agboola: above, so that… that doesn’t work. Can we try, like, middle or something? I just wanted to see…
272 00:31:56.650 ⇒ 00:31:59.340 Mustafa Raja: Yeah, middle one, the half, halfway shows up.
273 00:32:06.360 ⇒ 00:32:08.009 Demilade Agboola: Yeah, I think the bulb is probably the…
274 00:32:08.240 ⇒ 00:32:11.419 Demilade Agboola: best, but how do we turn off the other labels?
275 00:32:11.420 ⇒ 00:32:14.520 Uttam Kumaran: Another thing I can do, guys, is I can…
276 00:32:18.040 ⇒ 00:32:21.120 Uttam Kumaran: I can have… Ugh.
277 00:32:23.010 ⇒ 00:32:25.159 Demilade Agboola: Can we make it null instead of… is it 0?
278 00:32:25.160 ⇒ 00:32:26.269 Uttam Kumaran: It is null.
279 00:32:26.270 ⇒ 00:32:27.349 Demilade Agboola: It is normal.
280 00:32:27.900 ⇒ 00:32:33.370 Uttam Kumaran: But it’s… but it’s… but the thing is, it’s… it’s null in the value, but when it sums it, it sums to zero.
281 00:33:16.970 ⇒ 00:33:19.250 Uttam Kumaran: Alright, this is a complicated one.
282 00:33:43.880 ⇒ 00:33:46.589 Uttam Kumaran: Like, we want there to be no value.
283 00:33:46.980 ⇒ 00:33:50.189 Uttam Kumaran: Not null, like, no values for past months.
284 00:34:02.440 ⇒ 00:34:11.029 Uttam Kumaran: Yeah, I mean, I think you have to change the structure of the table, because what you could do is you could have one… if the underlying table has one row.
285 00:34:11.159 ⇒ 00:34:14.459 Uttam Kumaran: For March, projected, the number.
286 00:34:18.440 ⇒ 00:34:21.210 Demilade Agboola: Well, I feel like normal for the other rows, which would.
287 00:34:21.210 ⇒ 00:34:23.089 Uttam Kumaran: No, no, but… oh, you think so?
288 00:34:25.500 ⇒ 00:34:29.969 Demilade Agboola: Because the issue here is that we have null, which is continent 0, but it’s trying to label it…
289 00:34:30.530 ⇒ 00:34:31.699 Demilade Agboola: About we…
290 00:34:35.300 ⇒ 00:34:37.179 Demilade Agboola: Unless…
291 00:34:43.639 ⇒ 00:34:47.249 Demilade Agboola: Is there any way we can make that a target line instead?
292 00:34:48.400 ⇒ 00:34:50.330 Demilade Agboola: So the sum of it should be a target line.
293 00:34:50.330 ⇒ 00:34:52.809 Uttam Kumaran: You can’t do a dynamic target line.
294 00:34:54.560 ⇒ 00:34:56.909 Uttam Kumaran: That’s why I feel like maybe…
295 00:34:59.090 ⇒ 00:35:01.879 Uttam Kumaran: A new… like, maybe we have to…
296 00:35:04.230 ⇒ 00:35:10.300 Demilade Agboola: So if we did it in dbt, it will just come as a number, and we can just use it as a target line.
297 00:35:13.320 ⇒ 00:35:16.509 Uttam Kumaran: Okay, what I’m gonna do is I’m gonna leave this off for now.
298 00:35:17.770 ⇒ 00:35:20.030 Uttam Kumaran: And I’m just gonna publish it so it’s there.
299 00:35:21.600 ⇒ 00:35:22.610 Uttam Kumaran: At least.
300 00:35:23.120 ⇒ 00:35:23.770 Mustafa Raja: point.
301 00:35:25.830 ⇒ 00:35:33.480 Uttam Kumaran: Then… What we can think about doing… is…
302 00:35:41.850 ⇒ 00:35:45.329 Uttam Kumaran: It’s already… I want to just, like, expand this a little bit.
303 00:35:50.540 ⇒ 00:35:52.539 Uttam Kumaran: This is all jammed up in here.
304 00:35:59.820 ⇒ 00:36:00.830 Uttam Kumaran: I mean…
305 00:36:02.570 ⇒ 00:36:09.570 Uttam Kumaran: We should just create another chart directly to the right with projected revenue one month, filter the current month. Can we do that?
306 00:36:10.470 ⇒ 00:36:11.559 Uttam Kumaran: Just do that.
307 00:36:12.190 ⇒ 00:36:15.180 Uttam Kumaran: Put another tile right here. Move this.
308 00:36:15.860 ⇒ 00:36:16.640 Uttam Kumaran: Right.
309 00:36:22.310 ⇒ 00:36:23.459 Demilade Agboola: I’m not sure I go, you mean.
310 00:36:24.160 ⇒ 00:36:31.720 Uttam Kumaran: Like, I’m gonna duplicate this, I have to… I have to jump, but I’m gonna duplicate this, but I’m gonna just have the projected revenue
311 00:36:32.320 ⇒ 00:36:34.539 Uttam Kumaran: And I’m gonna just filter to March.
312 00:36:34.670 ⇒ 00:36:36.440 Uttam Kumaran: So it’s literally, like, one bar.
313 00:36:37.530 ⇒ 00:36:39.840 Uttam Kumaran: And I’m just gonna put it to the right of it.
314 00:36:41.650 ⇒ 00:36:43.740 Uttam Kumaran: At least you can see it side by side.
315 00:36:46.010 ⇒ 00:36:47.099 Demilade Agboola: I mean, fair enough, that could work.
316 00:36:47.200 ⇒ 00:36:48.179 Awaish Kumar: That’s true.
317 00:36:48.740 ⇒ 00:36:50.270 Uttam Kumaran: Okay, I’m gonna do that.
318 00:36:50.380 ⇒ 00:36:58.129 Uttam Kumaran: At least it’s there. Okay, let me do that. Alright, I’ll, I’ll hop back on if you guys are still on.
319 00:36:59.430 ⇒ 00:37:01.050 Demilade Agboola: Are you hop into the default call?
320 00:37:01.260 ⇒ 00:37:04.130 Uttam Kumaran: No, no, no, I have to call Jasmine.
321 00:37:10.090 ⇒ 00:37:12.610 Awaish Kumar: Demi, like, do you have time today?
322 00:37:13.870 ⇒ 00:37:16.530 Demilade Agboola: To be honest, at this point, like, default has stuff.
323 00:37:16.640 ⇒ 00:37:20.599 Demilade Agboola: this has stuff, I’m not even sure what to prioritize, but I can quickly, like, look at stuff here.
324 00:37:21.530 ⇒ 00:37:24.880 Awaish Kumar: I just have one ticket I wanted to hang over.
325 00:37:25.290 ⇒ 00:37:27.239 Awaish Kumar: I’m working on this one.
326 00:37:27.450 ⇒ 00:37:30.959 Awaish Kumar: And then I’m working on 4Joys report with Mustafa.
327 00:37:32.930 ⇒ 00:37:35.290 Awaish Kumar: I just had one… This one?
328 00:37:35.740 ⇒ 00:37:37.510 Awaish Kumar: That I haven’t started yet.
329 00:37:38.620 ⇒ 00:37:39.640 Demilade Agboola: I don’t know.
330 00:37:41.000 ⇒ 00:37:43.380 Awaish Kumar: I… yeah, I might…
331 00:37:45.710 ⇒ 00:37:51.420 Awaish Kumar: when it should be done. If you have… yeah, if you want to look at, then it’s okay, otherwise I can…
332 00:37:51.790 ⇒ 00:37:55.920 Awaish Kumar: See if I can… Right.
333 00:37:57.460 ⇒ 00:37:58.400 Demilade Agboola: I’m trying to see.
334 00:37:58.640 ⇒ 00:38:02.060 Demilade Agboola: Mustafa, can I send you the query, like, that you can run in BigQuery?
335 00:38:02.290 ⇒ 00:38:03.030 Demilade Agboola: So that you can see.
336 00:38:04.800 ⇒ 00:38:06.629 Mustafa Raja: Sorry, could you say that again?
337 00:38:06.630 ⇒ 00:38:09.579 Demilade Agboola: I might send you the query so that you can run in BigQuery.
338 00:38:09.580 ⇒ 00:38:20.080 Mustafa Raja: Yeah, yeah, yeah, let’s do that, because I have… I have an issue with that. BigQuery isn’t… is just not working for me. So let, send me the query.
339 00:38:20.210 ⇒ 00:38:21.090 Demilade Agboola: Eating.
340 00:38:21.900 ⇒ 00:38:22.960 Demilade Agboola: Hayden, I…
341 00:38:22.960 ⇒ 00:38:26.760 Mustafa Raja: Yeah, let me show you. Yeah, so I am signed in with this.
342 00:38:28.350 ⇒ 00:38:31.770 Demilade Agboola: And, okay, so can you run… can you run this query?
343 00:38:32.300 ⇒ 00:38:33.200 Mustafa Raja: This one.
344 00:38:33.200 ⇒ 00:38:33.970 Demilade Agboola: Yes, please.
345 00:38:34.710 ⇒ 00:38:37.550 Mustafa Raja: Yeah, let me… do this.
346 00:38:39.190 ⇒ 00:38:40.050 Mustafa Raja: See?
347 00:38:40.230 ⇒ 00:38:41.440 Demilade Agboola: You shouldn’t see me soon.
348 00:38:46.860 ⇒ 00:38:48.849 Mustafa Raja: Am I in the wrong project or something?
349 00:38:49.540 ⇒ 00:38:52.059 Awaish Kumar: Can I see your… You ready?
350 00:38:52.060 ⇒ 00:38:53.570 Mustafa Raja: I’m sharing screen.
351 00:38:54.500 ⇒ 00:38:57.500 Awaish Kumar: Hello, can I see you the email address you’ve used?
352 00:38:57.670 ⇒ 00:38:58.759 Mustafa Raja: Oh, yeah, this…
353 00:38:58.890 ⇒ 00:39:03.420 Awaish Kumar: Adela, And Shrek, can you select a project as well on the top?
354 00:39:05.340 ⇒ 00:39:06.430 Mustafa Raja: I…
355 00:39:06.570 ⇒ 00:39:07.860 Awaish Kumar: Yeah, select the one.
356 00:39:09.020 ⇒ 00:39:09.790 Mustafa Raja: Okay.
357 00:39:11.430 ⇒ 00:39:12.419 Awaish Kumar: Yeah, just leave.
358 00:39:12.750 ⇒ 00:39:13.430 Awaish Kumar: Just leave…
359 00:39:15.380 ⇒ 00:39:16.330 Mustafa Raja: Okay, another.
360 00:39:16.330 ⇒ 00:39:17.479 Awaish Kumar: I have the project right now.
361 00:39:20.790 ⇒ 00:39:22.060 Demilade Agboola: Oh yeah, that’s find the easiest way.
362 00:39:22.060 ⇒ 00:39:23.040 Awaish Kumar: slightly…
363 00:39:23.040 ⇒ 00:39:23.720 Mustafa Raja: Bye.
364 00:39:24.820 ⇒ 00:39:25.140 Demilade Agboola: Yeah, so…
365 00:39:25.140 ⇒ 00:39:26.309 Mustafa Raja: Was it January?
366 00:39:28.100 ⇒ 00:39:32.420 Demilade Agboola: And so you can look at it, and that at least takes some mental load off me.
367 00:39:33.360 ⇒ 00:39:36.309 Demilade Agboola: So this is what it will produce if you…
368 00:39:36.680 ⇒ 00:39:38.840 Demilade Agboola: if you create the dbt model.
369 00:39:39.700 ⇒ 00:39:42.050 Demilade Agboola: And so you can look at it.
370 00:39:47.570 ⇒ 00:39:53.549 Demilade Agboola: So, it will basically create new rows, so you can look for the new rows, ad spend by product date.
371 00:39:53.740 ⇒ 00:39:57.699 Demilade Agboola: So it’s basically putting… Eat on only one spot.
372 00:40:02.720 ⇒ 00:40:03.860 Mustafa Raja: Hmm…
373 00:40:08.940 ⇒ 00:40:12.089 Demilade Agboola: So for each product, I guess it’s just trying to do it one time.
374 00:40:13.840 ⇒ 00:40:21.099 Demilade Agboola: So that when you now do the sum, it would just do it properly, instead of having to do the max of each combination first.
375 00:40:23.630 ⇒ 00:40:37.300 Mustafa Raja: What I was… what I am really looking for is to, you know, get this new product users. Will it be able to do this? Is there a column for that? New product users?
376 00:40:37.480 ⇒ 00:40:39.710 Demilade Agboola: Yes, there is a con for new.
377 00:40:39.930 ⇒ 00:40:41.120 Mustafa Raja: Amuses.
378 00:40:43.210 ⇒ 00:40:44.579 Mustafa Raja: Okay, I guess.
379 00:40:45.170 ⇒ 00:40:48.570 Mustafa Raja: And, and which table, is this going into?
380 00:40:50.950 ⇒ 00:40:56.019 Demilade Agboola: What do you mean? It’s a model, it’s the model that you created, I just compiled it. That model that you created.
381 00:40:56.570 ⇒ 00:40:58.720 Mustafa Raja: So it’s going to be a table itself, right?
382 00:40:58.910 ⇒ 00:41:00.229 Demilade Agboola: Yeah, it’s gonna be the table itself.
383 00:41:00.940 ⇒ 00:41:01.640 Mustafa Raja: Okay.
384 00:41:03.080 ⇒ 00:41:07.419 Mustafa Raja: I just, so I would need to join it with sales summary.
385 00:41:07.690 ⇒ 00:41:08.730 Mustafa Raja: So…
386 00:41:11.930 ⇒ 00:41:13.580 Demilade Agboola: It’s already joined by its sales summary.
387 00:41:14.330 ⇒ 00:41:20.780 Demilade Agboola: That’s what I’m trying to make you understand. It’s the mod, like, it’s… sales summary joins a first-time product user summary.
388 00:41:22.900 ⇒ 00:41:23.620 Mustafa Raja: Okay.
389 00:41:26.670 ⇒ 00:41:28.090 Mustafa Raja: Yeah, I guess it’s good.
390 00:41:28.100 ⇒ 00:41:31.740 Demilade Agboola: Yeah, it’s just in the marks of the combinations of dates.
391 00:41:32.910 ⇒ 00:41:33.690 Mustafa Raja: Yep.
392 00:41:33.690 ⇒ 00:41:36.100 Demilade Agboola: Yeah, but the other details are still there.
393 00:41:37.230 ⇒ 00:41:38.660 Mustafa Raja: Yep, okay.
394 00:41:39.020 ⇒ 00:41:47.180 Mustafa Raja: Yeah, let’s, let’s get this… Wait…
395 00:41:49.530 ⇒ 00:41:51.579 Mustafa Raja: New product user can’t fix by this.
396 00:41:51.860 ⇒ 00:41:52.960 Mustafa Raja: 65?
397 00:41:53.210 ⇒ 00:41:54.230 Demilade Agboola: That’s okay.
398 00:41:55.820 ⇒ 00:41:56.600 Mustafa Raja: that…
399 00:42:01.070 ⇒ 00:42:01.550 Mustafa Raja: That’s…
400 00:42:05.080 ⇒ 00:42:14.119 Mustafa Raja: 36366… And this is core… E5. Let me, let me just, let me just filter this to…
401 00:42:15.990 ⇒ 00:42:17.010 Demilade Agboola: Yesterday, I think.
402 00:42:17.950 ⇒ 00:42:21.080 Mustafa Raja: Yesterday, it’s yesterday already.
403 00:42:22.640 ⇒ 00:42:25.529 Mustafa Raja: How do I select a day exactly here?
404 00:42:27.790 ⇒ 00:42:29.769 Demilade Agboola: You have to change the type of filter.
405 00:42:30.130 ⇒ 00:42:30.790 Mustafa Raja: Oh.
406 00:42:31.760 ⇒ 00:42:34.520 Demilade Agboola: So you can make it a bar, or something.
407 00:42:35.200 ⇒ 00:42:35.960 Mustafa Raja: Hmm.
408 00:42:36.060 ⇒ 00:42:37.050 Demilade Agboola: Sweet, like…
409 00:42:37.660 ⇒ 00:42:40.850 Mustafa Raja: 2, 2, 5, so 9, and 10.
410 00:42:41.570 ⇒ 00:42:46.490 Mustafa Raja: for… Injectable tumor.
411 00:42:50.300 ⇒ 00:42:52.460 Mustafa Raja: This should be somewhere to write.
412 00:42:59.750 ⇒ 00:43:01.250 Mustafa Raja: Injectable semen.
413 00:43:03.980 ⇒ 00:43:07.850 Mustafa Raja: multiplayer… Hmm.
414 00:43:15.230 ⇒ 00:43:20.199 Mustafa Raja: Hmm… I’m just not seeing… okay, this is for injectable semen.
415 00:43:21.680 ⇒ 00:43:24.949 Mustafa Raja: So, 5th, and… where am I standing?
416 00:43:26.130 ⇒ 00:43:27.950 Mustafa Raja: I’m standing on 6th.
417 00:43:28.740 ⇒ 00:43:34.170 Demilade Agboola: Also, let me confirm what it’s doing for… New products user.
418 00:43:37.370 ⇒ 00:43:44.079 Mustafa Raja: Wait, let me just, let me just get this dashboard, first, because, you know, we need to…
419 00:43:44.590 ⇒ 00:43:45.480 Awaish Kumar: What’s…
420 00:43:46.100 ⇒ 00:43:48.910 Mustafa Raja: Yeah, yeah, let’s get that dashboard, and then…
421 00:43:53.530 ⇒ 00:44:01.520 Mustafa Raja: Why did… This is good, this is not good.
422 00:44:12.790 ⇒ 00:44:13.640 Mustafa Raja: Neat.
423 00:44:20.740 ⇒ 00:44:24.290 Awaish Kumar: It’s still $116.
424 00:44:25.150 ⇒ 00:44:26.440 Awaish Kumar: For yesterday?
425 00:44:26.760 ⇒ 00:44:30.389 Awaish Kumar: Shouldn’t we remove… The abundant filter?
426 00:44:31.770 ⇒ 00:44:33.199 Mustafa Raja: Oh, which one?
427 00:44:34.710 ⇒ 00:44:37.960 Awaish Kumar: Can you see total revenue yesterday?
428 00:44:38.980 ⇒ 00:44:40.320 Mustafa Raja: Total revenue yesterday.
429 00:44:40.320 ⇒ 00:44:42.090 Awaish Kumar: This is good, okay.
430 00:44:42.780 ⇒ 00:44:51.129 Mustafa Raja: Yeah, yeah, so what I’m doing is I’m bringing all of the, all of the aggregations to this new topic. That’s what I’m doing.
431 00:44:51.360 ⇒ 00:44:52.120 Awaish Kumar: Okay.
432 00:44:52.900 ⇒ 00:44:57.129 Mustafa Raja: Yeah, let me just quickly add that, so…
433 00:44:57.380 ⇒ 00:45:02.760 Mustafa Raja: New order revenue yesterday, already in… So this one…
434 00:45:04.440 ⇒ 00:45:07.169 Mustafa Raja: Yeah, it just doesn’t do it on itself, so…
435 00:45:07.380 ⇒ 00:45:09.790 Mustafa Raja: I have to do some stuff manually.
436 00:45:12.890 ⇒ 00:45:14.629 Mustafa Raja: New order revenue 30 days.
437 00:45:34.930 ⇒ 00:45:35.610 Mustafa Raja: Shoot.
438 00:45:41.910 ⇒ 00:45:45.080 Awaish Kumar: Okay, and now you are also doing…
439 00:45:45.380 ⇒ 00:45:50.000 Awaish Kumar: the same carriers as AA villain, we want to have 31 days?
440 00:45:54.030 ⇒ 00:45:55.120 Awaish Kumar: I don’t know.
441 00:45:55.120 ⇒ 00:46:02.220 Mustafa Raja: Mmm, okay, give me a moment. So you’re suggesting that I should, I should make it different here?
442 00:46:02.390 ⇒ 00:46:03.960 Mustafa Raja: This leads up…
443 00:46:04.340 ⇒ 00:46:13.330 Awaish Kumar: This is… like, if you just say greater than equal to this, so if we subtract 30 days from today, it will be…
444 00:46:15.330 ⇒ 00:46:16.149 Mustafa Raja: Yeah, it really is.
445 00:46:16.220 ⇒ 00:46:25.279 Awaish Kumar: 4th Feb, right? And until today. We don’t want to… if we don’t want to include today’s data, then it should be greater than equal to
446 00:46:26.720 ⇒ 00:46:27.630 Awaish Kumar: permute.
447 00:46:28.290 ⇒ 00:46:31.810 Awaish Kumar: But it should stop at the yesterday’s date.
448 00:46:32.150 ⇒ 00:46:32.780 Awaish Kumar: Right?
449 00:46:33.470 ⇒ 00:46:35.209 Mustafa Raja: How do we stop that?
450 00:46:35.610 ⇒ 00:46:41.259 Awaish Kumar: We can add a condition like less than… Current date, or something.
451 00:46:41.260 ⇒ 00:46:45.070 Mustafa Raja: Oh, okay, and less, and…
452 00:46:47.220 ⇒ 00:46:48.460 Awaish Kumar: This is Eastern.
453 00:46:50.030 ⇒ 00:46:55.939 Mustafa Raja: This is less than… How do I say today?
454 00:46:56.060 ⇒ 00:46:57.670 Mustafa Raja: Current date, right? So…
455 00:47:00.800 ⇒ 00:47:02.459 Mustafa Raja: Can I not do this?
456 00:47:04.550 ⇒ 00:47:06.090 Awaish Kumar: No, no, no.
457 00:47:06.720 ⇒ 00:47:10.550 Awaish Kumar: It won’t do what we want to do.
458 00:47:11.230 ⇒ 00:47:11.940 Mustafa Raja: Love you.
459 00:47:12.570 ⇒ 00:47:18.140 Awaish Kumar: It will just subtract from current day, minus 1, and then from there, it will… might subtract 30 days.
460 00:47:18.140 ⇒ 00:47:18.700 Mustafa Raja: Okay.
461 00:47:18.890 ⇒ 00:47:25.660 Awaish Kumar: Where’s still… Yeah, we don’t want to include current date, which is, like, 6th March, which is running revenue.
462 00:47:26.310 ⇒ 00:47:28.350 Awaish Kumar: I just want to put closed revenue.
463 00:47:28.820 ⇒ 00:47:35.240 Mustafa Raja: Okay, okay. So this is, like, so this is going to make sure that, yeah, our date is less than this current date, right?
464 00:47:35.240 ⇒ 00:47:36.080 Awaish Kumar: It’s this…
465 00:47:37.180 ⇒ 00:47:39.359 Mustafa Raja: Okay, so… this is good, then?
466 00:47:40.670 ⇒ 00:47:42.010 Awaish Kumar: Yes, it should be.
467 00:47:42.260 ⇒ 00:47:43.020 Mustafa Raja: Okay.
468 00:47:44.020 ⇒ 00:47:47.610 Mustafa Raja: Yeah, I’ll update the rest of the ones, too.
469 00:47:48.330 ⇒ 00:47:52.049 Mustafa Raja: With this, let me just, for now, get all of them here.
470 00:47:53.860 ⇒ 00:47:56.260 Mustafa Raja: Then I can make this adjust… adjustment.
471 00:47:56.670 ⇒ 00:47:59.000 Mustafa Raja: 30 day, I think there’s just…
472 00:47:59.280 ⇒ 00:48:02.689 Mustafa Raja: Yeah, this is the last one, 30D.
473 00:48:04.720 ⇒ 00:48:06.949 Mustafa Raja: And… new customer surgery.
474 00:48:08.970 ⇒ 00:48:10.199 Mustafa Raja: In this research.
475 00:48:11.700 ⇒ 00:48:13.020 Mustafa Raja: Swim writing, okay.
476 00:48:53.610 ⇒ 00:48:55.510 Mustafa Raja: Oh, this is… this should be good.
477 00:48:55.780 ⇒ 00:48:58.489 Mustafa Raja: Either way, because this is just one day, right?
478 00:49:00.110 ⇒ 00:49:03.110 Mustafa Raja: No, this, this still needs to be added, okay.
479 00:49:04.070 ⇒ 00:49:07.089 Awaish Kumar: This is just for yesterday, right? So we don’t…
480 00:49:07.090 ⇒ 00:49:09.910 Mustafa Raja: But this is going to include today also, right? So…
481 00:49:10.220 ⇒ 00:49:10.960 Awaish Kumar: I don’t know.
482 00:49:11.770 ⇒ 00:49:13.720 Mustafa Raja: Okay, good.
483 00:49:13.930 ⇒ 00:49:15.870 Awaish Kumar: This condition is equals.
484 00:49:15.870 ⇒ 00:49:17.949 Mustafa Raja: Oh, yeah, equal dog, sorry, sorry, fine.
485 00:49:20.180 ⇒ 00:49:21.810 Mustafa Raja: Okay.
486 00:49:21.960 ⇒ 00:49:22.690 Mustafa Raja: Landa.
487 00:49:39.220 ⇒ 00:49:43.780 Mustafa Raja: I’m just going to make sure that my columns are perfectly aligned.
488 00:49:44.260 ⇒ 00:49:45.589 Mustafa Raja: With the columns.
489 00:49:45.870 ⇒ 00:49:57.460 Mustafa Raja: In order… So, why do new order revenue, new total, new order revenue, why they… New the revenue.
490 00:50:06.900 ⇒ 00:50:12.350 Awaish Kumar: Total revenue, mostly… And then we should have new customer revenue yesterday.
491 00:50:13.570 ⇒ 00:50:15.650 Awaish Kumar: And the orders for yesterday.
492 00:50:22.890 ⇒ 00:50:24.059 Mustafa Raja: Okay, this is…
493 00:50:33.600 ⇒ 00:50:34.320 Mustafa Raja: Okay.
494 00:50:36.950 ⇒ 00:50:38.429 Mustafa Raja: What order did you say?
495 00:50:42.970 ⇒ 00:50:44.030 Mustafa Raja: And then…
496 00:50:55.580 ⇒ 00:51:00.190 Mustafa Raja: And then total revenue, total orders, total revenue, total orders.
497 00:51:01.540 ⇒ 00:51:03.679 Mustafa Raja: Total revenue, 30 days.
498 00:51:22.870 ⇒ 00:51:25.110 Mustafa Raja: New customers OGD.
499 00:51:39.120 ⇒ 00:51:40.979 Mustafa Raja: And then 6060.
500 00:51:42.310 ⇒ 00:51:45.209 Mustafa Raja: Pending customers want tables there.
501 00:51:47.790 ⇒ 00:51:50.899 Mustafa Raja: So, we have pending customers and new orders every 30 days.
502 00:51:51.740 ⇒ 00:51:55.120 Mustafa Raja: Which goes… DR.
503 00:51:57.040 ⇒ 00:51:58.519 Mustafa Raja: And this one goes…
504 00:52:02.540 ⇒ 00:52:03.490 Mustafa Raja: Okay.
505 00:52:03.730 ⇒ 00:52:07.959 Mustafa Raja: So for Y-Day, I don’t need to do anything for 30 day, and for…
506 00:52:08.260 ⇒ 00:52:12.350 Mustafa Raja: 60-day, I need to make sure that we exclude today.
507 00:52:27.100 ⇒ 00:52:28.160 Mustafa Raja: Hmm…
508 00:52:42.800 ⇒ 00:52:44.449 Awaish Kumar: Yeah, it’s broken.
509 00:52:45.070 ⇒ 00:52:46.040 Awaish Kumar: It’s broken.
510 00:52:47.310 ⇒ 00:52:48.800 Mustafa Raja: Oh, yeah, sorry.
511 00:53:24.650 ⇒ 00:53:30.220 Mustafa Raja: Let me just copy this so I can just paste it directly in each of these, rather than having to write…
512 00:54:18.200 ⇒ 00:54:22.640 Mustafa Raja: Hmm… Okay, this one already has them.
513 00:54:26.440 ⇒ 00:54:28.290 Mustafa Raja: And this one…
514 00:54:32.980 ⇒ 00:54:34.310 Awaish Kumar: Okay, I’m gonna move…
515 00:54:34.890 ⇒ 00:54:35.980 Mustafa Raja: Yeah.
516 00:54:37.130 ⇒ 00:54:38.970 Mustafa Raja: As soon as I had the filter.
517 00:54:39.690 ⇒ 00:54:40.720 Mustafa Raja: Okay.
518 00:54:42.570 ⇒ 00:54:44.789 Mustafa Raja: Okay, we should be good now.
519 00:54:45.120 ⇒ 00:54:46.769 Mustafa Raja: Let’s test it out.
520 00:54:49.000 ⇒ 00:54:51.250 Awaish Kumar: Oh, this number went down, why?
521 00:54:51.570 ⇒ 00:54:55.319 Mustafa Raja: did we exclude today in the query?
522 00:54:56.660 ⇒ 00:54:58.250 Mustafa Raja: In the BigQuery quid?
523 00:54:58.880 ⇒ 00:55:00.709 Awaish Kumar: Yeah, but this is just yesterday.
524 00:55:03.230 ⇒ 00:55:05.049 Mustafa Raja: Oh, why did it go down?
525 00:55:05.410 ⇒ 00:55:06.940 Mustafa Raja: Total revenue while they…
526 00:55:23.340 ⇒ 00:55:27.840 Awaish Kumar: is adding other… and majors…
527 00:55:29.320 ⇒ 00:55:31.250 Mustafa Raja: No, that shouldn’t affect it.
528 00:55:31.770 ⇒ 00:55:34.760 Mustafa Raja: I never saw it affecting anything.
529 00:55:37.450 ⇒ 00:55:39.240 Awaish Kumar: Okay, I don’t know.
530 00:55:39.240 ⇒ 00:55:44.660 Mustafa Raja: Can we… can we query again, D, in… in… What’s it called?
531 00:55:45.470 ⇒ 00:55:46.590 Awaish Kumar: In the wake curry.
532 00:55:46.810 ⇒ 00:55:47.620 Mustafa Raja: Yeah.
533 00:55:48.960 ⇒ 00:55:51.240 Awaish Kumar: I’m looking…
534 00:55:54.970 ⇒ 00:55:56.340 Mustafa Raja: 10 refresh…
535 00:55:56.340 ⇒ 00:56:02.140 Awaish Kumar: Okay, this one… Let’s see… Injectable somehow.
536 00:56:02.820 ⇒ 00:56:04.599 Awaish Kumar: Okay, it went down.
537 00:56:05.330 ⇒ 00:56:07.369 Mustafa Raja: Oh, so… good?
538 00:56:07.870 ⇒ 00:56:10.300 Awaish Kumar: 117208.
539 00:56:10.750 ⇒ 00:56:12.499 Mustafa Raja: Yeah, it’s exactly the same.
540 00:56:13.320 ⇒ 00:56:15.920 Awaish Kumar: Okay, why does it end down?
541 00:56:18.160 ⇒ 00:56:20.099 Mustafa Raja: It went down in Big Buddy also, right?
542 00:56:20.460 ⇒ 00:56:21.210 Awaish Kumar: Yeah, yeah.
543 00:56:21.670 ⇒ 00:56:29.080 Awaish Kumar: Why do we not all. Let’s… Let’s, yeah, keep pushing.
544 00:56:29.950 ⇒ 00:56:39.550 Mustafa Raja: Okay, okay. I’m treating this. So, we should be able to test this one. Let me go here, and then let me make sure…
545 00:56:39.550 ⇒ 00:56:40.919 Awaish Kumar: I didn’t international.
546 00:56:41.680 ⇒ 00:56:42.370 Mustafa Raja: Buddy?
547 00:56:43.000 ⇒ 00:56:45.649 Awaish Kumar: Yeah, I’m saying just add it in the dashboard, then we can…
548 00:56:46.040 ⇒ 00:56:49.850 Mustafa Raja: Yeah, I’m doing that exactly.
549 00:56:50.720 ⇒ 00:56:54.989 Mustafa Raja: I’m going to hide this… Because we won’t be needing this.
550 00:56:55.590 ⇒ 00:56:57.830 Mustafa Raja: And then, let’s…
551 00:57:00.120 ⇒ 00:57:01.300 Mustafa Raja: Let’s make it bigger.
552 00:57:04.740 ⇒ 00:57:05.860 Awaish Kumar: Yeah, a little more.
553 00:57:06.130 ⇒ 00:57:07.499 Mustafa Raja: There’s just one…
554 00:57:07.500 ⇒ 00:57:08.220 Awaish Kumar: Remaining.
555 00:57:10.380 ⇒ 00:57:12.210 Mustafa Raja: Yeah, yeah, okay.
556 00:57:12.620 ⇒ 00:57:17.300 Mustafa Raja: Let me rename it also, so… This one’s weird.
557 00:57:20.740 ⇒ 00:57:21.520 Mustafa Raja: Copy.
558 00:57:26.580 ⇒ 00:57:30.829 Mustafa Raja: Okay, let’s look, let’s take a look.
559 00:57:32.240 ⇒ 00:57:35.089 Mustafa Raja: Also, one thing I’m liking here… okay, I’m gonna take.
560 00:57:35.090 ⇒ 00:57:37.939 Awaish Kumar: Yeah, we can. Let’s fix that.
561 00:57:38.600 ⇒ 00:57:39.540 Mustafa Raja: So, what…
562 00:57:43.040 ⇒ 00:57:45.120 Awaish Kumar: Renaming field for the… for the.
563 00:57:45.120 ⇒ 00:57:47.559 Mustafa Raja: Oh, no, yeah, I didn’t notice it, sorry.
564 00:57:49.750 ⇒ 00:57:51.280 Awaish Kumar: It’s because you’re having…
565 00:57:51.280 ⇒ 00:57:53.910 Mustafa Raja: Because we already have the same name.
566 00:57:54.230 ⇒ 00:57:54.920 Awaish Kumar: Yes.
567 00:57:55.620 ⇒ 00:57:59.060 Mustafa Raja: Okay, let me, let me fix that in the workbook, then.
568 00:58:08.280 ⇒ 00:58:09.650 Awaish Kumar: Yeah, maybe.
569 00:58:09.920 ⇒ 00:58:12.240 Awaish Kumar: Rename this to the old…
570 00:58:12.240 ⇒ 00:58:13.860 Mustafa Raja: Yeah.
571 00:58:18.120 ⇒ 00:58:20.060 Mustafa Raja: And then…
572 00:58:24.890 ⇒ 00:58:26.840 Awaish Kumar: Okay, let’s get back.
573 00:58:30.440 ⇒ 00:58:31.320 Mustafa Raja: dashboard.
574 00:58:32.120 ⇒ 00:58:34.030 Awaish Kumar: We can publish the changes.
575 00:58:37.120 ⇒ 00:58:37.760 Mustafa Raja: Okay.
576 00:58:38.120 ⇒ 00:58:39.229 Mustafa Raja: Let’s a group.
577 00:58:39.770 ⇒ 00:58:45.470 Awaish Kumar: Okay, the total revenue looks fine for injectable SEMA. Let’s look at the…
578 00:58:46.440 ⇒ 00:58:50.719 Awaish Kumar: New the revenue ID, let’s, let’s click on that. Click on edit.
579 00:58:52.280 ⇒ 00:58:54.499 Mustafa Raja: Okay, okay.
580 00:58:54.500 ⇒ 00:58:56.639 Awaish Kumar: Edit chart, and
581 00:59:00.610 ⇒ 00:59:04.449 Awaish Kumar: And go to the… call locator text.
582 00:59:07.430 ⇒ 00:59:10.799 Awaish Kumar: You can go to the header text on the right-hand side.
583 00:59:13.080 ⇒ 00:59:16.630 Awaish Kumar: And click on those, on those, yeah, this one.
584 00:59:16.770 ⇒ 00:59:18.850 Awaish Kumar: Yeah, let’s publish this.
585 00:59:19.730 ⇒ 00:59:20.620 Mustafa Raja: Okay, okay.
586 00:59:23.950 ⇒ 00:59:28.859 Mustafa Raja: Yeah, we might want to also add dollar signs to the revenue ones, right?
587 00:59:30.770 ⇒ 00:59:33.019 Mustafa Raja: Yeah, I’ll do that one free Q&A, I’ll do that.
588 00:59:33.640 ⇒ 00:59:36.900 Awaish Kumar: Let’s give away then. Then we have new order.
589 00:59:37.290 ⇒ 00:59:41.950 Awaish Kumar: Revenue, and this depends… User outer counter, right?
590 00:59:42.830 ⇒ 00:59:44.950 Awaish Kumar: Can I get out of this?
591 00:59:46.000 ⇒ 00:59:59.070 Awaish Kumar: And… equals one, and… For yesterday, it is, 17,365.
592 00:59:59.530 ⇒ 01:00:00.490 Mustafa Raja: No, same.
593 01:00:01.150 ⇒ 01:00:03.009 Mustafa Raja: Yeah, this is exactly the same.
594 01:00:04.930 ⇒ 01:00:12.240 Awaish Kumar: Okay, and then we have total orders, and… Let me go.
595 01:00:12.460 ⇒ 01:00:14.130 Awaish Kumar: Distingu…
596 01:00:23.740 ⇒ 01:00:24.600 Mustafa Raja: This is good?
597 01:00:26.110 ⇒ 01:00:29.740 Awaish Kumar: Order number for yesterday, total orders are 77.
598 01:00:30.410 ⇒ 01:00:34.930 Mustafa Raja: Yeah, total orders are 70… new customers are 77.
599 01:00:35.300 ⇒ 01:00:42.450 Awaish Kumar: Yeah, and without… and the… without new customers, It is, 518.
600 01:00:42.620 ⇒ 01:00:43.300 Awaish Kumar: Okay.
601 01:00:43.570 ⇒ 01:00:45.219 Mustafa Raja: Yeah, 514, yeah.
602 01:00:46.050 ⇒ 01:00:47.739 Awaish Kumar: What is pending customers?
603 01:00:48.660 ⇒ 01:00:51.210 Mustafa Raja: I can show you the definition.
604 01:01:04.220 ⇒ 01:01:07.269 Mustafa Raja: So, this here is the definition of that.
605 01:01:08.170 ⇒ 01:01:10.190 Awaish Kumar: This is the same as the new one.
606 01:01:12.160 ⇒ 01:01:21.560 Mustafa Raja: Okay, let me see… New customers, pending customers. Okay, so this is some other definition, depending on… Lending.
607 01:01:23.580 ⇒ 01:01:26.219 Awaish Kumar: Let’s click on this one…
608 01:01:26.790 ⇒ 01:01:28.540 Mustafa Raja: Alright, let me reconnect.
609 01:01:31.940 ⇒ 01:01:33.589 Mustafa Raja: Oh, this isn’t.
610 01:01:34.860 ⇒ 01:01:36.590 Awaish Kumar: Yeah, let me do it.
611 01:01:48.420 ⇒ 01:01:51.560 Awaish Kumar: Yeah, it says, user order counters.
612 01:01:52.800 ⇒ 01:01:55.469 Awaish Kumar: And the current state is equal to abandoned.
613 01:01:57.080 ⇒ 01:02:01.570 Mustafa Raja: Okay, okay, pending… I’m just going to try to copy.
614 01:02:03.150 ⇒ 01:02:03.470 Awaish Kumar: Just…
615 01:02:07.100 ⇒ 01:02:10.019 Awaish Kumar: Yeah, it just says one more filter of current status.
616 01:02:10.020 ⇒ 01:02:14.369 Mustafa Raja: Okay, okay, okay, let me, let me do that, then…
617 01:02:14.710 ⇒ 01:02:18.410 Mustafa Raja: Let me add that filter, and… Hmm.
618 01:02:21.690 ⇒ 01:02:35.870 Mustafa Raja: And here, we are going to see… Good on… Current… Status… loans… Abandoned Ava…
619 01:02:37.260 ⇒ 01:02:43.490 Awaish Kumar: Because you should only have to… Point to the… View name?
620 01:02:47.530 ⇒ 01:02:48.469 Mustafa Raja: Like this, right?
621 01:02:51.450 ⇒ 01:02:54.530 Awaish Kumar: This… their current status is the field, right?
622 01:02:54.750 ⇒ 01:02:56.270 Awaish Kumar: In the fact transaction.
623 01:02:56.880 ⇒ 01:03:00.340 Mustafa Raja: Oh, sorry, sorry for this.
624 01:03:01.470 ⇒ 01:03:02.399 Mustafa Raja: Yeah, you’re right.
625 01:03:02.570 ⇒ 01:03:04.070 Mustafa Raja: This, right?
626 01:03:04.890 ⇒ 01:03:05.630 Awaish Kumar: Yes.
627 01:03:06.280 ⇒ 01:03:08.530 Mustafa Raja: Okay, let me update this.
628 01:03:25.500 ⇒ 01:03:33.560 Demilade Agboola: I wish… I think I know the issue with the ticket you sent to me. I don’t think what… the topic is built off the daily table, rather than the…
629 01:03:33.810 ⇒ 01:03:39.060 Demilade Agboola: Other than the high-level summary table.
630 01:03:41.640 ⇒ 01:03:46.419 Demilade Agboola: That’s why even the numbers are much lower. The cohort sizes are much lower.
631 01:03:50.850 ⇒ 01:03:55.209 Demilade Agboola: So for December, we have 3,889.
632 01:03:56.180 ⇒ 01:04:00.500 Demilade Agboola: But when you look at it in… this dashboard…
633 01:04:01.970 ⇒ 01:04:11.220 Demilade Agboola: The cohort size is… give me one second, I’m trying to… When the cohort size is…
634 01:04:17.410 ⇒ 01:04:22.529 Demilade Agboola: The quarter is 148, so it’s, like, 30 times less, almost 40 times less.
635 01:04:23.020 ⇒ 01:04:28.960 Demilade Agboola: So… I… the issue is that… is the… The tables we’re using.
636 01:04:29.200 ⇒ 01:04:37.149 Demilade Agboola: So we need to switch… let me try and switch it to the, bigger table, like the monthly table, and see what the numbers look like.
637 01:04:38.480 ⇒ 01:04:39.160 Awaish Kumar: Okay.
638 01:04:39.340 ⇒ 01:04:43.029 Mustafa Raja: So, are you going to, edit the topic or the chart?
639 01:04:43.410 ⇒ 01:04:44.290 Demilade Agboola: Eddie the topic.
640 01:04:45.210 ⇒ 01:04:53.740 Mustafa Raja: I guess, the, it might be worth it, worth looking into if we have a topic with, with the, with the table that you need, you know?
641 01:04:55.280 ⇒ 01:04:57.540 Mustafa Raja: Because we might already have that topic.
642 01:05:01.800 ⇒ 01:05:03.079 Demilade Agboola: Alright, let me look into that.
643 01:05:03.720 ⇒ 01:05:04.630 Mustafa Raja: Okay, okay.
644 01:05:04.950 ⇒ 01:05:14.649 Mustafa Raja: Because I don’t know if the topic is being used with any other charts, and if it is, then those charts are going to be, you know, affected.
645 01:05:14.650 ⇒ 01:05:15.190 Demilade Agboola: -
646 01:05:15.740 ⇒ 01:05:16.510 Demilade Agboola: That’s fair.
647 01:05:17.570 ⇒ 01:05:21.009 Mustafa Raja: Okay, okay, let’s take a look at this ovation.
648 01:05:22.150 ⇒ 01:05:27.420 Awaish Kumar: Okay, 30-day revenue?
649 01:05:28.010 ⇒ 01:05:28.740 Mustafa Raja: Yeah, yeah.
650 01:05:29.420 ⇒ 01:05:31.500 Awaish Kumar: Injectables about…
651 01:05:35.940 ⇒ 01:05:41.840 Awaish Kumar: So, for the last 30 days is starting from… Good for him.
652 01:05:45.020 ⇒ 01:05:47.069 Awaish Kumar: This one, and we need one more.
653 01:05:48.300 ⇒ 01:05:49.500 Awaish Kumar: Group by…
654 01:05:59.150 ⇒ 01:06:01.060 Awaish Kumar: Transactional revenue, okay.
655 01:06:02.060 ⇒ 01:06:08.830 Awaish Kumar: It is a rejectables amount, this is… Holy shit.
656 01:06:12.130 ⇒ 01:06:15.300 Awaish Kumar: Like, 3.88 million?
657 01:06:15.300 ⇒ 01:06:16.720 Mustafa Raja: Yeah, 3.8, yeah.
658 01:06:17.010 ⇒ 01:06:17.710 Awaish Kumar: Okay.
659 01:06:19.160 ⇒ 01:06:24.509 Mustafa Raja: And then, total order revenue… well, sorry, new order revenue, sorry. New order revenue.
660 01:06:24.870 ⇒ 01:06:26.070 Mustafa Raja: For 30 days.
661 01:06:27.070 ⇒ 01:06:29.870 Awaish Kumar: Yeah, let me just add one card.
662 01:06:30.620 ⇒ 01:06:34.400 Awaish Kumar: Cruzer… Hmm.
663 01:06:36.360 ⇒ 01:06:38.820 Awaish Kumar: This is, like, self.
664 01:06:39.140 ⇒ 01:06:41.360 Awaish Kumar: 711372.
665 01:06:42.540 ⇒ 01:06:42.910 Awaish Kumar: Yep.
666 01:06:44.430 ⇒ 01:06:45.290 Awaish Kumar: Let’s repeat that.
667 01:06:45.290 ⇒ 01:06:47.620 Mustafa Raja: Now, 30-day total orders?
668 01:06:49.370 ⇒ 01:06:51.510 Awaish Kumar: Yes,
669 01:07:08.290 ⇒ 01:07:11.220 Awaish Kumar: 357? 3,057.
670 01:07:12.500 ⇒ 01:07:13.240 Mustafa Raja: Yes.
671 01:07:13.610 ⇒ 01:07:15.549 Mustafa Raja: That is correct.
672 01:07:15.830 ⇒ 01:07:18.219 Mustafa Raja: And then we have total revenue… sorry?
673 01:07:19.620 ⇒ 01:07:26.450 Awaish Kumar: Total orders… For the new is… okay, new… for the new one, it’s 357.
674 01:07:26.620 ⇒ 01:07:31.639 Awaish Kumar: And without new, The total ones.
675 01:07:32.440 ⇒ 01:07:36.310 Awaish Kumar: Should be… I’ll check.
676 01:07:38.140 ⇒ 01:07:42.060 Awaish Kumar: 16,913. Okay.
677 01:07:42.060 ⇒ 01:07:43.799 Mustafa Raja: Yep. Yeah. Okay.
678 01:07:44.010 ⇒ 01:07:48.650 Mustafa Raja: And then let’s take a look at, total revenue for 60 days now.
679 01:07:50.020 ⇒ 01:07:52.130 Awaish Kumar: 60 starts from 1.
680 01:07:53.180 ⇒ 01:07:55.460 Awaish Kumar: 6th… 6th January, right?
681 01:07:56.150 ⇒ 01:07:58.420 Mustafa Raja: Yeah, I believe so.
682 01:08:06.570 ⇒ 01:08:07.510 Awaish Kumar: Okay.
683 01:08:08.860 ⇒ 01:08:16.500 Awaish Kumar: Transaction revenue… is a 7… 460258.
684 01:08:17.279 ⇒ 01:08:18.730 Awaish Kumar: This is difficult.
685 01:08:19.960 ⇒ 01:08:21.529 Mustafa Raja: Siri, what was the value?
686 01:08:23.950 ⇒ 01:08:26.640 Awaish Kumar: 7460258.
687 01:08:26.649 ⇒ 01:08:27.419 Mustafa Raja: Hmm.
688 01:08:27.999 ⇒ 01:08:31.109 Mustafa Raja: So, total revenue 60, total revenue…
689 01:08:32.699 ⇒ 01:08:34.309 Awaish Kumar: It’s 715.
690 01:08:35.930 ⇒ 01:08:39.430 Mustafa Raja: Total revenue 60 day… I did.
691 01:08:39.930 ⇒ 01:08:41.470 Awaish Kumar: per injectable seminar.
692 01:08:42.170 ⇒ 01:08:44.720 Awaish Kumar: Let me verify the date.
693 01:08:44.720 ⇒ 01:08:47.770 Mustafa Raja: The dates are… yeah, let’s verify the date.
694 01:08:47.770 ⇒ 01:08:50.030 Awaish Kumar: Before you make any changes.
695 01:08:55.529 ⇒ 01:08:56.689 Awaish Kumar: That’s wrong.
696 01:08:57.689 ⇒ 01:09:01.939 Awaish Kumar: It’s from 5th, so it should be correct.
697 01:09:03.890 ⇒ 01:09:07.289 Mustafa Raja: Okay, now let’s, let’s take a look at the total load.
698 01:09:08.210 ⇒ 01:09:09.069 Mustafa Raja: Sorry?
699 01:09:11.500 ⇒ 01:09:13.270 Awaish Kumar: It looks okay, it’s correct.
700 01:09:13.779 ⇒ 01:09:14.659 Mustafa Raja: Okay, okay.
701 01:09:14.889 ⇒ 01:09:17.259 Mustafa Raja: Okay, so this should be good then, right?
702 01:09:18.729 ⇒ 01:09:21.539 Awaish Kumar: Let’s find out the total orders.
703 01:09:22.899 ⇒ 01:09:26.579 Mustafa Raja: Oh yeah, okay, okay. Total order, yeah, let’s take a look at that.
704 01:09:28.109 ⇒ 01:09:33.439 Awaish Kumar: It is, like, 33,564.
705 01:09:33.660 ⇒ 01:09:34.000 Mustafa Raja: Yes, sir.
706 01:09:34.000 ⇒ 01:09:35.229 Awaish Kumar: Okay, correct.
707 01:09:35.689 ⇒ 01:09:36.739 Mustafa Raja: That is correct, okay.
708 01:09:36.740 ⇒ 01:09:40.400 Awaish Kumar: correct, based on the queries we have, we are…
709 01:09:40.810 ⇒ 01:09:44.670 Awaish Kumar: It was, like, abandoned for the top titles.
710 01:09:44.840 ⇒ 01:09:47.740 Awaish Kumar: tactiles, but we are not using that for…
711 01:09:48.100 ⇒ 01:09:51.439 Awaish Kumar: the charts, that is the only difference with Tableau, right?
712 01:09:51.850 ⇒ 01:09:52.859 Mustafa Raja: Yes, yes.
713 01:09:53.359 ⇒ 01:09:55.359 Awaish Kumar: No, that’s not the default. That’s the…
714 01:09:55.519 ⇒ 01:10:04.709 Awaish Kumar: That’s exactly how Tableau does it. The only difference we have with Tableau is we are not including the current day, while the Tableau was including the current day.
715 01:10:05.299 ⇒ 01:10:07.080 Mustafa Raja: Yeah, yeah.
716 01:10:07.940 ⇒ 01:10:14.880 Awaish Kumar: Okay, this should be good. Let me… can you help? Yeah, let’s… let’s write down a message for…
717 01:10:18.760 ⇒ 01:10:20.829 Mustafa Raja: Sorry, are you… are you saying something to me?
718 01:10:21.700 ⇒ 01:10:24.169 Awaish Kumar: Saying we need to write a message for.
719 01:10:24.560 ⇒ 01:10:29.689 Mustafa Raja: Okay, okay. Let me publish this.
720 01:10:31.070 ⇒ 01:10:33.929 Awaish Kumar: Let’s publish this, and then what is…
721 01:10:34.790 ⇒ 01:10:40.049 Awaish Kumar: How basically he sees… how Josh sees it. Is he directly logged into the…
722 01:10:41.410 ⇒ 01:10:44.580 Mustafa Raja: I think, I think Josh already has access, no?
723 01:10:46.780 ⇒ 01:10:50.039 Awaish Kumar: However, how he actually goes in, that’s what I…
724 01:10:52.150 ⇒ 01:10:53.350 Mustafa Raja: Okay, that’s a video.
725 01:10:54.200 ⇒ 01:10:55.760 Mustafa Raja: I think he has a login.
726 01:10:57.020 ⇒ 01:10:59.269 Awaish Kumar: Okay, Omni sends the message.
727 01:10:59.690 ⇒ 01:11:00.620 Awaish Kumar: Cons like…
728 01:11:01.570 ⇒ 01:11:02.420 Mustafa Raja: Oh.
729 01:11:03.030 ⇒ 01:11:05.500 Awaish Kumar: Okay, can you send this one?
730 01:11:05.800 ⇒ 01:11:06.800 Awaish Kumar: Through only.
731 01:11:09.350 ⇒ 01:11:11.250 Mustafa Raja: I didn’t know we had that set up.
732 01:11:12.530 ⇒ 01:11:14.280 Awaish Kumar: There is a PNG.
733 01:11:15.110 ⇒ 01:11:16.530 Awaish Kumar: Sand by…
734 01:11:20.770 ⇒ 01:11:30.530 Mustafa Raja: Okay. Greg might have set that up… Because it wasn’t me… So, schedule… Okay, let me…
735 01:11:31.260 ⇒ 01:11:32.939 Awaish Kumar: Damien, do you know how can we…
736 01:11:33.230 ⇒ 01:11:36.290 Awaish Kumar: like, can we push forcefully from Omni?
737 01:11:36.760 ⇒ 01:11:40.149 Awaish Kumar: the… report to the Slack channel.
738 01:11:41.380 ⇒ 01:11:49.910 Demilade Agboola: forcefully… so, there are two ways. You can either download it and put it there, or you can send an email. I know that… I don’t know how Greg said of the schedule.
739 01:11:50.210 ⇒ 01:11:52.410 Demilade Agboola: But I noticed… so look at Share.
740 01:11:52.800 ⇒ 01:11:53.849 Demilade Agboola: I go to File.
741 01:11:55.050 ⇒ 01:11:56.080 Mustafa Raja: This one.
742 01:11:56.320 ⇒ 01:11:57.810 Demilade Agboola: Yes, let’s see.
743 01:12:00.450 ⇒ 01:12:02.600 Awaish Kumar: Is there, like, a schedule…
744 01:12:04.030 ⇒ 01:12:07.639 Mustafa Raja: Yeah, I don’t see a schedule, to be honest.
745 01:12:07.640 ⇒ 01:12:08.890 Demilade Agboola: Go to the settings, please.
746 01:12:10.860 ⇒ 01:12:13.440 Demilade Agboola: Like, no, no, share, and then sentence, I think.
747 01:12:14.230 ⇒ 01:12:15.189 Mustafa Raja: Oh, this one, okay.
748 01:12:15.190 ⇒ 01:12:16.430 Awaish Kumar: Yes, excellent.
749 01:12:16.710 ⇒ 01:12:17.790 Mustafa Raja: No, scheduled.
750 01:12:18.390 ⇒ 01:12:19.280 Demilade Agboola: So…
751 01:12:21.930 ⇒ 01:12:22.750 Awaish Kumar: Okay.
752 01:12:23.120 ⇒ 01:12:24.279 Demilade Agboola: Yeah, that’s all.
753 01:12:25.730 ⇒ 01:12:27.660 Demilade Agboola: They know that it’s scheduled somewhere.
754 01:12:28.050 ⇒ 01:12:34.719 Demilade Agboola: So you might need to, like, just check OmniDocs, like, what is scheduled to, and then if it’s, like, you maybe rerun it, rerun the schedule.
755 01:12:35.140 ⇒ 01:12:38.250 Awaish Kumar: Okay, let’s… can you publish, Musta, before…
756 01:12:38.570 ⇒ 01:12:40.560 Mustafa Raja: Yeah, the dashboard is published.
757 01:12:41.470 ⇒ 01:12:43.139 Mustafa Raja: Dashboard is updated.
758 01:12:43.390 ⇒ 01:12:44.310 Mustafa Raja: Published.
759 01:12:44.570 ⇒ 01:12:49.360 Awaish Kumar: Okay, let me… let’s see in the… Settings.
760 01:12:49.360 ⇒ 01:12:52.320 Demilade Agboola: What was the issue with the product velocity dashboard?
761 01:12:53.470 ⇒ 01:13:04.470 Mustafa Raja: The values weren’t matching, and, the initial, revenue details,
762 01:13:05.260 ⇒ 01:13:12.789 Mustafa Raja: topic that, I created, it was created, with pack transactions with all orders table.
763 01:13:13.170 ⇒ 01:13:14.160 Demilade Agboola: Oh…
764 01:13:14.160 ⇒ 01:13:24.450 Mustafa Raja: whereas we wanted fact transactions only. And I did select fact transactions, I don’t know why Omni changes that.
765 01:13:25.480 ⇒ 01:13:27.909 Mustafa Raja: Two-fact transactions, all of this.
766 01:13:28.510 ⇒ 01:13:29.690 Awaish Kumar: With all of this.
767 01:13:32.470 ⇒ 01:13:36.200 Awaish Kumar: It’s evening, Mondays, Tuesdays, Wednesdays, Thursdays, I…
768 01:13:36.660 ⇒ 01:13:38.160 Mustafa Raja: Redefine the schedule.
769 01:13:38.920 ⇒ 01:13:39.620 Awaish Kumar: Yes.
770 01:13:40.370 ⇒ 01:13:41.140 Mustafa Raja: Okay, okay.
771 01:13:42.210 ⇒ 01:13:47.260 Awaish Kumar: Let me see… Okay, s… It just says,
772 01:13:52.540 ⇒ 01:13:54.280 Awaish Kumar: It just brings me here.
773 01:13:55.400 ⇒ 01:13:56.540 Awaish Kumar: What the hell?
774 01:13:57.020 ⇒ 01:13:59.789 Awaish Kumar: Yeah, I’m not… why I’m not able to…
775 01:14:02.620 ⇒ 01:14:04.939 Mustafa Raja: Are you admin? Let me, let me check if you’re an admin or no.
776 01:14:08.920 ⇒ 01:14:15.350 Awaish Kumar: Yeah, I’m able to see that, but it does not, like… it just sends on a schedule.
777 01:14:17.780 ⇒ 01:14:19.640 Awaish Kumar: I don’t think it’s.
778 01:14:21.600 ⇒ 01:14:24.650 Mustafa Raja: Hmm, so there’s no force sent, right?
779 01:14:24.830 ⇒ 01:14:26.020 Awaish Kumar: Miche, what’d you say?
780 01:14:28.280 ⇒ 01:14:30.390 Awaish Kumar: entire dashboards and Slack.
781 01:14:34.000 ⇒ 01:14:35.130 Awaish Kumar: Okay, it’s…
782 01:14:51.870 ⇒ 01:14:53.339 Awaish Kumar: Okay, back to you soon.
783 01:15:01.830 ⇒ 01:15:03.579 Awaish Kumar: Okay, it sucked.
784 01:15:04.900 ⇒ 01:15:07.969 Awaish Kumar: Okay. But it’s in the old version, why?
785 01:15:09.710 ⇒ 01:15:21.340 Mustafa Raja: Why… oh, I think… Hmm… Do we need to select, the charts?
786 01:15:21.840 ⇒ 01:15:23.450 Mustafa Raja: Manually?
787 01:15:23.580 ⇒ 01:15:25.150 Mustafa Raja: To include in report?
788 01:15:26.770 ⇒ 01:15:29.020 Awaish Kumar: It’s a… If you…
789 01:15:29.020 ⇒ 01:15:34.889 Mustafa Raja: Because… because the older charts are still in the dashboard, you know? They are just hidden.
790 01:15:35.360 ⇒ 01:15:37.430 Awaish Kumar: Okay, let me just then verify.
791 01:15:38.060 ⇒ 01:15:40.409 Mustafa Raja: Yeah, let’s just verify.
792 01:15:40.780 ⇒ 01:15:42.909 Mustafa Raja: Because I think that might be the case.
793 01:15:43.720 ⇒ 01:15:46.800 Awaish Kumar: Yeah, but this shows me the new dashboard here.
794 01:15:47.190 ⇒ 01:15:52.350 Awaish Kumar: This is the… You can see the schedule, you can select the dashboard.
795 01:15:53.140 ⇒ 01:15:55.460 Mustafa Raja: Where’s the schedule? How can I get into the schedule?
796 01:15:56.660 ⇒ 01:15:58.550 Awaish Kumar: We can select on the settings.
797 01:16:00.140 ⇒ 01:16:05.930 Awaish Kumar: From… From here on the top right, or bottom left.
798 01:16:06.280 ⇒ 01:16:10.980 Awaish Kumar: Go to the settings, and then you go to the delivery, Individually true.
799 01:16:20.330 ⇒ 01:16:21.370 Awaish Kumar: Beautiful.
800 01:16:21.830 ⇒ 01:16:24.930 Awaish Kumar: G, schedule… Slack.
801 01:16:27.160 ⇒ 01:16:28.990 Mustafa Raja: Or deliveries and alerts.
802 01:16:31.760 ⇒ 01:16:36.899 Mustafa Raja: I’d say let’s just create… can we just create a new… new scheduled update?
803 01:16:39.330 ⇒ 01:16:40.270 Mustafa Raja: Edit.
804 01:16:42.940 ⇒ 01:16:44.580 Mustafa Raja: Delivery name this.
805 01:16:44.800 ⇒ 01:16:51.650 Mustafa Raja: Dashboard this… How do we select the charts?
806 01:16:54.550 ⇒ 01:16:58.180 Mustafa Raja: It’s sending entire dashboard.
807 01:16:58.990 ⇒ 01:16:59.460 Awaish Kumar: Yes.
808 01:16:59.760 ⇒ 01:17:06.420 Mustafa Raja: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11… yeah, we don’t have this much. We don’t have these many.
809 01:17:07.720 ⇒ 01:17:10.139 Mustafa Raja: It’s ending entire thing.
810 01:17:11.120 ⇒ 01:17:17.479 Mustafa Raja: So we might want to edit this to only select these, or I can delete the ones that I have hidden.
811 01:17:18.090 ⇒ 01:17:21.020 Mustafa Raja: Should I just delete it? Delete the ones that I’ve written?
812 01:17:21.660 ⇒ 01:17:22.350 Awaish Kumar: Yes.
813 01:17:24.650 ⇒ 01:17:26.270 Demilade Agboola: But the ones that I hit in today’s show.
814 01:17:27.280 ⇒ 01:17:32.380 Mustafa Raja: They don’t show up in the, dashboard, but they do show up in the workbook.
815 01:17:33.030 ⇒ 01:17:36.180 Demilade Agboola: Yeah, but, like, today, I don’t think it gets sent out, does it?
816 01:17:36.780 ⇒ 01:17:42.479 Mustafa Raja: It does, because those are being selected, no? It’s, hmm… I don’t think so. I don’t know.
817 01:17:42.670 ⇒ 01:17:47.390 Mustafa Raja: How does the report look like? I haven’t seen it. I can’t see it, I think.
818 01:17:49.540 ⇒ 01:17:52.299 Awaish Kumar: Okay, report does not have option 2.
819 01:17:52.980 ⇒ 01:17:55.690 Awaish Kumar: Select the specific charts, right?
820 01:17:56.320 ⇒ 01:17:58.569 Awaish Kumar: I can’t see it anywhere.
821 01:17:58.760 ⇒ 01:18:01.580 Awaish Kumar: It says entire dashboard or a single chart.
822 01:18:01.940 ⇒ 01:18:05.409 Awaish Kumar: I can’t… I can’t see, like, multiple charts, like, two, two.
823 01:18:05.600 ⇒ 01:18:06.409 Awaish Kumar: 3 for me.
824 01:18:06.410 ⇒ 01:18:11.760 Mustafa Raja: Okay, so, so… So I should just delete the hidden ones.
825 01:18:12.780 ⇒ 01:18:17.009 Awaish Kumar: Yeah, just keep the ones that are here, and not delete anything.
826 01:18:17.880 ⇒ 01:18:19.620 Mustafa Raja: Yeah, let me do that then.
827 01:18:39.230 ⇒ 01:18:40.990 Awaish Kumar: 8 times.
828 01:18:46.250 ⇒ 01:18:47.390 Awaish Kumar: Absolutely.
829 01:18:49.470 ⇒ 01:18:51.210 Awaish Kumar: I don’t want to test again.
830 01:18:53.620 ⇒ 01:18:54.310 Awaish Kumar: Okay.
831 01:19:05.430 ⇒ 01:19:08.019 Awaish Kumar: Okay, most of our number change.
832 01:19:09.440 ⇒ 01:19:10.240 Mustafa Raja: Which ones?
833 01:19:11.530 ⇒ 01:19:13.010 Awaish Kumar: 30-day revenue.
834 01:19:17.590 ⇒ 01:19:23.940 Mustafa Raja: I think that that might have changed in the tableau, in the… What’s it called?
835 01:19:24.570 ⇒ 01:19:25.510 Awaish Kumar: Okay.
836 01:19:25.910 ⇒ 01:19:27.209 Mustafa Raja: Yeah, BigQuery, yeah.
837 01:19:27.600 ⇒ 01:19:28.890 Awaish Kumar: Now, let me see…
838 01:19:40.330 ⇒ 01:19:42.420 Mustafa Raja: Because injectable female also changed, no?
839 01:19:42.600 ⇒ 01:19:44.490 Mustafa Raja: So I think that might be the case.
840 01:19:48.020 ⇒ 01:19:49.690 Mustafa Raja: This is the right chart.
841 01:19:51.190 ⇒ 01:19:52.080 Awaish Kumar: Yeah, but…
842 01:19:55.900 ⇒ 01:19:59.070 Awaish Kumar: 63613… Why are you?
843 01:19:59.070 ⇒ 01:20:07.379 Mustafa Raja: I’m just going to go and delete the charts that are in… Revenue details.
844 01:20:07.380 ⇒ 01:20:13.230 Demilade Agboola: Mustafa, for the tickets that awaits and to me for the cohort, Danny, I’ve created a new…
845 01:20:13.780 ⇒ 01:20:17.880 Demilade Agboola: Topic called Monthly Co-op retention, so you can try and use that to build it out.
846 01:20:18.900 ⇒ 01:20:19.630 Mustafa Raja: Okay.
847 01:20:23.100 ⇒ 01:20:25.649 Mustafa Raja: Revenue details, delete.
848 01:20:33.790 ⇒ 01:20:37.279 Awaish Kumar: Something happened again here.
849 01:20:38.950 ⇒ 01:20:40.239 Mustafa Raja: The values are not matching?
850 01:20:41.060 ⇒ 01:20:45.990 Awaish Kumar: Yes, it does… it’s not matching. Maybe you deleted the wrong chart or something?
851 01:20:46.380 ⇒ 01:20:48.299 Mustafa Raja: No, no, this is the correct topic, no?
852 01:20:50.840 ⇒ 01:20:51.460 Awaish Kumar: Yes.
853 01:20:51.460 ⇒ 01:20:55.920 Mustafa Raja: Did we add this, filter?
854 01:20:57.750 ⇒ 01:20:58.939 Mustafa Raja: For abandoned?
855 01:21:00.020 ⇒ 01:21:02.430 Awaish Kumar: Oh, no, actually. Let me ask.
856 01:21:02.430 ⇒ 01:21:03.999 Mustafa Raja: Yeah, let’s add that and see.
857 01:21:05.780 ⇒ 01:21:09.780 Awaish Kumar: Status… not equals.
858 01:21:19.120 ⇒ 01:21:23.069 Mustafa Raja: I’m only deleting the ones that were in the older topic.
859 01:21:29.080 ⇒ 01:21:30.230 Mustafa Raja: Does this match?
860 01:21:30.970 ⇒ 01:21:33.730 Awaish Kumar: 6 to 9… 6.29.
861 01:21:35.080 ⇒ 01:21:36.770 Mustafa Raja: Yeah, 6.296…
862 01:21:37.580 ⇒ 01:21:38.110 Awaish Kumar: Okay.
863 01:21:38.110 ⇒ 01:21:39.120 Mustafa Raja: 47th.
864 01:21:40.530 ⇒ 01:21:41.250 Mustafa Raja: Yeah.
865 01:21:41.420 ⇒ 01:21:46.530 Mustafa Raja: The values in the… Bigquery just updated, I think.
866 01:21:48.710 ⇒ 01:21:50.530 Mustafa Raja: Let me see what else is…
867 01:21:51.240 ⇒ 01:21:55.290 Mustafa Raja: This is from big… oh, this is from there, so delete.
868 01:21:57.950 ⇒ 01:21:58.730 Awaish Kumar: Okay.
869 01:21:59.200 ⇒ 01:22:00.140 Awaish Kumar: Guts.
870 01:22:01.270 ⇒ 01:22:05.179 Awaish Kumar: Internal Maybe it’s a license, right?
871 01:22:06.940 ⇒ 01:22:07.570 Mustafa Raja: Sorry?
872 01:22:08.760 ⇒ 01:22:11.279 Awaish Kumar: Maybe the image is correct, then I just…
873 01:22:11.690 ⇒ 01:22:14.540 Awaish Kumar: Yeah, the image is correct, right?
874 01:22:14.890 ⇒ 01:22:15.590 Awaish Kumar: Very strange.
875 01:22:15.590 ⇒ 01:22:16.160 Mustafa Raja: Oh.
876 01:22:17.290 ⇒ 01:22:18.210 Mustafa Raja: Okay.
877 01:22:18.360 ⇒ 01:22:20.800 Mustafa Raja: Then I don’t need to delete this, then.
878 01:22:21.380 ⇒ 01:22:22.310 Awaish Kumar: Oh my god.
879 01:22:23.150 ⇒ 01:22:24.180 Mustafa Raja: Okay, okay.
880 01:22:24.180 ⇒ 01:22:25.920 Awaish Kumar: 6’2”, and I said, oh, what?
881 01:22:26.490 ⇒ 01:22:27.720 Awaish Kumar: What the hell is it?
882 01:22:28.330 ⇒ 01:22:31.050 Mustafa Raja: Okay, okay, I’m just going to publish this.
883 01:22:31.890 ⇒ 01:22:37.430 Awaish Kumar: 629647 fold… Okay.
884 01:22:38.430 ⇒ 01:22:40.180 Mustafa Raja: Okay, this was good then.
885 01:22:41.770 ⇒ 01:22:45.639 Mustafa Raja: Okay, then maybe the ones that are not hidden are only sent, right?
886 01:22:46.690 ⇒ 01:22:51.110 Awaish Kumar: 190… Is the chart correct? Let me check.
887 01:22:51.890 ⇒ 01:22:52.380 Awaish Kumar: Mr.
888 01:22:56.520 ⇒ 01:22:57.530 Awaish Kumar: form.
889 01:22:57.630 ⇒ 01:22:59.380 Awaish Kumar: Finally, you don’t… okay.
890 01:23:05.850 ⇒ 01:23:07.310 Mustafa Raja: Okay, so this is good then.
891 01:23:08.210 ⇒ 01:23:14.800 Awaish Kumar: Yes, yes. Let’s, let’s write down a message.
892 01:23:16.000 ⇒ 01:23:16.890 Mustafa Raja: What do you want to say?
893 01:23:18.030 ⇒ 01:23:21.775 Awaish Kumar: That’s okay, that I’m also trying to… Pink.
894 01:23:23.070 ⇒ 01:23:23.710 Mustafa Raja: Okay.
895 01:23:24.030 ⇒ 01:23:27.710 Awaish Kumar: Let’s see… What should I say, huh?
896 01:23:27.930 ⇒ 01:23:30.370 Mustafa Raja: Josh is the CEO of Eden.
897 01:23:30.780 ⇒ 01:23:31.520 Awaish Kumar: Yes.
898 01:23:32.170 ⇒ 01:23:32.750 Mustafa Raja: Oh.
899 01:23:34.350 ⇒ 01:23:40.240 Demilade Agboola: So you can download the PDF version of it, and say, hi, Josh.
900 01:23:40.510 ⇒ 01:23:48.479 Demilade Agboola: This has been fixed now. Here is the new, update of it. And going forward, it should be aligned with the
901 01:23:48.620 ⇒ 01:23:51.820 Demilade Agboola: Tableau, blah blah blah, to be previous Tableau dashboards.
902 01:23:52.870 ⇒ 01:23:59.380 Mustafa Raja: I think we need to also tell him that, you know, we defined… we made a new definition, and we are excluding today.
903 01:24:00.900 ⇒ 01:24:03.840 Demilade Agboola: It does not completely align with the tableau, because…
904 01:24:05.510 ⇒ 01:24:09.430 Awaish Kumar: the valid… in Tableau, it was… it says 30-day.
905 01:24:09.640 ⇒ 01:24:12.540 Awaish Kumar: But then it was using 31 days, like…
906 01:24:12.650 ⇒ 01:24:15.830 Awaish Kumar: It was including the current day’s revenue in the.
907 01:24:16.420 ⇒ 01:24:18.629 Demilade Agboola: Oh, and the 30-day…
908 01:24:18.630 ⇒ 01:24:20.320 Awaish Kumar: You know, it comes in 30 days.
909 01:24:20.540 ⇒ 01:24:29.710 Awaish Kumar: And now, like Utham said, mentioned that we should have closed… only the closed revenue, which means we have 30 days only until…
910 01:24:30.990 ⇒ 01:24:38.330 Demilade Agboola: Yeah, just, you just put that there as well. So just, like, some changes have been made. These include, Tableau was counting.
911 01:24:39.200 ⇒ 01:24:41.670 Demilade Agboola: I’m not sure if we want to mention that, but just…
912 01:24:43.880 ⇒ 01:24:45.040 Awaish Kumar: That I’m the humble.
913 01:24:45.290 ⇒ 01:24:46.249 Mustafa Raja: Like, we don’t.
914 01:24:46.250 ⇒ 01:24:49.289 Demilade Agboola: Yeah, I’m not sure we want to mention that Tableau was counting.
915 01:24:49.460 ⇒ 01:24:51.810 Demilade Agboola: More days than before, like…
916 01:24:51.810 ⇒ 01:24:57.830 Mustafa Raja: I think… I think Tableau one was fine, because it only accounted for, for one study, right? So…
917 01:24:57.990 ⇒ 01:25:05.099 Mustafa Raja: It’s not going to include everything, you know? Maybe parts or parts of… very small parts of it, so negligible difference.
918 01:25:07.400 ⇒ 01:25:14.089 Awaish Kumar: Yeah, but we can’t say that. For more than a year, we have been… Showing him the wrong revenue.
919 01:25:14.730 ⇒ 01:25:17.330 Mustafa Raja: Oh… Yeah, that makes sense.
920 01:25:17.330 ⇒ 01:25:21.079 Demilade Agboola: Yeah, that’s why… that’s why I stopped halfway and said, oh…
921 01:25:21.540 ⇒ 01:25:22.400 Mustafa Raja: Yeah.
922 01:25:28.470 ⇒ 01:25:30.460 Mustafa Raja: So, Avish, are you still in UAE?
923 01:25:31.310 ⇒ 01:25:31.980 Awaish Kumar: Yes.
924 01:25:33.160 ⇒ 01:25:33.880 Mustafa Raja: Okay, okay.
925 01:25:42.250 ⇒ 01:25:43.060 Awaish Kumar: Yup.
926 01:25:44.920 ⇒ 01:25:51.680 Awaish Kumar: Do we still have a… does he… like, why… I don’t know why… He said it’s not usable.
927 01:25:57.820 ⇒ 01:26:04.749 Mustafa Raja: I think he might have looked into the, Tableau ones, and so might have seen discrepancies and, you know.
928 01:26:05.650 ⇒ 01:26:07.500 Awaish Kumar: But does he have access to…
929 01:26:10.830 ⇒ 01:26:15.520 Mustafa Raja: I think Tableau might be also sending him reports, no? If… if this is sending…
930 01:26:15.520 ⇒ 01:26:23.129 Demilade Agboola: So we have scheduled reports that go to him every morning, so that’s what he sees. And also, we have.
931 01:26:23.770 ⇒ 01:26:24.560 Awaish Kumar: We haven’t passed.
932 01:26:24.560 ⇒ 01:26:26.540 Demilade Agboola: I have access to the dashboard, too.
933 01:26:26.540 ⇒ 01:26:27.979 Awaish Kumar: Yes, except for Tableau.
934 01:26:28.410 ⇒ 01:26:30.619 Demilade Agboola: Yes, but he doesn’t use it that often.
935 01:26:30.740 ⇒ 01:26:31.899 Demilade Agboola: To be honest.
936 01:26:32.770 ⇒ 01:26:35.140 Mustafa Raja: Okay. But the schedule doesn’t change, right?
937 01:26:35.520 ⇒ 01:26:39.690 Demilade Agboola: Yeah, schedule gets to him, because he’s a… he’s usually, like, a mobile person.
938 01:26:40.250 ⇒ 01:26:48.430 Demilade Agboola: So he just likes to be able to quickly… that’s why he likes Slack reports, so he can… on his phone, he can open up his phone and quickly, look at the PDFs and see what’s going on with his day.
939 01:26:49.180 ⇒ 01:26:52.040 Demilade Agboola: Before, he does… that’s why he doesn’t always go into Tableau.
940 01:27:25.960 ⇒ 01:27:32.910 Awaish Kumar: Tableau. Actually, Tableau 1 is… If not higher.
941 01:27:33.730 ⇒ 01:27:34.550 Awaish Kumar: So…
942 01:27:56.800 ⇒ 01:28:03.250 Demilade Agboola: I think… I think, ultimately, we can just say, hey, this has been resolved, disparities have been noted, and
943 01:28:03.800 ⇒ 01:28:04.700 Demilade Agboola: Resolved?
944 01:28:06.720 ⇒ 01:28:12.530 Demilade Agboola: And… in Tableau… I mean, in Tableau, we can always make that change, too, to be fair.
945 01:28:12.820 ⇒ 01:28:16.759 Demilade Agboola: And just make it… exclude the current dates in Tableau as well.
946 01:28:21.530 ⇒ 01:28:22.850 Awaish Kumar: Oh, do you think we should…
947 01:28:23.240 ⇒ 01:28:25.539 Awaish Kumar: Just do that right now, or…
948 01:28:25.690 ⇒ 01:28:27.489 Demilade Agboola: Yeah, yeah, we can always switch that right now.
949 01:28:34.730 ⇒ 01:28:35.180 Awaish Kumar: Okay.
950 01:28:35.700 ⇒ 01:28:40.309 Demilade Agboola: Most of our piece, can you look at the dash, like, look at the topic and try and create the new…
951 01:28:40.770 ⇒ 01:28:41.999 Demilade Agboola: number, so I can be sure that.
952 01:28:42.000 ⇒ 01:28:47.829 Mustafa Raja: Could you, could you tell me the ticket, the number of the ticket that you’re looking into?
953 01:28:48.270 ⇒ 01:28:54.500 Demilade Agboola: It’s the lifecycle one, let me… let me go to 1494.
954 01:28:55.750 ⇒ 01:28:56.909 Mustafa Raja: Okay, okay, okay.
955 01:28:56.910 ⇒ 01:28:57.970 Demilade Agboola: 1494.
956 01:28:59.550 ⇒ 01:29:02.390 Mustafa Raja: Always… 1494…
957 01:29:07.630 ⇒ 01:29:10.270 Mustafa Raja: Okay, what’s the… what’s the name of the topic now?
958 01:29:10.600 ⇒ 01:29:15.890 Demilade Agboola: Monthly cohort revenue, or retention, sorry. Monthly cohort retention. So you’re using, like, the daily…
959 01:29:16.300 ⇒ 01:29:23.730 Demilade Agboola: Numbers, which is why it’s, like, 30 times smaller than… happening in… In…
960 01:29:23.730 ⇒ 01:29:26.029 Mustafa Raja: So we are only talking about this chart, right?
961 01:29:26.190 ⇒ 01:29:26.830 Demilade Agboola: Yes.
962 01:29:27.520 ⇒ 01:29:28.330 Mustafa Raja: Okay.
963 01:29:29.110 ⇒ 01:29:32.250 Demilade Agboola: At least that’s what I… that’s what I can see in the ticket, that’s what I looked at.
964 01:29:33.060 ⇒ 01:29:33.810 Mustafa Raja: Okay.
965 01:29:37.800 ⇒ 01:29:43.059 Demilade Agboola: So what I did is I made a copy, but when I tried to switch… so I made a copy, and then tried to switch
966 01:29:43.190 ⇒ 01:29:46.250 Demilade Agboola: It’s to the new, like, the monthly version, and it broke.
967 01:29:46.570 ⇒ 01:29:47.300 Demilade Agboola: So it appears.
968 01:29:47.300 ⇒ 01:29:47.620 Mustafa Raja: Okay.
969 01:29:47.800 ⇒ 01:29:48.650 Demilade Agboola: Heck yeah.
970 01:29:48.820 ⇒ 01:29:53.040 Demilade Agboola: I’m not sure how you came up with the initial top… the initial chart table.
971 01:29:54.980 ⇒ 01:29:58.150 Mustafa Raja: I think, the, this…
972 01:29:58.910 ⇒ 01:30:01.449 Mustafa Raja: I wish to get over, no?
973 01:30:02.980 ⇒ 01:30:03.549 Awaish Kumar: Which one?
974 01:30:03.550 ⇒ 01:30:04.279 Mustafa Raja: From the time.
975 01:30:04.630 ⇒ 01:30:06.339 Mustafa Raja: This, life cycle.
976 01:30:07.920 ⇒ 01:30:11.950 Awaish Kumar: Yeah, I’m… I had just mentioned to Demilade that I haven’t started working yet.
977 01:30:12.210 ⇒ 01:30:12.730 Awaish Kumar: So if you…
978 01:30:12.730 ⇒ 01:30:19.310 Demilade Agboola: Yeah, I’m saying I fixed it, like, there’s now the monthly, so if you go to monthly, like, yes, under that, under that brick topic.
979 01:30:20.280 ⇒ 01:30:21.259 Demilade Agboola: Can you go back there?
980 01:30:23.500 ⇒ 01:30:25.310 Demilade Agboola: Of cohort retention and cohorts.
981 01:30:26.900 ⇒ 01:30:28.929 Demilade Agboola: Cohorts retention and cohorts.
982 01:30:30.180 ⇒ 01:30:32.840 Mustafa Raja: Sorry. Yeah, this one, right?
983 01:30:32.840 ⇒ 01:30:34.130 Demilade Agboola: If you scroll down.
984 01:30:34.900 ⇒ 01:30:39.449 Demilade Agboola: You should see monthly cohort retention. That’s what I created, yes.
985 01:30:40.280 ⇒ 01:30:42.710 Demilade Agboola: So that’s what’s going to replace the daily.
986 01:30:43.900 ⇒ 01:30:44.620 Mustafa Raja: Okay.
987 01:30:47.110 ⇒ 01:30:50.299 Mustafa Raja: Let me take a look what’s here, month or first month…
988 01:30:54.740 ⇒ 01:30:56.570 Mustafa Raja: Cohort science fiction by cohort.
989 01:30:59.780 ⇒ 01:31:02.499 Awaish Kumar: And code size fixed by cop is not here, right?
990 01:31:03.460 ⇒ 01:31:13.060 Mustafa Raja: Yeah… And this is a… wait, let me just… let me just walk, and then see what happens.
991 01:31:13.810 ⇒ 01:31:15.500 Mustafa Raja: Last 18 months.
992 01:31:21.660 ⇒ 01:31:30.530 Awaish Kumar: Could you… Code size, fixed by quote, and revenue, you just have it, right? For which… I would…
993 01:31:30.940 ⇒ 01:31:32.569 Awaish Kumar: Topic you added?
994 01:31:36.420 ⇒ 01:31:37.789 Mustafa Raja: Monthly converted.
995 01:31:38.600 ⇒ 01:31:44.119 Awaish Kumar: No, no, no, you just created a PR, right, which included the same Exact same.
996 01:31:46.410 ⇒ 01:31:51.740 Mustafa Raja: Yeah, it was, it was for, refund something.
997 01:31:52.600 ⇒ 01:31:54.180 Awaish Kumar: Return of purchase.
998 01:31:54.760 ⇒ 01:31:57.080 Mustafa Raja: Oh, yeah, returns, yeah, so, yeah, yeah.
999 01:31:57.460 ⇒ 01:32:01.589 Demilade Agboola: Yeah, yeah, so that would be… so I think that’s what we need to do for this as well. Like, the max…
1000 01:32:02.440 ⇒ 01:32:06.499 Awaish Kumar: Customer cohorts, blah blah blah. We can do the same thing for this, as well.
1001 01:32:18.470 ⇒ 01:32:19.940 Mustafa Raja: Yeah, return on ad spend.
1002 01:32:23.650 ⇒ 01:32:26.280 Mustafa Raja: So I should do it for this one, too?
1003 01:32:28.530 ⇒ 01:32:31.010 Awaish Kumar: Yeah, let’s about to first look at Tableau, what?
1004 01:32:31.620 ⇒ 01:32:33.329 Awaish Kumar: How it calculates the code.
1005 01:32:34.620 ⇒ 01:32:35.240 Mustafa Raja: And…
1006 01:32:42.350 ⇒ 01:32:48.370 Awaish Kumar: I, you know, edit, but, yeah, let’s… Awesome.
1007 01:33:05.760 ⇒ 01:33:08.720 Mustafa Raja: Yeah, first of the month, first of a product.
1008 01:33:09.280 ⇒ 01:33:13.240 Mustafa Raja: And this one was first for my first one product, and then channel, also.
1009 01:33:14.270 ⇒ 01:33:16.260 Awaish Kumar: Yeah, we just use that.
1010 01:33:17.000 ⇒ 01:33:20.859 Awaish Kumar: And, for the… what table is being used?
1011 01:33:24.320 ⇒ 01:33:25.310 Awaish Kumar: Download.
1012 01:33:26.610 ⇒ 01:33:29.450 Mustafa Raja: Retention, cohort Revenue Retention Summary.
1013 01:33:31.340 ⇒ 01:33:32.029 Awaish Kumar: Is it?
1014 01:33:33.150 ⇒ 01:33:35.050 Mustafa Raja: This one, did you see code revenue retention?
1015 01:33:35.050 ⇒ 01:33:35.590 Awaish Kumar: boom.
1016 01:33:36.150 ⇒ 01:33:42.080 Awaish Kumar: I said, don’t… It says dot dot dot, can you see the full name? Yeah.
1017 01:33:42.190 ⇒ 01:33:44.189 Awaish Kumar: Oh yeah, okay, what odds.
1018 01:33:57.410 ⇒ 01:34:00.030 Mustafa Raja: Yeah, I’m just going to ask her, so to help me out with that.
1019 01:34:01.980 ⇒ 01:34:02.670 Awaish Kumar: Okay.
1020 01:34:03.560 ⇒ 01:34:11.150 Awaish Kumar: Okay, Nedalie then… Oh, work on the live order journey ticket?
1021 01:34:14.320 ⇒ 01:34:21.189 Awaish Kumar: Autogenic Gold Tracker, and… Let’s wait for…
1022 01:34:21.400 ⇒ 01:34:24.900 Awaish Kumar: Tom to get some feedback on this.
1023 01:34:38.190 ⇒ 01:34:40.470 Mustafa Raja: 412 million, okay.
1024 01:34:44.820 ⇒ 01:34:45.930 Mustafa Raja: I mean…
1025 01:35:48.090 ⇒ 01:35:49.560 Mustafa Raja: 1494…
1026 01:39:43.680 ⇒ 01:39:46.210 Mustafa Raja: So, do you have any plans for the weekend?
1027 01:39:53.620 ⇒ 01:39:54.140 Awaish Kumar: Nope.
1028 01:39:56.790 ⇒ 01:39:58.490 Awaish Kumar: And how’s you right now?
1029 01:40:00.490 ⇒ 01:40:02.880 Mustafa Raja: It’s okay. Is it…
1030 01:40:02.880 ⇒ 01:40:03.460 Awaish Kumar: Thank you.
1031 01:40:03.560 ⇒ 01:40:07.740 Awaish Kumar: Everything is working fine, everybody’s working, like, not into office at all.
1032 01:40:08.310 ⇒ 01:40:11.169 Awaish Kumar: It’s just sometimes we get alert on mobile phone.
1033 01:40:12.220 ⇒ 01:40:13.230 Mustafa Raja: Done.
1034 01:40:13.600 ⇒ 01:40:18.529 Awaish Kumar: Regarding the… Drones, but otherwise, it’s good.
1035 01:40:20.880 ⇒ 01:40:21.530 Mustafa Raja: Yeah.
1036 01:40:24.890 ⇒ 01:40:27.300 Demilade Agboola: I don’t really have fans this weekend.
1037 01:40:28.190 ⇒ 01:40:30.149 Demilade Agboola: Iva, I just plan to…
1038 01:40:30.740 ⇒ 01:40:35.840 Demilade Agboola: I think I play tennis on Saturday… on Sunday morning. I think that’s really it. Apart from that.
1039 01:40:36.660 ⇒ 01:40:37.410 Mustafa Raja: That’s nice.
1040 01:40:37.410 ⇒ 01:40:40.439 Demilade Agboola: It’s been a long week, and I think I need to rest.
1041 01:40:42.170 ⇒ 01:40:44.359 Mustafa Raja: Same, I’ll be sleeping.
1042 01:40:48.900 ⇒ 01:40:53.070 Mustafa Raja: Okay, this looks good, I’m going to… BWR.
1043 01:41:23.640 ⇒ 01:41:24.720 Mustafa Raja: Hmm.
1044 01:41:56.550 ⇒ 01:41:59.460 Mustafa Raja: Let me create a PR, could you take a look at that?
1045 01:43:50.830 ⇒ 01:43:55.340 Mustafa Raja: Yeah, let me know, Demi, if you’ve been taking a look at this.
1046 01:43:59.510 ⇒ 01:44:00.200 Demilade Agboola: Oh.
1047 01:44:00.720 ⇒ 01:44:03.330 Demilade Agboola: Oh, at the PR, give me one second.
1048 01:44:03.980 ⇒ 01:44:04.689 Mustafa Raja: with VR.
1049 01:44:07.850 ⇒ 01:44:10.559 Demilade Agboola: Trying to get some default stuff for that line.
1050 01:44:11.150 ⇒ 01:44:11.980 Mustafa Raja: Oh, yeah.
1051 01:44:40.470 ⇒ 01:44:41.630 Demilade Agboola: I’ve changed.
1052 01:44:51.830 ⇒ 01:44:53.699 Demilade Agboola: Both sides fixed by coin, hmm.
1053 01:44:56.170 ⇒ 01:44:57.140 Awaish Kumar: Hmm…
1054 01:44:58.290 ⇒ 01:44:59.400 Demilade Agboola: Yeah, -
1055 01:44:59.860 ⇒ 01:45:00.899 Demilade Agboola: I guess I proved it.
1056 01:45:02.560 ⇒ 01:45:03.230 Mustafa Raja: Okay.
1057 01:45:03.990 ⇒ 01:45:05.550 Demilade Agboola: Let the… let the run finish.
1058 01:45:05.550 ⇒ 01:45:10.910 Mustafa Raja: I’m just, yeah, yeah, this run is… Running.
1059 01:45:20.120 ⇒ 01:45:21.769 Mustafa Raja: This takes a lot of time.
1060 01:45:38.250 ⇒ 01:45:42.889 Mustafa Raja: I wish they, game of Thrones prequel.
1061 01:45:43.110 ⇒ 01:45:45.139 Mustafa Raja: Last week, pretty good.
1062 01:45:50.140 ⇒ 01:45:51.510 Demilade Agboola: I didn’t know that was a prequel.
1063 01:45:52.390 ⇒ 01:45:56.399 Mustafa Raja: Oh, the… the Knight of the Seven Kingdoms, right?
1064 01:45:57.240 ⇒ 01:45:58.050 Demilade Agboola: Oh, really?
1065 01:45:58.980 ⇒ 01:46:03.420 Mustafa Raja: Yeah, yeah, so, yeah, that was… Good.
1066 01:46:03.660 ⇒ 01:46:04.929 Mustafa Raja: story, I believe.
1067 01:48:18.350 ⇒ 01:48:22.399 Mustafa Raja: I believe we merged the retention one, so I’ll take a look.
1068 01:48:28.550 ⇒ 01:48:30.760 Mustafa Raja: Retention.
1069 01:49:54.150 ⇒ 01:49:55.270 Awaish Kumar: What the…
1070 01:50:01.490 ⇒ 01:50:11.159 Awaish Kumar: Why the number… in Tableau should be lower when the data is… It’s, like, it’s old, right?
1071 01:50:15.630 ⇒ 01:50:17.810 Demilade Agboola: Are you using monthly cohorts.
1072 01:50:19.570 ⇒ 01:50:20.110 Awaish Kumar: Huh?
1073 01:50:21.130 ⇒ 01:50:21.740 Mustafa Raja: It’s a good topic.
1074 01:50:22.190 ⇒ 01:50:24.249 Demilade Agboola: Yeah, it’s not…
1075 01:50:24.250 ⇒ 01:50:27.029 Awaish Kumar: I’m talking about order journey.
1076 01:50:27.660 ⇒ 01:50:28.750 Demilade Agboola: Oh, Audit Journey.
1077 01:50:29.650 ⇒ 01:50:37.960 Awaish Kumar: The thing is that… I’m looking at this data this week, from, like, 6th February.
1078 01:50:38.630 ⇒ 01:50:40.990 Awaish Kumar: It says 579.
1079 01:50:41.360 ⇒ 01:50:46.300 Awaish Kumar: Oh, and while the victory says, 5598.
1080 01:50:50.170 ⇒ 01:50:55.390 Awaish Kumar: And, how many matches with the number in victory?
1081 01:50:56.720 ⇒ 01:50:58.700 Awaish Kumar: This does not match.
1082 01:50:59.370 ⇒ 01:51:03.210 Awaish Kumar: It’s being calculated the same way, from order summary table.
1083 01:51:03.860 ⇒ 01:51:06.709 Awaish Kumar: It’s for 80 weeks start, that’s the same.
1084 01:51:11.670 ⇒ 01:51:13.150 Awaish Kumar: What is the difference?
1085 01:51:14.110 ⇒ 01:51:15.910 Demilade Agboola: Priority weeks.
1086 01:51:16.640 ⇒ 01:51:20.530 Demilade Agboola: And is it also excluding the same things, because… Maybe Wax Studio.
1087 01:51:20.530 ⇒ 01:51:21.560 Awaish Kumar: Yeah.
1088 01:51:23.740 ⇒ 01:51:26.800 Awaish Kumar: So… Where do you go.
1089 01:51:29.360 ⇒ 01:51:30.180 Awaish Kumar: Okay.
1090 01:51:32.000 ⇒ 01:51:34.759 Demilade Agboola: Sorry, it’s using order summary independent, okay.
1091 01:51:37.590 ⇒ 01:51:38.190 Awaish Kumar: What is that?
1092 01:51:40.700 ⇒ 01:51:42.540 Demilade Agboola: Okay… That’s weird.
1093 01:51:42.540 ⇒ 01:51:44.139 Awaish Kumar: Where does Olyssip end up?
1094 01:51:45.000 ⇒ 01:51:45.980 Demilade Agboola: I have no idea.
1095 01:51:49.740 ⇒ 01:51:51.329 Awaish Kumar: What the hell?
1096 01:51:52.200 ⇒ 01:51:57.370 Awaish Kumar: Yeah, I think… People just started creating.
1097 01:51:58.280 ⇒ 01:51:59.730 Awaish Kumar: Anything they wanted.
1098 01:52:01.510 ⇒ 01:52:04.520 Demilade Agboola: Okay, still… I mean, I think it’s still auto summary, I think.
1099 01:52:26.960 ⇒ 01:52:30.150 Awaish Kumar: My How to find what is the difference?
1100 01:52:32.440 ⇒ 01:52:40.390 Awaish Kumar: Is this a… Is this a data source, or something created in Tableau?
1101 01:52:41.160 ⇒ 01:52:45.310 Demilade Agboola: I think it’s a data source, I think it’s just pointing to order somewhere, but it’s named differently.
1102 01:52:51.770 ⇒ 01:52:52.980 Awaish Kumar: Okay, wonderful.
1103 01:53:01.840 ⇒ 01:53:09.440 Awaish Kumar: Okay, let’s see… How can I then check if it was refreshed recently?
1104 01:53:23.390 ⇒ 01:53:24.310 Awaish Kumar: Cove.
1105 01:53:27.390 ⇒ 01:53:29.120 Awaish Kumar: Published data sources…
1106 01:53:42.650 ⇒ 01:53:45.670 Awaish Kumar: There’s no such datasets… sources.
1107 01:53:46.040 ⇒ 01:53:47.429 Awaish Kumar: Order somebody in-depth.
1108 01:54:56.690 ⇒ 01:55:04.329 Mustafa Raja: Yeah, this cohort really isn’t… Working… Let’s try out it.
1109 01:55:17.710 ⇒ 01:55:21.580 Mustafa Raja: ID of, 7, 13, 18, 14, 86.
1110 01:56:27.630 ⇒ 01:56:30.340 Mustafa Raja: Yes, this, it still doesn’t make sense.
1111 01:56:30.700 ⇒ 01:56:32.549 Mustafa Raja: This is for retention 1.
1112 01:56:38.230 ⇒ 01:56:41.679 Demilade Agboola: Mute retention, are we talking… is it the one we’re trying to replace?
1113 01:56:42.310 ⇒ 01:56:43.140 Mustafa Raja: Oh, shit.
1114 01:56:43.140 ⇒ 01:56:43.870 Demilade Agboola: of different…
1115 01:56:45.460 ⇒ 01:56:52.419 Mustafa Raja: The monthly retention dashboard, the one that we also debugged last week, you know? Do you remember?
1116 01:56:53.840 ⇒ 01:56:55.009 Mustafa Raja: Oh, yeah, the option.
1117 01:56:55.010 ⇒ 01:56:56.280 Demilade Agboola: Pro versus the other.
1118 01:56:56.750 ⇒ 01:56:59.559 Mustafa Raja: Yeah, this, this, I pushed the…
1119 01:57:00.270 ⇒ 01:57:03.240 Mustafa Raja: PR for this, and this isn’t… You know?
1120 01:57:04.510 ⇒ 01:57:06.989 Mustafa Raja: This isn’t what it should be.
1121 01:57:07.860 ⇒ 01:57:11.080 Mustafa Raja: And this is what it should be, but it already was.
1122 01:57:19.530 ⇒ 01:57:25.929 Mustafa Raja: Could you… if I send you the PR, could you take a look if I did it the right way, or not?
1123 01:57:27.880 ⇒ 01:57:29.690 Mustafa Raja: It should be this one.
1124 01:57:36.090 ⇒ 01:57:39.950 Mustafa Raja: So, partition, first of the month, first of product channel.
1125 01:57:41.030 ⇒ 01:57:44.140 Mustafa Raja: Order by first order month at… hmm!
1126 01:57:48.090 ⇒ 01:57:49.950 Mustafa Raja: Lifetime Max Row…
1127 01:57:50.490 ⇒ 01:57:51.750 Demilade Agboola: If you do use our filter?
1128 01:57:52.450 ⇒ 01:57:53.400 Mustafa Raja: No.
1129 01:57:54.410 ⇒ 01:57:56.549 Mustafa Raja: But the filter is going to reduce stuff, no?
1130 01:57:58.180 ⇒ 01:57:58.900 Demilade Agboola: Probably.
1131 01:57:58.900 ⇒ 01:58:02.190 Mustafa Raja: So what I should do is, I should get rid of this.
1132 01:58:02.550 ⇒ 01:58:05.790 Mustafa Raja: I should try using the normal cohort.
1133 01:58:06.690 ⇒ 01:58:09.009 Mustafa Raja: With some… with this filter.
1134 01:58:10.650 ⇒ 01:58:11.600 Mustafa Raja: filter.
1135 01:58:12.630 ⇒ 01:58:13.530 Mustafa Raja: Oriental.
1136 01:58:13.690 ⇒ 01:58:14.380 Mustafa Raja: True.
1137 01:58:19.600 ⇒ 01:58:22.970 Mustafa Raja: Hmm… Nope.
1138 01:58:34.410 ⇒ 01:58:35.440 Mustafa Raja: Hmm…
1139 01:58:51.680 ⇒ 01:58:52.520 Mustafa Raja: Oh…
1140 01:58:56.270 ⇒ 01:58:57.950 Mustafa Raja: Analytics revenues.
1141 01:58:58.750 ⇒ 01:59:00.440 Mustafa Raja: Lifetime cumulative revenue.
1142 01:59:00.790 ⇒ 01:59:03.239 Mustafa Raja: At least, this should be good.
1143 01:59:06.230 ⇒ 01:59:09.540 Mustafa Raja: Cumulative revenue… Max.
1144 01:59:16.270 ⇒ 01:59:18.900 Mustafa Raja: This is exactly the same, though.
1145 02:01:20.190 ⇒ 02:01:21.030 Mustafa Raja: This…
1146 02:01:59.690 ⇒ 02:02:04.270 Mustafa Raja: Max, hold on 6… Oh, thanks to this.
1147 02:02:13.710 ⇒ 02:02:14.440 Mustafa Raja: Nice.
1148 02:03:00.060 ⇒ 02:03:06.910 Mustafa Raja: Will someone be able to help me, verify this from, bigQuery?
1149 02:03:12.980 ⇒ 02:03:13.910 Awaish Kumar: What do you need?
1150 02:03:15.310 ⇒ 02:03:18.860 Mustafa Raja: So, so, after, even after adding the…
1151 02:03:19.880 ⇒ 02:03:23.540 Mustafa Raja: Cohort, this still is, you know, not working.
1152 02:03:24.290 ⇒ 02:03:25.489 Mustafa Raja: Not good enough.
1153 02:03:26.400 ⇒ 02:03:28.750 Mustafa Raja: So, in short, it’s wrong.
1154 02:03:29.330 ⇒ 02:03:31.030 Mustafa Raja: For other channels.
1155 02:03:31.760 ⇒ 02:03:40.829 Mustafa Raja: So, I’m wondering if anyone can help me see if we can replicate this in BigQuery, replicate this data in BigQuery at all, or not.
1156 02:03:44.080 ⇒ 02:03:46.830 Awaish Kumar: That is coming from return on ad spend, right?
1157 02:03:47.610 ⇒ 02:03:48.360 Mustafa Raja: Yes.
1158 02:03:49.160 ⇒ 02:03:50.970 Awaish Kumar: Okay, gentlemen.
1159 02:03:52.300 ⇒ 02:03:55.050 Awaish Kumar: At a span, both sides.
1160 02:03:56.020 ⇒ 02:04:00.350 Awaish Kumar: Okay, so… You have the carry, right? And with that, let’s try.
1161 02:04:02.110 ⇒ 02:04:03.460 Mustafa Raja: I don’t have the query, though.
1162 02:04:04.520 ⇒ 02:04:06.219 Awaish Kumar: If you’re just editing the model.
1163 02:04:07.070 ⇒ 02:04:09.930 Mustafa Raja: Oh yeah, this one, this?
1164 02:04:12.170 ⇒ 02:04:13.380 Mustafa Raja: Let me send you that.
1165 02:04:20.300 ⇒ 02:04:21.410 Awaish Kumar: Oh, it’s…
1166 02:04:50.400 ⇒ 02:04:53.400 Awaish Kumar: What table is it? Return or not as far, right?
1167 02:04:55.130 ⇒ 02:04:56.700 Awaish Kumar: Nothing go here.
1168 02:05:15.670 ⇒ 02:05:17.299 Awaish Kumar: What do we want to see?
1169 02:05:22.610 ⇒ 02:05:29.250 Mustafa Raja: We want to see, if we can replicate For this other…
1170 02:05:30.680 ⇒ 02:05:31.650 Awaish Kumar: That’s what I did.
1171 02:05:31.750 ⇒ 02:05:33.189 Mustafa Raja: I can’t see your screen.
1172 02:05:34.150 ⇒ 02:05:35.020 Mustafa Raja: Oh, sorry.
1173 02:05:39.280 ⇒ 02:05:46.559 Awaish Kumar: Huh, let’s take one thing. Let’s take… what is the most thing, like, most per… like, revenue?
1174 02:05:46.560 ⇒ 02:05:47.220 Mustafa Raja: Yeah, so…
1175 02:05:47.350 ⇒ 02:05:49.170 Awaish Kumar: Which one is non-basic?
1176 02:05:49.800 ⇒ 02:05:53.430 Mustafa Raja: Yeah, this, so for March 25th.
1177 02:05:53.850 ⇒ 02:05:55.990 Mustafa Raja: I cannot get this cohort.
1178 02:05:57.250 ⇒ 02:06:09.049 Awaish Kumar: Okay, let’s see, first order product, okay, let’s see, we have… Say… West quarter product is…
1179 02:06:11.700 ⇒ 02:06:15.249 Mustafa Raja: And I don’t even have the personal product filter up yet.
1180 02:06:19.770 ⇒ 02:06:22.780 Awaish Kumar: And… What else?
1181 02:06:24.040 ⇒ 02:06:28.740 Mustafa Raja: So, first our product, and then channel must be other.
1182 02:06:29.730 ⇒ 02:06:32.920 Mustafa Raja: And then the definition for that is this.
1183 02:06:35.540 ⇒ 02:06:40.969 Mustafa Raja: So if it is not the offer, it’s going to be considered other.
1184 02:06:41.490 ⇒ 02:06:42.270 Awaish Kumar: Okay.
1185 02:06:43.290 ⇒ 02:06:47.430 Mustafa Raja: And then, we want to see if we can get this cohort.
1186 02:08:09.520 ⇒ 02:08:11.080 Awaish Kumar: What month you’re looking at?
1187 02:08:11.730 ⇒ 02:08:13.080 Mustafa Raja: March 25th.
1188 02:08:13.270 ⇒ 02:08:16.099 Mustafa Raja: Oh, sorry, March 2025.
1189 02:08:19.360 ⇒ 02:08:19.980 Awaish Kumar: Okay.
1190 02:08:42.700 ⇒ 02:08:47.190 Awaish Kumar: Okay, we already… We have cohort fries in there.
1191 02:09:23.260 ⇒ 02:09:25.109 Mustafa Raja: Let me look, give it a look.
1192 02:10:05.210 ⇒ 02:10:09.350 Awaish Kumar: Hold… What size?
1193 02:10:21.970 ⇒ 02:10:24.710 Awaish Kumar: One, since first order is,
1194 02:10:37.930 ⇒ 02:10:39.119 Awaish Kumar: Okay, look.
1195 02:10:49.610 ⇒ 02:10:50.530 Awaish Kumar: Okay.
1196 02:11:13.720 ⇒ 02:11:21.199 Mustafa Raja: Yeah, and the table that I’m using isn’t being used in any joins, so this should be good. Actually…
1197 02:11:29.080 ⇒ 02:11:32.959 Awaish Kumar: It says… cannot get terrible.
1198 02:11:46.850 ⇒ 02:11:51.390 Awaish Kumar: Recalls… Probably don’t know.
1199 02:11:53.020 ⇒ 02:11:54.150 Awaish Kumar: somewhere.
1200 02:12:15.840 ⇒ 02:12:17.250 Awaish Kumar: Okay, we shut down.
1201 02:12:37.670 ⇒ 02:12:41.750 Awaish Kumar: Okay, code for… March?
1202 02:12:42.390 ⇒ 02:12:43.760 Awaish Kumar: 2025.
1203 02:12:44.650 ⇒ 02:12:46.640 Awaish Kumar: How much is that for you?
1204 02:12:49.510 ⇒ 02:12:55.880 Mustafa Raja: So, for me, for… We are only looking into the other channel, right?
1205 02:12:56.540 ⇒ 02:12:57.500 Awaish Kumar: Yes, yes.
1206 02:12:58.040 ⇒ 02:12:59.760 Mustafa Raja: It’s 1260.
1207 02:13:00.640 ⇒ 02:13:02.050 Awaish Kumar: And what is in Tableau?
1208 02:13:06.750 ⇒ 02:13:07.650 Mustafa Raja: this one.
1209 02:13:08.710 ⇒ 02:13:10.400 Awaish Kumar: 2470.
1210 02:13:12.130 ⇒ 02:13:15.950 Awaish Kumar: Cohort size for March 2024.
1211 02:13:19.910 ⇒ 02:13:20.560 Awaish Kumar: Terrific.
1212 02:13:21.350 ⇒ 02:13:22.670 Mustafa Raja: And this is the difference.
1213 02:13:22.840 ⇒ 02:13:24.330 Mustafa Raja: In Tableau.
1214 02:13:25.650 ⇒ 02:13:33.860 Awaish Kumar: Yeah, thing is… And, what we are doing now?
1215 02:13:36.470 ⇒ 02:13:38.459 Awaish Kumar: We should be able…
1216 02:14:29.610 ⇒ 02:14:32.830 Mustafa Raja: Are we able to replicate this, this definition with query?
1217 02:14:35.270 ⇒ 02:14:35.840 Mustafa Raja: In between.
1218 02:14:37.400 ⇒ 02:14:38.400 Awaish Kumar: Yes.
1219 02:14:58.420 ⇒ 02:15:00.940 Awaish Kumar: That was some court size.
1220 02:15:05.100 ⇒ 02:15:08.820 Awaish Kumar: The value for… Injectable seminar.
1221 02:15:08.960 ⇒ 02:15:09.890 Awaish Kumar: March.
1222 02:15:10.550 ⇒ 02:15:13.830 Awaish Kumar: 2025 is 2477.
1223 02:15:15.260 ⇒ 02:15:16.280 Mustafa Raja: 77?
1224 02:15:17.110 ⇒ 02:15:17.920 Awaish Kumar: Yes.
1225 02:15:18.880 ⇒ 02:15:21.490 Mustafa Raja: Yeah, here it’s 70, but it’s very close.
1226 02:15:24.040 ⇒ 02:15:25.910 Mustafa Raja: Okay, then…
1227 02:15:33.150 ⇒ 02:15:35.039 Mustafa Raja: This is weird, then.
1228 02:15:41.530 ⇒ 02:15:43.549 Mustafa Raja: And I haven’t even added the product.
1229 02:15:48.370 ⇒ 02:15:58.910 Awaish Kumar: Because for… This table has… first order month. Like, the primary key for this table is
1230 02:15:59.290 ⇒ 02:16:04.209 Awaish Kumar: First order month, first order product, channel, and month since first order.
1231 02:16:04.950 ⇒ 02:16:12.720 Awaish Kumar: But in this… In this chart, you basically are depend… you’re… you’re using…
1232 02:16:14.080 ⇒ 02:16:18.619 Awaish Kumar: You have to use, like, first order month, which is your column.
1233 02:16:18.870 ⇒ 02:16:23.720 Awaish Kumar: And then you have cohort size, and then… You have a filter on.
1234 02:16:24.510 ⇒ 02:16:36.530 Awaish Kumar: Injectable sema, but for the cohort size, We basically have to select… one value, by each… Partition.
1235 02:16:36.860 ⇒ 02:16:37.670 Awaish Kumar: the…
1236 02:16:41.370 ⇒ 02:16:44.209 Awaish Kumar: It should not be the max, because max…
1237 02:16:47.500 ⇒ 02:16:47.920 Mustafa Raja: Okay.
1238 02:16:47.920 ⇒ 02:16:52.450 Awaish Kumar: By each, by each of these, like, breakdowns, Cool.
1239 02:16:52.660 ⇒ 02:16:53.340 Awaish Kumar: What?
1240 02:16:53.510 ⇒ 02:16:59.339 Awaish Kumar: First order month, first order perk, channel, you should take the max, and then you have to sum it.
1241 02:16:59.559 ⇒ 02:17:01.230 Awaish Kumar: Then you will get the correct value.
1242 02:17:04.000 ⇒ 02:17:05.410 Mustafa Raja: Sorry, could you say that again?
1243 02:17:07.180 ⇒ 02:17:07.750 Awaish Kumar: You know.
1244 02:17:08.350 ⇒ 02:17:14.190 Awaish Kumar: So… For the first order month, first order product, and the
1245 02:17:15.990 ⇒ 02:17:22.229 Awaish Kumar: Yeah, let’s… let’s say you can select… can you select on the channel size max sum instead of max?
1246 02:17:23.600 ⇒ 02:17:26.100 Mustafa Raja: Channel side… sorry, channel size?
1247 02:17:26.170 ⇒ 02:17:28.199 Awaish Kumar: Sorry, code size sub.
1248 02:17:29.370 ⇒ 02:17:31.499 Mustafa Raja: Cohort size, this one, right?
1249 02:17:34.530 ⇒ 02:17:36.039 Awaish Kumar: And this one, or the…
1250 02:17:39.219 ⇒ 02:17:40.289 Mustafa Raja: This is good.
1251 02:17:42.090 ⇒ 02:17:45.509 Mustafa Raja: This is the other, this is the off… oh, this is good, thank you!
1252 02:17:50.090 ⇒ 02:17:52.000 Mustafa Raja: for clinical 70.
1253 02:17:52.209 ⇒ 02:18:00.790 Mustafa Raja: 25, 46… 1453… This is so cool.
1254 02:18:03.350 ⇒ 02:18:08.879 Mustafa Raja: Okay, for August, we have… for September, we have 5,02.
1255 02:18:09.540 ⇒ 02:18:15.179 Mustafa Raja: September, we have this. Okay, okay, this is cool. Thank you. Thank you so much. I stuck on this.
1256 02:18:18.900 ⇒ 02:18:20.450 Mustafa Raja: Okay, this is.
1257 02:18:22.730 ⇒ 02:18:23.450 Awaish Kumar: Okay.
1258 02:18:27.270 ⇒ 02:18:28.880 Mustafa Raja: Okay, but the revenue is incorrect.
1259 02:18:31.129 ⇒ 02:18:34.040 Demilade Agboola: I think you’re also using the Mac, so you need to switch it to the SUM.
1260 02:18:34.780 ⇒ 02:18:36.219 Mustafa Raja: Oh, that’s funny.
1261 02:18:51.219 ⇒ 02:18:52.780 Mustafa Raja: Yeah, this is good, thank you.
1262 02:18:54.459 ⇒ 02:18:55.729 Awaish Kumar: Okay, huh.
1263 02:19:00.639 ⇒ 02:19:03.219 Mustafa Raja: Revenue per customer would become…
1264 02:19:08.959 ⇒ 02:19:10.819 Mustafa Raja: Please do a little bit of cohort.
1265 02:19:10.820 ⇒ 02:19:12.830 Awaish Kumar: E1, right?
1266 02:19:14.350 ⇒ 02:19:15.790 Mustafa Raja: Wow.
1267 02:19:16.799 ⇒ 02:19:18.429 Mustafa Raja: Simple evil, please.
1268 02:19:31.440 ⇒ 02:19:35.500 Mustafa Raja: Okay, this is… Acceptable, I believe.
1269 02:19:43.719 ⇒ 02:19:45.719 Mustafa Raja: Yeah, this is cool.
1270 02:19:47.400 ⇒ 02:19:48.989 Mustafa Raja: And here’s what you want.
1271 02:19:49.870 ⇒ 02:19:51.250 Awaish Kumar: Okay.
1272 02:19:53.610 ⇒ 02:19:54.340 Mustafa Raja: Okay.
1273 02:19:55.860 ⇒ 02:19:58.489 Mustafa Raja: C40 DHH2…
1274 02:19:59.370 ⇒ 02:20:00.859 Awaish Kumar: Let me switch back.
1275 02:20:06.910 ⇒ 02:20:07.590 Mustafa Raja: Okay.
1276 02:20:09.150 ⇒ 02:20:10.830 Mustafa Raja: If I go here…
1277 02:20:25.650 ⇒ 02:20:27.620 Mustafa Raja: Come on, size revenue doesn’t focus on it.
1278 02:20:43.930 ⇒ 02:20:44.790 Awaish Kumar: Boom.
1279 02:20:45.460 ⇒ 02:20:46.450 Awaish Kumar: Mustafar?
1280 02:20:47.920 ⇒ 02:20:50.159 Awaish Kumar: You just let me know where?
1281 02:20:50.350 ⇒ 02:20:52.229 Awaish Kumar: You’re bringing this from.
1282 02:20:53.650 ⇒ 02:20:55.020 Mustafa Raja: Which one?
1283 02:20:55.020 ⇒ 02:20:57.119 Awaish Kumar: What is this? Rif and view dimension?
1284 02:20:58.540 ⇒ 02:21:00.550 Mustafa Raja: Wait, can you share screen?
1285 02:21:01.420 ⇒ 02:21:02.740 Awaish Kumar: Oh, this one here.
1286 02:21:03.500 ⇒ 02:21:04.000 Awaish Kumar: I’m one.
1287 02:21:04.000 ⇒ 02:21:11.799 Mustafa Raja: Yeah, I was in the wrong tab. Okay, this I am not bringing, this blobby is bringing.
1288 02:21:13.010 ⇒ 02:21:13.520 Awaish Kumar: Cool.
1289 02:21:13.670 ⇒ 02:21:17.939 Mustafa Raja: Oh, you might have created this with Blobby.
1290 02:21:20.590 ⇒ 02:21:29.400 Mustafa Raja: Yeah, this is an issue. We have to create this. We have to look into the definition in the…
1291 02:21:31.200 ⇒ 02:21:32.440 Mustafa Raja: In the blue.
1292 02:21:34.070 ⇒ 02:21:37.430 Awaish Kumar: Yeah, avoid is, like… Oh, the…
1293 02:21:37.430 ⇒ 02:21:39.440 Mustafa Raja: Yeah, let’s search it on the left side, no?
1294 02:21:39.610 ⇒ 02:21:41.380 Mustafa Raja: Let’s search it on the left, yeah.
1295 02:21:41.780 ⇒ 02:21:45.080 Mustafa Raja: What the describes is, oh, we can do this.
1296 02:21:48.470 ⇒ 02:21:53.819 Mustafa Raja: Refund selector… refund… we would need refund segment selector for this then, right?
1297 02:21:55.030 ⇒ 02:21:56.240 Mustafa Raja: Do we have that?
1298 02:21:58.080 ⇒ 02:21:59.559 Awaish Kumar: This is a filter.
1299 02:22:01.010 ⇒ 02:22:02.960 Awaish Kumar: Okay, we need to add this.
1300 02:22:03.410 ⇒ 02:22:05.130 Awaish Kumar: As a column.
1301 02:22:06.390 ⇒ 02:22:06.849 Mustafa Raja: That’s weird.
1302 02:22:07.440 ⇒ 02:22:08.250 Awaish Kumar: Look at this.
1303 02:22:11.020 ⇒ 02:22:11.680 Mustafa Raja: Yeah.
1304 02:22:12.350 ⇒ 02:22:15.559 Demilade Agboola: Can you find what refund segment selector is?
1305 02:22:16.710 ⇒ 02:22:19.970 Awaish Kumar: This is just a filter, it is pointing to a filter.
1306 02:22:20.540 ⇒ 02:22:21.750 Demilade Agboola: Okay, yeah.
1307 02:22:22.320 ⇒ 02:22:23.349 Demilade Agboola: Like, it’s a parameter.
1308 02:22:23.350 ⇒ 02:22:32.070 Awaish Kumar: It says when you select the value overall in the filter, Then it just stays… overall…
1309 02:22:34.560 ⇒ 02:22:40.149 Mustafa Raja: Yeah, so we have to create this… create this then, right? So we need to see the definition of refund segment.
1310 02:22:40.260 ⇒ 02:22:41.900 Mustafa Raja: Selector then, right?
1311 02:22:45.650 ⇒ 02:22:48.749 Mustafa Raja: Because I don’t think we have that in the columns in Omni.
1312 02:22:50.020 ⇒ 02:22:54.589 Awaish Kumar: Yeah, but… yeah, how Tableau is working, I don’t know, with this.
1313 02:22:55.020 ⇒ 02:22:59.380 Mustafa Raja: Do we not have this in Tableau also?
1314 02:23:01.420 ⇒ 02:23:06.889 Awaish Kumar: like, this is not a field or something here, right? Okay.
1315 02:23:09.570 ⇒ 02:23:12.509 Awaish Kumar: I don’t know where it is bringing it from.
1316 02:23:13.880 ⇒ 02:23:16.880 Mustafa Raja: Can we search it? Maybe each one of the tables might pop up.
1317 02:23:18.980 ⇒ 02:23:20.430 Awaish Kumar: Yeah, but it is… I…
1318 02:23:20.430 ⇒ 02:23:21.309 Demilade Agboola: What’d I try to find?
1319 02:23:22.610 ⇒ 02:23:23.170 Awaish Kumar: Huh?
1320 02:23:23.290 ⇒ 02:23:24.349 Demilade Agboola: What are you trying to find?
1321 02:23:26.230 ⇒ 02:23:26.630 Awaish Kumar: Yeah.
1322 02:23:26.630 ⇒ 02:23:28.050 Mustafa Raja: Refund segment collector.
1323 02:23:28.050 ⇒ 02:23:30.230 Demilade Agboola: It’s at the bottom, it says parameter, so you.
1324 02:23:30.230 ⇒ 02:23:30.829 Awaish Kumar: Love you.
1325 02:23:30.830 ⇒ 02:23:31.050 Mustafa Raja: Oh.
1326 02:23:31.270 ⇒ 02:23:33.029 Demilade Agboola: Yeah, so you can right-click it, describe.
1327 02:23:34.770 ⇒ 02:23:37.320 Awaish Kumar: Oh, this… so there’s another thing, this.
1328 02:23:38.440 ⇒ 02:23:45.429 Demilade Agboola: Yeah, so it’s basically… So it’s basically trying to do…
1329 02:23:45.430 ⇒ 02:23:48.670 Awaish Kumar: Let me see… What I… what I think…
1330 02:23:48.670 ⇒ 02:23:51.539 Demilade Agboola: Can you do that again? I’m sorry, I was trying to look at that.
1331 02:23:53.220 ⇒ 02:23:53.900 Awaish Kumar: Miss?
1332 02:23:54.310 ⇒ 02:23:54.930 Demilade Agboola: Yeah.
1333 02:23:55.300 ⇒ 02:23:57.720 Demilade Agboola: Is it overall, universes repeat.
1334 02:23:57.970 ⇒ 02:23:58.940 Demilade Agboola: My product.
1335 02:24:04.600 ⇒ 02:24:08.379 Awaish Kumar: I think it’s just Tableau when you dynamically select some values.
1336 02:24:08.760 ⇒ 02:24:09.390 Demilade Agboola: Yeah.
1337 02:24:09.570 ⇒ 02:24:11.410 Awaish Kumar: It… it brings them to…
1338 02:24:15.920 ⇒ 02:24:18.360 Mustafa Raja: So how do you reflect that, though, in Omni?
1339 02:24:19.700 ⇒ 02:24:21.289 Awaish Kumar: We have to find other ways.
1340 02:24:24.120 ⇒ 02:24:25.810 Awaish Kumar: Some way to do that.
1341 02:24:26.430 ⇒ 02:24:29.219 Awaish Kumar: Let’s see, let’s understand what it is doing.
1342 02:24:32.720 ⇒ 02:24:36.829 Awaish Kumar: Okay, when it says segment is overall, then just say overall.
1343 02:24:37.360 ⇒ 02:24:39.710 Awaish Kumar: It’s new versus complete orders.
1344 02:24:43.880 ⇒ 02:24:50.249 Awaish Kumar: Okay, like… that’s what I did for my yesterday’s chart. What I did, basically.
1345 02:24:50.660 ⇒ 02:24:54.659 Awaish Kumar: This… what it is trying to do is… These are just different…
1346 02:24:55.710 ⇒ 02:24:57.990 Awaish Kumar: Ways of breaking down the chart.
1347 02:24:58.290 ⇒ 02:25:03.690 Awaish Kumar: And in here, it is basically trying to use this one column.
1348 02:25:04.050 ⇒ 02:25:05.699 Awaish Kumar: To handle that, so, like…
1349 02:25:10.840 ⇒ 02:25:15.720 Awaish Kumar: If you say by product, then it will bring values for opposite tricep product name.
1350 02:25:16.060 ⇒ 02:25:21.860 Awaish Kumar: If you say this, then it will bring values from This influence is chocolate.
1351 02:25:22.280 ⇒ 02:25:23.529 Awaish Kumar: So, why not…
1352 02:25:24.180 ⇒ 02:25:31.389 Awaish Kumar: What we can do is, we can split this chart, the single thing, into 3 different charts.
1353 02:25:34.090 ⇒ 02:25:36.090 Awaish Kumar: One shows overall values.
1354 02:25:36.420 ⇒ 02:25:39.520 Awaish Kumar: One shows that the split by new versus repeat.
1355 02:25:39.860 ⇒ 02:25:42.750 Awaish Kumar: And one shows the breakdown by products.
1356 02:25:43.380 ⇒ 02:25:46.060 Awaish Kumar: So you will see, like… Month?
1357 02:25:46.610 ⇒ 02:25:51.250 Awaish Kumar: And the products… And then another one month, and the new verses.
1358 02:25:53.700 ⇒ 02:25:54.580 Awaish Kumar: Repeat.
1359 02:25:54.960 ⇒ 02:25:59.620 Awaish Kumar: And then it was one… One versus overall, that’s all.
1360 02:26:00.420 ⇒ 02:26:11.560 Awaish Kumar: So that way, it will, yeah, simplify this thing. That’s what I did for my… last,
1361 02:26:12.290 ⇒ 02:26:15.709 Awaish Kumar: dashboard as well. Otherwise, if I create a field.
1362 02:26:15.990 ⇒ 02:26:26.440 Awaish Kumar: Something like this. It will be, like… For a disaster, like… It will have multiple Rhino’s like this… Mmm…
1363 02:26:27.400 ⇒ 02:26:32.170 Awaish Kumar: Basically, the full table with everything it says overall.
1364 02:26:32.460 ⇒ 02:26:36.539 Awaish Kumar: Then we all… once again, I will have saved full table with,
1365 02:26:38.700 ⇒ 02:26:44.920 Awaish Kumar: With, inviting… with a column, with the… Values like new versus repeat.
1366 02:26:50.610 ⇒ 02:26:51.920 Awaish Kumar: And then again.
1367 02:26:52.960 ⇒ 02:26:57.769 Awaish Kumar: So, one single column with a lot of different Types of values.
1368 02:26:58.540 ⇒ 02:27:07.090 Awaish Kumar: Instead of that, I think I… I should have, three different charts, which basically… Should we…
1369 02:27:07.880 ⇒ 02:27:11.049 Awaish Kumar: In the dashboard, and let us just view that.
1370 02:27:14.410 ⇒ 02:27:15.540 Awaish Kumar: What do you think?
1371 02:27:24.670 ⇒ 02:27:28.410 Mustafa Raja: So we just want… we just want 3 different charts with the values.
1372 02:27:30.190 ⇒ 02:27:32.949 Mustafa Raja: With the… with the filter values, right?
1373 02:27:33.510 ⇒ 02:27:40.769 Awaish Kumar: Yeah, you see like this. This is a dynamically segment, and if I try to add all of that.
1374 02:27:40.920 ⇒ 02:27:45.789 Awaish Kumar: in a BigQuery column, and then filter, and based on that, then I just need to…
1375 02:27:45.950 ⇒ 02:27:49.060 Awaish Kumar: For each row, I will have to say if it’s a first or a new.
1376 02:27:49.180 ⇒ 02:27:51.050 Awaish Kumar: And then I also have to say…
1377 02:27:51.270 ⇒ 02:27:55.190 Awaish Kumar: if it is a part of overall, and then I also say what product it is part of.
1378 02:27:55.840 ⇒ 02:27:58.970 Awaish Kumar: I have to select 3 different things, right?
1379 02:27:59.390 ⇒ 02:28:00.690 Awaish Kumar: And it will just…
1380 02:28:02.610 ⇒ 02:28:07.360 Mustafa Raja: Hmm. Maybe, maybe if you could implement your solution, and then let Greg know?
1381 02:28:07.900 ⇒ 02:28:10.359 Mustafa Raja: Since he’s handling communication with them.
1382 02:28:11.540 ⇒ 02:28:15.799 Awaish Kumar: So, yeah, this is one of the ways, and what it will do is just…
1383 02:28:16.750 ⇒ 02:28:23.880 Awaish Kumar: This one, overall, just scroll down a little bit, it will have another chart with, mcDonald’s.
1384 02:28:24.040 ⇒ 02:28:31.770 Awaish Kumar: by… New versus Repeat, and then scroll down, you will see their breakdown by products.
1385 02:28:32.080 ⇒ 02:28:34.759 Awaish Kumar: That will make it simpler than selecting.
1386 02:28:35.600 ⇒ 02:28:36.430 Mustafa Raja: Yeah.
1387 02:28:38.310 ⇒ 02:28:39.740 Awaish Kumar: Okay, I’ll do that.
1388 02:28:39.850 ⇒ 02:28:43.109 Awaish Kumar: But apart from that, I don’t see any problems.
1389 02:28:43.900 ⇒ 02:28:45.190 Mustafa Raja: Yeah, yeah, there is…
1390 02:28:46.960 ⇒ 02:28:47.450 Awaish Kumar: Okay.
1391 02:28:47.450 ⇒ 02:28:50.560 Mustafa Raja: I believe the rest was good, let me double-check the ticket.
1392 02:28:51.030 ⇒ 02:28:53.170 Awaish Kumar: Yeah, I saw that again, it says,
1393 02:28:55.680 ⇒ 02:28:59.230 Awaish Kumar: Numbers… number one was that adding the filters.
1394 02:29:00.510 ⇒ 02:29:01.950 Awaish Kumar: Which are already there.
1395 02:29:01.950 ⇒ 02:29:06.260 Mustafa Raja: I added the filters, this one filter I couldn’t add.
1396 02:29:06.910 ⇒ 02:29:09.699 Awaish Kumar: Yeah, then it says the refund rate is,
1397 02:29:12.300 ⇒ 02:29:14.389 Awaish Kumar: I don’t know what… man, I hate it.
1398 02:29:18.630 ⇒ 02:29:23.360 Awaish Kumar: Different rate, maybe… it shows different… little bit different values, right?
1399 02:29:23.560 ⇒ 02:29:25.620 Awaish Kumar: I guess just because of,
1400 02:29:29.150 ⇒ 02:29:35.049 Awaish Kumar: Because these, these values actually… match with the BigQuery, so I don’t know, I…
1401 02:29:37.640 ⇒ 02:29:38.670 Mustafa Raja: Okay.
1402 02:29:38.850 ⇒ 02:29:42.849 Awaish Kumar: Yeah, because if you see here, We have orders.
1403 02:29:43.880 ⇒ 02:29:45.820 Awaish Kumar: And this is coming from here.
1404 02:29:46.180 ⇒ 02:29:47.029 Awaish Kumar: I get it.
1405 02:29:47.170 ⇒ 02:29:48.600 Awaish Kumar: It’ll just count.
1406 02:29:48.780 ⇒ 02:29:50.560 Awaish Kumar: Distinct order number, right?
1407 02:29:52.610 ⇒ 02:29:53.840 Mustafa Raja: Yeah.
1408 02:29:53.840 ⇒ 02:29:55.050 Awaish Kumar: the month of March.
1409 02:29:57.680 ⇒ 02:29:58.560 Awaish Kumar: And…
1410 02:29:58.560 ⇒ 02:29:59.130 Mustafa Raja: Yep.
1411 02:30:01.300 ⇒ 02:30:05.879 Mustafa Raja: I think I took a look at that, and I might have fixed that.
1412 02:30:06.290 ⇒ 02:30:08.600 Mustafa Raja: I remember working on that.
1413 02:30:10.120 ⇒ 02:30:11.400 Awaish Kumar: Okay, what?
1414 02:30:11.580 ⇒ 02:30:15.360 Mustafa Raja: Yeah, the difference is very slight… very, very minimal now.
1415 02:30:17.780 ⇒ 02:30:18.340 Awaish Kumar: What is it?
1416 02:30:18.340 ⇒ 02:30:20.010 Mustafa Raja: I think Greg was okay with it.
1417 02:30:21.130 ⇒ 02:30:23.030 Awaish Kumar: 2089… okay.
1418 02:30:23.250 ⇒ 02:30:31.870 Awaish Kumar: And then, 447… Yeah, there’s a little bit of difference with this, but then I compared with BigQuery.
1419 02:30:33.010 ⇒ 02:30:35.630 Awaish Kumar: And then I… it was really…
1420 02:30:35.810 ⇒ 02:30:38.179 Awaish Kumar: Matching with the bakery itself, so it’s okay.
1421 02:30:38.590 ⇒ 02:30:42.070 Awaish Kumar: I will just add a few more charts here, and close this again.
1422 02:30:46.190 ⇒ 02:30:46.900 Awaish Kumar: Okay.
1423 02:30:49.980 ⇒ 02:30:51.770 Awaish Kumar: What else do we have here?
1424 02:30:55.490 ⇒ 02:30:58.440 Awaish Kumar: Okay, I don’t know which table this is using, by the way.
1425 02:30:59.690 ⇒ 02:31:01.030 Awaish Kumar: This has a lot of…
1426 02:31:02.320 ⇒ 02:31:11.710 Mustafa Raja: Yeah, if you would, if you would hover over the pharmacy SLA, there’s going to be, three dots pop up, and then you can go to the definition of the table.
1427 02:31:11.860 ⇒ 02:31:15.060 Mustafa Raja: No, no, no, in the… in the view. Yeah.
1428 02:31:19.500 ⇒ 02:31:21.790 Mustafa Raja: Okay, this is weird.
1429 02:31:22.560 ⇒ 02:31:25.340 Mustafa Raja: Maybe, maybe in one of the fields you would try that?
1430 02:31:26.760 ⇒ 02:31:28.390 Awaish Kumar: Yeah, what.
1431 02:31:28.640 ⇒ 02:31:31.160 Mustafa Raja: Modeling, and then… definition, yeah.
1432 02:31:32.470 ⇒ 02:31:35.329 Mustafa Raja: This should take you to the table, yeah, the orders on the table.
1433 02:31:36.490 ⇒ 02:31:38.289 Awaish Kumar: What is the base view over here?
1434 02:31:39.310 ⇒ 02:31:52.389 Mustafa Raja: So for that, you’ll have to take a look at the… so this is the table, right? For the base view, base views belong to topics, so let’s… let’s search for pharmacy SLA.
1435 02:31:55.690 ⇒ 02:31:58.030 Mustafa Raja: Let’s search for pharmacy SLA.
1436 02:31:58.750 ⇒ 02:31:59.999 Awaish Kumar: Where’d get myself.
1437 02:32:00.880 ⇒ 02:32:02.979 Mustafa Raja: Yeah, on the top, you see? Find.
1438 02:32:08.970 ⇒ 02:32:15.199 Mustafa Raja: Yeah, yeah, at the bottom, you see patient filing and Pharmacy Center.
1439 02:32:16.050 ⇒ 02:32:26.250 Mustafa Raja: Yeah, so here, there, yeah, order, order summary is the… is the base view, and then it’s joined with, transactions.
1440 02:32:30.000 ⇒ 02:32:30.660 Awaish Kumar: Okay.
1441 02:32:32.090 ⇒ 02:32:33.000 Awaish Kumar: Free.
1442 02:32:34.380 ⇒ 02:32:37.610 Awaish Kumar: Go back here, and if I select… Jews.
1443 02:32:40.170 ⇒ 02:32:42.129 Awaish Kumar: Okay, and what is this, then?
1444 02:32:45.140 ⇒ 02:32:46.789 Awaish Kumar: So this is coming from.
1445 02:32:46.790 ⇒ 02:32:58.879 Mustafa Raja: These ones are usually, so the ones… so the ones that are in query fields, heading, these ones are usually created when, when Blobby works on it, you know, when the Omni AI works on it.
1446 02:32:59.070 ⇒ 02:33:13.680 Mustafa Raja: Sometimes it creates, fields outside of the topic, and those, those are, appear, appeared as here. You know, we can promote this to our, topic or to our view, though, from here.
1447 02:33:17.850 ⇒ 02:33:18.540 Awaish Kumar: Okay.
1448 02:33:22.320 ⇒ 02:33:22.940 Awaish Kumar: Sweet.
1449 02:33:22.940 ⇒ 02:33:27.480 Mustafa Raja: Yeah, we can promote it to our, shared tables, but yeah.
1450 02:33:31.200 ⇒ 02:33:34.530 Awaish Kumar: Order date, month, and refund view.
1451 02:33:36.260 ⇒ 02:33:37.140 Awaish Kumar: Okay.
1452 02:33:37.440 ⇒ 02:33:40.719 Awaish Kumar: Yeah, thank you for this. I will just close this ticket.
1453 02:33:41.280 ⇒ 02:33:42.290 Awaish Kumar: Aww.
1454 02:33:43.090 ⇒ 02:33:48.170 Awaish Kumar: I’ve asked Thom to help on replying to… Josh?
1455 02:33:48.590 ⇒ 02:33:51.709 Awaish Kumar: What else is here? Like, this is closed.
1456 02:33:52.040 ⇒ 02:33:53.550 Awaish Kumar: This is kind of closed.
1457 02:33:53.930 ⇒ 02:33:56.340 Awaish Kumar: Lifecycle marketing, you’re closing it, right?
1458 02:33:58.050 ⇒ 02:34:02.769 Mustafa Raja: Lifecycle marketing, where’s that? Let me, let me double-check that.
1459 02:34:02.770 ⇒ 02:34:05.910 Awaish Kumar: You just work… the demo… the demo artist…
1460 02:34:06.760 ⇒ 02:34:09.600 Mustafa Raja: Oh, yeah, that’s in PR, demilodi…
1461 02:34:11.450 ⇒ 02:34:13.039 Awaish Kumar: This one, like, the…
1462 02:34:13.920 ⇒ 02:34:15.740 Mustafa Raja: Yeah, I’m merging it.
1463 02:34:18.900 ⇒ 02:34:19.790 Mustafa Raja: Okay.
1464 02:34:23.630 ⇒ 02:34:24.330 Awaish Kumar: Okay.
1465 02:34:25.020 ⇒ 02:34:28.199 Awaish Kumar: So, this is about to close, right? Because…
1466 02:34:29.170 ⇒ 02:34:35.039 Awaish Kumar: Code size? No, you were working on the offer versus the other.
1467 02:34:36.430 ⇒ 02:34:40.020 Mustafa Raja: Yeah, that was, in retention one. That was the…
1468 02:34:40.300 ⇒ 02:34:43.890 Mustafa Raja: Retention one. That is closed now.
1469 02:34:46.420 ⇒ 02:34:55.289 Mustafa Raja: Wait, I didn’t publish it, let me publish it. I’m just adding filters for that, and then I’ll work on other things.
1470 02:34:57.450 ⇒ 02:35:03.349 Mustafa Raja: I’ll… I’ll first work on the… work on ones that, that were assigned to them.
1471 02:35:05.560 ⇒ 02:35:06.310 Awaish Kumar: Okay.
1472 02:35:07.350 ⇒ 02:35:14.430 Awaish Kumar: But, like, this was the one that, demi, shared with you the…
1473 02:35:14.990 ⇒ 02:35:16.400 Mustafa Raja: Yeah, I’m taking care of it.
1474 02:35:17.900 ⇒ 02:35:19.999 Awaish Kumar: Yeah, let’s see.
1475 02:35:20.430 ⇒ 02:35:23.829 Awaish Kumar: I can’t… Thank you.
1476 02:35:23.830 ⇒ 02:35:24.250 Mustafa Raja: Beautiful.
1477 02:35:25.380 ⇒ 02:35:30.150 Awaish Kumar: Yeah, let me close this one, then, like, we can see… we can collaborate on this one.
1478 02:35:31.240 ⇒ 02:35:31.730 Mustafa Raja: Thank you.
1479 02:35:32.010 ⇒ 02:35:33.599 Awaish Kumar: I think the other one. Okay.
1480 02:35:34.590 ⇒ 02:35:38.769 Awaish Kumar: Maybe let’s… Nice to regroup,
1481 02:35:42.400 ⇒ 02:35:44.870 Awaish Kumar: Maybe a rescue group and what, like…
1482 02:35:45.240 ⇒ 02:35:46.510 Mustafa Raja: blah, blah, blah.
1483 02:35:48.840 ⇒ 02:35:50.810 Awaish Kumar: Whenever you’re done, just ping me on Slack.
1484 02:35:51.580 ⇒ 02:35:52.260 Mustafa Raja: Okay.
1485 02:35:53.840 ⇒ 02:35:54.689 Awaish Kumar: Thank you.
1486 02:35:55.510 ⇒ 02:35:56.489 Mustafa Raja: Okay, thank you.
1487 02:35:57.050 ⇒ 02:35:57.369 Awaish Kumar: But…