Meeting Title: Omni Eden Review Date: 2026-02-23 Meeting participants: Mustafa Raja, Demilade Agboola
WEBVTT
1 00:03:25.140 ⇒ 00:03:26.380 Demilade Agboola: Hi, Mustafa.
2 00:03:32.300 ⇒ 00:03:33.150 Mustafa Raja: Hey, how are you?
3 00:03:33.900 ⇒ 00:03:35.410 Demilade Agboola: I’m doing very well, how are you?
4 00:03:36.170 ⇒ 00:03:40.659 Mustafa Raja: Yeah, doing good. Sorry. Sorry for setting up this long meeting.
5 00:03:40.990 ⇒ 00:03:42.709 Demilade Agboola: It’s all good.
6 00:03:43.010 ⇒ 00:03:48.629 Demilade Agboola: It was just… I had a friend visiting town, so I just wanted to quickly see them before they left tomorrow.
7 00:03:48.630 ⇒ 00:03:50.550 Mustafa Raja: Oh, yeah, yeah, that’s good.
8 00:03:51.390 ⇒ 00:03:57.240 Mustafa Raja: Okay, so, let me share my screen.
9 00:03:57.760 ⇒ 00:03:58.570 Demilade Agboola: Sounds good.
10 00:04:00.370 ⇒ 00:04:01.689 Mustafa Raja: Sorry, not this one.
11 00:04:02.870 ⇒ 00:04:06.620 Mustafa Raja: This… I always get confused with double monitors.
12 00:04:07.310 ⇒ 00:04:09.109 Mustafa Raja: Okay, this one.
13 00:04:10.400 ⇒ 00:04:14.689 Mustafa Raja: Okay, so… were you able to take a look at this?
14 00:04:15.540 ⇒ 00:04:18.389 Demilade Agboola: Yes, I was able to take a look at what…
15 00:04:20.209 ⇒ 00:04:23.520 Demilade Agboola: We were trying, like, what the issues have been so far.
16 00:04:27.880 ⇒ 00:04:28.699 Demilade Agboola: Okay, so for the ball…
17 00:04:28.700 ⇒ 00:04:32.459 Mustafa Raja: Okay, so, so for this, I met with…
18 00:04:35.830 ⇒ 00:04:36.710 Mustafa Raja: Sorry?
19 00:04:37.410 ⇒ 00:04:38.660 Demilade Agboola: Nothing you can consume.
20 00:04:39.000 ⇒ 00:04:40.650 Mustafa Raja: Troy, you’re saying something?
21 00:04:41.330 ⇒ 00:04:46.890 Mustafa Raja: Oh, okay, okay. Yeah, so for this, I met with Ush, and
22 00:04:54.300 ⇒ 00:04:55.290 Mustafa Raja: Sorry?
23 00:04:56.010 ⇒ 00:04:56.760 Mustafa Raja: I’m like, cutting.
24 00:04:56.760 ⇒ 00:04:58.040 Demilade Agboola: I think there’s a lag.
25 00:05:01.030 ⇒ 00:05:02.939 Demilade Agboola: Can you check if your laptop is lagging?
26 00:05:03.730 ⇒ 00:05:04.690 Mustafa Raja: Oh, wait…
27 00:05:08.050 ⇒ 00:05:10.900 Mustafa Raja: Give me a moment, actually.
28 00:05:10.900 ⇒ 00:05:11.570 Demilade Agboola: Okay.
29 00:05:20.150 ⇒ 00:05:25.639 Mustafa Raja: Okay, I’ll share again now, and tell me if I’m still lagging. Am I still lagging?
30 00:05:26.500 ⇒ 00:05:27.830 Demilade Agboola: Can you hear me now?
31 00:05:29.520 ⇒ 00:05:30.710 Mustafa Raja: Yeah, again.
32 00:05:31.420 ⇒ 00:05:34.309 Demilade Agboola: Okay. It was a little bit delayed, but, like, it’s fine.
33 00:05:36.080 ⇒ 00:05:39.380 Mustafa Raja: Okay, okay. Okay, so yeah, so,
34 00:05:39.720 ⇒ 00:05:45.719 Mustafa Raja: Okay, so, I met with Wish on this, right? And I worked on it a little.
35 00:05:46.640 ⇒ 00:05:50.639 Mustafa Raja: Now, for the values that are in the offer.
36 00:05:50.770 ⇒ 00:05:54.879 Mustafa Raja: They do align, you know? They do make sense, they are all correct.
37 00:05:55.500 ⇒ 00:05:57.879 Mustafa Raja: But the ones here are not.
38 00:05:58.200 ⇒ 00:06:04.600 Mustafa Raja: In the other. Now, my suspect… my suspicion is on this one, this filter.
39 00:06:04.960 ⇒ 00:06:09.400 Mustafa Raja: You know, could you tell me what this strike-through means?
40 00:06:16.540 ⇒ 00:06:17.710 Demilade Agboola: The stripe.
41 00:06:19.750 ⇒ 00:06:22.029 Demilade Agboola: So I think this is the first order.
42 00:06:22.670 ⇒ 00:06:25.380 Demilade Agboola: Like, what do you mean by, oh, the strike across it?
43 00:06:25.670 ⇒ 00:06:33.720 Mustafa Raja: Yeah, yeah, this, this is right through, right? I tried to, so, so, if I were to, you know, let me…
44 00:06:34.410 ⇒ 00:06:36.599 Mustafa Raja: This isn’t the one.
45 00:06:37.160 ⇒ 00:06:45.669 Mustafa Raja: First order… Once in first order, with a filter, and I set it to not equal to…
46 00:06:46.350 ⇒ 00:06:49.080 Mustafa Raja: And this would be Z minus 1, right?
47 00:06:52.470 ⇒ 00:06:59.049 Mustafa Raja: Yeah, so one other issue is none of these filters on this specific
48 00:06:59.330 ⇒ 00:07:02.810 Mustafa Raja: Table, or, you know, making any changes.
49 00:07:04.300 ⇒ 00:07:09.329 Mustafa Raja: I’m going to publish it, and I’m going to edit it again, to see if that changes it.
50 00:07:14.670 ⇒ 00:07:15.510 Mustafa Raja: Tito.
51 00:07:19.120 ⇒ 00:07:21.459 Mustafa Raja: Yeah, nothing changes here.
52 00:07:22.120 ⇒ 00:07:23.250 Mustafa Raja: Anyways…
53 00:07:24.450 ⇒ 00:07:31.019 Mustafa Raja: Yeah, so, yeah, so, so did you know, so do you know what this strikethrough really means?
54 00:07:31.440 ⇒ 00:07:36.170 Mustafa Raja: Does it mean that this one is not included and all others are?
55 00:07:40.050 ⇒ 00:07:41.129 Mustafa Raja: Can you hear me?
56 00:07:43.130 ⇒ 00:07:47.860 Demilade Agboola: Can you hear me? Yes, I can hear you. I’m saying, to be honest, I actually don’t know, this is one of the things I’m not sure I know.
57 00:07:48.220 ⇒ 00:07:48.930 Demilade Agboola: And there’s no…
58 00:07:48.930 ⇒ 00:07:51.269 Mustafa Raja: Yeah, because this is messing up.
59 00:07:51.310 ⇒ 00:07:53.350 Demilade Agboola: Is there any notes on it anywhere?
60 00:07:54.200 ⇒ 00:07:58.150 Mustafa Raja: I couldn’t find any… To be honest.
61 00:07:58.710 ⇒ 00:08:02.840 Mustafa Raja: And this is very weird, so I’m going to show you one more… one more example.
62 00:08:03.060 ⇒ 00:08:07.440 Mustafa Raja: So, for this one… Let’s cross this…
63 00:08:10.620 ⇒ 00:08:19.250 Mustafa Raja: And I’m going to show you one more example with this, and you’ll see that this… Somewhat is weird.
64 00:08:20.700 ⇒ 00:08:23.500 Mustafa Raja: Sorry, my internet is a little, you know, slow.
65 00:08:24.630 ⇒ 00:08:25.750 Demilade Agboola: It’s all good.
66 00:08:26.890 ⇒ 00:08:28.439 Mustafa Raja: Not this one.
67 00:08:30.180 ⇒ 00:08:38.050 Mustafa Raja: If you open it up… You’d see that… you’d see that it has a few of these selected, right?
68 00:08:40.299 ⇒ 00:08:41.869 Demilade Agboola: mmm…
69 00:08:42.409 ⇒ 00:08:44.419 Mustafa Raja: Right, okay. Now…
70 00:08:48.489 ⇒ 00:09:07.149 Mustafa Raja: Now, let’s take a look… let’s only look at this cohort size sum column, right? So, based on this, if I consider this is, if I consider this strike through, in not equal to, then I should, you know, be doing…
71 00:09:07.239 ⇒ 00:09:17.409 Mustafa Raja: For example… Minus 1, 0… 922…
72 00:09:20.839 ⇒ 00:09:31.569 Mustafa Raja: 9… 0, 9, 22… not a zero… 09… 22…
73 00:09:36.879 ⇒ 00:09:37.869 Mustafa Raja: This is one.
74 00:09:38.089 ⇒ 00:09:49.399 Mustafa Raja: And 324253627… 8… 9… 30… 51.
75 00:09:50.459 ⇒ 00:09:51.979 Mustafa Raja: Never validated.
76 00:09:53.189 ⇒ 00:10:01.699 Mustafa Raja: You see how, how this, this, this, this confirms that this is not not equal to, right? Because if I were to just…
77 00:10:01.700 ⇒ 00:10:05.759 Demilade Agboola: But let’s do, let’s do, you know, let’s do what. Let’s take it step by step.
78 00:10:05.970 ⇒ 00:10:10.349 Demilade Agboola: Can you unselect everything, but, like, the not… like, the strikeouts?
79 00:10:11.360 ⇒ 00:10:12.999 Demilade Agboola: Negative 1.
80 00:10:13.000 ⇒ 00:10:13.590 Mustafa Raja: Right.
81 00:10:14.550 ⇒ 00:10:18.959 Mustafa Raja: So if I… if I am selecting anything, it just automatically puts us right through.
82 00:10:19.450 ⇒ 00:10:22.290 Demilade Agboola: Okay. Alright, so select, select all.
83 00:10:24.380 ⇒ 00:10:25.760 Mustafa Raja: All now.
84 00:10:26.570 ⇒ 00:10:27.210 Demilade Agboola: Cool.
85 00:10:28.130 ⇒ 00:10:30.009 Demilade Agboola: Alright, so you’ve selected all now.
86 00:10:30.160 ⇒ 00:10:34.589 Demilade Agboola: Alright, can we go back there? I’m trying to see, like, let’s… I’m trying to understand what it’s doing.
87 00:10:35.350 ⇒ 00:10:35.740 Mustafa Raja: Absolutely.
88 00:10:36.240 ⇒ 00:10:37.589 Demilade Agboola: So go back to… no…
89 00:10:39.060 ⇒ 00:10:44.510 Demilade Agboola: So it matches right now, everything is fine. Yeah, but this is… this is on equal to 1, no?
90 00:10:44.880 ⇒ 00:10:45.580 Demilade Agboola: Alright.
91 00:10:45.970 ⇒ 00:10:47.390 Demilade Agboola: So let’s go back there.
92 00:10:48.540 ⇒ 00:10:51.890 Mustafa Raja: And if this is all, then this happens.
93 00:10:52.490 ⇒ 00:10:54.540 Demilade Agboola: That’s fine. Please can’t go back.
94 00:10:56.440 ⇒ 00:11:05.229 Demilade Agboola: Alright, so this is all. Can we then select… the… Alright, and then… Can we select?
95 00:11:06.670 ⇒ 00:11:08.789 Demilade Agboola: 0. Let’s select zero.
96 00:11:09.400 ⇒ 00:11:10.570 Mustafa Raja: This one, right?
97 00:11:10.700 ⇒ 00:11:13.950 Mustafa Raja: Oh, okay, this now is right too, okay.
98 00:11:15.250 ⇒ 00:11:15.630 Demilade Agboola: Does he…
99 00:11:15.630 ⇒ 00:11:22.940 Mustafa Raja: Yeah, one… yeah, this is something else that I noticed. This doesn’t change… Much.
100 00:11:28.250 ⇒ 00:11:31.840 Demilade Agboola: I mean, it kind of makes sense. The co-op size should not change.
101 00:11:34.070 ⇒ 00:11:35.230 Demilade Agboola: Think about it.
102 00:11:35.400 ⇒ 00:11:39.709 Demilade Agboola: The number of people who bought a certain product in the first month, Will not change.
103 00:11:41.950 ⇒ 00:11:44.640 Demilade Agboola: Now, if you change the products, it should change.
104 00:11:52.590 ⇒ 00:12:03.750 Demilade Agboola: So, only one person bought Finest Stride in the month of May. Do you get my point? So, if you’re looking at… this is the number of people that bought the first thing in 2024. That should not change.
105 00:12:04.340 ⇒ 00:12:05.740 Demilade Agboola: That cohort size.
106 00:12:05.920 ⇒ 00:12:07.260 Demilade Agboola: It shouldn’t change.
107 00:12:07.580 ⇒ 00:12:09.720 Mustafa Raja: Did you get my point? My first order.
108 00:12:11.710 ⇒ 00:12:14.100 Demilade Agboola: So, do you understand what a cohort is, in the context.
109 00:12:14.100 ⇒ 00:12:17.220 Mustafa Raja: Yeah, yeah, this cohort is the number of customers, right?
110 00:12:17.700 ⇒ 00:12:23.859 Demilade Agboola: New customers, or people that made their first purchase, If you’re doing all.
111 00:12:24.960 ⇒ 00:12:40.670 Demilade Agboola: everything should be the same. The core size will not change. Unless you’re looking at maybe different products, then the core size should change, obviously, because some people are buying injectable semi, some people are buying Finestride, some people are buying Teserpitide, like, they’re different products, right?
112 00:12:41.240 ⇒ 00:12:42.280 Demilade Agboola: So that’s phenomenal.
113 00:12:43.850 ⇒ 00:12:46.209 Demilade Agboola: So, mountains, so that should not change anything.
114 00:12:46.360 ⇒ 00:12:47.400 Demilade Agboola: in this.
115 00:12:48.240 ⇒ 00:12:50.780 Demilade Agboola: Unless we are looking at, let’s see…
116 00:12:52.920 ⇒ 00:12:54.980 Demilade Agboola: Yeah, you should not change anything like this, like…
117 00:12:54.980 ⇒ 00:13:03.230 Mustafa Raja: My question would be, are we able to selectively select which column this filter applies to?
118 00:13:04.170 ⇒ 00:13:08.629 Demilade Agboola: I’m not sure, I’m not sure that’s what’s going on here. I think what’s happening here is…
119 00:13:08.820 ⇒ 00:13:15.200 Demilade Agboola: Because it doesn’t apply or do any change to the data, that’s where it’s striking out. That’s my guess.
120 00:13:16.030 ⇒ 00:13:18.840 Demilade Agboola: But let me, let me, let me Google. Let me see what Google says.
121 00:13:18.840 ⇒ 00:13:19.920 Mustafa Raja: Okay, okay, okay.
122 00:13:20.360 ⇒ 00:13:25.559 Mustafa Raja: Because in Omni, it’s, it’s changing, you know? The data is changing.
123 00:13:25.710 ⇒ 00:13:27.200 Demilade Agboola: Mmm, yeah, I can see that.
124 00:13:27.590 ⇒ 00:13:35.510 Mustafa Raja: And the topic is only this, this table. There are not joins at all, so…
125 00:13:59.510 ⇒ 00:14:04.030 Demilade Agboola: I’m trying to even see the… what field… what dashboard is this? Is the retention dashboard?
126 00:14:04.030 ⇒ 00:14:07.120 Mustafa Raja: This is the retention one. Do you want me to send the link?
127 00:14:07.690 ⇒ 00:14:10.130 Demilade Agboola: I’m almost there.
128 00:14:10.660 ⇒ 00:14:11.470 Mustafa Raja: I’m good.
129 00:14:22.290 ⇒ 00:14:23.620 Mustafa Raja: Who built these?
130 00:14:24.660 ⇒ 00:14:29.800 Demilade Agboola: And my guess is probably, it’s either Annie or… I think it’s Annie.
131 00:14:30.150 ⇒ 00:14:30.820 Mustafa Raja: Okay.
132 00:14:31.570 ⇒ 00:14:35.120 Demilade Agboola: Maybe… Henry. I think it was on here.
133 00:14:35.120 ⇒ 00:14:36.510 Mustafa Raja: Oh, okay, good.
134 00:14:42.830 ⇒ 00:14:45.180 Demilade Agboola: And he was really good with, like, Tableau and stuff.
135 00:14:47.620 ⇒ 00:14:48.490 Mustafa Raja: Yep.
136 00:14:49.090 ⇒ 00:14:52.880 Demilade Agboola: Incredibly good at Apple. I actually learned some things from her as well.
137 00:14:54.020 ⇒ 00:14:56.270 Mustafa Raja: Yeah, and I’m learning a lot from you.
138 00:14:58.990 ⇒ 00:15:00.180 Mustafa Raja: The cycle goes on.
139 00:15:01.850 ⇒ 00:15:04.629 Demilade Agboola: Definitely. It’s just one of those things where…
140 00:15:08.000 ⇒ 00:15:12.979 Demilade Agboola: No, like, Tableau just works, possessing things, but for some other things, it’s just weird.
141 00:15:14.320 ⇒ 00:15:15.160 Mustafa Raja: Yeah.
142 00:15:15.160 ⇒ 00:15:16.970 Demilade Agboola: This is when it starts to get really complex.
143 00:15:48.520 ⇒ 00:15:49.920 Demilade Agboola: Whoa!
144 00:15:50.170 ⇒ 00:15:53.830 Demilade Agboola: So, this is what’s happening. Let me quickly share my screen.
145 00:15:54.200 ⇒ 00:15:54.850 Mustafa Raja: Yes, ma’am.
146 00:15:59.240 ⇒ 00:16:00.300 Demilade Agboola: Can you see my screen?
147 00:16:00.650 ⇒ 00:16:01.560 Mustafa Raja: Yup.
148 00:16:04.090 ⇒ 00:16:08.980 Demilade Agboola: The filter here, if you look at Edit Filter, or if you look at this, you can see it’s excluding values.
149 00:16:10.090 ⇒ 00:16:15.079 Demilade Agboola: So, it’s not… it’s… basically, yeah, you’re right, it’s a not equals to thing.
150 00:16:15.360 ⇒ 00:16:16.150 Demilade Agboola: No.
151 00:16:16.150 ⇒ 00:16:21.409 Mustafa Raja: It’s… it’s just saying, not equal to 1, right?
152 00:16:21.670 ⇒ 00:16:22.310 Demilade Agboola: Yes.
153 00:16:22.480 ⇒ 00:16:23.389 Demilade Agboola: Right now.
154 00:16:24.520 ⇒ 00:16:25.370 Mustafa Raja: Mmm.
155 00:16:26.000 ⇒ 00:16:28.519 Mustafa Raja: But it still doesn’t make sense, to be honest.
156 00:16:28.770 ⇒ 00:16:30.419 Demilade Agboola: It does, if you think about it.
157 00:16:31.020 ⇒ 00:16:33.899 Demilade Agboola: So what it’s saying is not equals to the first month.
158 00:16:36.840 ⇒ 00:16:39.050 Demilade Agboola: So then… I’m trying to see…
159 00:16:45.220 ⇒ 00:16:47.880 Demilade Agboola: Why is this… I thought I just noticed it said change.
160 00:16:49.120 ⇒ 00:16:52.060 Mustafa Raja: Yeah, I did too, but it’s not happening anymore.
161 00:16:53.840 ⇒ 00:16:54.680 Demilade Agboola: That’s strange.
162 00:16:57.560 ⇒ 00:17:00.820 Mustafa Raja: Oh, there was a change. I think February got removed.
163 00:17:01.040 ⇒ 00:17:01.680 Demilade Agboola: Yes.
164 00:17:06.470 ⇒ 00:17:08.410 Mustafa Raja: Oh, I… .
165 00:17:10.060 ⇒ 00:17:15.319 Demilade Agboola: So it’s not that it’s changing the values, it’s that it’s removing the month of first order.
166 00:17:15.599 ⇒ 00:17:23.450 Demilade Agboola: So you’re saying, basically, exclude where the Monson’s first order is… from Montego.
167 00:17:30.360 ⇒ 00:17:32.030 Mustafa Raja: Month or first daughter.
168 00:17:33.020 ⇒ 00:17:34.240 Mustafa Raja: For the customer?
169 00:17:38.440 ⇒ 00:17:39.079 Mustafa Raja: What do you call?
170 00:17:39.080 ⇒ 00:17:44.279 Demilade Agboola: It doesn’t seem like you can remove any, like, you can’t remove a random value, that’s what I’m.
171 00:17:44.280 ⇒ 00:17:46.160 Mustafa Raja: Yeah, it has to be in a sequence.
172 00:17:46.320 ⇒ 00:17:47.700 Demilade Agboola: EA has been a sequence.
173 00:17:50.850 ⇒ 00:17:53.380 Mustafa Raja: And then all doesn’t work also then, right?
174 00:17:54.490 ⇒ 00:17:55.560 Demilade Agboola: FIPS, so…
175 00:17:59.290 ⇒ 00:18:03.230 Mustafa Raja: Yeah, you have to start from minus 1 for it to work.
176 00:18:03.740 ⇒ 00:18:04.970 Demilade Agboola: Exactly.
177 00:18:08.050 ⇒ 00:18:17.039 Mustafa Raja: But then, in Omni, it’s a little weird also there. Do you want to take a look at that? How Omni’s doing this?
178 00:18:20.680 ⇒ 00:18:25.439 Demilade Agboola: Yeah, let’s try that, let me see. Also, you see, when you select everything now, it’s gone.
179 00:18:26.640 ⇒ 00:18:31.330 Mustafa Raja: Why is it now… hmm… Oh.
180 00:18:32.390 ⇒ 00:18:35.059 Mustafa Raja: Okay, okay. Let me share my screen now.
181 00:18:35.250 ⇒ 00:18:35.940 Demilade Agboola: Okay.
182 00:18:38.810 ⇒ 00:18:39.730 Mustafa Raja: Okay…
183 00:18:44.980 ⇒ 00:18:59.030 Mustafa Raja: Okay, so in Omni, you see, if I… if I don’t have any filters over it, you know, it’s going to, just give me all these values, but now if I were to, say.
184 00:18:59.200 ⇒ 00:19:00.369 Mustafa Raja: 1 over here.
185 00:19:01.650 ⇒ 00:19:04.769 Mustafa Raja: This is going to exactly match with this.
186 00:19:04.920 ⇒ 00:19:05.790 Mustafa Raja: Go ahead.
187 00:19:07.320 ⇒ 00:19:13.380 Demilade Agboola: You know what I suggest? I think this is a filter that is not necessary. Like, I don’t think it’s a filter that you… like, let me see the entire dashboard.
188 00:19:13.790 ⇒ 00:19:21.320 Demilade Agboola: If it’s not a filter that matters much, you can just ignore it, because all it’s just doing is removing the last one. Like, to be honest, that’s not a really significant business.
189 00:19:21.500 ⇒ 00:19:22.520 Demilade Agboola: use case.
190 00:19:23.060 ⇒ 00:19:25.420 Demilade Agboola: they will be fine without it. It’s not that deep.
191 00:19:25.940 ⇒ 00:19:28.309 Mustafa Raja: Yeah, so here’s the dashboard.
192 00:19:58.320 ⇒ 00:20:06.090 Demilade Agboola: Okay, so this is by product. So, you see, like, can you see that it’s just… first of the month is the main thing that is being used for this?
193 00:20:06.930 ⇒ 00:20:07.790 Mustafa Raja: Yeah.
194 00:20:08.680 ⇒ 00:20:14.899 Demilade Agboola: I don’t think, honestly, I don’t think you need… I don’t think that filter is necessary. Like, you can get rid of it, it’s not that serious.
195 00:20:14.900 ⇒ 00:20:17.269 Mustafa Raja: But then, this is, like…
196 00:20:18.020 ⇒ 00:20:24.860 Demilade Agboola: Okay, so you know what, I think you should add that filter in, but don’t make it available to… like, make it the same, but don’t make it available.
197 00:20:25.970 ⇒ 00:20:29.789 Demilade Agboola: I also think you’re probably doing a summation of, like, values across val…
198 00:20:29.790 ⇒ 00:20:31.420 Mustafa Raja: Yeah, this is also Sam, no.
199 00:20:34.270 ⇒ 00:20:36.029 Mustafa Raja: The cohort is a sum overall.
200 00:20:37.780 ⇒ 00:20:38.610 Demilade Agboola: Is it?
201 00:20:38.610 ⇒ 00:20:39.310 Mustafa Raja: Yep.
202 00:20:41.460 ⇒ 00:20:43.100 Demilade Agboola: Until we’re just across the month.
203 00:20:44.090 ⇒ 00:20:47.360 Demilade Agboola: Yeah, I don’t… I don’t think, like, it should not be that high.
204 00:20:47.360 ⇒ 00:20:50.630 Mustafa Raja: Yeah, you see, it’s a sumo roll, no?
205 00:20:51.360 ⇒ 00:20:54.489 Demilade Agboola: Yes, but it’s a sum across new customers in that month.
206 00:20:54.840 ⇒ 00:20:56.090 Mustafa Raja: Yeah.
207 00:20:59.900 ⇒ 00:21:01.090 Demilade Agboola: Yeah.
208 00:21:01.090 ⇒ 00:21:07.149 Mustafa Raja: So, for a month and product, it selects the max value, which Omni already does.
209 00:21:07.540 ⇒ 00:21:09.290 Mustafa Raja: And then put some over it.
210 00:21:10.170 ⇒ 00:21:13.409 Demilade Agboola: I don’t think it’s… I don’t think it’s a sum in that sense.
211 00:21:15.030 ⇒ 00:21:16.780 Demilade Agboola: The reason why I say that is…
212 00:21:21.030 ⇒ 00:21:25.419 Demilade Agboola: A cohort size is the cohort size. You’re not going to… do you get my point?
213 00:21:25.840 ⇒ 00:21:29.260 Demilade Agboola: it’s… I guess it’s summed across maybe multiple products?
214 00:21:30.600 ⇒ 00:21:32.630 Demilade Agboola: But it’s not a sum across…
215 00:21:32.820 ⇒ 00:21:34.209 Demilade Agboola: I’m trying to trigger my points.
216 00:21:35.770 ⇒ 00:21:37.590 Demilade Agboola: Let’s go back to the Omni dashboard.
217 00:21:38.480 ⇒ 00:21:39.470 Mustafa Raja: Yep.
218 00:21:41.800 ⇒ 00:21:42.900 Demilade Agboola: Okay, so here.
219 00:21:43.610 ⇒ 00:21:46.839 Demilade Agboola: I can tell you for free, there’s no way we had 96,000 people.
220 00:21:47.040 ⇒ 00:21:48.590 Demilade Agboola: new customers in.
221 00:21:48.900 ⇒ 00:21:54.259 Demilade Agboola: in a month, in September, the journalist, I’m trying to say. So, like.
222 00:21:54.340 ⇒ 00:21:55.260 Mustafa Raja: Clearly.
223 00:21:56.520 ⇒ 00:21:58.549 Demilade Agboola: Can I… can we look at cohort size some?
224 00:22:00.030 ⇒ 00:22:02.110 Mustafa Raja: It’s just this processing.
225 00:22:02.600 ⇒ 00:22:04.280 Demilade Agboola: Alright, can I look at the formula?
226 00:22:04.900 ⇒ 00:22:11.109 Mustafa Raja: Oh, it’s just aggregate over it, so cohort size, and then aggregate, and then some.
227 00:22:15.580 ⇒ 00:22:17.310 Demilade Agboola: So, you see, the sum is…
228 00:22:18.150 ⇒ 00:22:21.539 Demilade Agboola: Can you go back to Tableau’s formula again? And you see what I’m trying to say.
229 00:22:22.390 ⇒ 00:22:23.939 Demilade Agboola: So look at call ties.
230 00:22:24.480 ⇒ 00:22:31.589 Demilade Agboola: Fixed, right? It is… for the first month, and for the first order product, so for every product.
231 00:22:31.730 ⇒ 00:22:35.020 Demilade Agboola: And the first month, take the maximum court size.
232 00:22:36.550 ⇒ 00:22:40.459 Demilade Agboola: Then, across the multiple products, as you know there are multiple products.
233 00:22:40.590 ⇒ 00:22:48.419 Demilade Agboola: sum it up. So, take one for… in a hundred that were bought for this, 100 that were bought. So, I think what you’re doing is you’re summing up…
234 00:22:48.680 ⇒ 00:22:50.260 Mustafa Raja: Yeah, I get it.
235 00:22:50.390 ⇒ 00:22:54.020 Demilade Agboola: Yeah, so I think that’s the issue. It should not… they’d definitely never be this high.
236 00:22:54.720 ⇒ 00:22:55.440 Mustafa Raja: Okay.
237 00:22:56.520 ⇒ 00:23:03.940 Mustafa Raja: Yeah, I tried, I tried telling Kurser this, and it was just, saying, no, no, just do this.
238 00:23:03.940 ⇒ 00:23:16.150 Demilade Agboola: So here’s… well, here’s what you… two things you might do. One is you might put that filter automatically, the one that you had that made you have exactly the same numbers, automatically you might do that. The one that you removed, but just hide it so that it’s not in the dashboard.
239 00:23:16.150 ⇒ 00:23:26.969 Mustafa Raja: No, no, the issue with that is it messes up with all of the values. So only this column is going to be, you know, matching with the dashboard, and all others are just messed up.
240 00:23:27.160 ⇒ 00:23:27.920 Demilade Agboola: Oh, okay.
241 00:23:27.920 ⇒ 00:23:30.949 Mustafa Raja: So we need to, you know, work, work on this.
242 00:23:31.510 ⇒ 00:23:32.140 Demilade Agboola: Yeah.
243 00:23:33.000 ⇒ 00:23:35.979 Mustafa Raja: Could you guide me through the SQL or something with that?
244 00:23:36.140 ⇒ 00:23:38.740 Mustafa Raja: Because Cursor is just not working on it.
245 00:23:40.880 ⇒ 00:23:43.730 Demilade Agboola: Let me see…
246 00:23:55.630 ⇒ 00:23:56.480 Demilade Agboola: Let’s see…
247 00:24:03.550 ⇒ 00:24:05.560 Demilade Agboola: its own… given…
248 00:24:29.620 ⇒ 00:24:31.599 Demilade Agboola: Alright, so this was kind of…
249 00:24:36.530 ⇒ 00:24:38.820 Demilade Agboola: Can you make this into a column?
250 00:24:40.120 ⇒ 00:24:41.650 Demilade Agboola: Sorry,
251 00:24:43.260 ⇒ 00:24:48.219 Demilade Agboola: From… what’s the name of the table again? Like, what’s the name of the table of view you’re using?
252 00:24:49.110 ⇒ 00:24:49.550 Mustafa Raja: Sorry, sorry?
253 00:24:49.550 ⇒ 00:24:54.620 Demilade Agboola: What’s… Clay, can you make a distinct, like, table of view?
254 00:24:55.870 ⇒ 00:24:58.189 Demilade Agboola: Like, or can you create a new column?
255 00:24:58.740 ⇒ 00:25:00.479 Mustafa Raja: Yeah, yeah.
256 00:25:00.480 ⇒ 00:25:01.210 Demilade Agboola: Let me see.
257 00:25:01.880 ⇒ 00:25:05.620 Mustafa Raja: And then we could, put a formula like SQL in here.
258 00:25:06.340 ⇒ 00:25:11.840 Demilade Agboola: Alright, so, like, I just sent you in the chat, like, what the concepts that… like, what’s going on underneath.
259 00:25:11.970 ⇒ 00:25:14.430 Demilade Agboola: So for every combination, it’s saying, hey.
260 00:25:14.820 ⇒ 00:25:18.279 Demilade Agboola: Select the max cohort size, and then we’re now doing a sum of those.
261 00:25:20.870 ⇒ 00:25:21.890 Mustafa Raja: Hmm…
262 00:25:21.890 ⇒ 00:25:25.280 Demilade Agboola: So, we first need to have a distinct column in the table.
263 00:25:27.050 ⇒ 00:25:33.719 Demilade Agboola: Where we’re doing that. So we’d select max score size for every combination of first of the month and that.
264 00:25:33.890 ⇒ 00:25:35.880 Demilade Agboola: And then we now sum it up.
265 00:25:36.330 ⇒ 00:25:38.159 Demilade Agboola: So that’s the sum of what we’re doing.
266 00:25:40.030 ⇒ 00:25:41.010 Mustafa Raja: Okay.
267 00:25:41.010 ⇒ 00:25:41.739 Demilade Agboola: This is where I’m.
268 00:25:41.740 ⇒ 00:25:43.430 Mustafa Raja: This isn’t going to…
269 00:25:45.290 ⇒ 00:25:48.540 Demilade Agboola: So, like, I think this is something we need to do in the topic, basically.
270 00:25:48.540 ⇒ 00:25:55.510 Mustafa Raja: Yeah, I think so too. This, this is just it, you know? We could just put it over here, and this goes into the topic.
271 00:26:05.170 ⇒ 00:26:08.860 Mustafa Raja: Wait, I’m just going to ask yourself to… You know.
272 00:26:09.500 ⇒ 00:26:11.090 Mustafa Raja: Translate this for me.
273 00:26:20.200 ⇒ 00:26:20.880 Mustafa Raja: Thank you.
274 00:26:51.730 ⇒ 00:26:57.369 Mustafa Raja: Yeah, you see… you see what it’s saying. SQL for custom fields should be this.
275 00:27:01.350 ⇒ 00:27:06.929 Mustafa Raja: Actually, let me try this now. Let me… let me actually try this, how might just work?
276 00:27:12.380 ⇒ 00:27:14.359 Demilade Agboola: Don’t you already have a custom max field?
277 00:27:16.050 ⇒ 00:27:16.870 Mustafa Raja: Sorry?
278 00:27:17.240 ⇒ 00:27:19.229 Demilade Agboola: Don’t you already have a custom max field?
279 00:27:19.230 ⇒ 00:27:26.569 Mustafa Raja: Yeah, but it’s going to be, hmm… yeah…
280 00:27:27.150 ⇒ 00:27:29.430 Mustafa Raja: This doesn’t make sense to think.
281 00:27:29.750 ⇒ 00:27:34.229 Demilade Agboola: Let me look at… what’s the formula for your… your cumulative, like, core size max wood?
282 00:27:34.390 ⇒ 00:27:35.719 Demilade Agboola: There’s quarter size marks right there.
283 00:27:35.720 ⇒ 00:27:37.939 Mustafa Raja: I think it’s just this.
284 00:27:39.000 ⇒ 00:27:41.409 Demilade Agboola: The problem is, doing max is…
285 00:27:42.330 ⇒ 00:27:48.799 Demilade Agboola: Are you sure it’s doing across the same grain? Like, is it grouping by first order month and first order product? That’s the problem.
286 00:27:49.400 ⇒ 00:27:54.150 Mustafa Raja: Yeah, I think it… it is. First order month and first order product, right?
287 00:27:55.400 ⇒ 00:27:57.900 Demilade Agboola: The easy way to test that… would be…
288 00:27:58.860 ⇒ 00:28:00.970 Demilade Agboola: Add the products in there. Okay, so…
289 00:28:04.110 ⇒ 00:28:07.070 Demilade Agboola: Can you add the marks? The max column, please?
290 00:28:18.520 ⇒ 00:28:19.509 Demilade Agboola: Okay, so…
291 00:28:23.150 ⇒ 00:28:24.360 Demilade Agboola: Alright, so we do.
292 00:28:24.360 ⇒ 00:28:27.549 Mustafa Raja: My idea was if we do max, and then we submit.
293 00:28:28.490 ⇒ 00:28:32.630 Demilade Agboola: So what are you summing? So when you’re doing the sum, what is the sum summing? Can you… can I check the…
294 00:28:32.630 ⇒ 00:28:34.179 Mustafa Raja: It’s this, this, go ahead.
295 00:28:34.180 ⇒ 00:28:37.210 Demilade Agboola: No, it should be some… it should be some in quotes, Max. That’s the problem.
296 00:28:37.940 ⇒ 00:28:39.469 Mustafa Raja: Okay, okay. So.
297 00:28:40.000 ⇒ 00:28:42.440 Demilade Agboola: In some column, it should be summoning cohort marks.
298 00:28:43.460 ⇒ 00:28:45.750 Mustafa Raja: Okay, let me, let me just add this then.
299 00:28:46.080 ⇒ 00:28:48.270 Demilade Agboola: No, no, no, this is fine. What you’ve done is fine.
300 00:28:48.600 ⇒ 00:28:53.210 Demilade Agboola: Cohort size sum is the problem. It needs to be sum in cohort size max.
301 00:28:53.400 ⇒ 00:29:01.420 Mustafa Raja: Yeah, but but what we need to do is we need to add it as a dimension, so it can be aggregated. We cannot aggregate this right now.
302 00:29:01.890 ⇒ 00:29:03.989 Demilade Agboola: But you cannot aggregate… oh, gotcha.
303 00:29:04.190 ⇒ 00:29:05.900 Mustafa Raja: Yeah, so we need to add this.
304 00:29:06.400 ⇒ 00:29:08.570 Mustafa Raja: You know? And then we can do that.
305 00:29:09.170 ⇒ 00:29:11.210 Mustafa Raja: Okay, sure. Damn.
306 00:29:12.370 ⇒ 00:29:13.870 Mustafa Raja: And…
307 00:29:26.180 ⇒ 00:29:28.760 Mustafa Raja: What?
308 00:29:28.960 ⇒ 00:29:30.220 Demilade Agboola: Yeah, so…
309 00:29:32.160 ⇒ 00:29:39.929 Demilade Agboola: We either need to… can you, like, how do you change… can you make a measure, like, can you go to the… the… what’s it called, the model?
310 00:29:40.470 ⇒ 00:29:41.370 Mustafa Raja: Yeah.
311 00:29:41.370 ⇒ 00:29:45.679 Demilade Agboola: And then to actually force it to be a measure, and a dimension, sorry.
312 00:29:47.960 ⇒ 00:29:50.400 Demilade Agboola: So instead of, like, when he names it a…
313 00:29:50.630 ⇒ 00:29:53.240 Demilade Agboola: Like, go to the topic, or wherever.
314 00:29:53.450 ⇒ 00:29:54.520 Mustafa Raja: Yeah.
315 00:29:57.100 ⇒ 00:30:00.920 Mustafa Raja: I think we’ll have to go into the table itself, but let me see…
316 00:30:04.660 ⇒ 00:30:05.870 Mustafa Raja: Okay.
317 00:30:16.740 ⇒ 00:30:17.900 Mustafa Raja: This one?
318 00:30:23.310 ⇒ 00:30:25.369 Demilade Agboola: So, like, let’s find the cohort.
319 00:30:25.370 ⇒ 00:30:29.029 Mustafa Raja: I might have not pushed it to…
320 00:30:32.880 ⇒ 00:30:34.120 Mustafa Raja: Okay, there’s a lot.
321 00:30:34.380 ⇒ 00:30:35.360 Mustafa Raja: Popfruit.
322 00:30:41.740 ⇒ 00:30:44.499 Mustafa Raja: Let’s just create it, then, over there.
323 00:30:45.260 ⇒ 00:30:49.070 Mustafa Raja: So… repet is this aggregate type max.
324 00:30:49.410 ⇒ 00:30:53.260 Mustafa Raja: So if we were to add it as a measure, we would say…
325 00:30:55.270 ⇒ 00:31:01.250 Mustafa Raja: But we don’t want to add that as my… so, could you help me translate this in dimensions?
326 00:31:01.810 ⇒ 00:31:06.799 Mustafa Raja: So, let me just first add it as a merger and see how we can convert it into a dimension?
327 00:31:07.150 ⇒ 00:31:09.960 Demilade Agboola: No, let’s… let’s add as a… let’s add as a dimension.
328 00:31:09.960 ⇒ 00:31:11.939 Mustafa Raja: Yeah, how do you do that?
329 00:31:13.140 ⇒ 00:31:20.110 Mustafa Raja: Oh, so there’s an SQL for that, right? So, it was cohort size then, right? Cohort code…
330 00:31:22.830 ⇒ 00:31:24.650 Mustafa Raja: I know, that’s so cool.
331 00:31:26.630 ⇒ 00:31:28.469 Demilade Agboola: a cohort summary.
332 00:31:28.650 ⇒ 00:31:29.860 Demilade Agboola: Can you scroll down?
333 00:31:33.830 ⇒ 00:31:36.180 Demilade Agboola: Okay, so there isn’t any cohort summary.
334 00:31:45.000 ⇒ 00:31:48.380 Mustafa Raja: SQL, and then… is it going to be just Max? Like this?
335 00:31:48.680 ⇒ 00:31:50.070 Demilade Agboola: It’ll be the Mox thingy.
336 00:31:51.280 ⇒ 00:31:54.259 Mustafa Raja: And then I’m going to say… cohort size.
337 00:31:54.810 ⇒ 00:31:55.690 Mustafa Raja: Right.
338 00:31:57.840 ⇒ 00:31:59.480 Mustafa Raja: And then I’m going to save it.
339 00:32:01.630 ⇒ 00:32:05.270 Mustafa Raja: And then I’m going here, and then I’m refreshing this.
340 00:32:06.900 ⇒ 00:32:08.280 Mustafa Raja: What do we have?
341 00:32:09.230 ⇒ 00:32:14.620 Mustafa Raja: We cannot… Group by clause cannot contain aggregates.
342 00:32:15.700 ⇒ 00:32:18.549 Mustafa Raja: So I think the issue here is our max.
343 00:32:21.120 ⇒ 00:32:26.320 Mustafa Raja: This is an aggregate, and this, I think… Is,
344 00:32:27.020 ⇒ 00:32:31.989 Mustafa Raja: It depend… I think it’s dependent on the months and stuff, you know.
345 00:32:32.300 ⇒ 00:32:34.400 Mustafa Raja: Close to a manifested product.
346 00:32:35.340 ⇒ 00:32:36.629 Demilade Agboola: Okay, let me see.
347 00:32:37.440 ⇒ 00:32:43.040 Mustafa Raja: That’s why it was being added as… Measure from the field.
348 00:32:45.700 ⇒ 00:32:46.780 Mustafa Raja: Huh…
349 00:32:56.140 ⇒ 00:32:58.130 Mustafa Raja: Which PI tool do you love?
350 00:32:59.520 ⇒ 00:33:00.809 Demilade Agboola: None, really. I don’t enjoy being.
351 00:33:00.810 ⇒ 00:33:01.429 Mustafa Raja: Excuse me.
352 00:33:01.430 ⇒ 00:33:02.499 Demilade Agboola: That’s a big fan.
353 00:33:03.640 ⇒ 00:33:06.710 Demilade Agboola: It’s very… it can be a very frustrating thing.
354 00:33:06.710 ⇒ 00:33:09.650 Mustafa Raja: Yeah, I can understand, you know.
355 00:33:13.730 ⇒ 00:33:18.869 Mustafa Raja: for a lot of these, this is… this is… this goes smooth. For the ones that it…
356 00:33:19.020 ⇒ 00:33:24.089 Mustafa Raja: It, you know, the ones that get us stuck, you know, it really frustrates.
357 00:33:25.410 ⇒ 00:33:29.509 Demilade Agboola: Yes, it’s… And it’s really, like, a very small detail that you might have to.
358 00:33:29.510 ⇒ 00:33:30.980 Mustafa Raja: Funny. Yeah.
359 00:33:31.600 ⇒ 00:33:33.940 Mustafa Raja: Yeah, I get you.
360 00:33:35.250 ⇒ 00:33:39.080 Mustafa Raja: And you might have seen that from the summary I have created.
361 00:34:01.160 ⇒ 00:34:05.409 Mustafa Raja: By the way, do you have time to work on the dashboard tickets that you were assigned?
362 00:34:06.850 ⇒ 00:34:11.919 Demilade Agboola: I mean, I will try and see if I can do something later today, but it will be a bit tricky.
363 00:34:12.989 ⇒ 00:34:13.769 Mustafa Raja: Okay.
364 00:34:14.169 ⇒ 00:34:17.629 Mustafa Raja: I’ll see if I can take any of those out of your plate.
365 00:34:18.440 ⇒ 00:34:19.310 Demilade Agboola: Let’s see.
366 00:34:19.620 ⇒ 00:34:20.910 Demilade Agboola: Or, it seems like…
367 00:34:24.670 ⇒ 00:34:29.199 Demilade Agboola: Can we make a new view based off an SQL?
368 00:34:30.130 ⇒ 00:34:30.800 Demilade Agboola: Let’s try that.
369 00:34:31.050 ⇒ 00:34:34.620 Mustafa Raja: OpenSQL, a new view. I think we can.
370 00:34:34.620 ⇒ 00:34:35.460 Demilade Agboola: Yeah, so…
371 00:34:35.469 ⇒ 00:34:36.139 Mustafa Raja: And you…
372 00:34:36.139 ⇒ 00:34:39.929 Demilade Agboola: We will now define this this way, and let’s see what works.
373 00:34:41.620 ⇒ 00:34:45.540 Mustafa Raja: I don’t know how, though. I know that there’s virtual views here.
374 00:34:46.190 ⇒ 00:34:53.310 Mustafa Raja: Omni will use… Yeah, let’s say how many custom views? Custom views.
375 00:34:55.790 ⇒ 00:34:58.009 Mustafa Raja: That’s the views, no problem.
376 00:34:58.560 ⇒ 00:35:05.139 Mustafa Raja: Oh, query views, yeah, it was called query views. So we’ll create a query, and that’ll create a view.
377 00:35:08.050 ⇒ 00:35:09.559 Mustafa Raja: Do you want to do that?
378 00:35:11.170 ⇒ 00:35:12.600 Demilade Agboola: Yeah, sure, let’s try that.
379 00:35:12.870 ⇒ 00:35:13.790 Mustafa Raja: Oh, okay.
380 00:35:15.190 ⇒ 00:35:25.110 Mustafa Raja: Well, this is a disaster, so… Let’s try… Yeah, let’s save this…
381 00:35:28.200 ⇒ 00:35:39.110 Mustafa Raja: And then let’s… Explorer… And then… Sorry, non-dimi.
382 00:35:39.470 ⇒ 00:35:40.000 Demilade Agboola: Alright.
383 00:35:40.470 ⇒ 00:35:41.810 Demilade Agboola: Let’s see…
384 00:35:43.680 ⇒ 00:35:46.309 Mustafa Raja: Okay, so what do you want to do? What do you want to do?
385 00:35:49.690 ⇒ 00:35:51.560 Mustafa Raja: Actually, I’m not going to do that.
386 00:35:51.710 ⇒ 00:35:53.980 Mustafa Raja: I am going to stay.
387 00:35:56.170 ⇒ 00:36:05.339 Mustafa Raja: within this, we should be able to do that. Okay, so here we want to do… I think what we want to do is just write by month, and then make it…
388 00:36:05.340 ⇒ 00:36:13.130 Demilade Agboola: That makes sense an idea of what we’ll need to do, and just… Sends it to you.
389 00:36:16.880 ⇒ 00:36:19.120 Mustafa Raja: You know what, I… the… okay, let’s…
390 00:36:19.580 ⇒ 00:36:22.389 Mustafa Raja: Okay, so I should just paste it in SQL, right?
391 00:36:26.050 ⇒ 00:36:28.489 Demilade Agboola: I just sent you the SQL of what we kind of.
392 00:36:28.490 ⇒ 00:36:29.620 Mustafa Raja: Yeah, this one, right?
393 00:36:29.620 ⇒ 00:36:33.520 Demilade Agboola: Yeah, so we need to just refer to the appropriate view, though, like, change the.
394 00:36:33.520 ⇒ 00:36:35.060 Mustafa Raja: Oh, okay, okay.
395 00:36:38.780 ⇒ 00:36:43.239 Demilade Agboola: Cohorts, blah blah blah blah blah, like, I’m not sure. Cohorts retention, summary…
396 00:36:43.240 ⇒ 00:36:47.480 Mustafa Raja: It, this was… this is something else.
397 00:37:01.190 ⇒ 00:37:03.329 Mustafa Raja: Good revenue retention summary.
398 00:37:06.070 ⇒ 00:37:08.160 Mustafa Raja: Where’s from this, right? Okay.
399 00:37:11.000 ⇒ 00:37:16.940 Mustafa Raja: If I just… Grab it, like… This copy of your name.
400 00:37:19.890 ⇒ 00:37:21.199 Mustafa Raja: Hmm, right on it.
401 00:37:26.560 ⇒ 00:37:29.340 Mustafa Raja: Ban request.
402 00:37:29.550 ⇒ 00:37:30.960 Demilade Agboola: What was the… what’s the error?
403 00:37:34.640 ⇒ 00:37:35.980 Demilade Agboola: Oh, dataset.
404 00:37:36.920 ⇒ 00:37:43.500 Demilade Agboola: So I think it needs, like, prod… proddbt blah blah blah before the name. So proddbt dot, like…
405 00:37:44.990 ⇒ 00:37:48.269 Mustafa Raja: Hey, but I’m doing that, no? Prod dbt mods.
406 00:37:48.270 ⇒ 00:37:49.399 Demilade Agboola: It’s a dataset.com.
407 00:37:49.400 ⇒ 00:37:50.410 Mustafa Raja: Oh.
408 00:37:57.270 ⇒ 00:37:58.170 Mustafa Raja: Whoa.
409 00:38:01.540 ⇒ 00:38:07.410 Demilade Agboola: So, a couple of things. Just before we do this, this should be fine. Can we see the… can we see the…
410 00:38:08.420 ⇒ 00:38:10.990 Demilade Agboola: The mocks, blah blah blah, at the end.
411 00:38:12.510 ⇒ 00:38:13.540 Mustafa Raja: Oh, okay, okay.
412 00:38:15.450 ⇒ 00:38:16.330 Mustafa Raja: Got it.
413 00:38:16.680 ⇒ 00:38:17.410 Demilade Agboola: Yeah.
414 00:38:17.810 ⇒ 00:38:19.679 Demilade Agboola: Alright, so let’s see if…
415 00:38:23.970 ⇒ 00:38:25.030 Mustafa Raja: Oh, my God.
416 00:38:27.280 ⇒ 00:38:29.730 Mustafa Raja: I can just save it as query view if you want.
417 00:38:31.850 ⇒ 00:38:34.389 Demilade Agboola: Yeah, let’s try it, let’s see if I square UVM, let’s see.
418 00:38:35.500 ⇒ 00:38:36.720 Demilade Agboola: If that works.
419 00:38:37.170 ⇒ 00:38:38.960 Mustafa Raja: What do you want to name this view?
420 00:38:40.180 ⇒ 00:38:46.229 Demilade Agboola: Cohort Revenue Retention Summary V2, or something?
421 00:38:51.690 ⇒ 00:38:58.690 Mustafa Raja: Cohort revenue summary… Me too.
422 00:39:05.240 ⇒ 00:39:06.170 Mustafa Raja: 1…
423 00:39:14.690 ⇒ 00:39:16.050 Mustafa Raja: It’s saying this now.
424 00:39:17.910 ⇒ 00:39:20.670 Demilade Agboola: So in that case, I think you need to put…
425 00:39:25.990 ⇒ 00:39:27.910 Mustafa Raja: They have multiple datasets.
426 00:39:32.420 ⇒ 00:39:34.140 Demilade Agboola: Put the… your more circuit.
427 00:40:09.020 ⇒ 00:40:11.300 Demilade Agboola: Very pleasantly in with this, let’s see if it works.
428 00:40:16.470 ⇒ 00:40:22.900 Mustafa Raja: Okay… So, what am I replacing, though?
429 00:40:24.030 ⇒ 00:40:25.350 Demilade Agboola: The name, the full name.
430 00:40:25.350 ⇒ 00:40:26.719 Mustafa Raja: The name of the… okay.
431 00:40:27.450 ⇒ 00:40:28.870 Mustafa Raja: The name of the table, right?
432 00:40:29.830 ⇒ 00:40:30.450 Demilade Agboola: Yes.
433 00:40:30.780 ⇒ 00:40:32.429 Mustafa Raja: Discard team dies.
434 00:40:36.860 ⇒ 00:40:38.140 Mustafa Raja: Discarding this.
435 00:40:40.390 ⇒ 00:40:41.439 Mustafa Raja: What the heck?
436 00:40:43.310 ⇒ 00:40:44.930 Mustafa Raja: Anyways,
437 00:40:54.280 ⇒ 00:41:03.010 Mustafa Raja: Let’s run it… And then that’s it… retrievenue.
438 00:41:09.620 ⇒ 00:41:10.630 Mustafa Raja: Immediately.
439 00:41:14.600 ⇒ 00:41:16.750 Mustafa Raja: Oh, this looks… oh, this looks like it.
440 00:41:16.910 ⇒ 00:41:19.209 Mustafa Raja: Oh, this… oh, wow.
441 00:41:20.060 ⇒ 00:41:23.120 Mustafa Raja: Okay, so we use it in a query then, right? Now.
442 00:41:25.040 ⇒ 00:41:31.250 Demilade Agboola: Yes, let’s try and save it, so let’s use it in a membership query, but, like, yeah, let’s see if we can…
443 00:41:31.930 ⇒ 00:41:33.600 Demilade Agboola: Build it out, like…
444 00:41:34.190 ⇒ 00:41:36.740 Mustafa Raja: Okay, so we just select the month.
445 00:41:36.910 ⇒ 00:41:39.320 Mustafa Raja: Where is it? Where is it? This.
446 00:41:39.520 ⇒ 00:41:42.200 Mustafa Raja: We just select the month…
447 00:41:42.910 ⇒ 00:41:48.310 Mustafa Raja: Month from here, and then… this was the one that you added, right? Cohort size fixed.
448 00:41:48.600 ⇒ 00:41:50.410 Demilade Agboola: Do we need… yes, yes.
449 00:41:50.660 ⇒ 00:41:51.910 Mustafa Raja: Some over it, right?
450 00:41:53.420 ⇒ 00:41:55.850 Demilade Agboola: Sure, let’s try that, yeah, let’s sum over it.
451 00:42:01.790 ⇒ 00:42:07.080 Mustafa Raja: September 24, September… Yeah, it’s still the same.
452 00:42:07.080 ⇒ 00:42:08.399 Demilade Agboola: Yeah, okay.
453 00:42:15.480 ⇒ 00:42:16.660 Mustafa Raja: This is messy.
454 00:42:19.270 ⇒ 00:42:20.200 Demilade Agboola: Where’s the other one?
455 00:42:31.600 ⇒ 00:42:35.069 Demilade Agboola: Look at the… There’s clearly something we’re missing somewhere.
456 00:42:45.780 ⇒ 00:42:46.550 Demilade Agboola: Dammit.
457 00:42:58.380 ⇒ 00:43:00.999 Demilade Agboola: Hey, big tears need more light, yeah, yeah.
458 00:44:13.750 ⇒ 00:44:14.979 Demilade Agboola: Compliance here, okay.
459 00:44:16.090 ⇒ 00:44:25.919 Demilade Agboola: You know what? Can you create a sum of this table? Like, don’t do sum directly. Create a new column that is the sum of that cohort.
460 00:44:27.940 ⇒ 00:44:29.679 Demilade Agboola: Did you try… have you tried that?
461 00:44:30.530 ⇒ 00:44:31.500 Mustafa Raja: Nope.
462 00:44:31.500 ⇒ 00:44:32.889 Demilade Agboola: register soon.
463 00:44:36.700 ⇒ 00:44:42.759 Demilade Agboola: So let’s try and create a new, yeah, calculation… no. But this will make it spread out, right?
464 00:44:44.060 ⇒ 00:44:47.649 Mustafa Raja: Yeah, this will make… yeah, you’re right, this isn’t going to be granular, yeah.
465 00:44:47.650 ⇒ 00:44:48.220 Demilade Agboola: You know.
466 00:44:48.540 ⇒ 00:44:51.050 Demilade Agboola: So what I’m saying is, like, create a new column.
467 00:44:51.300 ⇒ 00:44:53.989 Demilade Agboola: Like, a new calculation column on the side.
468 00:44:55.050 ⇒ 00:44:57.810 Demilade Agboola: And let that column be called.
469 00:45:01.070 ⇒ 00:45:09.689 Demilade Agboola: So, you know, like, how you have columns at the bottom? Can you try and make a column, like, a calculated column that is the sum of cohort size fixed?
470 00:45:11.110 ⇒ 00:45:12.030 Mustafa Raja: This? No, no.
471 00:45:12.140 ⇒ 00:45:13.480 Demilade Agboola: No, not that way.
472 00:45:14.980 ⇒ 00:45:17.229 Demilade Agboola: like… How do I put it?
473 00:45:18.890 ⇒ 00:45:21.519 Demilade Agboola: Can you just create a… is there a way to create a new column?
474 00:45:21.810 ⇒ 00:45:24.560 Demilade Agboola: Just like… Can you calculate Sean?
475 00:45:27.150 ⇒ 00:45:28.439 Demilade Agboola: And they can knock it.
476 00:45:28.670 ⇒ 00:45:34.289 Demilade Agboola: Yeah, can y’all do some… of that, like, I don’t know how to explain… I’m just trying to…
477 00:45:36.080 ⇒ 00:45:37.780 Demilade Agboola: Is this the, like…
478 00:45:38.360 ⇒ 00:45:46.900 Demilade Agboola: Because I don’t want to do it the same way that didn’t work, and I’ve seen it, like, the way you created it, we’re trying to create a new field, and we’re trying to do max in it, like, can you do that same thing right now?
479 00:45:49.680 ⇒ 00:45:50.960 Mustafa Raja: It was just this.
480 00:45:51.000 ⇒ 00:46:01.530 Demilade Agboola: No, can I remember… can you go back to the previous dashboard that you were working with? Can you remember when you were trying to do this max, and you were like, oh, I’m going to… and you put open a new tab.
481 00:46:02.000 ⇒ 00:46:04.419 Demilade Agboola: And you are trying to put the formula in.
482 00:46:04.760 ⇒ 00:46:05.670 Mustafa Raja: Oh.
483 00:46:06.050 ⇒ 00:46:07.660 Demilade Agboola: Can you do that for this, please?
484 00:46:08.920 ⇒ 00:46:09.600 Mustafa Raja: Fifth.
485 00:46:09.800 ⇒ 00:46:10.529 Demilade Agboola: Yes, please.
486 00:46:12.060 ⇒ 00:46:18.120 Demilade Agboola: So can you now try and see if we can do Field labels, or, like, Copy it.
487 00:46:18.780 ⇒ 00:46:20.679 Mustafa Raja: Just a little.
488 00:46:20.680 ⇒ 00:46:26.429 Demilade Agboola: You just need, yeah, some of cohort size fixed marks or something. Some cohort size fixed marks.
489 00:46:43.840 ⇒ 00:46:44.690 Mustafa Raja: What?
490 00:46:50.180 ⇒ 00:46:54.489 Mustafa Raja: So, you want the… some of, some of this maxed, right?
491 00:46:54.830 ⇒ 00:46:57.379 Demilade Agboola: No, no, yes, some of the cord size fixed.
492 00:46:59.530 ⇒ 00:47:01.809 Mustafa Raja: Yeah, I don’t know why this isn’t…
493 00:47:02.260 ⇒ 00:47:07.499 Mustafa Raja: popping up. VU name would be… COVID revenue 300.
494 00:47:11.560 ⇒ 00:47:13.799 Mustafa Raja: I think what I need to do is this.
495 00:47:16.530 ⇒ 00:47:29.800 Mustafa Raja: Oh, horn… Let’s called revenue… Underscore Weasley dot… Cool.
496 00:47:34.980 ⇒ 00:47:36.780 Demilade Agboola: No, the one below, yes.
497 00:47:39.340 ⇒ 00:47:41.499 Demilade Agboola: No, we saw it, we’re not Maxim, we’re summit.
498 00:47:42.900 ⇒ 00:47:43.860 Mustafa Raja: Okay, sorry.
499 00:47:48.270 ⇒ 00:47:56.280 Demilade Agboola: And then, coming out, name this the name that it was before, which is… quarter size… sum, or something.
500 00:47:57.970 ⇒ 00:48:00.759 Mustafa Raja: Do you want to name this? Name it this? Fix MyCommit?
501 00:48:01.020 ⇒ 00:48:02.260 Mustafa Raja: No? Okay.
502 00:48:02.260 ⇒ 00:48:08.580 Demilade Agboola: So, technically, the core size fixed is fixed by cohorts. Now we’re doing cohort, because remember, it’s summing fixed by, like, the co…
503 00:48:08.840 ⇒ 00:48:12.309 Demilade Agboola: It’s summing the fixed cohort size, yeah, so let’s just do some, yeah.
504 00:48:13.530 ⇒ 00:48:16.720 Mustafa Raja: Sam is already taken, so I’m, naming it some.
505 00:48:17.000 ⇒ 00:48:19.550 Demilade Agboola: Okay, sounds good, let’s see if you can add it.
506 00:48:25.720 ⇒ 00:48:27.209 Demilade Agboola: Alright, can we remove…
507 00:48:28.340 ⇒ 00:48:29.660 Mustafa Raja: Yeah, it’s this one.
508 00:48:30.700 ⇒ 00:48:31.600 Mustafa Raja: Sounds…
509 00:48:32.480 ⇒ 00:48:35.240 Demilade Agboola: Still incredibly beehive. Jesus Christ.
510 00:48:36.590 ⇒ 00:48:37.430 Mustafa Raja: I’ll get…
511 00:48:38.670 ⇒ 00:48:43.749 Demilade Agboola: Alright, in that case, like, I don’t want to spend too much time on this, I don’t… let’s just do it, add the filter.
512 00:48:44.380 ⇒ 00:48:50.440 Demilade Agboola: Let’s use the formatting what we’re doing, but add the filter directly, like, the default filter, so that it always just makes it look the same.
513 00:48:50.980 ⇒ 00:48:54.409 Mustafa Raja: Yeah, but with that, the problem becomes… let me show you.
514 00:48:55.790 ⇒ 00:49:00.149 Mustafa Raja: Was it this one? Monthly retention… our product.
515 00:49:00.810 ⇒ 00:49:01.910 Mustafa Raja: This one.
516 00:49:03.500 ⇒ 00:49:08.640 Mustafa Raja: Okay, if I were to add this… Equal to 1.
517 00:49:10.350 ⇒ 00:49:12.589 Mustafa Raja: No, no, no, this one, it wasn’t this one.
518 00:49:13.180 ⇒ 00:49:14.060 Mustafa Raja: That’s funny.
519 00:49:14.250 ⇒ 00:49:15.290 Mustafa Raja: It’s this one.
520 00:49:18.400 ⇒ 00:49:19.130 Mustafa Raja: Okay.
521 00:49:29.280 ⇒ 00:49:42.949 Mustafa Raja: Okay, now if I add… 1 since first order filter, do one… This looks super good, but…
522 00:49:43.090 ⇒ 00:49:44.479 Mustafa Raja: All others are missed.
523 00:49:49.470 ⇒ 00:49:52.849 Mustafa Raja: Why is the old orders I missed? Yeah, so…
524 00:49:53.980 ⇒ 00:49:56.370 Mustafa Raja: So let’s take a look at the order sum.
525 00:50:00.230 ⇒ 00:50:02.999 Demilade Agboola: So the question is, are you using the same formulas? That’s, like, let’s go back.
526 00:50:03.000 ⇒ 00:50:05.749 Mustafa Raja: Yeah, if.
527 00:50:08.350 ⇒ 00:50:09.359 Demilade Agboola: Because it’s some…
528 00:50:10.340 ⇒ 00:50:19.749 Mustafa Raja: Yeah, it’s the same thing then, no? So for the formula of this cumulative orders, it’s exactly the same it was for cohort size.
529 00:50:26.580 ⇒ 00:50:27.900 Mustafa Raja: Do you get my point?
530 00:50:28.400 ⇒ 00:50:30.240 Demilade Agboola: Yeah, I’m trying to look at it myself, honestly.
531 00:50:30.240 ⇒ 00:50:31.029 Mustafa Raja: I’ll click it.
532 00:50:34.800 ⇒ 00:50:36.570 Mustafa Raja: Sorry for putting it into this!
533 00:50:52.300 ⇒ 00:50:53.630 Demilade Agboola: Okay, so can we go back?
534 00:50:54.890 ⇒ 00:50:55.920 Mustafa Raja: Yes.
535 00:50:57.420 ⇒ 00:50:59.610 Demilade Agboola: And then can I see the connative Order song?
536 00:51:00.240 ⇒ 00:51:01.069 Demilade Agboola: A lot, please.
537 00:51:02.770 ⇒ 00:51:04.130 Mustafa Raja: Is this an aggregate?
538 00:51:10.060 ⇒ 00:51:12.530 Mustafa Raja: And Kesha says that this is the way to do it.
539 00:51:13.390 ⇒ 00:51:19.630 Mustafa Raja: even after looking at the formula, because of how, I think, Omni aggregates things.
540 00:51:21.060 ⇒ 00:51:22.749 Demilade Agboola: Do you want to read the chat?
541 00:51:24.090 ⇒ 00:51:25.790 Demilade Agboola: Yeah, sure, let’s see, let’s see.
542 00:51:39.850 ⇒ 00:51:44.069 Mustafa Raja: So this, this sort of query just doesn’t work in Omni, you know?
543 00:51:46.100 ⇒ 00:51:51.970 Mustafa Raja: So, Ukasta suggested this should be put in the dbt model itself.
544 00:51:54.250 ⇒ 00:51:56.020 Demilade Agboola: Yeah, I think that’s what we need to do.
545 00:51:57.980 ⇒ 00:52:01.869 Mustafa Raja: And then it says, this is the correct definition for what you want.
546 00:52:03.130 ⇒ 00:52:04.230 Mustafa Raja: ain’ on me.
547 00:52:04.760 ⇒ 00:52:06.320 Mustafa Raja: No window function.
548 00:52:09.140 ⇒ 00:52:12.079 Mustafa Raja: Because the above one just failed.
549 00:52:14.830 ⇒ 00:52:20.970 Demilade Agboola: And the problem with using just marks alone is that you can’t then find… if you… if you use the filter by products, it will start to break.
550 00:52:22.060 ⇒ 00:52:41.489 Mustafa Raja: Yeah, so you see, it suggested me to, you know, add this as a field, you know? Like how we were creating fields using SQL. It suggested me add this SQL. Now, I couldn’t. I got an error, right? And then…
551 00:52:42.080 ⇒ 00:52:44.400 Mustafa Raja: Then it said, okay, just use this.
552 00:52:46.730 ⇒ 00:52:54.319 Mustafa Raja: And then I told it, you know, the values aren’t coming out to be the same. And then it gave me this root cause.
553 00:52:58.100 ⇒ 00:52:59.520 Mustafa Raja: And then it set.
554 00:52:59.800 ⇒ 00:53:03.299 Mustafa Raja: put it in dbt, if you want to fix it.
555 00:53:05.250 ⇒ 00:53:07.450 Demilade Agboola: Yeah, potentially, that’s what we need to do.
556 00:53:08.650 ⇒ 00:53:11.560 Mustafa Raja: Or we could add first-order product.
557 00:53:13.740 ⇒ 00:53:14.850 Mustafa Raja: It says…
558 00:53:19.630 ⇒ 00:53:22.700 Mustafa Raja: In the query, but that’s just going to be more granular.
559 00:53:23.180 ⇒ 00:53:26.760 Mustafa Raja: Well, I don’t know, but this isn’t our, purpose already.
560 00:53:29.520 ⇒ 00:53:32.300 Mustafa Raja: And then it just… I asked it about this time.
561 00:53:32.300 ⇒ 00:53:36.819 Demilade Agboola: The problem with adding first-order products is that if you add first-order product, it will spread out too much.
562 00:53:36.820 ⇒ 00:53:42.370 Mustafa Raja: Yeah, it’s just going to be more granular, which we don’t want, right? So this, this makes sense.
563 00:53:44.370 ⇒ 00:53:50.759 Mustafa Raja: And then it just said, okay, try, try putting, putting it 1, you know?
564 00:53:52.590 ⇒ 00:54:03.560 Mustafa Raja: And then when I did this one column got fixed, and then the others got messed up, but they were already messed up, they were incorrect either way, so…
565 00:54:04.420 ⇒ 00:54:05.500 Demilade Agboola: Fair enough.
566 00:54:07.980 ⇒ 00:54:09.919 Demilade Agboola: Everything looks off, to be honest.
567 00:54:13.440 ⇒ 00:54:21.210 Demilade Agboola: Alright, so I think for this, I need to do a… I need to make a model fix for you, so you can kind of try and do it in…
568 00:54:21.880 ⇒ 00:54:25.820 Mustafa Raja: Yeah, I think for this also, it’s pretty much a similar problem.
569 00:54:26.140 ⇒ 00:54:27.039 Demilade Agboola: Which one is that?
570 00:54:27.370 ⇒ 00:54:30.640 Mustafa Raja: This last thing…
571 00:54:32.290 ⇒ 00:54:36.970 Demilade Agboola: Just send the models to me and the columns you need, like, and I can try and make the right model.
572 00:54:38.300 ⇒ 00:54:43.639 Mustafa Raja: So… Here, the offer ones are good.
573 00:54:45.820 ⇒ 00:54:51.420 Mustafa Raja: Yeah, so, this thing customers is just cohort size. Let me just add a cohort size.
574 00:54:51.590 ⇒ 00:54:57.729 Demilade Agboola: Can you just make a list of the columns that you need and the models that you need me to do, like, the max value that you need to sum?
575 00:55:00.350 ⇒ 00:55:12.719 Mustafa Raja: I think this one might be a little different than the other one, because, here, this portion is good, but this isn’t good. So, I need someone to investigate with me also.
576 00:55:13.260 ⇒ 00:55:14.910 Demilade Agboola: Okay, can we look at it?
577 00:55:16.600 ⇒ 00:55:17.869 Mustafa Raja: So this one is good.
578 00:55:18.000 ⇒ 00:55:19.560 Mustafa Raja: But this one is not good.
579 00:55:25.910 ⇒ 00:55:26.495 Demilade Agboola: So…
580 00:55:27.080 ⇒ 00:55:31.820 Mustafa Raja: Let’s see what’s not good. So… February…
581 00:55:32.230 ⇒ 00:55:37.569 Mustafa Raja: H95, 120… 1277, H95, 1277, 1460.
582 00:55:38.360 ⇒ 00:55:43.210 Mustafa Raja: 175… Yeah, so nothing just makes sense here.
583 00:55:47.340 ⇒ 00:55:49.919 Mustafa Raja: I think this filter might be the issue, to be honest.
584 00:55:49.920 ⇒ 00:55:52.279 Demilade Agboola: Are you sure the offer is also good, too?
585 00:55:53.510 ⇒ 00:55:54.500 Mustafa Raja: Yeah, is it not?
586 00:55:55.110 ⇒ 00:55:56.380 Mustafa Raja: Oh, it’s between now…
587 00:55:56.380 ⇒ 00:55:57.770 Demilade Agboola: Now, some of the numbers look off.
588 00:56:01.650 ⇒ 00:56:05.720 Demilade Agboola: Call size is good, though, but some of the, like, revenue and revenue per customer numbers look off.
589 00:56:18.530 ⇒ 00:56:19.340 Mustafa Raja: Me.
590 00:56:19.860 ⇒ 00:56:26.880 Mustafa Raja: Oh, fu… Yeah, so it was just a filter, you know.
591 00:56:27.380 ⇒ 00:56:30.540 Demilade Agboola: Okay, you had the filter on there, sorry.
592 00:56:30.840 ⇒ 00:56:31.610 Demilade Agboola: Looked a bit off.
593 00:56:31.870 ⇒ 00:56:33.439 Demilade Agboola: Alright.
594 00:56:33.480 ⇒ 00:56:36.910 Mustafa Raja: 771, okay.
595 00:56:39.740 ⇒ 00:56:49.170 Mustafa Raja: Yeah, so for this, I think this could just be my, my… Filter, let me show you… Great.
596 00:56:50.470 ⇒ 00:56:52.029 Mustafa Raja: I find it in chewing.
597 00:56:53.660 ⇒ 00:56:54.330 Mustafa Raja: Hmm…
598 00:56:55.000 ⇒ 00:56:56.660 Demilade Agboola: How do you define other here?
599 00:56:57.090 ⇒ 00:57:00.839 Mustafa Raja: Yeah, it’s just… oh, let me answer this for you here.
600 00:57:02.950 ⇒ 00:57:04.030 Mustafa Raja: This…
601 00:57:08.200 ⇒ 00:57:11.009 Demilade Agboola: Is that what is done? Let me give you… let me check.
602 00:57:11.880 ⇒ 00:57:15.219 Mustafa Raja: Yeah, oh, yeah, please check.
603 00:57:23.840 ⇒ 00:57:24.860 Demilade Agboola: I want to…
604 00:57:30.880 ⇒ 00:57:32.090 Mustafa Raja: What time is it there?
605 00:57:33.780 ⇒ 00:57:36.480 Demilade Agboola: It’s not that late, it’s 10.30, I’m just tired.
606 00:57:37.220 ⇒ 00:57:38.170 Mustafa Raja: Yeah.
607 00:57:50.360 ⇒ 00:57:53.330 Demilade Agboola: So it’s not all others that are…
608 00:57:53.640 ⇒ 00:57:57.020 Demilade Agboola: necessarily that, like, okay, give me one second. There’s a list.
609 00:58:00.520 ⇒ 00:58:03.729 Demilade Agboola: I don’t like when we use Tableau for some of these things.
610 00:58:04.600 ⇒ 00:58:07.649 Demilade Agboola: like, some of these logic things. It’s hard to keep track
611 00:58:08.000 ⇒ 00:58:10.419 Demilade Agboola: And the best things of it, that’s why we use dbt.
612 00:58:10.830 ⇒ 00:58:14.160 Demilade Agboola: So if I put the channels in dbt, it would consist of.
613 00:58:14.160 ⇒ 00:58:17.809 Mustafa Raja: Oh, yeah, that’s just going to make everyone’s life easier, no?
614 00:58:21.410 ⇒ 00:58:23.829 Demilade Agboola: Alright, so I found a list of channels.
615 00:58:24.140 ⇒ 00:58:27.790 Demilade Agboola: Once I can’t… copying it, it’s not letting me copy fucking hell.
616 00:58:31.670 ⇒ 00:58:37.929 Demilade Agboola: But there is a list. I think that’s the problem. I think that’s why you’re probably of accounting, because you’re including things that are not…
617 00:58:39.330 ⇒ 00:58:41.149 Demilade Agboola: Potentially in the list as well.
618 00:58:41.440 ⇒ 00:58:47.490 Mustafa Raja: I’m over-counting, or am I undercounting? I think I’m… Undercounting…
619 00:58:48.530 ⇒ 00:58:50.190 Demilade Agboola: Was that the 25th?
620 00:58:50.190 ⇒ 00:58:53.489 Mustafa Raja: Revenue is $12.77, right?
621 00:58:53.590 ⇒ 00:58:59.049 Mustafa Raja: February 18, yeah, it says 70… 715.
622 00:58:59.510 ⇒ 00:59:00.770 Demilade Agboola: Interesting, so you are…
623 00:59:00.770 ⇒ 00:59:02.000 Mustafa Raja: Primal choice.
624 00:59:03.680 ⇒ 00:59:08.079 Mustafa Raja: 500,000, sorry, not 5 million, 500,000 short.
625 00:59:08.390 ⇒ 00:59:12.040 Demilade Agboola: Okay, yeah, so there is an accounting going on, let me see.
626 00:59:16.520 ⇒ 00:59:17.990 Mustafa Raja: Injectable sinner.
627 00:59:19.390 ⇒ 00:59:25.700 Mustafa Raja: Also, these filters, if I… even if I were to filter… let me filter this to something else and see…
628 00:59:27.160 ⇒ 00:59:30.960 Mustafa Raja: Let me filter this to… This one… okay, this is changing.
629 00:59:30.960 ⇒ 00:59:33.020 Demilade Agboola: Sir, can you go back to the formula?
630 00:59:33.270 ⇒ 00:59:36.439 Demilade Agboola: I’m just trying to look at it again. I think when you have all the…
631 00:59:36.570 ⇒ 00:59:38.179 Mustafa Raja: Oh, yeah, hip.
632 00:59:38.330 ⇒ 00:59:43.240 Demilade Agboola: Yeah, offer… One second…
633 01:00:01.710 ⇒ 01:00:03.300 Demilade Agboola: What are clauses?
634 01:00:44.540 ⇒ 01:00:45.920 Demilade Agboola: Where are you feeling?
635 01:00:46.040 ⇒ 01:00:47.060 Demilade Agboola: Congratulations.
636 01:00:52.600 ⇒ 01:00:53.860 Demilade Agboola: Are you fasting?
637 01:00:54.780 ⇒ 01:00:55.620 Mustafa Raja: Yep.
638 01:00:56.670 ⇒ 01:00:57.980 Demilade Agboola: Nice, how’s that come along?
639 01:00:58.850 ⇒ 01:01:09.150 Mustafa Raja: Oh, this, these have been pretty chill, because, when I, when I started it, I, Ramadan used to come in summers, right? And in summers.
640 01:01:09.150 ⇒ 01:01:10.960 Demilade Agboola: Isn’t it a great story?
641 01:01:10.960 ⇒ 01:01:15.549 Mustafa Raja: Long days and hot weather, but it comes in winter now.
642 01:01:15.700 ⇒ 01:01:19.890 Mustafa Raja: And probably in 20 or so years, it’s going to go into somewhere again.
643 01:01:20.730 ⇒ 01:01:21.600 Demilade Agboola: Yeah.
644 01:01:21.950 ⇒ 01:01:34.390 Mustafa Raja: Yeah, it changes, because it’s based on lunar calendar, right? So, lunar calendar is just, 10 days. There’s a difference between lunar calendar and the calendar that we follow, 10 days difference between those.
645 01:01:35.390 ⇒ 01:01:38.859 Demilade Agboola: Fair enough, fair enough. Like, my closest friend is Muslim, so…
646 01:01:39.130 ⇒ 01:01:39.830 Mustafa Raja: Yeah.
647 01:01:39.830 ⇒ 01:01:41.490 Demilade Agboola: I’m fairly…
648 01:01:41.490 ⇒ 01:01:47.680 Mustafa Raja: I have a, I have added a block on my calendar for my dawn meal.
649 01:01:47.930 ⇒ 01:01:51.750 Mustafa Raja: Utem and I used to, wipe code in that time.
650 01:01:51.830 ⇒ 01:01:57.819 Demilade Agboola: But now I need that time. Yeah, you definitely need to eat before the day starts. If not, it will be tough.
651 01:01:58.610 ⇒ 01:01:59.650 Mustafa Raja: Yeah.
652 01:02:00.330 ⇒ 01:02:04.899 Demilade Agboola: I have a friend, my friend, like, the times he would maybe oversleep, and, like, miss…
653 01:02:04.900 ⇒ 01:02:09.779 Mustafa Raja: Oh… So, is he, like, living with you or something?
654 01:02:10.080 ⇒ 01:02:15.490 Demilade Agboola: Oh, no, no, like, I mean, we’ve been friends since we’re, like, 10 years old, so we go way, way back. So, like…
655 01:02:15.490 ⇒ 01:02:16.240 Mustafa Raja: Okay, okay, okay.
656 01:02:16.240 ⇒ 01:02:23.830 Demilade Agboola: I know there are times that he would, like, maybe sleep, he’ll just text me one, like, day, or call me, and just be like, I miss, like, Sahara, and, like, I’ll start laughing, because I know.
657 01:02:23.830 ⇒ 01:02:40.129 Mustafa Raja: Yeah, I can get it, I can get it. I had friends in university that were staying over in the hostel, and they sometimes would oversleep, too. But I live with my family, right? So, they just wake me up no matter what.
658 01:02:41.870 ⇒ 01:02:44.489 Demilade Agboola: Yeah, that definitely helps, that definitely helps.
659 01:02:48.200 ⇒ 01:02:53.779 Demilade Agboola: Okay, so I can see the list, so this is the list, by the way, in case you wanted to know…
660 01:02:54.180 ⇒ 01:02:55.320 Mustafa Raja: Yeah.
661 01:02:55.460 ⇒ 01:03:01.580 Mustafa Raja: How… Yeah, I’m just wondering if I… if I’m undercounting, there might be some other issue also going on.
662 01:03:01.580 ⇒ 01:03:06.170 Demilade Agboola: Yeah, I understand that, like, it’s definitely not that, but I’m trying to see, at least let’s get that to match.
663 01:03:06.780 ⇒ 01:03:12.570 Demilade Agboola: And then… Let’s see, so if the co-op size revenue and revenue per customer are all lower.
664 01:03:12.900 ⇒ 01:03:17.260 Demilade Agboola: Therefore, we’re not looking at that, and maybe…
665 01:03:17.710 ⇒ 01:03:20.470 Demilade Agboola: It is a function of the…
666 01:03:30.310 ⇒ 01:03:38.849 Mustafa Raja: We could, we could take a look at this, or investigate this further more later, because I have a lot… a lot more for you.
667 01:03:39.620 ⇒ 01:03:42.730 Demilade Agboola: Okay, what do you have? Well, let’s, let’s go into it, let’s do it.
668 01:03:43.460 ⇒ 01:03:44.520 Mustafa Raja: Okay…
669 01:03:49.420 ⇒ 01:03:53.809 Mustafa Raja: I want to close this, so I’m just going to start a new tab.
670 01:03:55.990 ⇒ 01:04:00.520 Mustafa Raja: Actually, not this one. Let’s… let’s go back here.
671 01:04:00.890 ⇒ 01:04:01.910 Mustafa Raja: Take the chief.
672 01:04:03.530 ⇒ 01:04:09.349 Mustafa Raja: Let’s come here also… And let’s start from this.
673 01:04:10.650 ⇒ 01:04:11.730 Mustafa Raja: Okay.
674 01:04:12.440 ⇒ 01:04:14.850 Mustafa Raja: You’d see this looks pretty good, right?
675 01:04:16.490 ⇒ 01:04:20.370 Mustafa Raja: So the values… pretty much match.
676 01:04:20.960 ⇒ 01:04:23.149 Demilade Agboola: Are we using the same decimal points.
677 01:04:23.340 ⇒ 01:04:27.439 Mustafa Raja: No, no, no, we’re not… and this isn’t going to be about decimals.
678 01:04:27.440 ⇒ 01:04:29.100 Demilade Agboola: No, I understand that, but I’m just saying, like.
679 01:04:29.100 ⇒ 01:04:30.749 Mustafa Raja: Oh, no, yeah, we’re not…
680 01:04:30.750 ⇒ 01:04:34.380 Demilade Agboola: It’s a small fix, but, like, just, like, as much as possible, let’s try and keep it.
681 01:04:34.380 ⇒ 01:04:36.139 Mustafa Raja: Okay, let me, let me do it right now, then.
682 01:04:36.140 ⇒ 01:04:39.489 Demilade Agboola: No, it’s fine, it’s just… I’m just letting you know that, like, so it doesn’t…
683 01:04:40.410 ⇒ 01:04:43.440 Mustafa Raja: Oh, okay, yeah. Let me go back.
684 01:04:43.860 ⇒ 01:04:50.099 Demilade Agboola: It’s fine, like, it’s a small fix. As long as numbers are in the same range, I don’t really care. As long as it’s just, like, something to note.
685 01:04:50.530 ⇒ 01:04:58.310 Mustafa Raja: Yeah, yeah, yeah. I’ll make sure that, the format is aligned. Okay. Now, the issue is in…
686 01:05:00.370 ⇒ 01:05:02.550 Mustafa Raja: When we go to the last value.
687 01:05:03.230 ⇒ 01:05:08.030 Mustafa Raja: For each of these rows, they are just slightly overestimated.
688 01:05:10.040 ⇒ 01:05:13.420 Demilade Agboola: So it’s 51.0… I think that was 51.7?
689 01:05:13.680 ⇒ 01:05:19.089 Mustafa Raja: No, no, no, so, for example, so there’s 54.7, right? And then here it’s 51.
690 01:05:19.340 ⇒ 01:05:23.349 Mustafa Raja: But then this is all good, and this whole column is all good.
691 01:05:23.700 ⇒ 01:05:26.880 Mustafa Raja: Similar for this, this is 41.5, right? So…
692 01:05:27.020 ⇒ 01:05:31.100 Mustafa Raja: 42 point something, and then this whole colon would be good.
693 01:05:32.820 ⇒ 01:05:36.150 Demilade Agboola: 30 point something, and this is 29.7.
694 01:05:37.230 ⇒ 01:05:40.390 Demilade Agboola: That’s 25.0 can go back, and 15.0.
695 01:05:40.960 ⇒ 01:05:45.600 Demilade Agboola: 25.59… 15.0 says 15.45.
696 01:05:46.370 ⇒ 01:05:48.440 Demilade Agboola: Okay, so it’s just slightly over.
697 01:05:48.440 ⇒ 01:05:51.160 Mustafa Raja: Yeah, just slightly.
698 01:05:52.600 ⇒ 01:05:55.160 Mustafa Raja: And this is the case for all of them.
699 01:05:55.360 ⇒ 01:05:56.749 Mustafa Raja: All of the heat maps.
700 01:05:57.730 ⇒ 01:06:00.730 Demilade Agboola: So basically, the last month, is off.
701 01:06:01.900 ⇒ 01:06:04.960 Mustafa Raja: Yeah, for everyone, yeah.
702 01:06:16.030 ⇒ 01:06:17.880 Demilade Agboola: Can I look at your formulas for this piece?
703 01:06:20.050 ⇒ 01:06:21.150 Mustafa Raja: The formula doesn’t…
704 01:06:21.150 ⇒ 01:06:24.330 Demilade Agboola: Are the coat sizes the same, please? Let’s look at it.
705 01:06:24.690 ⇒ 01:06:27.660 Demilade Agboola: So, for instance, January 2026, the quarter is the same.
706 01:06:28.290 ⇒ 01:06:30.939 Demilade Agboola: The 2004-28… is it the same?
707 01:06:30.940 ⇒ 01:06:34.620 Mustafa Raja: Let me see. Go ahead.
708 01:06:36.110 ⇒ 01:06:42.170 Mustafa Raja: 2390, 2390, and then 20, 14…
709 01:06:42.170 ⇒ 01:06:43.020 Demilade Agboola: Slightly different.
710 01:06:43.910 ⇒ 01:06:44.670 Mustafa Raja: This one.
711 01:06:44.840 ⇒ 01:06:46.040 Demilade Agboola: Yeah, slightly different.
712 01:06:49.410 ⇒ 01:06:52.149 Mustafa Raja: 3428.
713 01:06:52.420 ⇒ 01:06:52.990 Demilade Agboola: Yeah.
714 01:06:53.170 ⇒ 01:06:55.290 Mustafa Raja: There’s 3… 3 numbers only, though.
715 01:06:55.890 ⇒ 01:06:59.980 Demilade Agboola: Yeah, no, I’m just saying, it’s slightly different, so… it’s something to note, like…
716 01:07:01.040 ⇒ 01:07:05.159 Demilade Agboola: That’s why I say it’s like, you say it’s like, all the others seem too much, it’s just the last one seems to be slightly different.
717 01:07:06.600 ⇒ 01:07:09.100 Demilade Agboola: Alright, so let’s go into the… He was…
718 01:07:11.110 ⇒ 01:07:15.989 Mustafa Raja: This is just selecting the, you know, rows, and there’s no particular formula going on.
719 01:07:16.670 ⇒ 01:07:18.919 Demilade Agboola: Okay, so let me hop into the…
720 01:07:23.130 ⇒ 01:07:25.360 Mustafa Raja: And this is just repurchase rate.
721 01:07:25.490 ⇒ 01:07:28.100 Mustafa Raja: Yeah, that’s in pivot.
722 01:07:36.420 ⇒ 01:07:37.970 Mustafa Raja: What does your friend do?
723 01:07:39.950 ⇒ 01:07:42.410 Demilade Agboola: Which of my friends is my… my Muslim friend?
724 01:07:42.410 ⇒ 01:07:43.300 Mustafa Raja: Yeah, yeah.
725 01:07:43.680 ⇒ 01:07:46.709 Demilade Agboola: So right now, he’s a scrum master.
726 01:07:48.020 ⇒ 01:07:49.140 Mustafa Raja: Witchmaster?
727 01:07:49.300 ⇒ 01:07:50.280 Demilade Agboola: a scrum master.
728 01:07:50.280 ⇒ 01:07:51.959 Mustafa Raja: Oh, Scrum Master, okay, great.
729 01:07:53.190 ⇒ 01:07:55.100 Demilade Agboola: He’s in the UK, so…
730 01:07:55.100 ⇒ 01:08:00.600 Mustafa Raja: Oh, you, you’ve actually got a UK accent. Were you brought up there?
731 01:08:01.440 ⇒ 01:08:03.290 Demilade Agboola: No, it was not brought up in the UK.
732 01:08:03.430 ⇒ 01:08:07.060 Demilade Agboola: I was brought up in Nigeria. I lived in Nigeria up until 3 years ago.
733 01:08:07.560 ⇒ 01:08:14.599 Mustafa Raja: Oh, so how do you have this? I think… because I have a lot of cousins in UK, and you and they have…
734 01:08:15.040 ⇒ 01:08:17.310 Mustafa Raja: Almost the same accent.
735 01:08:17.700 ⇒ 01:08:19.839 Demilade Agboola: I promise you, I don’t have a UK accent, I just have.
736 01:08:19.840 ⇒ 01:08:21.629 Mustafa Raja: I didn’t have a UK accent.
737 01:08:22.069 ⇒ 01:08:24.689 Demilade Agboola: I promise I don’t have a… I…
738 01:08:25.039 ⇒ 01:08:32.579 Demilade Agboola: So, like, Nigeria’s, like, official language is English, and my parents, like, my mom in particular, was very, like.
739 01:08:33.019 ⇒ 01:08:34.849 Demilade Agboola: particular about my English.
740 01:08:35.249 ⇒ 01:08:46.689 Demilade Agboola: So when I was younger, she would just give me, like, newspapers to read, correct my pronunciation, she tells me, like, the alphabet, but phonetically. So, like, phonetically.
741 01:08:46.939 ⇒ 01:08:51.689 Demilade Agboola: So I was… she was very particular about my English, so that’s kind of why I talk the way I talk.
742 01:08:53.520 ⇒ 01:08:54.090 Demilade Agboola: But…
743 01:08:54.380 ⇒ 01:08:56.739 Mustafa Raja: I thought you were just brought up in the UK.
744 01:08:57.840 ⇒ 01:09:00.719 Demilade Agboola: First time I was in the UK, it was 2023 or 2024.
745 01:09:01.399 ⇒ 01:09:03.309 Demilade Agboola: That’s right there, yeah.
746 01:09:03.310 ⇒ 01:09:06.510 Mustafa Raja: Yeah, the locals must be thinking that you’re local.
747 01:09:06.840 ⇒ 01:09:14.289 Demilade Agboola: No, not really. That’s what I’m trying to say, like, if a proper British person talks to me, like, they know I’m not from… no, I’m not from…
748 01:09:14.500 ⇒ 01:09:19.399 Mustafa Raja: Okay, okay, okay. I just thought that you were from there, sorry.
749 01:09:20.260 ⇒ 01:09:22.829 Demilade Agboola: Mmm, that’s not so good. Let me see.
750 01:09:24.770 ⇒ 01:09:27.710 Mustafa Raja: Yeah, so this is actually coming directly from the table now.
751 01:09:28.580 ⇒ 01:09:31.549 Demilade Agboola: Okay, let me do some quick calculation.
752 01:09:31.870 ⇒ 01:09:32.750 Mustafa Raja: Okay, okay.
753 01:09:39.760 ⇒ 01:09:43.679 Mustafa Raja: I’m just wondering if there’s some filter that I’m missing.
754 01:09:43.689 ⇒ 01:09:44.409 Demilade Agboola: Wonderful.
755 01:09:44.599 ⇒ 01:09:46.759 Demilade Agboola: Cause I was looking at the… sorry.
756 01:09:49.200 ⇒ 01:09:52.140 Mustafa Raja: Oh, there’s one filter missing. One sense first order.
757 01:09:52.740 ⇒ 01:09:55.370 Mustafa Raja: Month since first order.
758 01:09:57.190 ⇒ 01:09:59.790 Mustafa Raja: Okay. Max month since first month.
759 01:10:04.780 ⇒ 01:10:07.750 Mustafa Raja: And who… Max wants infest one.
760 01:10:12.130 ⇒ 01:10:14.880 Mustafa Raja: How do you see definitions of a filter?
761 01:10:16.390 ⇒ 01:10:17.670 Demilade Agboola: in Tableau?
762 01:10:17.670 ⇒ 01:10:18.680 Mustafa Raja: Yeah, yeah.
763 01:10:20.450 ⇒ 01:10:24.010 Demilade Agboola: It depends on what you want to see. You just click…
764 01:10:24.220 ⇒ 01:10:30.600 Demilade Agboola: No, so, like, go to the, like, I don’t know how to explain it. So, hover over the filter.
765 01:10:31.970 ⇒ 01:10:34.239 Demilade Agboola: On the right, no, not that one, on the right.
766 01:10:34.470 ⇒ 01:10:35.460 Demilade Agboola: On the right.
767 01:10:35.570 ⇒ 01:10:38.100 Demilade Agboola: like, on the right. You’re going to the left.
768 01:10:38.230 ⇒ 01:10:41.580 Demilade Agboola: On the right of it, can you see it? Yes, stop, yes, click on it.
769 01:10:42.710 ⇒ 01:10:51.740 Demilade Agboola: So it depends on what you want to see. So you can see what it’s trying to do, and then if you want, you can try and edit the filter, so that also gives you more idea of what is going on underneath.
770 01:10:52.830 ⇒ 01:10:53.690 Mustafa Raja: That’s okay.
771 01:10:55.140 ⇒ 01:10:58.109 Mustafa Raja: Embarrassed 18 months. Okay, this looks good.
772 01:11:07.680 ⇒ 01:11:14.530 Demilade Agboola: So, can you go back to the… The Omni dashboard, please.
773 01:11:15.880 ⇒ 01:11:16.999 Demilade Agboola: Let’s do something.
774 01:11:17.160 ⇒ 01:11:18.560 Demilade Agboola: Give me one second…
775 01:11:27.450 ⇒ 01:11:28.400 Demilade Agboola: Interesting.
776 01:11:30.580 ⇒ 01:11:32.550 Demilade Agboola: Okay,
777 01:11:37.080 ⇒ 01:11:37.959 Demilade Agboola: Fink’s going down.
778 01:12:08.020 ⇒ 01:12:10.520 Demilade Agboola: You can do what you’re doing, I’m just trying to clean our own stuff now.
779 01:12:12.550 ⇒ 01:12:13.430 Mustafa Raja: Sorry?
780 01:12:13.430 ⇒ 01:12:14.970 Demilade Agboola: I said, you can do what you’re doing, I’m playing around.
781 01:12:14.970 ⇒ 01:12:16.559 Mustafa Raja: Okay, okay, good.
782 01:12:16.730 ⇒ 01:12:20.020 Mustafa Raja: Yeah, I was just… I was just thinking, maybe I’m missing a filter or something?
783 01:12:21.450 ⇒ 01:12:22.650 Demilade Agboola: Yeah…
784 01:12:23.650 ⇒ 01:12:27.000 Mustafa Raja: Oh yeah, there’s not… I’m not missing a filter.
785 01:12:30.440 ⇒ 01:12:31.370 Demilade Agboola: Let’s see…
786 01:12:32.040 ⇒ 01:12:36.520 Mustafa Raja: What’s your favorite part about data engineering?
787 01:12:38.850 ⇒ 01:12:40.449 Demilade Agboola: When I solve a problem.
788 01:12:40.760 ⇒ 01:12:43.689 Mustafa Raja: Oh, yeah, the adrenaline is nice.
789 01:12:46.340 ⇒ 01:12:52.690 Demilade Agboola: Yeah, I mean, there was a time when I used to work in a fintech, Nowadays, when,
790 01:12:53.670 ⇒ 01:12:56.210 Demilade Agboola: They’ll just be like, oh, we just…
791 01:12:56.590 ⇒ 01:13:00.049 Demilade Agboola: Because fraud is a huge problem with, like, financial services.
792 01:13:00.740 ⇒ 01:13:19.909 Demilade Agboola: We just had a lot of money, like, just lost a lot of money, we need to figure out which accounts did it, like, we need to find out their bank details and, like, send details to, like, the bank so they can freeze their external accounts, blah blah blah blah blah. I used to love it, I used to love that experience of… it felt like being a detective and trying to figure out the money trail.
793 01:13:20.150 ⇒ 01:13:21.040 Mustafa Raja: Yeah.
794 01:13:21.330 ⇒ 01:13:25.520 Demilade Agboola: Trying to figure out, like, when they usually happen at nights, when they did it.
795 01:13:26.590 ⇒ 01:13:41.919 Demilade Agboola: like, trying to just, like, it was just, it was just nice to see, like, the trail, how many transactions happened, suspected, like, people who were, you know, lying, maybe they sent themselves money, so, like, you need to find all accounts that got the money.
796 01:13:42.020 ⇒ 01:13:49.650 Demilade Agboola: And then all accounts, our money was sent to… like, just trying, like, it was just… I really liked it. It was just… it felt like working as a detective.
797 01:13:49.970 ⇒ 01:13:51.850 Mustafa Raja: Yeah, yeah.
798 01:13:52.030 ⇒ 01:13:57.580 Demilade Agboola: But yeah, it’s… I was like, at this point, how many years ago was that?
799 01:13:58.060 ⇒ 01:14:01.020 Demilade Agboola: Maybe… Five years ago?
800 01:14:01.770 ⇒ 01:14:02.320 Mustafa Raja: Oh.
801 01:14:02.320 ⇒ 01:14:04.020 Demilade Agboola: Maybe 5, 6 hours ago.
802 01:14:06.500 ⇒ 01:14:08.049 Mustafa Raja: This is actually my first job.
803 01:14:08.750 ⇒ 01:14:09.529 Demilade Agboola: Oh, really?
804 01:14:09.680 ⇒ 01:14:10.300 Mustafa Raja: Yeah.
805 01:14:11.200 ⇒ 01:14:18.900 Demilade Agboola: I mean, you’re doing a great job, I couldn’t… I definitely could not tell that. You know, sometimes you hear where people are like, yeah, this is… this is definitely your first job.
806 01:14:20.170 ⇒ 01:14:25.110 Demilade Agboola: This is definitely… this is definitely your first job, so… We’re done.
807 01:14:25.110 ⇒ 01:14:26.720 Mustafa Raja: Do my best, to be honest.
808 01:14:27.340 ⇒ 01:14:29.250 Mustafa Raja: And not disappoint anyone.
809 01:14:30.200 ⇒ 01:14:31.740 Demilade Agboola: Hmm, I think you’re doing a great job.
810 01:14:32.080 ⇒ 01:14:32.770 Mustafa Raja: Thank you.
811 01:14:34.710 ⇒ 01:14:41.200 Mustafa Raja: Yeah, okay, I think we have 30 more minutes, right?
812 01:14:42.400 ⇒ 01:14:43.889 Demilade Agboola: Yeah, like, 12 more minutes.
813 01:14:44.120 ⇒ 01:14:50.580 Mustafa Raja: 12 more minutes, okay, okay. Do you want to go through other ones? Because I think, I think,
814 01:14:50.680 ⇒ 01:14:57.619 Mustafa Raja: I think you now get a gist of it, what the issue is. We could investigate it further later, because I have some other pressing issues also.
815 01:14:57.900 ⇒ 01:14:58.920 Demilade Agboola: Alright, I’m listening.
816 01:15:00.680 ⇒ 01:15:07.880 Mustafa Raja: Let me see what other one would be nice. So you just know that, you know, if a column is measure, we cannot add it to the heat map, right?
817 01:15:08.890 ⇒ 01:15:10.519 Mustafa Raja: That’s just how Omni does it.
818 01:15:12.650 ⇒ 01:15:14.170 Demilade Agboola: If a column is what?
819 01:15:14.190 ⇒ 01:15:16.459 Mustafa Raja: If a column is a measure.
820 01:15:18.160 ⇒ 01:15:25.280 Mustafa Raja: Right? If a column is a major, and we are trying to add it in a pivot, but not in the pivoted section.
821 01:15:25.530 ⇒ 01:15:26.919 Mustafa Raja: Outside of Pivot.
822 01:15:29.000 ⇒ 01:15:30.289 Demilade Agboola: Where is the… where’s the.
823 01:15:30.290 ⇒ 01:15:31.820 Mustafa Raja: Let me show you an example.
824 01:15:31.820 ⇒ 01:15:33.400 Demilade Agboola: Okay, that’d be great.
825 01:15:34.030 ⇒ 01:15:36.740 Mustafa Raja: Let me show you an example.
826 01:15:37.110 ⇒ 01:15:51.039 Mustafa Raja: Wait, where it isn’t… Oish… And then… the first privilege I worked on… And then…
827 01:15:54.330 ⇒ 01:15:55.090 Mustafa Raja: Hmm.
828 01:15:55.980 ⇒ 01:16:00.459 Mustafa Raja: And then this… And then… this…
829 01:16:01.960 ⇒ 01:16:03.809 Mustafa Raja: Sorry, this was another back and forth.
830 01:16:05.130 ⇒ 01:16:06.240 Mustafa Raja: Okay.
831 01:16:06.980 ⇒ 01:16:13.660 Mustafa Raja: And then… this… Okay, you see that, we have, repurchase, rate over here?
832 01:16:17.890 ⇒ 01:16:26.000 Mustafa Raja: Now, I cannot add this over here. If I try and add it, what happens is, it gets added to the pivoted section, you know?
833 01:16:27.460 ⇒ 01:16:30.400 Mustafa Raja: And the reason why is it’s… is it is a major.
834 01:16:35.140 ⇒ 01:16:37.020 Mustafa Raja: Repurchase percentage.
835 01:16:37.580 ⇒ 01:16:38.340 Demilade Agboola: Okay.
836 01:16:38.620 ⇒ 01:16:41.259 Mustafa Raja: And then there’s no way of getting it out of here.
837 01:16:43.260 ⇒ 01:16:46.039 Demilade Agboola: Wait, you can’t do res… oof.
838 01:16:46.300 ⇒ 01:16:49.540 Demilade Agboola: First off, this looks ugly. But secondly.
839 01:16:51.290 ⇒ 01:16:59.639 Demilade Agboola: Alright, so you know what we… All we could do, How about we make… Two tables, or two charts.
840 01:17:02.050 ⇒ 01:17:09.810 Mustafa Raja: Yeah, this is exactly what Omni also suggested… oh, sorry, Kaiser also suggested, one with all the pivots, and one with all… all of this.
841 01:17:10.680 ⇒ 01:17:15.069 Demilade Agboola: Yeah, just one with, like… Yeah, just put two charts.
842 01:17:15.300 ⇒ 01:17:16.750 Demilade Agboola: Put the same filters.
843 01:17:16.750 ⇒ 01:17:19.899 Mustafa Raja: So if anyone changes one, they change both of them.
844 01:17:22.350 ⇒ 01:17:24.450 Demilade Agboola: Like, we just have to do what we can do it.
845 01:17:24.450 ⇒ 01:17:25.420 Mustafa Raja: One more thing.
846 01:17:25.600 ⇒ 01:17:26.140 Demilade Agboola: Yeah.
847 01:17:26.280 ⇒ 01:17:31.309 Mustafa Raja: Omni can only have these sort of filters at the top only.
848 01:17:31.990 ⇒ 01:17:34.749 Demilade Agboola: You can’t have, like, different filters within.
849 01:17:36.300 ⇒ 01:17:42.340 Mustafa Raja: that seems to be the case. I haven’t dug really deep into it, but from the looks of it.
850 01:17:42.490 ⇒ 01:17:43.480 Mustafa Raja: I cannot.
851 01:17:45.510 ⇒ 01:17:46.930 Mustafa Raja: Let me… Can you ask them?
852 01:17:46.930 ⇒ 01:17:49.940 Demilade Agboola: Do we have access to the Omni team? Can you just quickly ask them?
853 01:17:50.330 ⇒ 01:17:51.150 Mustafa Raja: Yeah, yeah.
854 01:17:52.160 ⇒ 01:17:54.469 Mustafa Raja: Yeah, I’ll ask, I’ll ask them.
855 01:17:54.470 ⇒ 01:17:57.049 Demilade Agboola: Sure, try. Try. Click Edit.
856 01:17:58.870 ⇒ 01:18:03.110 Demilade Agboola: Let’s see… Add filters, yeah, add filter.
857 01:18:04.980 ⇒ 01:18:08.720 Mustafa Raja: Let me add a random filter. Let me add a filter on like this.
858 01:18:09.020 ⇒ 01:18:09.750 Demilade Agboola: Yeah.
859 01:18:09.910 ⇒ 01:18:10.490 Demilade Agboola: Let’s see…
860 01:18:10.490 ⇒ 01:18:11.640 Mustafa Raja: And then let me add.
861 01:18:12.040 ⇒ 01:18:15.229 Mustafa Raja: And this is just… this is just stuck over here, is it?
862 01:18:15.230 ⇒ 01:18:19.570 Demilade Agboola: No, no, that’s fine. But, like, click on… Edit.
863 01:18:20.230 ⇒ 01:18:21.350 Mustafa Raja: Which I did?
864 01:18:21.680 ⇒ 01:18:24.490 Demilade Agboola: Yeah, there’s that, like, it’s open door, edit filter on the right.
865 01:18:24.770 ⇒ 01:18:29.699 Demilade Agboola: So the default value says last 7 days. You can choose what it maps to.
866 01:18:30.190 ⇒ 01:18:30.970 Mustafa Raja: Mia.
867 01:18:31.450 ⇒ 01:18:34.460 Demilade Agboola: So yeah, I think technically you should be able to do it. Let’s see.
868 01:18:34.460 ⇒ 01:18:40.949 Mustafa Raja: No, no, we can add multiple filters. It’s just that we cannot add it in the middle of the dashboard.
869 01:18:41.360 ⇒ 01:18:43.770 Demilade Agboola: Can’t we try… like, you can’t move it? Are you sure?
870 01:18:44.100 ⇒ 01:18:46.339 Mustafa Raja: Yeah, this is… I’m trying to move it.
871 01:18:46.510 ⇒ 01:18:48.900 Mustafa Raja: It doesn’t move, whereas these would move.
872 01:18:51.830 ⇒ 01:18:55.399 Mustafa Raja: I’ll just double-check with the Omni team then, also.
873 01:18:55.940 ⇒ 01:18:59.390 Demilade Agboola: Alright, can you also do… let me see, let’s click on the ad again.
874 01:19:00.350 ⇒ 01:19:00.990 Mustafa Raja: this?
875 01:19:01.290 ⇒ 01:19:06.819 Demilade Agboola: Yeah… Can you make it? Shit, shit, straight from the blah blah blah…
876 01:19:10.470 ⇒ 01:19:12.600 Demilade Agboola: Can you try text?
877 01:19:14.140 ⇒ 01:19:14.520 Mustafa Raja: text.
878 01:19:14.770 ⇒ 01:19:16.870 Demilade Agboola: Yeah, let’s just something, let’s just something.
879 01:19:17.800 ⇒ 01:19:18.969 Mustafa Raja: This is a smartphone.
880 01:19:19.220 ⇒ 01:19:20.250 Demilade Agboola: Yeah, I understand.
881 01:19:21.920 ⇒ 01:19:27.659 Demilade Agboola: I just want to see what you can include in here. Maybe you can include…
882 01:19:28.130 ⇒ 01:19:33.169 Mustafa Raja: Yeah, yeah, that’s what I’m… sometimes, sometimes people can’t allow you to do that, no, it doesn’t.
883 01:19:33.870 ⇒ 01:19:39.019 Demilade Agboola: Because even in Tableau, part of how you do it is you need to put, like, a bit of a text thing.
884 01:19:39.020 ⇒ 01:19:40.549 Mustafa Raja: Oh, what’s a good thing.
885 01:19:40.550 ⇒ 01:19:43.390 Demilade Agboola: I wanted to be sure if that was what you could do as well.
886 01:19:44.550 ⇒ 01:19:46.309 Demilade Agboola: So if you… let me see…
887 01:19:47.490 ⇒ 01:19:50.929 Demilade Agboola: This just allows the McDonald’s gravies, blah blah blah, okay, sure.
888 01:19:51.740 ⇒ 01:19:55.389 Demilade Agboola: Alright, so you can delete that, I’m just… I was just trying to see if that was useful.
889 01:19:55.830 ⇒ 01:19:58.539 Mustafa Raja: Okay, I’ll just double-check with the Omni team also.
890 01:19:59.140 ⇒ 01:20:02.789 Mustafa Raja: Alright. We’re, like, 100% sure of this.
891 01:20:03.670 ⇒ 01:20:04.290 Demilade Agboola: Okay.
892 01:20:05.410 ⇒ 01:20:06.639 Mustafa Raja: New draft.
893 01:20:08.040 ⇒ 01:20:13.519 Mustafa Raja: Yeah, so, this issue, which, yeah, you’re just saying that, yeah, let’s just split it.
894 01:20:13.740 ⇒ 01:20:16.020 Mustafa Raja: What else?
895 01:20:16.410 ⇒ 01:20:22.069 Mustafa Raja: the armor… Hmm, this looks good, this…
896 01:20:22.970 ⇒ 01:20:25.190 Mustafa Raja: This, we just took a look.
897 01:20:25.900 ⇒ 01:20:29.039 Mustafa Raja: Okay, yeah, let’s take a look at Farmacy SLA.
898 01:20:30.850 ⇒ 01:20:38.070 Mustafa Raja: For the rest, where we wouldn’t be able to take a look because of the time, I’ll just send a… I’ll just record a Zoom clip.
899 01:20:38.610 ⇒ 01:20:46.380 Demilade Agboola: Yeah, you could record a Zoom clip, or if you, like, Me too, potentially…
900 01:20:47.440 ⇒ 01:20:52.179 Demilade Agboola: Am I doing anything tomorrow, Maureen? Probably not, so…
901 01:20:52.180 ⇒ 01:20:55.969 Mustafa Raja: Actually, Greg also needs to present it tomorrow to…
902 01:20:56.350 ⇒ 01:20:57.239 Demilade Agboola: Yeah, I know.
903 01:20:58.710 ⇒ 01:21:00.059 Mustafa Raja: the team, you know?
904 01:21:01.850 ⇒ 01:21:08.589 Mustafa Raja: Okay… okay, so the… all tables are looking good, except this one.
905 01:21:10.650 ⇒ 01:21:15.690 Mustafa Raja: And all columns are here good, except these two.
906 01:21:17.010 ⇒ 01:21:25.639 Mustafa Raja: So breached SLA is 17%. For null strength, right? Null strength, null strength.
907 01:21:26.260 ⇒ 01:21:28.580 Mustafa Raja: is 25% over here.
908 01:21:28.610 ⇒ 01:21:31.830 Demilade Agboola: With a bridge turn around, 3.8.
909 01:21:31.860 ⇒ 01:21:36.419 Mustafa Raja: And here, 4.2. Oh, sorry. Is it just for… is it just for NOR, or is it for everything?
910 01:21:36.760 ⇒ 01:21:37.900 Mustafa Raja: It’s for everything.
911 01:21:38.030 ⇒ 01:21:40.559 Demilade Agboola: Yeah, these two columns are just for everything.
912 01:21:41.300 ⇒ 01:21:43.220 Demilade Agboola: So what’s the formula that we’re using?
913 01:21:46.730 ⇒ 01:21:48.480 Mustafa Raja: I think OmniCrafted this.
914 01:21:51.190 ⇒ 01:21:54.840 Mustafa Raja: And I don’t think that we’ll be able to know what’s underneath.
915 01:21:55.680 ⇒ 01:21:59.260 Mustafa Raja: BCT breached SLA, PCT breached SLA on.
916 01:22:01.250 ⇒ 01:22:02.160 Mustafa Raja: Edit.
917 01:22:03.230 ⇒ 01:22:06.580 Mustafa Raja: Okay, this isn’t. This is the thing that’s going under.
918 01:22:10.980 ⇒ 01:22:12.910 Mustafa Raja: Do you need a link to this dashboard?
919 01:22:15.540 ⇒ 01:22:20.060 Demilade Agboola: No, it’s a… I’m fine.
920 01:22:21.490 ⇒ 01:22:24.149 Demilade Agboola: Which one? Are you seeing the one in Omni or this… this one?
921 01:22:24.150 ⇒ 01:22:25.010 Mustafa Raja: This tablo one.
922 01:22:25.170 ⇒ 01:22:26.430 Demilade Agboola: Oh, no, Tableau’s fine.
923 01:22:27.360 ⇒ 01:22:29.510 Mustafa Raja: I can share you the Omni one also, if you want.
924 01:22:29.990 ⇒ 01:22:32.479 Demilade Agboola: Sure, let’s do this.
925 01:22:56.980 ⇒ 01:23:04.849 Demilade Agboola: But when you do the bridge… presented bridge SLA for the pharmacy turnaround, is that fine? Is it just the last chart, the product overview chart?
926 01:23:05.050 ⇒ 01:23:06.390 Mustafa Raja: Sorry, which one?
927 01:23:06.970 ⇒ 01:23:09.699 Demilade Agboola: So there are two charts. Can you go back to Tableau for one second?
928 01:23:10.560 ⇒ 01:23:12.129 Mustafa Raja: Yeah, this one, turnaround is good.
929 01:23:13.010 ⇒ 01:23:15.739 Demilade Agboola: So, previously, it’s just for the last chart that is weird.
930 01:23:17.950 ⇒ 01:23:19.889 Mustafa Raja: Breezy slip percentage.
931 01:23:20.770 ⇒ 01:23:21.330 Demilade Agboola: Jason.
932 01:23:21.730 ⇒ 01:23:27.770 Demilade Agboola: Yeah, these two, like, pharmacy overview and pharmacy Turnaround, are they fine? It’s just product overview.
933 01:23:27.770 ⇒ 01:23:30.329 Mustafa Raja: fine for the other ones. Let me just double check that.
934 01:23:32.560 ⇒ 01:23:35.679 Mustafa Raja: I did take a look at this earlier today.
935 01:23:36.210 ⇒ 01:23:44.650 Mustafa Raja: Yeah, 36.5, 4.5, this is good. Let’s take a look at Google Maps, 30.4, 4.4.4.
936 01:23:44.920 ⇒ 01:23:46.320 Mustafa Raja: Google Mage…
937 01:23:51.450 ⇒ 01:23:54.040 Mustafa Raja: Maybe slightly off, 30.4, right?
938 01:23:54.790 ⇒ 01:23:56.410 Mustafa Raja: 314414.
939 01:23:58.080 ⇒ 01:23:59.469 Mustafa Raja: Just lightly off.
940 01:24:01.350 ⇒ 01:24:09.070 Demilade Agboola: They appear to be the same sort of thing, just, like, different cuts, different granularity, so if it’s fine for those, it should not be wrong for that. That’s why I asked the question.
941 01:24:10.260 ⇒ 01:24:12.919 Mustafa Raja: 21.54.5 for absolute.
942 01:24:13.770 ⇒ 01:24:20.360 Mustafa Raja: Absolute… Yeah, this is… They’re not, they’re not…
943 01:24:20.360 ⇒ 01:24:20.719 Demilade Agboola: Are you fine.
944 01:24:20.940 ⇒ 01:24:25.200 Mustafa Raja: 22, 20.2, which is… Which is the one, right?
945 01:24:25.490 ⇒ 01:24:28.009 Mustafa Raja: Pretty much. Yeah, it’s very slightly off.
946 01:24:28.840 ⇒ 01:24:34.780 Mustafa Raja: So this is 20.2, and here this is 20.5 and 4.5.
947 01:24:35.650 ⇒ 01:24:41.619 Mustafa Raja: This is round… this will be rounded to 4.5, this would be rounded to 20.3, not 20.5.
948 01:24:41.940 ⇒ 01:24:45.530 Mustafa Raja: And then 44.36, 44.27…
949 01:24:46.100 ⇒ 01:24:50.469 Demilade Agboola: So here, let me just teach you a couple of tricks we can do. One is we can say.
950 01:24:50.680 ⇒ 01:25:01.290 Demilade Agboola: like, while we’re working on this, we will definitely just be like, hey, a lot of things, some of the numbers here are slightly off, but they’re directionally accurate, so that’s, like, one of the easiest things you can always learn.
951 01:25:01.460 ⇒ 01:25:08.819 Demilade Agboola: What that just means is, they’re not exactly what you… like, they’re not exactly to what is in Tableau.
952 01:25:08.960 ⇒ 01:25:10.110 Demilade Agboola: However.
953 01:25:10.280 ⇒ 01:25:17.650 Demilade Agboola: the difference lets you know what is important, what’s not important. Like, if something’s 20.8 and something is 20.5, or 20.3,
954 01:25:18.000 ⇒ 01:25:27.049 Demilade Agboola: And we know that once it increases, it increases here. Once it decreases, it increases there. Like, it directionally lets you know what’s, like, what to do, or what you need to flag.
955 01:25:27.240 ⇒ 01:25:32.370 Demilade Agboola: it might not necessarily be the most accurate. Like, for instance, here you can see Contigo is still higher than, or…
956 01:25:32.480 ⇒ 01:25:41.750 Demilade Agboola: you know, Enox… Inovex is more… it’s much higher than, you know, Absolute Pharmacy. So whoever’s making the decision knows that we need to actually look into Inovex.
957 01:25:42.060 ⇒ 01:25:44.129 Demilade Agboola: And we also need to look, like.
958 01:25:44.130 ⇒ 01:25:45.160 Mustafa Raja: If I was going to…
959 01:25:46.470 ⇒ 01:25:52.540 Demilade Agboola: give a reward to a pharmacy, it will be absolute pharmacy. If we go back to our dashboard, for instance, can we see our dashboard?
960 01:25:53.990 ⇒ 01:25:55.800 Demilade Agboola: You will still make that same decision.
961 01:25:56.680 ⇒ 01:25:57.940 Mustafa Raja: Yeah.
962 01:25:58.450 ⇒ 01:26:11.469 Demilade Agboola: Now, obviously, I understand that we want to get it exactly, and I will look at that, but, like, sometimes some of these things just need to be like, oh, well, it’s directionally accurate. Now, for this one, the fact that it’s 17 is a bit worrying. That’s what I’m trying to look at now.
963 01:26:11.520 ⇒ 01:26:14.229 Mustafa Raja: So, it’s a 125. Yeah.
964 01:26:16.170 ⇒ 01:26:24.110 Mustafa Raja: I mean, let’s take a look at the, let’s take a look at Absolute Pharmacy, because this is just a granular view of Absolute Pharmacy, right?
965 01:26:26.280 ⇒ 01:26:29.989 Mustafa Raja: Let me, let me double-check the Absal Pharmacy one, Absal Pharmacy.
966 01:26:30.550 ⇒ 01:26:36.470 Mustafa Raja: American Pharmacy, firstly, only has two… Two suite names.
967 01:26:36.880 ⇒ 01:26:45.849 Mustafa Raja: 28.6, 19.2, 28.6, 19.2… I mean, yeah, this is… this is done… doesn’t make sense.
968 01:26:47.390 ⇒ 01:26:50.470 Mustafa Raja: Absolute pharmacy over here is 28.
969 01:26:50.470 ⇒ 01:26:52.910 Demilade Agboola: Can you go back to the workbook.
970 01:26:53.010 ⇒ 01:26:55.000 Demilade Agboola: For, what’s it called?
971 01:26:57.010 ⇒ 01:26:57.780 Demilade Agboola: Omni.
972 01:26:58.770 ⇒ 01:27:01.020 Demilade Agboola: Can I see the Sheetz product?
973 01:27:01.330 ⇒ 01:27:05.309 Demilade Agboola: Promisey… Product overview sheet.
974 01:27:06.690 ⇒ 01:27:07.599 Mustafa Raja: This one, right?
975 01:27:07.750 ⇒ 01:27:08.410 Demilade Agboola: Yes.
976 01:27:09.810 ⇒ 01:27:12.699 Demilade Agboola: Can I see… can you edit? Yeah, okay, thank you.
977 01:27:15.610 ⇒ 01:27:18.509 Mustafa Raja: Let me see if filters, filters make sense.
978 01:27:18.670 ⇒ 01:27:20.959 Demilade Agboola: Yeah, that’s what I’m trying to say, so can we see that?
979 01:27:21.160 ⇒ 01:27:24.930 Demilade Agboola: Can we also then go back to the… the products…
980 01:27:25.650 ⇒ 01:27:29.870 Mustafa Raja: You know what? What I think there’s also… what I have also noticed is when we…
981 01:27:30.190 ⇒ 01:27:37.890 Demilade Agboola: Can you… can you… I just want to create this with something. You’re moving a lot. It’s stress. Can you go back to Army? Can you go back to Army, please?
982 01:27:38.460 ⇒ 01:27:43.509 Demilade Agboola: Okay, can you go product overview, and then Product Turnaround? Can you go to those two, two?
983 01:27:43.660 ⇒ 01:27:45.009 Mustafa Raja: Perfect. Performance coming on.
984 01:27:45.010 ⇒ 01:27:46.249 Demilade Agboola: I promise to turn around.
985 01:27:49.310 ⇒ 01:27:52.160 Demilade Agboola: So… Can’t prompt WVM pharmacy turnaround.
986 01:27:53.910 ⇒ 01:27:54.770 Demilade Agboola: Okay.
987 01:27:54.880 ⇒ 01:27:56.550 Demilade Agboola: Can you then go back, please?
988 01:27:59.180 ⇒ 01:28:03.439 Demilade Agboola: Alright, thank you. Like, I just wanted to be, like, again, it was… let me see…
989 01:28:06.240 ⇒ 01:28:08.819 Demilade Agboola: Can you add essential pharmacy is true?
990 01:28:09.850 ⇒ 01:28:10.960 Demilade Agboola: As a filter.
991 01:28:17.530 ⇒ 01:28:19.460 Mustafa Raja: And to pharmacy…
992 01:28:22.080 ⇒ 01:28:30.789 Demilade Agboola: So, can you go back to product pharmacy Turnaround? There’s a filter that you’re using, it’s Center Pharmacy, it’s true, so is center pharmacy, so it starts with I.
993 01:28:32.490 ⇒ 01:28:34.280 Mustafa Raja: Eastern, yeah, yeah, sorry.
994 01:28:41.460 ⇒ 01:28:43.530 Demilade Agboola: It’s tough, you’ve passed it, go back down.
995 01:28:44.990 ⇒ 01:28:49.480 Demilade Agboola: So, add it, please, and then… It’s true.
996 01:28:55.620 ⇒ 01:28:57.530 Demilade Agboola: But I didn’t change anything interesting.
997 01:29:00.720 ⇒ 01:29:04.839 Demilade Agboola: Mmm… Okay, so let’s go back.
998 01:29:05.550 ⇒ 01:29:07.500 Demilade Agboola: to… Fucks and around.
999 01:29:08.670 ⇒ 01:29:10.139 Demilade Agboola: Your son’s pharmacy.
1000 01:29:10.640 ⇒ 01:29:15.919 Demilade Agboola: Alright, can I look at your percentage breach SLA? Can I look at what that looks like? Like…
1001 01:29:16.170 ⇒ 01:29:17.879 Demilade Agboola: column, percentage progesterity.
1002 01:29:18.810 ⇒ 01:29:20.049 Demilade Agboola: Can I look at that?
1003 01:29:23.690 ⇒ 01:29:24.550 Demilade Agboola: Edit.
1004 01:29:25.610 ⇒ 01:29:26.560 Demilade Agboola: So it’s this formula.
1005 01:29:28.460 ⇒ 01:29:35.880 Demilade Agboola: Alright, can we then go to… so it’s PHSL account divided by somepharmacy.com, okay, cool. Can we then go to…
1006 01:29:37.400 ⇒ 01:29:38.640 Demilade Agboola: Yes, yes.
1007 01:29:39.550 ⇒ 01:29:40.280 Mustafa Raja: don’t you?
1008 01:29:40.280 ⇒ 01:29:41.030 Demilade Agboola: Yes, please.
1009 01:29:42.010 ⇒ 01:29:45.670 Demilade Agboola: And then can we now look at the bridged SLA count as well?
1010 01:29:46.200 ⇒ 01:29:47.729 Demilade Agboola: This one? Yes, please.
1011 01:29:54.110 ⇒ 01:29:59.020 Mustafa Raja: Yeah, the SQL is a little different, but this is for percentage also, right? What was that?
1012 01:29:59.700 ⇒ 01:30:04.129 Demilade Agboola: So… Okay, let me now look at it here.
1013 01:30:04.600 ⇒ 01:30:15.469 Demilade Agboola: And just confirm, because… I… think… It might be… Very similar formulas.
1014 01:30:15.780 ⇒ 01:30:18.940 Demilade Agboola: like, they’re literally using the same, like, in Tableau, you’re using the same column.
1015 01:30:19.860 ⇒ 01:30:23.660 Demilade Agboola: So if you’re changing it, I’m not sure if… That is…
1016 01:30:25.210 ⇒ 01:30:27.240 Demilade Agboola: Maybe that is what the issue is.
1017 01:30:28.980 ⇒ 01:30:30.120 Demilade Agboola: Don’t see each preach us.
1018 01:30:42.840 ⇒ 01:30:46.110 Demilade Agboola: So this is… Oops, pending.
1019 01:31:08.610 ⇒ 01:31:13.939 Demilade Agboola: Okay, can I share my screen so I can show you what’s going on, and why I think this is the issue?
1020 01:31:14.740 ⇒ 01:31:18.830 Mustafa Raja: Yes, let me figure out how to… oh yeah, this is, over here. Okay.
1021 01:31:21.250 ⇒ 01:31:28.150 Demilade Agboola: So, in this formula, So you can see here that what we’re using is presented Butcher Saleh.
1022 01:31:28.520 ⇒ 01:31:31.359 Demilade Agboola: That formula… Is… this.
1023 01:31:33.020 ⇒ 01:31:41.340 Demilade Agboola: Right here, alright? It’s all this about count these things, if it is filled late, if not known, blah blah blah blah blah blah, then other ID, if not.
1024 01:31:41.590 ⇒ 01:31:42.639 Demilade Agboola: than this.
1025 01:31:42.990 ⇒ 01:31:43.730 Demilade Agboola: Right.
1026 01:31:44.060 ⇒ 01:31:50.189 Demilade Agboola: So this is for pending unlaid, this is for field and lead, else is null, and then blah blah blah, divided by number, I’ll send to pharmacy orders.
1027 01:31:52.030 ⇒ 01:31:59.210 Demilade Agboola: This is literally the same formula that is being used here as well. It’s the percent… breach all.
1028 01:32:00.170 ⇒ 01:32:02.320 Demilade Agboola: So you’re using two different formulas for something.
1029 01:32:02.320 ⇒ 01:32:06.880 Mustafa Raja: Okay, yeah, so I just… I should just pick the formula from pharmacy Turnaround.
1030 01:32:07.250 ⇒ 01:32:07.800 Demilade Agboola: Yeah.
1031 01:32:09.580 ⇒ 01:32:14.939 Mustafa Raja: Let me just share my screen. Let’s quickly fix that, and then let’s call it a dish, since you have a meeting.
1032 01:32:14.960 ⇒ 01:32:16.350 Demilade Agboola: I want to drag it.
1033 01:32:18.510 ⇒ 01:32:20.539 Mustafa Raja: Sorry, I’m sharing the wrong screen.
1034 01:32:25.830 ⇒ 01:32:32.390 Mustafa Raja: Give me, Let me grab this formula… Percentage, please.
1035 01:32:32.390 ⇒ 01:32:39.259 Demilade Agboola: Who else… I didn’t realize… I mean, I actually said it well equal. I just realized I don’t know.
1036 01:32:39.410 ⇒ 01:32:43.020 Demilade Agboola: Painting actually started a while ago. I thought it was only at the hour.
1037 01:32:43.470 ⇒ 01:32:44.210 Mustafa Raja: Okay, okay.
1038 01:32:44.330 ⇒ 01:32:45.780 Demilade Agboola: I didn’t know what’s throwing.
1039 01:32:46.020 ⇒ 01:32:46.700 Demilade Agboola: I see.
1040 01:32:46.970 ⇒ 01:32:47.840 Mustafa Raja: And it…
1041 01:32:51.790 ⇒ 01:32:54.080 Mustafa Raja: Why? Why is it not letting me update?
1042 01:32:59.090 ⇒ 01:33:01.690 Demilade Agboola: Road this field to the workbook to edit it.
1043 01:33:03.150 ⇒ 01:33:07.590 Mustafa Raja: Yeah, I’ll have to promote it first. But I don’t want to promote it now.
1044 01:33:08.950 ⇒ 01:33:13.859 Demilade Agboola: So I’m going… let me try and join my meeting, because I just realized I’m, like, 20 minutes late to my meeting.
1045 01:33:13.860 ⇒ 01:33:19.359 Mustafa Raja: Oh, okay, okay, yeah, yeah, yeah, okay, okay. I’ll take care of this. You should, you should leave. Okay. See you.
1046 01:33:19.360 ⇒ 01:33:20.850 Demilade Agboola: See you. Bye.