2024-05-02_uttam-kumarans-personal-meeting-room_1359b0ec

Meeting Title: Uttam-Kumaran’s-Personal-Meeting-Room Date: 2024-05-02 Meeting participants: Ryan Luke Daque, Patrick Trainer, Uttam Kumaran

---

WEBVTT

1 00:01:14.930 ⇒ 00:01:15.250 Ryan Luke Daque: Little

2 00:01:20.570 ⇒ 00:01:22.150 Ryan Luke Daque: Hello, Tom! Can you hear me?

3 00:01:22.840 ⇒ 00:01:24.398 Uttam Kumaran: Hey? Can you hear me.

4 00:01:25.430 ⇒ 00:01:27.789 Uttam Kumaran: hey? 1 s, 1 s

5 00:01:35.140 ⇒ 00:01:36.610 Uttam Kumaran: manufacturer

6 00:01:40.990 ⇒ 00:01:41.890 Uttam Kumaran: wire

7 00:01:42.010 ⇒ 00:01:44.440 Uttam Kumaran: right now. Gotcha!

8 00:01:46.960 ⇒ 00:01:48.369 Ryan Luke Daque: Are you talking.

9 00:01:49.310 ⇒ 00:01:50.750 Uttam Kumaran: Once I understand it.

10 00:01:50.750 ⇒ 00:01:51.960 Ryan Luke Daque: I’m sure sure no problem.

11 00:01:53.807 ⇒ 00:01:57.852 Uttam Kumaran: Yeah, we just have, like a bunch of issues with

12 00:01:59.520 ⇒ 00:02:01.610 Uttam Kumaran: details, dashboards that

13 00:02:02.120 ⇒ 00:02:04.019 Uttam Kumaran: we really need to resolve.

14 00:02:05.118 ⇒ 00:02:09.662 Uttam Kumaran: So I’ll just, I guess I’ll just wait to take fairness. But

15 00:02:11.280 ⇒ 00:02:24.790 Uttam Kumaran: yeah, so basically, kind of like, the overall is like we brought on. I mean, Patrick, join mainly to handle like a lot of the data vis for cool parts. But looks like we still haven’t finished. Quite a bit of updates.

16 00:02:24.940 ⇒ 00:02:29.179 Uttam Kumaran: and some of those tickets have been sitting there for quite a while. And then I just got emailed

17 00:02:29.310 ⇒ 00:02:37.292 Uttam Kumaran: by, like the CEO and CEO saying, like, Where are these updates? Been like 2, 3 weeks? Some of them are quite small.

18 00:02:37.720 ⇒ 00:02:38.970 Uttam Kumaran: Hmm.

19 00:02:39.780 ⇒ 00:02:45.960 Uttam Kumaran: and we’re basically we’re like need to make some bundle changes by tomorrow.

20 00:02:45.990 ⇒ 00:02:50.964 Uttam Kumaran: unless and then otherwise, we’re gonna lose probably a good portion of the contract.

21 00:02:53.850 ⇒ 00:02:55.210 Uttam Kumaran: So

22 00:02:55.530 ⇒ 00:02:58.820 Uttam Kumaran: in particular, I’m just going to

23 00:03:01.920 ⇒ 00:03:04.559 Uttam Kumaran: I’m just gonna share this

24 00:03:05.860 ⇒ 00:03:06.970 Uttam Kumaran: wall

25 00:03:08.350 ⇒ 00:03:09.910 Uttam Kumaran: right now.

26 00:03:23.070 ⇒ 00:03:26.380 Uttam Kumaran: So there’s mainly 3 things.

27 00:03:27.930 ⇒ 00:03:29.680 Uttam Kumaran: we need to.

28 00:03:30.726 ⇒ 00:03:33.070 Uttam Kumaran: We need to remove.

29 00:03:33.340 ⇒ 00:03:35.710 Uttam Kumaran: We need to remove top customers.

30 00:03:38.260 ⇒ 00:03:39.959 Uttam Kumaran: I’m just gonna make a list.

31 00:03:41.430 ⇒ 00:03:43.400 Uttam Kumaran: Top customers

32 00:03:44.580 ⇒ 00:03:46.120 Uttam Kumaran: add time.

33 00:03:49.040 ⇒ 00:03:50.535 Uttam Kumaran: Yeah, hang on Brandon.

34 00:03:51.190 ⇒ 00:03:52.140 Uttam Kumaran: Cold.

35 00:03:56.810 ⇒ 00:04:02.960 Uttam Kumaran: implement the month, the new month of the month logic.

36 00:04:04.620 ⇒ 00:04:06.790 Uttam Kumaran: We need to add in

37 00:04:07.900 ⇒ 00:04:09.370 Uttam Kumaran: high

38 00:04:09.650 ⇒ 00:04:12.372 Uttam Kumaran: shipping cost States.

39 00:04:15.992 ⇒ 00:04:21.960 Uttam Kumaran: We need a 52 week shipment category.

40 00:04:22.380 ⇒ 00:04:27.270 Uttam Kumaran: So this is for changes for daily auto times.

41 00:04:29.450 ⇒ 00:04:32.049 Uttam Kumaran: This is for shipping.

42 00:04:33.870 ⇒ 00:04:37.020 Uttam Kumaran: The high shipping cost. States need to show

43 00:04:41.630 ⇒ 00:04:48.290 Uttam Kumaran: a good discussion on how to present the highest

44 00:04:48.440 ⇒ 00:04:49.690 Uttam Kumaran: shipping

45 00:04:50.340 ⇒ 00:04:52.550 Uttam Kumaran: percent states

46 00:04:55.910 ⇒ 00:04:57.993 Uttam Kumaran: this one. We need to

47 00:04:58.880 ⇒ 00:05:00.480 Uttam Kumaran: understand.

48 00:05:01.840 ⇒ 00:05:04.170 Uttam Kumaran: risk off

49 00:05:28.040 ⇒ 00:05:28.760 Uttam Kumaran: accept.

50 00:05:47.610 ⇒ 00:05:50.219 Ryan Luke Daque: Which dashboards are these.

51 00:05:51.030 ⇒ 00:05:54.539 Uttam Kumaran: This is for the shipping dashboard and for the

52 00:05:58.480 ⇒ 00:06:02.489 Uttam Kumaran: shipping dashboard, and for the vital signs.

53 00:06:03.330 ⇒ 00:06:04.130 Ryan Luke Daque: And care

54 00:07:07.460 ⇒ 00:07:10.580 Ryan Luke Daque: did we already have like tickets or tasks for this.

55 00:07:12.410 ⇒ 00:07:14.026 Uttam Kumaran: Yeah, I mean, we’ve had

56 00:07:51.740 ⇒ 00:07:54.230 Uttam Kumaran: I’m gonna look at vital signs.

57 00:08:05.550 ⇒ 00:08:07.780 Ryan Luke Daque: You’re looking at a new one, right?

58 00:08:10.030 ⇒ 00:08:11.040 Ryan Luke Daque: You’re looking into.

59 00:08:11.040 ⇒ 00:08:11.940 Uttam Kumaran: Everyone. Yeah.

60 00:08:23.860 ⇒ 00:08:24.550 Uttam Kumaran: Class.

61 00:09:36.765 ⇒ 00:09:39.735 Uttam Kumaran: so can you look into implementing?

62 00:09:40.950 ⇒ 00:09:42.705 Uttam Kumaran: that’s new change.

63 00:09:43.500 ⇒ 00:09:44.170 Uttam Kumaran: Where.

64 00:09:44.170 ⇒ 00:09:44.490 Ryan Luke Daque: Yes.

65 00:09:44.490 ⇒ 00:09:46.200 Uttam Kumaran: It is actually

66 00:09:54.150 ⇒ 00:09:55.803 Uttam Kumaran: It was

67 00:10:04.310 ⇒ 00:10:05.679 Uttam Kumaran: It was this one.

68 00:10:07.200 ⇒ 00:10:13.480 Uttam Kumaran: and I’m gonna keep. Let me know if you see that. And if there’s any questions.

69 00:10:18.720 ⇒ 00:10:24.490 Ryan Luke Daque: Different new calculations. Then, like that.

70 00:10:30.670 ⇒ 00:10:33.569 Ryan Luke Daque: Right? I think this is the one that Patrick

71 00:10:35.310 ⇒ 00:10:37.839 Ryan Luke Daque: mentioned before. Right like we are, we are

72 00:10:38.390 ⇒ 00:10:41.609 Ryan Luke Daque: where we were like calculating until

73 00:10:41.890 ⇒ 00:10:43.489 Ryan Luke Daque: just today’s date.

74 00:10:45.580 ⇒ 00:10:47.439 Uttam Kumaran: Yeah. So basically, we have to.

75 00:10:48.690 ⇒ 00:10:51.830 Uttam Kumaran: Yeah. So wherever it’s like a comparison

76 00:10:53.037 ⇒ 00:10:57.340 Uttam Kumaran: between, like the same time, last year, same

77 00:10:57.570 ⇒ 00:10:58.750 Uttam Kumaran: same

78 00:10:59.690 ⇒ 00:11:02.649 Uttam Kumaran: versus previous month. We want to use

79 00:11:03.610 ⇒ 00:11:04.960 Uttam Kumaran: that new data.

80 00:11:05.390 ⇒ 00:11:06.100 Ryan Luke Daque: Right.

81 00:11:08.310 ⇒ 00:11:12.730 Ryan Luke Daque: So it should be that all of the previous month, right? Not just the

82 00:11:12.950 ⇒ 00:11:14.360 Ryan Luke Daque: not just for

83 00:11:15.250 ⇒ 00:11:17.699 Ryan Luke Daque: the month. Until today.

84 00:11:18.330 ⇒ 00:11:19.180 Ryan Luke Daque: Something like that.

85 00:11:19.180 ⇒ 00:11:22.459 Uttam Kumaran: Well it should, it should be, it should be until the same day last month.

86 00:11:22.750 ⇒ 00:11:23.599 Ryan Luke Daque: All right.

87 00:11:28.190 ⇒ 00:11:28.940 Ryan Luke Daque: Thanks, huh!

88 00:11:29.360 ⇒ 00:11:31.270 Uttam Kumaran: So basically

89 00:11:31.770 ⇒ 00:11:32.940 Uttam Kumaran: my back. It’s possible

90 00:11:34.270 ⇒ 00:11:37.809 Uttam Kumaran: anytime where it says versus previous month.

91 00:11:37.960 ⇒ 00:11:41.049 Uttam Kumaran: it needs to be at the same time last month.

92 00:11:41.200 ⇒ 00:11:42.080 Uttam Kumaran: right?

93 00:11:43.550 ⇒ 00:11:49.070 Ryan Luke Daque: And currently we’re doing it until the I mean the whole month last month. And versus.

94 00:11:50.145 ⇒ 00:11:50.650 Uttam Kumaran: Yeah.

95 00:11:50.890 ⇒ 00:11:51.520 Ryan Luke Daque: Like.

96 00:11:53.160 ⇒ 00:11:54.590 Ryan Luke Daque: yeah, that’s why it’s like.

97 00:11:54.590 ⇒ 00:11:56.500 Uttam Kumaran: So you see that that example.

98 00:11:56.500 ⇒ 00:11:57.110 Ryan Luke Daque: Yeah.

99 00:11:57.370 ⇒ 00:11:58.110 Uttam Kumaran: Yeah.

100 00:11:58.260 ⇒ 00:12:00.610 Uttam Kumaran: So do you see his? Pr, that’s linked.

101 00:12:01.570 ⇒ 00:12:03.090 Ryan Luke Daque: What? Go ahead! Go ahead! Say that again.

102 00:12:04.300 ⇒ 00:12:06.110 Uttam Kumaran: Do you see his pr, that’s linked.

103 00:12:07.820 ⇒ 00:12:08.430 Ryan Luke Daque: Yep.

104 00:12:08.430 ⇒ 00:12:09.803 Uttam Kumaran: 3, 95.

105 00:12:11.910 ⇒ 00:12:12.340 Ryan Luke Daque: Looks like.

106 00:12:12.340 ⇒ 00:12:17.070 Uttam Kumaran: So looks like you can actually use all orders over period now

107 00:12:17.330 ⇒ 00:12:18.190 Uttam Kumaran: or

108 00:12:19.100 ⇒ 00:12:26.610 Uttam Kumaran: in Kp, in Kpis. Well, this is all in evidence. So yeah, all orders, period over period should have

109 00:12:27.350 ⇒ 00:12:29.200 Uttam Kumaran: all the data we need. Now.

110 00:12:32.500 ⇒ 00:12:35.629 Ryan Luke Daque: All orders, period.

111 00:13:24.860 ⇒ 00:13:30.159 Uttam Kumaran: Is it like a new table that we may have to make bring into light dash? Or what is it.

112 00:13:34.480 ⇒ 00:13:40.740 Ryan Luke Daque: Yeah, may, maybe we need to use this all orders over period. So in light dash

113 00:13:41.610 ⇒ 00:13:42.870 Ryan Luke Daque: instead of

114 00:13:47.000 ⇒ 00:13:50.630 Ryan Luke Daque: this month today, pros is from.

115 00:13:53.140 ⇒ 00:13:53.880 Ryan Luke Daque: But I know

116 00:13:55.470 ⇒ 00:13:56.460 Ryan Luke Daque: sales

117 00:13:58.730 ⇒ 00:13:59.780 Ryan Luke Daque: right

118 00:13:59.980 ⇒ 00:14:01.390 Ryan Luke Daque: shipping over, really.

119 00:14:04.060 ⇒ 00:14:06.629 Ryan Luke Daque: Where’d you find this file?

120 00:14:09.170 ⇒ 00:14:10.650 Uttam Kumaran: In title signs.

121 00:14:11.130 ⇒ 00:14:12.539 Ryan Luke Daque: Oh, 5 cents. Right?

122 00:14:19.920 ⇒ 00:14:20.840 Ryan Luke Daque: So

123 00:14:22.540 ⇒ 00:14:23.710 Ryan Luke Daque: morning me.

124 00:14:36.040 ⇒ 00:14:38.939 Ryan Luke Daque: currently, it’s still using the Daily Kpis. One

125 00:14:39.590 ⇒ 00:14:41.689 Ryan Luke Daque: check. Let me try

126 00:14:42.230 ⇒ 00:14:45.110 Ryan Luke Daque: creating a pile using the view table.

127 00:15:21.590 ⇒ 00:15:22.449 Ryan Luke Daque: I mean, you

128 00:15:24.060 ⇒ 00:15:25.959 Ryan Luke Daque: don’t see this

129 00:15:26.920 ⇒ 00:15:27.830 Ryan Luke Daque: long.

130 00:15:39.710 ⇒ 00:15:40.460 Uttam Kumaran: Aye.

131 00:15:41.650 ⇒ 00:15:44.530 Ryan Luke Daque: I’m I’m trying to look for. The model here.

132 00:15:45.010 ⇒ 00:15:46.539 Ryan Luke Daque: Doesn’t look like it’s

133 00:15:49.450 ⇒ 00:15:50.450 Ryan Luke Daque: exists.

134 00:16:15.510 ⇒ 00:16:17.289 Ryan Luke Daque: Is Patrick gonna join.

135 00:16:18.600 ⇒ 00:16:23.359 Uttam Kumaran: Yeah, he’s gonna join. Yeah, I see all over his period over period. But there’s no

136 00:16:24.710 ⇒ 00:16:25.710 Uttam Kumaran: There’s no

137 00:16:27.660 ⇒ 00:16:29.955 Uttam Kumaran: like Yaml for it.

138 00:16:35.170 ⇒ 00:16:36.260 Uttam Kumaran: Yeah.

139 00:16:36.350 ⇒ 00:16:38.320 Uttam Kumaran: gonna pull my phone number.

140 00:16:57.580 ⇒ 00:17:00.159 Ryan Luke Daque: Looks like there’s a yaml, but.

141 00:17:11.849 ⇒ 00:17:12.983 Uttam Kumaran: There is.

142 00:17:13.550 ⇒ 00:17:16.949 Ryan Luke Daque: There is, but I I think it needs to be deleted

143 00:17:20.680 ⇒ 00:17:22.180 Ryan Luke Daque: me create a branch.

144 00:17:37.030 ⇒ 00:17:42.589 Uttam Kumaran: Do you wanna go? Actually, I think I could probably do it. Do you wanna make you wanna go check out the updates for the shipping stuff.

145 00:17:43.350 ⇒ 00:17:44.299 Ryan Luke Daque: Okay. Sure.

146 00:17:46.010 ⇒ 00:17:48.690 Uttam Kumaran: And let me work on. Let me work on this.

147 00:17:49.060 ⇒ 00:17:53.080 Ryan Luke Daque: Yeah, I guess you just need to do a life dash, maybe to your end or something

148 00:17:53.555 ⇒ 00:17:55.330 Ryan Luke Daque: to update the ammo file.

149 00:18:01.020 ⇒ 00:18:04.409 Ryan Luke Daque: Oh, Patrick’s saying it. We’re looking at the wrong dashboard.

150 00:18:06.550 ⇒ 00:18:08.729 Uttam Kumaran: I just made these changes.

151 00:18:14.980 ⇒ 00:18:16.930 Ryan Luke Daque: Well, we are looking at this one.

152 00:18:35.500 ⇒ 00:18:37.540 Uttam Kumaran: What is this copy?

153 00:19:12.160 ⇒ 00:19:20.589 Ryan Luke Daque: I. I’m looking at the new one and the working progress one. It’s still the same, though it’s like 20 the the month to date. It is still using the old.

154 00:19:21.670 ⇒ 00:19:22.550 Ryan Luke Daque: modest.

155 00:19:24.180 ⇒ 00:19:24.910 Uttam Kumaran: Yeah.

156 00:19:37.730 ⇒ 00:19:44.019 Ryan Luke Daque: Shipping. High shipping cost states discussion 100%. The highest shipping States.

157 00:19:46.930 ⇒ 00:19:48.790 Ryan Luke Daque: See 20.

158 00:19:50.820 ⇒ 00:19:53.269 Ryan Luke Daque: My shipping costs dates.

159 00:19:58.838 ⇒ 00:20:01.140 Ryan Luke Daque: So I guess if they want to

160 00:20:01.440 ⇒ 00:20:05.440 Ryan Luke Daque: change how this is being presented in terms of states

161 00:20:06.860 ⇒ 00:20:07.669 Ryan Luke Daque: that are high.

162 00:20:07.670 ⇒ 00:20:08.670 Uttam Kumaran: Child.

163 00:20:09.820 ⇒ 00:20:10.472 Uttam Kumaran: I don’t know.

164 00:20:11.450 ⇒ 00:20:14.169 Ryan Luke Daque: Maybe instead of a tabular view, they want

165 00:20:15.090 ⇒ 00:20:16.370 Ryan Luke Daque: it differently.

166 00:20:17.210 ⇒ 00:20:18.810 Ryan Luke Daque: It’s currently we have.

167 00:20:19.910 ⇒ 00:20:22.840 Ryan Luke Daque: We have it like in a matrix format.

168 00:20:23.590 ⇒ 00:20:25.390 Ryan Luke Daque: It’s month versus

169 00:20:26.010 ⇒ 00:20:26.830 Ryan Luke Daque: state.

170 00:20:27.770 ⇒ 00:20:32.690 Ryan Luke Daque: And like the details of those States, like the shipping percent of sales.

171 00:20:34.000 ⇒ 00:20:35.150 Ryan Luke Daque: Yeah, shipping

172 00:20:35.700 ⇒ 00:20:37.679 Ryan Luke Daque: terms of percent of sales.

173 00:20:38.380 ⇒ 00:20:39.500 Ryan Luke Daque: First thing.

174 00:20:44.750 ⇒ 00:20:47.430 Ryan Luke Daque: 52 week shit.

175 00:20:47.690 ⇒ 00:20:49.639 Ryan Luke Daque: then category.

176 00:20:51.460 ⇒ 00:20:53.559 Ryan Luke Daque: Anyone to understand the unit’s cost.

177 00:20:55.470 ⇒ 00:20:58.634 Ryan Luke Daque: which is 400 for the last 3.

178 00:21:12.730 ⇒ 00:21:16.299 Ryan Luke Daque: There’s no I should be presented, but not for sales for this thing.

179 00:21:16.420 ⇒ 00:21:17.250 Ryan Luke Daque: Okay.

180 00:21:20.470 ⇒ 00:21:21.419 Uttam Kumaran: Be this matter.

181 00:21:24.850 ⇒ 00:21:27.020 Uttam Kumaran: wondering. I’m sorry about flying over.

182 00:21:27.640 ⇒ 00:21:32.385 Ryan Luke Daque: Sample AR is the first in the list to 60.9 4,

183 00:21:34.410 ⇒ 00:21:37.670 Ryan Luke Daque: but not to the sales for that state, for example.

184 00:21:39.080 ⇒ 00:21:43.560 Ryan Luke Daque: but that could be $300 in terms of sales.

185 00:21:43.680 ⇒ 00:21:44.700 Ryan Luke Daque: I see.

186 00:21:55.680 ⇒ 00:22:01.649 Ryan Luke Daque: So they want to see. And aside from the percentage, the sales

187 00:22:03.720 ⇒ 00:22:05.330 Ryan Luke Daque: mount as well.

188 00:22:08.350 ⇒ 00:22:12.679 Uttam Kumaran: I think 2 things. So one is can you share your screen? I can show you.

189 00:22:13.750 ⇒ 00:22:14.420 Ryan Luke Daque: Shares

190 00:22:31.010 ⇒ 00:22:32.060 Ryan Luke Daque: and see my screen.

191 00:22:34.360 ⇒ 00:22:35.410 Uttam Kumaran: Yeah.

192 00:22:35.740 ⇒ 00:22:42.860 Uttam Kumaran: so shipping is, a percent of sales is high here. But the I’m actually amount of shipping.

193 00:22:43.640 ⇒ 00:22:45.782 Ryan Luke Daque: Yeah. They wanna see them.

194 00:22:46.140 ⇒ 00:22:47.760 Uttam Kumaran: Not as sales is low.

195 00:22:49.630 ⇒ 00:22:56.467 Uttam Kumaran: So the one thing that we we need to decide on is how we can only show

196 00:22:57.130 ⇒ 00:22:59.950 Uttam Kumaran: certain states with like significant.

197 00:23:06.250 ⇒ 00:23:07.630 Ryan Luke Daque: Percentage you need.

198 00:23:08.972 ⇒ 00:23:13.817 Uttam Kumaran: Like, we should only show the top, like 20 States by sales. Here.

199 00:23:17.900 ⇒ 00:23:18.740 Ryan Luke Daque: Okay.

200 00:23:20.390 ⇒ 00:23:21.419 Uttam Kumaran: Do what I mean.

201 00:23:22.610 ⇒ 00:23:23.270 Ryan Luke Daque: Yeah.

202 00:23:25.230 ⇒ 00:23:26.359 Uttam Kumaran: Thank you. Michael.

203 00:23:28.480 ⇒ 00:23:33.239 Ryan Luke Daque: And I think they they might also want to see the actual value

204 00:23:34.630 ⇒ 00:23:35.540 Ryan Luke Daque: of

205 00:23:37.470 ⇒ 00:23:38.549 Ryan Luke Daque: of the State

206 00:23:39.500 ⇒ 00:23:40.270 Ryan Luke Daque: right

207 00:23:40.820 ⇒ 00:23:42.600 Ryan Luke Daque: sales value.

208 00:23:45.510 ⇒ 00:23:46.965 Uttam Kumaran: Yeah, I guess.

209 00:23:48.670 ⇒ 00:23:52.570 Uttam Kumaran: even this one. Maybe we can leave. But what’s the $400 units round.

210 00:23:54.180 ⇒ 00:23:56.280 Ryan Luke Daque: $400 units one.

211 00:23:57.200 ⇒ 00:24:00.810 Ryan Luke Daque: I think they just want to understand why.

212 00:24:01.570 ⇒ 00:24:05.300 Ryan Luke Daque: it seems to be very low. 400, you know, when it

213 00:24:05.480 ⇒ 00:24:06.410 Ryan Luke Daque: so.

214 00:24:12.130 ⇒ 00:24:20.129 Uttam Kumaran: Can we back into? Can we just like give him a Google spreadsheet of like the rows for a given week?

215 00:24:23.210 ⇒ 00:24:25.099 Ryan Luke Daque: Ship name. Let’s see.

216 00:24:26.210 ⇒ 00:24:28.061 Uttam Kumaran: And then let’s just confirm that

217 00:24:29.800 ⇒ 00:24:32.120 Uttam Kumaran: like these are.

218 00:24:32.180 ⇒ 00:24:34.809 Uttam Kumaran: I guess 2 things we can do. And

219 00:24:35.120 ⇒ 00:24:37.880 Uttam Kumaran: I’m just gonna I just put the notes here, and

220 00:24:41.620 ⇒ 00:24:43.069 Uttam Kumaran: this time

221 00:24:46.400 ⇒ 00:24:47.800 Uttam Kumaran: I’ll head back to the place.

222 00:25:04.520 ⇒ 00:25:05.250 Uttam Kumaran: So

223 00:25:05.970 ⇒ 00:25:09.979 Uttam Kumaran: one is to get all emails

224 00:25:10.440 ⇒ 00:25:11.100 Uttam Kumaran: ends.

225 00:25:12.580 ⇒ 00:25:13.580 Uttam Kumaran: Or

226 00:25:14.190 ⇒ 00:25:15.610 Uttam Kumaran: if it’s last week

227 00:25:16.480 ⇒ 00:25:17.910 Uttam Kumaran: one spreadsheet

228 00:25:19.000 ⇒ 00:25:22.550 Uttam Kumaran: also get all units

229 00:25:23.845 ⇒ 00:25:25.575 Uttam Kumaran: shipments from

230 00:25:27.853 ⇒ 00:25:29.280 Uttam Kumaran: from shopify.

231 00:25:31.530 ⇒ 00:25:33.289 Uttam Kumaran: and when she

232 00:25:33.870 ⇒ 00:25:38.680 Uttam Kumaran: and then I’m sure that the sum is paying a few 100 bucks.

233 00:26:08.020 ⇒ 00:26:08.750 Ryan Luke Daque: To.

234 00:26:09.140 ⇒ 00:26:09.900 Ryan Luke Daque: And it’s

235 00:26:21.980 ⇒ 00:26:25.119 Ryan Luke Daque: yeah. It looks like it’s 400 something.

236 00:26:25.900 ⇒ 00:26:28.140 Ryan Luke Daque: even if from the raw file.

237 00:26:29.020 ⇒ 00:26:29.950 Ryan Luke Daque: so it

238 00:26:32.100 ⇒ 00:26:33.410 Ryan Luke Daque: could be.

239 00:26:35.760 ⇒ 00:26:36.810 Uttam Kumaran: I think I mean, I’m

240 00:26:37.160 ⇒ 00:26:42.229 Uttam Kumaran: I assume we’re right. But I don’t know if you could just put all that into like one new

241 00:26:42.300 ⇒ 00:26:43.960 Uttam Kumaran: Google Sheet

242 00:26:44.310 ⇒ 00:26:48.337 Uttam Kumaran: like a whole new workbook that way. We could just send that to him and say, like, here’s everything.

243 00:26:49.370 ⇒ 00:26:50.339 Ryan Luke Daque: Like this, or.

244 00:26:50.340 ⇒ 00:26:51.879 Uttam Kumaran: You just pick one.

245 00:26:52.000 ⇒ 00:26:54.391 Uttam Kumaran: No, no, no meaning. I create a new.

246 00:26:55.320 ⇒ 00:26:56.120 Ryan Luke Daque: Right.

247 00:26:57.330 ⇒ 00:27:02.259 Uttam Kumaran: Like. I just sent the list in slack, which is just like, if you could take just take one week.

248 00:27:02.540 ⇒ 00:27:04.179 Uttam Kumaran: like all the unish shipments.

249 00:27:04.350 ⇒ 00:27:08.769 Uttam Kumaran: Take all of the shopify orders for that week, and we could just say, Hey, here’s everything for that one week.

250 00:27:08.940 ⇒ 00:27:10.819 Uttam Kumaran: showing that the data is accurate.

251 00:27:11.040 ⇒ 00:27:11.750 Ryan Luke Daque: And pay.

252 00:27:12.170 ⇒ 00:27:13.659 Ryan Luke Daque: So we can do.

253 00:27:15.180 ⇒ 00:27:17.970 Ryan Luke Daque: Like from the eighteenth.

254 00:27:19.050 ⇒ 00:27:20.910 Ryan Luke Daque: Oh, me! I mean.

255 00:27:22.140 ⇒ 00:27:25.179 Uttam Kumaran: I mean, let’s pick the let’s pick last week, because it’s the most

256 00:27:25.410 ⇒ 00:27:28.129 Uttam Kumaran: complete week. Right before the 20 s.

257 00:27:29.780 ⇒ 00:27:32.190 Ryan Luke Daque: Is this is this is just Monday to Friday

258 00:27:32.810 ⇒ 00:27:34.010 Ryan Luke Daque: or Sunday to.

259 00:27:34.924 ⇒ 00:27:39.040 Uttam Kumaran: I would just do 20 s until the 28.

260 00:27:39.040 ⇒ 00:27:41.930 Ryan Luke Daque: Okay, 2722, 28.

261 00:27:42.580 ⇒ 00:27:45.580 Ryan Luke Daque: I don’t think we have 28 yet.

262 00:27:46.250 ⇒ 00:27:50.389 Ryan Luke Daque: The newest we have is 26. I guess

263 00:27:52.660 ⇒ 00:27:53.710 Ryan Luke Daque: this nice.

264 00:28:30.080 ⇒ 00:28:30.730 Uttam Kumaran: It happened.

265 00:29:18.350 ⇒ 00:29:19.020 Uttam Kumaran: Think

266 00:29:24.050 ⇒ 00:29:26.100 Uttam Kumaran: it could just be my January.

267 00:29:26.430 ⇒ 00:29:27.190 Uttam Kumaran: Okay.

268 00:29:56.926 ⇒ 00:29:57.843 Uttam Kumaran: hey?

269 00:30:29.850 ⇒ 00:30:30.740 Uttam Kumaran: Okay.

270 00:30:31.490 ⇒ 00:30:34.395 Ryan Luke Daque: We have 55 or 4 55.

271 00:31:10.080 ⇒ 00:31:12.130 Ryan Luke Daque: We need to like

272 00:31:12.410 ⇒ 00:31:16.500 Ryan Luke Daque: great like a summary as well here in the Google Sheet.

273 00:31:16.840 ⇒ 00:31:17.780 Ryan Luke Daque: where it’s like the.

274 00:31:17.780 ⇒ 00:31:21.400 Uttam Kumaran: Yeah, that would be great, or like a piv like a just a pivot table or something.

275 00:31:26.630 ⇒ 00:31:41.949 Uttam Kumaran: I guess. I also, I I just wanna also confirm with like from the shopify side like these are all the like for that same week. Can you pull in all the shopify orders for those queues.

276 00:31:43.750 ⇒ 00:31:44.940 Uttam Kumaran: You see what I’m saying

277 00:31:47.890 ⇒ 00:31:51.409 Uttam Kumaran: that way. We can just show, like, hey, all the shopify orders

278 00:31:53.100 ⇒ 00:31:54.150 Uttam Kumaran: I’ll spend.

279 00:31:55.400 ⇒ 00:31:57.759 Uttam Kumaran: and these are the ones we got back from us.

280 00:32:00.790 ⇒ 00:32:03.309 Uttam Kumaran: Cause in from ship station.

281 00:32:03.990 ⇒ 00:32:06.559 Uttam Kumaran: Yeah, we’re we’re gonna know all the ones

282 00:32:06.830 ⇒ 00:32:09.770 Uttam Kumaran: and didn’t ship through ship station. Basically

283 00:32:11.320 ⇒ 00:32:12.790 Uttam Kumaran: with those skews.

284 00:32:20.470 ⇒ 00:32:21.160 Ryan Luke Daque: Hmm.

285 00:32:31.080 ⇒ 00:32:35.324 Uttam Kumaran: Yeah, I mean, I could make a bunch of changes to the Yaml cause it’s not

286 00:32:35.720 ⇒ 00:32:36.420 Uttam Kumaran: laugh.

287 00:33:37.110 ⇒ 00:33:37.800 Uttam Kumaran: Be popular.

288 00:33:41.110 ⇒ 00:33:42.290 Uttam Kumaran: laughing.

289 00:34:53.440 ⇒ 00:34:54.210 Patrick Trainer: Yo.

290 00:34:55.460 ⇒ 00:34:56.400 Uttam Kumaran: Loathe.

291 00:34:56.719 ⇒ 00:34:58.489 Patrick Trainer: What’s going on? Oh, sorry, Matt!

292 00:35:01.990 ⇒ 00:35:09.490 Uttam Kumaran: So so I got like a flurry of things from like Ben and Dan.

293 00:35:12.140 ⇒ 00:35:16.759 Uttam Kumaran: I guess. Long story short, one. I don’t know if they’re, I guess. Okay. So

294 00:35:17.030 ⇒ 00:35:18.558 Uttam Kumaran: I’m just starting from

295 00:35:19.390 ⇒ 00:35:35.099 Uttam Kumaran: graph that message me this morning. And I was kinda like, Okay, I think they just want updates on this. But then Dan sent me that long, like set of emails, basically, like where all these updates, I think parts of which have been done in that new copy

296 00:35:35.510 ⇒ 00:35:36.950 Uttam Kumaran: work in progress.

297 00:35:36.950 ⇒ 00:35:37.580 Patrick Trainer: Right.

298 00:35:37.950 ⇒ 00:35:43.880 Uttam Kumaran: But also I think they’re overall just like we only receive like 2 weeks on dashboards.

299 00:35:45.150 ⇒ 00:35:45.740 Uttam Kumaran: So

300 00:35:47.970 ⇒ 00:35:49.640 Uttam Kumaran: one is like

301 00:35:49.830 ⇒ 00:35:52.499 Uttam Kumaran: one. We should try to complete all these.

302 00:35:53.180 ⇒ 00:35:58.900 Uttam Kumaran: I believe, tomorrow, which I think it’s a lot really comfortable with 2 like, I think we’re really at risk of losing

303 00:35:59.400 ⇒ 00:36:03.070 Uttam Kumaran: like them funding these the dashboard side of stuff.

304 00:36:04.420 ⇒ 00:36:06.330 Uttam Kumaran: So I think

305 00:36:06.970 ⇒ 00:36:11.080 Uttam Kumaran: I mean one. I think we really need to bear. Hug this for a little bit.

306 00:36:11.516 ⇒ 00:36:14.449 Uttam Kumaran: Cause. I know we kind of ran into the same issue

307 00:36:14.620 ⇒ 00:36:37.970 Uttam Kumaran: like a few months ago, when there was kind of just like delays, and I think there was just lag between like us, communicating and getting back to them. And this one, too, I think, like we have, like, you know, 2, 3 weeks of like good momentum, and then like 2 weeks of doing a period of period stuff. And I think making these changes. But it’s clear that one they’re looking at like an old version, and then 2, I think just waiting on the period stuff

308 00:36:38.050 ⇒ 00:36:39.120 Uttam Kumaran: I am.

309 00:36:39.150 ⇒ 00:36:46.350 Uttam Kumaran: I mean, I think most likely I think overall. It’s just like we just need to get on a better cadence for communication and

310 00:36:46.410 ⇒ 00:36:51.639 Uttam Kumaran: delivering this stuff to them. I know you’ve been working on a ton of stuff where you have access into Stella. So it’s

311 00:36:51.800 ⇒ 00:36:54.619 Uttam Kumaran: it’s not like entirely on you.

312 00:36:55.510 ⇒ 00:36:56.400 Uttam Kumaran: Bye.

313 00:36:57.060 ⇒ 00:36:59.560 Uttam Kumaran: yeah, basically, like.

314 00:36:59.580 ⇒ 00:37:05.899 Uttam Kumaran: I think we just need to try to get for short term. We really need to try to get some of this by tomorrow.

315 00:37:06.310 ⇒ 00:37:08.549 Uttam Kumaran: Is that a lot sometime?

316 00:37:08.930 ⇒ 00:37:13.969 Uttam Kumaran: But the second thing is, we need to think a little bit longer term about like how we’re going to make sure that.

317 00:37:14.000 ⇒ 00:37:16.849 Uttam Kumaran: And and that’s what the business is getting

318 00:37:17.010 ⇒ 00:37:18.679 Uttam Kumaran: like. Dashboard log

319 00:37:21.120 ⇒ 00:37:22.080 Uttam Kumaran: that.

320 00:37:22.220 ⇒ 00:37:23.589 Uttam Kumaran: Yeah. What do you think.

321 00:37:26.990 ⇒ 00:37:30.239 Patrick Trainer: I mean, I agree, I think.

322 00:37:30.936 ⇒ 00:37:34.249 Patrick Trainer: part of it got slipped by the wayside, and I think there’s

323 00:37:34.510 ⇒ 00:37:42.104 Patrick Trainer: there is like a lag between, I guess, like our communication and and and Dan as well, or at least Dan especially

324 00:37:42.580 ⇒ 00:37:44.213 Patrick Trainer: I think,

325 00:37:45.100 ⇒ 00:37:47.689 Patrick Trainer: like the first kind of like correspondence

326 00:37:47.870 ⇒ 00:37:53.039 Patrick Trainer: took, like, I think, 2 weeks from from his side, and then was like, Oh, I finally

327 00:37:53.270 ⇒ 00:37:57.310 Patrick Trainer: looked at it and did that but then afterwards we

328 00:37:57.460 ⇒ 00:38:01.140 Patrick Trainer: had the discussion of

329 00:38:02.550 ⇒ 00:38:05.970 Patrick Trainer: the like, the new dashboard, and like he liked it, approved.

330 00:38:05.990 ⇒ 00:38:08.319 Patrick Trainer: Then we have the the logic.

331 00:38:08.430 ⇒ 00:38:11.230 Patrick Trainer: The last part of it is

332 00:38:11.330 ⇒ 00:38:14.090 Patrick Trainer: like, I said this morning is just the moving

333 00:38:14.200 ⇒ 00:38:14.780 Patrick Trainer: of.

334 00:38:15.410 ⇒ 00:38:17.229 Patrick Trainer: That logic on those

335 00:38:17.250 ⇒ 00:38:19.540 Patrick Trainer: month over month, tiles.

336 00:38:21.480 ⇒ 00:38:31.409 Uttam Kumaran: Yeah. So I think we can do that. And I, actually, I like, I think I just need to make a couple of changes to the light dash camera, I guess overall one is, I think.

337 00:38:31.860 ⇒ 00:38:36.580 Uttam Kumaran: are we confirmed that, like he was just probably looking at that older version of the dashboard.

338 00:38:37.150 ⇒ 00:38:44.570 Patrick Trainer: So when you go, yeah, when you go to the like, the old vital signs, I think. Like that edit.

339 00:38:44.988 ⇒ 00:38:46.930 Patrick Trainer: There, that’s in the title.

340 00:38:46.940 ⇒ 00:38:49.940 Patrick Trainer: It does show the top customers in there.

341 00:38:51.150 ⇒ 00:38:56.790 Uttam Kumaran: Yeah. So so there’s old, there’s new. And then there’s a work in progress. So the new one, I actually just removed

342 00:38:57.380 ⇒ 00:39:02.040 Uttam Kumaran: customers. But then the one you sent was work in progress, copy.

343 00:39:02.440 ⇒ 00:39:03.500 Patrick Trainer: Right? Yeah, the.

344 00:39:03.500 ⇒ 00:39:06.830 Uttam Kumaran: Actually actually work in progress copy. So I don’t think he has access to that.

345 00:39:07.250 ⇒ 00:39:08.429 Uttam Kumaran: Well, he’s not seeing that.

346 00:39:10.020 ⇒ 00:39:10.850 Patrick Trainer: Okay.

347 00:39:12.280 ⇒ 00:39:13.389 Uttam Kumaran: You see what I’m saying?

348 00:39:13.390 ⇒ 00:39:16.209 Patrick Trainer: Yeah, I think. Well, then, that’s probably where

349 00:39:17.030 ⇒ 00:39:18.800 Patrick Trainer: wires are getting cross.

350 00:39:19.820 ⇒ 00:39:23.556 Uttam Kumaran: So one thing we can do right now is, let’s

351 00:39:24.170 ⇒ 00:39:26.100 Uttam Kumaran: I’m gonna go ahead and just

352 00:39:26.770 ⇒ 00:39:32.814 Uttam Kumaran: let’s just make this say, like work in progress like, let’s just call this like work in progress.

353 00:39:33.200 ⇒ 00:39:34.506 Uttam Kumaran: Vital signs.

354 00:39:36.850 ⇒ 00:39:40.159 Uttam Kumaran: Alright, and then I’m I think one thing we can do is like

355 00:39:40.750 ⇒ 00:39:41.660 Uttam Kumaran: we can.

356 00:39:42.460 ⇒ 00:39:55.539 Uttam Kumaran: I think we should try right now just to fix as much as we can. And then I’m gonna send it to him and say, like, Oh, you’re looking at a wrong version. Basically, because in here, in here, we there’s actually like a bunch of changes that he asked for.

357 00:39:55.550 ⇒ 00:39:56.930 Uttam Kumaran: Let’s

358 00:39:57.690 ⇒ 00:39:59.190 Uttam Kumaran: try and do that.

359 00:39:59.710 ⇒ 00:40:09.269 Patrick Trainer: Right? Yeah, I was gonna say, because, like my, my last conversation with them was like everything checked out so like the him saying like

360 00:40:09.350 ⇒ 00:40:13.579 Patrick Trainer: requested this months ago. It’s like, but he’s misremembering.

361 00:40:14.160 ⇒ 00:40:17.750 Uttam Kumaran: Yeah, yeah, yeah, and that’s fine. I just like, I think, like.

362 00:40:18.060 ⇒ 00:40:33.265 Uttam Kumaran: I’m actually, I’m actually really happy that we have this new version. Because I’ll basically we’ll just say that, hey, you’re actually looking at the older version, the stuff for shipping we can get to separately. But can we try and make these changes for the period over period. Stuff.

363 00:40:34.261 ⇒ 00:40:39.860 Uttam Kumaran: One thing I’m gonna do now is I don’t see that period over period table in light dash.

364 00:40:39.890 ⇒ 00:40:42.230 Uttam Kumaran: So I’m going to just push the Pr.

365 00:40:42.340 ⇒ 00:40:47.439 Uttam Kumaran: To get it into light dash, because I think the gamble just needs a little bit of modification.

366 00:40:47.440 ⇒ 00:40:49.579 Patrick Trainer: Right. I think the yaml

367 00:40:51.645 ⇒ 00:40:56.300 Patrick Trainer: might just need the. There’s like a prod tag right.

368 00:40:58.440 ⇒ 00:41:15.100 Uttam Kumaran: There is a pro tag. But actually, I’m just I think some of the the columns themselves have pro tags. I’m just gonna rerun like a Dbt. Run on it right now and then. Just get it in there and then. We can each cause I know it’s gonna probably take some time for us to go through, so we can each just like

369 00:41:15.500 ⇒ 00:41:16.790 Uttam Kumaran: tagging that

370 00:41:18.760 ⇒ 00:41:26.119 Uttam Kumaran: Ryan is working on the stuff for shipping. But there are a couple of like shipping related

371 00:41:26.530 ⇒ 00:41:30.469 Uttam Kumaran: updates. There, if you wanna take a look at that while I just like wrap this up

372 00:41:33.440 ⇒ 00:41:36.999 Patrick Trainer: Yeah. Okay, yeah. I have all

373 00:41:38.510 ⇒ 00:41:40.639 Patrick Trainer: all orders over. Period.

374 00:41:41.920 ⇒ 00:41:42.820 Patrick Trainer: Yamall.

375 00:41:43.350 ⇒ 00:41:46.289 Patrick Trainer: yeah. And it’s got all the prod configs.

376 00:41:47.490 ⇒ 00:41:53.080 Uttam Kumaran: Yeah, you only, but you only need to do prod prod is for the model itself, not for the

377 00:41:54.400 ⇒ 00:41:55.530 Uttam Kumaran: each call.

378 00:41:57.725 ⇒ 00:41:58.680 Patrick Trainer: Okay.

379 00:41:58.890 ⇒ 00:42:04.119 Uttam Kumaran: Yeah, let me just run. I’ll just run it. I’ll just run and refresh it real quick. It’ll it’ll just take me a sec.

380 00:42:04.120 ⇒ 00:42:05.490 Patrick Trainer: Okay. Awesome.

381 00:42:15.820 ⇒ 00:42:20.269 Uttam Kumaran: Yeah, he said. Top product sold, do we get? We got rid of that or what happened with that.

382 00:42:23.310 ⇒ 00:42:24.090 Patrick Trainer: Go back.

383 00:42:26.240 ⇒ 00:42:30.620 Uttam Kumaran: I mean, I guess that maybe it wasn’t. And so I think that

384 00:42:30.670 ⇒ 00:42:33.879 Uttam Kumaran: we should talk about. And then also, we should definitely put something just basic.

385 00:42:35.540 ⇒ 00:42:36.410 Patrick Trainer: We should, what.

386 00:42:37.380 ⇒ 00:42:41.119 Uttam Kumaran: We should put something in the placeholder like the Laura that said, You’re right.

387 00:42:46.810 ⇒ 00:42:48.490 Patrick Trainer: Top product sold.

388 00:42:50.070 ⇒ 00:42:52.340 Uttam Kumaran: I think that that was in the

389 00:42:52.790 ⇒ 00:42:54.320 Uttam Kumaran: the existing new.

390 00:42:56.070 ⇒ 00:43:01.010 Uttam Kumaran: the one I’m gonna just yeah, that was that’s in the existing new

391 00:43:01.400 ⇒ 00:43:03.000 Uttam Kumaran: on the work in progress.

392 00:43:03.820 ⇒ 00:43:04.450 Patrick Trainer: Okay.

393 00:43:06.150 ⇒ 00:43:09.655 Uttam Kumaran: But again, like, if you guys didn’t talk about it, and maybe you just asked to delete that.

394 00:43:11.510 ⇒ 00:43:12.610 Patrick Trainer: Yeah, I don’t

395 00:43:15.280 ⇒ 00:43:17.560 Patrick Trainer: feel like going back through

396 00:43:18.412 ⇒ 00:43:20.890 Patrick Trainer: whatever it might be. But okay.

397 00:43:22.460 ⇒ 00:43:24.140 Patrick Trainer: let’s see.

398 00:43:32.190 ⇒ 00:43:34.219 Patrick Trainer: this is like the same problem.

399 00:43:34.800 ⇒ 00:43:36.420 Patrick Trainer: I feel like that all

400 00:43:36.900 ⇒ 00:43:42.529 Patrick Trainer: dashboarding things have in common where, like you just click copy, and then it.

401 00:44:00.810 ⇒ 00:44:02.769 Uttam Kumaran: Okay. Almost done.

402 00:44:16.230 ⇒ 00:44:20.710 Ryan Luke Daque: I just sent you the number sheet put down for the newest shipments for last week.

403 00:44:20.990 ⇒ 00:44:21.700 Patrick Trainer: On!

404 00:44:22.060 ⇒ 00:44:23.230 Ryan Luke Daque: And

405 00:44:23.370 ⇒ 00:44:24.710 Ryan Luke Daque: should have all of

406 00:44:25.100 ⇒ 00:44:28.180 Ryan Luke Daque: it also has a summary

407 00:44:28.700 ⇒ 00:44:29.570 Ryan Luke Daque: tab.

408 00:44:29.780 ⇒ 00:44:34.089 Ryan Luke Daque: It shows, like the shipping cost per day for last week.

409 00:44:35.520 ⇒ 00:44:36.560 Ryan Luke Daque: and

410 00:44:37.820 ⇒ 00:44:39.800 Ryan Luke Daque: the shopify orders that are

411 00:44:40.580 ⇒ 00:44:42.170 Ryan Luke Daque: related to those

412 00:44:42.430 ⇒ 00:44:43.650 Ryan Luke Daque: shipping costs.

413 00:44:48.578 ⇒ 00:44:55.280 Ryan Luke Daque: The other one he was looking at he wanted to look at is shipping

414 00:45:08.338 ⇒ 00:45:11.490 Ryan Luke Daque: February, and that’s short.

415 00:45:12.950 ⇒ 00:45:14.849 Ryan Luke Daque: Says it’s too, birdie.

416 00:45:16.860 ⇒ 00:45:17.640 Ryan Luke Daque: paint.

417 00:45:22.950 ⇒ 00:45:24.660 Ryan Luke Daque: rename this 7.

418 00:45:35.650 ⇒ 00:45:36.830 Uttam Kumaran: Got anything else

419 00:46:13.230 ⇒ 00:46:14.370 Uttam Kumaran: for some more

420 00:46:14.750 ⇒ 00:46:15.550 Uttam Kumaran: estimate

421 00:46:34.650 ⇒ 00:46:35.410 Uttam Kumaran: office.

422 00:46:35.850 ⇒ 00:46:37.110 Uttam Kumaran: That’s the piece

423 00:46:57.310 ⇒ 00:46:58.579 Uttam Kumaran: shares for singing.

424 00:47:01.502 ⇒ 00:47:03.460 Uttam Kumaran: Wait a minute.

425 00:47:03.460 ⇒ 00:47:06.379 Patrick Trainer: I’m adding top products sold.

426 00:47:14.640 ⇒ 00:47:15.450 Uttam Kumaran: Number.

427 00:47:18.510 ⇒ 00:47:20.710 Uttam Kumaran: So numbers

428 00:47:28.310 ⇒ 00:47:31.239 Uttam Kumaran: number number number

429 00:47:33.510 ⇒ 00:47:36.590 Uttam Kumaran: metric is where accounts

430 00:47:42.030 ⇒ 00:47:42.690 Uttam Kumaran: have

431 00:47:46.390 ⇒ 00:47:49.319 Uttam Kumaran: account admission type number in the trip.

432 00:48:07.630 ⇒ 00:48:08.550 Uttam Kumaran: Believe?

433 00:48:21.420 ⇒ 00:48:22.690 Uttam Kumaran: Okay.

434 00:48:27.360 ⇒ 00:48:29.375 Uttam Kumaran: let’s put it today.

435 00:48:37.000 ⇒ 00:48:43.440 Uttam Kumaran: So pat. All the is is current. Month is current month to date, that’s all. Boolean values right? Like 0 1.

436 00:48:43.440 ⇒ 00:48:44.200 Patrick Trainer: Correct.

437 00:48:48.300 ⇒ 00:48:49.580 Uttam Kumaran: Hey?

438 00:48:50.900 ⇒ 00:48:53.060 Uttam Kumaran: Alright! Let’s push this

439 00:49:18.170 ⇒ 00:49:20.300 Uttam Kumaran: alright. This is running

440 00:49:31.440 ⇒ 00:49:32.150 Uttam Kumaran: damn

441 00:49:50.510 ⇒ 00:49:51.210 Uttam Kumaran: roof

442 00:50:42.700 ⇒ 00:50:43.730 Uttam Kumaran: right now

443 00:50:50.990 ⇒ 00:50:52.310 Uttam Kumaran: to that, really.

444 00:51:02.380 ⇒ 00:51:03.220 Uttam Kumaran: and ask

445 00:51:05.400 ⇒ 00:51:06.450 Uttam Kumaran: so

446 00:51:06.690 ⇒ 00:51:07.805 Uttam Kumaran: discounts

447 00:51:13.235 ⇒ 00:51:16.100 Uttam Kumaran: shipping cost discount

448 00:51:17.530 ⇒ 00:51:18.819 Uttam Kumaran: tomorrow he’s up.

449 00:51:21.030 ⇒ 00:51:22.230 Uttam Kumaran: Turn me.

450 00:51:26.220 ⇒ 00:51:26.910 Uttam Kumaran: Look

451 00:52:00.830 ⇒ 00:52:01.490 Uttam Kumaran: now.

452 00:52:24.200 ⇒ 00:52:24.870 Uttam Kumaran: this

453 00:52:31.220 ⇒ 00:52:32.080 Uttam Kumaran: okay

454 00:52:36.570 ⇒ 00:52:38.870 Uttam Kumaran: ship dates.

455 00:52:42.890 ⇒ 00:52:43.819 Uttam Kumaran: Send it to

456 00:52:52.500 ⇒ 00:52:56.139 Uttam Kumaran: quoted cost discounts.

457 00:53:02.020 ⇒ 00:53:04.360 Uttam Kumaran: discounts.

458 00:53:06.240 ⇒ 00:53:08.120 Uttam Kumaran: billing cause

459 00:53:13.180 ⇒ 00:53:14.320 Uttam Kumaran: nonprofits.

460 00:53:15.010 ⇒ 00:53:17.989 Patrick Trainer: Adam, you’re working on the all orders of a period.

461 00:53:18.340 ⇒ 00:53:22.123 Uttam Kumaran: Yeah, so pr, but

462 00:53:23.110 ⇒ 00:53:23.810 Uttam Kumaran: to cover.

463 00:53:23.810 ⇒ 00:53:25.520 Patrick Trainer: Yeah, I think all that

464 00:53:25.860 ⇒ 00:53:27.940 Patrick Trainer: is all that you added in. We’re like.

465 00:53:28.030 ⇒ 00:53:30.949 Patrick Trainer: got it in total sales. Cogs discount.

466 00:53:31.480 ⇒ 00:53:33.270 Uttam Kumaran: Yeah, if you

467 00:53:34.520 ⇒ 00:53:36.090 Uttam Kumaran: well, if you look at it.

468 00:53:36.190 ⇒ 00:53:37.820 Uttam Kumaran: are you seeing the Pr.

469 00:53:38.165 ⇒ 00:53:39.889 Patrick Trainer: No, not yet! Hold on!

470 00:53:41.980 ⇒ 00:53:49.480 Uttam Kumaran: I actually didn’t actually do need to do that. I didn’t add any of those. I just was checking that the structure was there?

471 00:53:50.572 ⇒ 00:53:54.660 Uttam Kumaran: But we could. We should do that. Actually, I didn’t know it wasn’t there.

472 00:53:56.216 ⇒ 00:53:58.639 Patrick Trainer: Let’s see files chain.

473 00:54:00.050 ⇒ 00:54:01.679 Patrick Trainer: Oh, I see what you’re saying.

474 00:54:01.870 ⇒ 00:54:04.475 Uttam Kumaran: Oh, so we were from all orders.

475 00:54:05.420 ⇒ 00:54:07.839 Uttam Kumaran: okay, okay, yeah. I can modify and do that.

476 00:54:08.308 ⇒ 00:54:10.819 Uttam Kumaran: I was just checking that this slide.

477 00:54:10.820 ⇒ 00:54:12.710 Patrick Trainer: So you, you see, or

478 00:54:12.920 ⇒ 00:54:15.369 Patrick Trainer: here, let’s see if I can share

479 00:54:15.840 ⇒ 00:54:16.650 Patrick Trainer: this.

480 00:54:17.350 ⇒ 00:54:20.180 Uttam Kumaran: So could not reach Snowflake. Issue

481 00:54:23.130 ⇒ 00:54:23.810 Uttam Kumaran: feels good.

482 00:54:25.810 ⇒ 00:54:28.870 Patrick Trainer: Alright, so like

483 00:54:29.400 ⇒ 00:54:30.680 Patrick Trainer: over.

484 00:54:31.400 ⇒ 00:54:35.240 Patrick Trainer: So th, so this is all orders over period right here.

485 00:54:35.520 ⇒ 00:54:36.250 Patrick Trainer: right.

486 00:54:36.460 ⇒ 00:54:37.130 Uttam Kumaran: Yeah.

487 00:54:37.270 ⇒ 00:54:42.610 Patrick Trainer: And so what we’re doing, we’ve got a we’re selecting from all orders.

488 00:54:42.890 ⇒ 00:54:50.129 Patrick Trainer: And so this is the normal daily Kpi app. And then everything selects from all orders as well.

489 00:54:50.722 ⇒ 00:55:00.520 Patrick Trainer: And so what what is going on here is like? It’s taking an order. Id. Instead, it’s just adding a one for a row, for an order.

490 00:55:00.520 ⇒ 00:55:01.239 Uttam Kumaran: As well. Yeah.

491 00:55:01.240 ⇒ 00:55:08.474 Patrick Trainer: As the order count. And then here, because we already like these are already values, not ids.

492 00:55:08.990 ⇒ 00:55:12.420 Patrick Trainer: We should just be able to add in like

493 00:55:13.620 ⇒ 00:55:14.450 Patrick Trainer: whoops

494 00:55:15.040 ⇒ 00:55:15.800 Patrick Trainer: like

495 00:55:16.490 ⇒ 00:55:18.069 Patrick Trainer: total sales.

496 00:55:20.710 ⇒ 00:55:22.130 Patrick Trainer: We’ll do that

497 00:55:22.140 ⇒ 00:55:23.200 Patrick Trainer: total.

498 00:55:24.240 ⇒ 00:55:24.760 Patrick Trainer: But.

499 00:55:24.760 ⇒ 00:55:27.930 Uttam Kumaran: What about? What about? How does a grouping happen?

500 00:55:29.830 ⇒ 00:55:31.689 Patrick Trainer: So this is

501 00:55:31.760 ⇒ 00:55:33.779 Patrick Trainer: the the grouping

502 00:55:34.220 ⇒ 00:55:36.139 Patrick Trainer: happens in the

503 00:55:38.950 ⇒ 00:55:41.520 Patrick Trainer: in, in, like, in the bi tool.

504 00:55:41.900 ⇒ 00:55:44.659 Patrick Trainer: And so what this is going to create

505 00:55:46.390 ⇒ 00:55:49.890 Patrick Trainer: is like something that you can sum in the Bi tool.

506 00:55:50.190 ⇒ 00:55:51.380 Patrick Trainer: And so

507 00:55:51.930 ⇒ 00:55:57.220 Patrick Trainer: this is like the order count on each day. This is the the sum of

508 00:55:57.520 ⇒ 00:55:58.370 Patrick Trainer: what you’re gonna call it.

509 00:55:58.370 ⇒ 00:55:59.900 Uttam Kumaran: Oh, each day.

510 00:56:00.568 ⇒ 00:56:03.499 Uttam Kumaran: but all orders isn’t at the day.

511 00:56:04.420 ⇒ 00:56:11.189 Patrick Trainer: No, so it only has. It only has rows for days that there was an order.

512 00:56:11.370 ⇒ 00:56:12.240 Uttam Kumaran: Okay.

513 00:56:12.240 ⇒ 00:56:14.280 Patrick Trainer: And so what this is doing.

514 00:56:14.865 ⇒ 00:56:17.390 Patrick Trainer: It’s creating this like calendar

515 00:56:17.730 ⇒ 00:56:18.780 Patrick Trainer: table

516 00:56:19.060 ⇒ 00:56:22.330 Patrick Trainer: and then joining that on

517 00:56:22.780 ⇒ 00:56:24.250 Patrick Trainer: every date.

518 00:56:27.000 ⇒ 00:56:27.760 Ryan Luke Daque: Right.

519 00:56:27.970 ⇒ 00:56:31.770 Patrick Trainer: We’re on on the calendar. And so and so we get

520 00:56:32.160 ⇒ 00:56:33.799 Patrick Trainer: every single date.

521 00:56:34.180 ⇒ 00:56:37.269 Patrick Trainer: regardless of if there was an order or not.

522 00:56:37.640 ⇒ 00:56:38.340 Patrick Trainer: Okay.

523 00:56:39.520 ⇒ 00:56:42.407 Uttam Kumaran: So if I could just go, I’ll just go in there and add,

524 00:56:44.950 ⇒ 00:56:47.599 Uttam Kumaran: I’ll just go in and add each of those columns

525 00:56:47.740 ⇒ 00:56:48.940 Uttam Kumaran: eyes.

526 00:56:51.290 ⇒ 00:56:52.500 Ryan Luke Daque: Dimension.

527 00:56:53.220 ⇒ 00:56:55.150 Uttam Kumaran: Yeah, it’s just the column name. So let me go. Do.

528 00:56:55.150 ⇒ 00:56:59.279 Patrick Trainer: Right? Right? Yeah. And so year, month and day.

529 00:56:59.670 ⇒ 00:57:02.460 Patrick Trainer: and then, like the is current

530 00:57:02.480 ⇒ 00:57:06.849 Patrick Trainer: like, or your month and day and date become dimensions.

531 00:57:06.870 ⇒ 00:57:11.540 Patrick Trainer: order, count, and all the other things become the aggregations.

532 00:57:12.100 ⇒ 00:57:17.200 Patrick Trainer: and then is current. Month is current, month to date, or just filters.

533 00:57:18.520 ⇒ 00:57:21.450 Uttam Kumaran: So then how would I do something like W. How I do something like

534 00:57:23.190 ⇒ 00:57:24.060 Uttam Kumaran: Quantity

535 00:57:25.050 ⇒ 00:57:25.720 Uttam Kumaran: like.

536 00:57:25.720 ⇒ 00:57:26.920 Patrick Trainer: Quantity.

537 00:57:26.920 ⇒ 00:57:28.689 Uttam Kumaran: It’s like quantity of orders.

538 00:57:30.365 ⇒ 00:57:33.930 Patrick Trainer: Well, so would that be like total orders?

539 00:57:35.016 ⇒ 00:57:38.939 Patrick Trainer: Okay? So like what you would do then it’d be like.

540 00:57:38.960 ⇒ 00:57:40.200 Patrick Trainer: select

541 00:57:41.887 ⇒ 00:57:47.830 Patrick Trainer: or you could do like select sum of order, count as total orders

542 00:57:48.090 ⇒ 00:57:49.840 Patrick Trainer: from whatever this

543 00:57:49.890 ⇒ 00:57:53.150 Patrick Trainer: table and then like. If we’re looking for

544 00:57:53.160 ⇒ 00:57:54.450 Patrick Trainer: this month’s

545 00:57:54.680 ⇒ 00:57:56.960 Patrick Trainer: current orders, we can do that.

546 00:57:57.070 ⇒ 00:58:00.549 Patrick Trainer: or we could do like is

547 00:58:00.810 ⇒ 00:58:02.160 Patrick Trainer: current month to date.

548 00:58:02.160 ⇒ 00:58:02.970 Uttam Kumaran: Okay.

549 00:58:02.970 ⇒ 00:58:05.440 Patrick Trainer: One, or

550 00:58:06.395 ⇒ 00:58:07.330 Patrick Trainer: where.

551 00:58:07.330 ⇒ 00:58:08.149 Uttam Kumaran: Each other.

552 00:58:09.140 ⇒ 00:58:12.659 Patrick Trainer: Is previous month to date

553 00:58:12.880 ⇒ 00:58:14.250 Patrick Trainer: equals one.

554 00:58:15.350 ⇒ 00:58:19.210 Patrick Trainer: and then and then you can like group by that. But then we could also.

555 00:58:19.580 ⇒ 00:58:21.069 Patrick Trainer: like select

556 00:58:21.160 ⇒ 00:58:23.095 Patrick Trainer: from like

557 00:58:24.130 ⇒ 00:58:25.900 Patrick Trainer: we can sum the

558 00:58:27.250 ⇒ 00:58:28.450 Patrick Trainer: a.

559 00:58:28.760 ⇒ 00:58:30.199 Uttam Kumaran: Oh, I see. Okay.

560 00:58:30.200 ⇒ 00:58:34.009 Patrick Trainer: Like. If we, if we added in like total sales.

561 00:58:35.180 ⇒ 00:58:37.150 Patrick Trainer: it’ll be that total sales

562 00:58:38.260 ⇒ 00:58:39.560 Patrick Trainer: for that day.

563 00:58:40.170 ⇒ 00:58:41.270 Patrick Trainer: and then

564 00:58:41.340 ⇒ 00:58:45.399 Patrick Trainer: or for that each individual day. And then here we can sum

565 00:58:47.370 ⇒ 00:58:48.570 Patrick Trainer: total sales.

566 00:58:49.060 ⇒ 00:58:49.660 Uttam Kumaran: Okay.

567 00:58:50.715 ⇒ 00:58:51.290 Patrick Trainer: And

568 00:58:51.400 ⇒ 00:58:54.809 Patrick Trainer: so like, because aggregations happen

569 00:58:55.090 ⇒ 00:58:57.709 Patrick Trainer: in the bi tool instead of here.

570 00:58:58.820 ⇒ 00:59:02.370 Patrick Trainer: we want to have all the data at a

571 00:59:02.600 ⇒ 00:59:11.249 Patrick Trainer: date level grain. And so now this enables us to roll up and roll down a as we need.

572 00:59:14.530 ⇒ 00:59:17.410 Uttam Kumaran: Okay, so let me so

573 00:59:18.000 ⇒ 00:59:21.040 Uttam Kumaran: I can share. Let me just share this

574 00:59:22.450 ⇒ 00:59:23.140 Uttam Kumaran: to show

575 00:59:23.400 ⇒ 00:59:24.170 Uttam Kumaran: the next one.

576 00:59:25.475 ⇒ 00:59:29.830 Uttam Kumaran: So right now, what I’ll do is, I just have these like here.

577 00:59:32.150 ⇒ 00:59:34.040 Uttam Kumaran: and then I’ll just bring these down

578 00:59:34.960 ⇒ 00:59:36.640 Uttam Kumaran: here. Yep.

579 00:59:38.330 ⇒ 00:59:40.969 Uttam Kumaran: So the only things that we’re missing

580 00:59:41.420 ⇒ 00:59:42.600 Uttam Kumaran: are

581 00:59:42.730 ⇒ 00:59:46.020 Uttam Kumaran: like the marketing related things which are coming from

582 00:59:46.310 ⇒ 00:59:48.269 Uttam Kumaran: combined marketing performance.

583 00:59:50.120 ⇒ 00:59:51.090 Patrick Trainer: Eee.

584 00:59:51.090 ⇒ 00:59:54.689 Uttam Kumaran: What like we need that to do profit?

585 00:59:55.649 ⇒ 00:59:58.880 Uttam Kumaran: So one thing I could do is I can just make another.

586 00:59:59.350 ⇒ 01:00:02.499 Uttam Kumaran: Should I just make another Ct and join on

587 01:00:02.540 ⇒ 01:00:03.609 Uttam Kumaran: and join.

588 01:00:04.040 ⇒ 01:00:04.840 Uttam Kumaran: Yeah.

589 01:00:05.140 ⇒ 01:00:06.129 Patrick Trainer: Yeah, that would work.

590 01:00:07.286 ⇒ 01:00:08.720 Patrick Trainer: You would

591 01:00:09.290 ⇒ 01:00:10.490 Patrick Trainer: rep orders.

592 01:00:10.490 ⇒ 01:00:11.969 Uttam Kumaran: Take this

593 01:00:12.880 ⇒ 01:00:13.880 Uttam Kumaran: basically.

594 01:00:14.880 ⇒ 01:00:24.240 Patrick Trainer: Yeah, take that, basically. Yeah. And then create the cte that selects from the combined marketing. Yup, Yup, yup, yup! And then.

595 01:00:26.880 ⇒ 01:00:28.609 Patrick Trainer: you can.

596 01:00:30.400 ⇒ 01:00:37.589 Patrick Trainer: yeah, put in all of the like. Total marketing cost or or cost impressions. Clicks.

597 01:00:38.336 ⇒ 01:00:39.449 Patrick Trainer: And then.

598 01:00:40.620 ⇒ 01:00:46.509 Patrick Trainer: yeah, then then the join will already be in there with the like. The order date in the calendar.

599 01:00:47.430 ⇒ 01:00:51.412 Uttam Kumaran: Okay, so I would need total

600 01:00:52.130 ⇒ 01:00:54.560 Uttam Kumaran: marketing cost

601 01:00:55.430 ⇒ 01:00:56.520 Uttam Kumaran: total

602 01:00:56.640 ⇒ 01:00:58.869 Uttam Kumaran: works. So for here.

603 01:01:00.160 ⇒ 01:01:01.045 Uttam Kumaran: okay.

604 01:01:02.720 ⇒ 01:01:03.385 Uttam Kumaran: but

605 01:01:08.090 ⇒ 01:01:08.465 Uttam Kumaran: yeah.

606 01:01:11.720 ⇒ 01:01:12.580 Uttam Kumaran: and

607 01:01:13.830 ⇒ 01:01:16.740 Uttam Kumaran: do is here. We’ll do daily

608 01:01:17.180 ⇒ 01:01:18.120 Uttam Kumaran: order

609 01:01:20.330 ⇒ 01:01:21.230 Uttam Kumaran: data.

610 01:01:24.664 ⇒ 01:01:27.560 Uttam Kumaran: Oh, okay, let’s see.

611 01:01:27.843 ⇒ 01:01:29.830 Patrick Trainer: Yeah, you could join on the day.

612 01:01:39.750 ⇒ 01:01:40.440 Uttam Kumaran: Earth

613 01:01:45.480 ⇒ 01:01:46.140 Uttam Kumaran: yep.

614 01:01:49.130 ⇒ 01:01:50.439 Patrick Trainer: Might be date.

615 01:01:56.430 ⇒ 01:01:57.679 Uttam Kumaran: Which is changing

616 01:01:57.790 ⇒ 01:01:58.570 Uttam Kumaran: us.

617 01:01:58.570 ⇒ 01:02:01.730 Patrick Trainer: And we should probably change that name.

618 01:02:01.730 ⇒ 01:02:02.470 Uttam Kumaran: And here

619 01:02:02.580 ⇒ 01:02:03.280 Uttam Kumaran: in marketing.

620 01:02:04.770 ⇒ 01:02:06.639 Uttam Kumaran: Oh, you think it’s gonna get screwed up.

621 01:02:06.640 ⇒ 01:02:09.770 Patrick Trainer: Yeah, I think, yeah, date just being a reserved word.

622 01:02:10.700 ⇒ 01:02:11.330 Uttam Kumaran: I’d like to.

623 01:02:11.330 ⇒ 01:02:13.780 Patrick Trainer: You could, you could rename it in the

624 01:02:14.000 ⇒ 01:02:20.860 Patrick Trainer: in the top like you could have date, ask order, date, and then just leave everything else the same that should be able to reline it

625 01:02:21.410 ⇒ 01:02:22.579 Patrick Trainer: or inline it.

626 01:02:25.350 ⇒ 01:02:26.960 Patrick Trainer: Oh, yeah, marketing date.

627 01:02:28.030 ⇒ 01:02:29.000 Patrick Trainer: So a.

628 01:02:56.260 ⇒ 01:02:57.470 Uttam Kumaran: Cool

629 01:02:59.930 ⇒ 01:03:03.263 Uttam Kumaran: cool daily marketing data, daily.

630 01:03:03.930 ⇒ 01:03:05.660 Patrick Trainer: Yeah. Yeah. That last date. Yup.

631 01:03:07.280 ⇒ 01:03:07.950 Patrick Trainer: Oh.

632 01:03:11.220 ⇒ 01:03:12.450 Patrick Trainer: okay, cool

633 01:03:14.550 ⇒ 01:03:15.620 Patrick Trainer: full pineapple.

634 01:03:27.580 ⇒ 01:03:28.920 Uttam Kumaran: Okay, let’s

635 01:03:30.200 ⇒ 01:03:31.557 Uttam Kumaran: by this guy.

636 01:03:32.190 ⇒ 01:03:33.010 Uttam Kumaran: April.

637 01:03:52.700 ⇒ 01:03:54.160 Patrick Trainer: Wonder if there’s a lot of

638 01:03:54.770 ⇒ 01:03:56.919 Patrick Trainer: resources queuing and stuff like.

639 01:03:57.720 ⇒ 01:03:59.549 Uttam Kumaran: Yeah, I don’t know.

640 01:04:04.810 ⇒ 01:04:05.535 Uttam Kumaran: Nice.

641 01:04:09.500 ⇒ 01:04:14.484 Uttam Kumaran: Also, Ryan. It’s keeps every time I just do. I’m just running a normal

642 01:04:16.100 ⇒ 01:04:20.490 Uttam Kumaran: It’s running elementary on elementary hooks, every on everything.

643 01:04:21.220 ⇒ 01:04:22.428 Ryan Luke Daque: Yeah, I haven’t. I don’t.

644 01:04:23.401 ⇒ 01:04:30.460 Ryan Luke Daque: See. Cause I think that’s what elementary does everything. Every time we run something in Dbt, it’s gonna

645 01:04:31.970 ⇒ 01:04:33.050 Ryan Luke Daque: create a hook.

646 01:04:34.140 ⇒ 01:04:38.280 Patrick Trainer: That’s shit. I wonder if we can stop the hook if there’s an error.

647 01:04:39.730 ⇒ 01:04:40.870 Uttam Kumaran: Yeah.

648 01:04:40.870 ⇒ 01:04:42.816 Patrick Trainer: Cause. I wanna know what the error is.

649 01:04:45.470 ⇒ 01:04:47.809 Patrick Trainer: I feel like we’re missing something simple.

650 01:04:52.190 ⇒ 01:04:53.570 Uttam Kumaran: Total cost, right.

651 01:04:54.033 ⇒ 01:04:54.959 Patrick Trainer: Command failed.

652 01:04:57.710 ⇒ 01:04:58.890 Patrick Trainer: Oh, wait! I’m sorry.

653 01:04:59.610 ⇒ 01:05:01.050 Ryan Luke Daque: Product box.

654 01:05:02.100 ⇒ 01:05:02.800 Ryan Luke Daque: Thank you.

655 01:05:06.220 ⇒ 01:05:08.059 Patrick Trainer: Oh, that’s confusing!

656 01:05:11.510 ⇒ 01:05:13.193 Ryan Luke Daque: Product coming into other teams.

657 01:05:13.530 ⇒ 01:05:16.563 Uttam Kumaran: Thing I’m gonna bring in is this, which is

658 01:05:32.750 ⇒ 01:05:33.250 Uttam Kumaran: First.

659 01:05:35.230 ⇒ 01:05:37.510 Uttam Kumaran: total.

660 01:05:37.710 ⇒ 01:05:39.720 Uttam Kumaran: 3 guys.

661 01:05:46.420 ⇒ 01:05:50.460 Ryan Luke Daque: Think it’s in total impressions. That’s in a letter end.

662 01:05:52.710 ⇒ 01:05:53.460 Patrick Trainer: Nice.

663 01:05:54.460 ⇒ 01:05:55.919 Ryan Luke Daque: And I think the total

664 01:05:56.550 ⇒ 01:05:59.900 Ryan Luke Daque: colleagues was it at the top? I think that all that also.

665 01:05:59.900 ⇒ 01:06:01.510 Patrick Trainer: Oh, yeah, total, that needs to.

666 01:06:01.510 ⇒ 01:06:02.989 Uttam Kumaran: This should be good. Now

667 01:06:03.410 ⇒ 01:06:04.959 Uttam Kumaran: we aliased it here.

668 01:06:04.960 ⇒ 01:06:06.189 Ryan Luke Daque: Product product cost.

669 01:06:07.020 ⇒ 01:06:08.140 Patrick Trainer: Aha!

670 01:06:10.170 ⇒ 01:06:11.469 Uttam Kumaran: Sign in

671 01:06:19.860 ⇒ 01:06:20.870 Uttam Kumaran: case.

672 01:06:37.690 ⇒ 01:06:39.430 Uttam Kumaran: Supervisor. Yeah.

673 01:06:42.800 ⇒ 01:06:45.080 Uttam Kumaran: what is it? Dvt compile.

674 01:06:46.560 ⇒ 01:06:48.350 Patrick Trainer: Yeah. And then we can check the target.

675 01:06:49.570 ⇒ 01:06:50.859 Uttam Kumaran: Let’s just see.

676 01:06:52.710 ⇒ 01:06:54.190 Uttam Kumaran: I’ll see what it looks like.

677 01:07:06.760 ⇒ 01:07:07.540 Uttam Kumaran: Rebecca.

678 01:07:14.340 ⇒ 01:07:15.070 Uttam Kumaran: Yeah.

679 01:07:15.310 ⇒ 01:07:16.060 Uttam Kumaran: Nice

680 01:07:16.220 ⇒ 01:07:17.910 Uttam Kumaran: also. No.

681 01:07:31.720 ⇒ 01:07:32.750 Uttam Kumaran: all 11.

682 01:07:38.100 ⇒ 01:07:38.890 Uttam Kumaran: Everywhere.

683 01:07:44.720 ⇒ 01:07:46.279 Uttam Kumaran: It’s on planning.

684 01:07:54.810 ⇒ 01:07:57.570 Uttam Kumaran: Let’s just do what’s fastest.

685 01:08:17.630 ⇒ 01:08:19.839 Patrick Trainer: Trying to see if I can see it in query. History.

686 01:08:23.210 ⇒ 01:08:24.526 Uttam Kumaran: I think it’s the error.

687 01:08:24.950 ⇒ 01:08:25.600 Patrick Trainer: Yeah.

688 01:08:30.569 ⇒ 01:08:31.520 Uttam Kumaran: Kathy.

689 01:08:32.649 ⇒ 01:08:33.330 Patrick Trainer: Haven’t.

690 01:08:35.250 ⇒ 01:08:36.255 Uttam Kumaran: Hold on, Chris!

691 01:08:49.340 ⇒ 01:08:50.840 Patrick Trainer: Might not be able to.

692 01:09:11.340 ⇒ 01:09:13.619 Uttam Kumaran: This is account distinct.

693 01:09:13.689 ⇒ 01:09:14.700 Uttam Kumaran: total.

694 01:09:14.770 ⇒ 01:09:18.709 Uttam Kumaran: This is a countdinct order. Id. Where total refund amount is nominal.

695 01:09:19.930 ⇒ 01:09:21.399 Uttam Kumaran: What should we do about that?

696 01:09:22.556 ⇒ 01:09:23.669 Patrick Trainer: Hold on!

697 01:09:24.120 ⇒ 01:09:25.270 Patrick Trainer: Where do you see that.

698 01:09:25.950 ⇒ 01:09:29.080 Uttam Kumaran: Right here. So in order to get total refunds

699 01:09:29.220 ⇒ 01:09:32.930 Uttam Kumaran: like this is the total number of refunds being like

700 01:09:33.029 ⇒ 01:09:35.270 Uttam Kumaran: 10 refunded items for orders.

701 01:09:43.380 ⇒ 01:09:44.149 Uttam Kumaran: file.

702 01:09:46.260 ⇒ 01:09:46.910 Patrick Trainer: Wait.

703 01:09:48.930 ⇒ 01:09:51.490 Patrick Trainer: Total refunds

704 01:09:51.840 ⇒ 01:09:52.590 Patrick Trainer: anyone.

705 01:10:06.630 ⇒ 01:10:07.650 Patrick Trainer: distinct

706 01:10:07.730 ⇒ 01:10:09.279 Patrick Trainer: case when

707 01:10:09.660 ⇒ 01:10:11.160 Patrick Trainer: refund amount.

708 01:10:18.260 ⇒ 01:10:20.450 Patrick Trainer: I think it’s gonna be

709 01:10:22.730 ⇒ 01:10:26.119 Patrick Trainer: yeah. It’s just it’ll it’ll be similar to

710 01:10:26.774 ⇒ 01:10:31.220 Patrick Trainer: it’s gonna be a case. So like case when refund amount.

711 01:10:32.476 ⇒ 01:10:34.229 Patrick Trainer: Then one

712 01:10:34.850 ⇒ 01:10:36.209 Patrick Trainer: else is 0.

713 01:10:37.020 ⇒ 01:10:38.010 Uttam Kumaran: Per call, and.

714 01:10:38.010 ⇒ 01:10:41.369 Patrick Trainer: That would be, it’d be like the same as order count

715 01:10:56.990 ⇒ 01:10:57.980 Patrick Trainer: total.

716 01:11:01.330 ⇒ 01:11:02.120 Patrick Trainer: So now.

717 01:11:02.770 ⇒ 01:11:03.970 Uttam Kumaran: Oh, that’s true. Yeah.

718 01:11:03.970 ⇒ 01:11:04.700 Patrick Trainer: Yeah.

719 01:11:04.820 ⇒ 01:11:09.379 Patrick Trainer: Yeah. Case, when total refund amount is not null, then one

720 01:11:09.600 ⇒ 01:11:10.730 Patrick Trainer: l. 0,

721 01:11:10.800 ⇒ 01:11:12.110 Patrick Trainer: that’s refund count.

722 01:11:26.740 ⇒ 01:11:29.809 Uttam Kumaran: Owner, Desktop.

723 01:11:42.070 ⇒ 01:11:44.770 Uttam Kumaran: Whoa.

724 01:11:47.980 ⇒ 01:11:50.499 Patrick Trainer: Yeah. Just like, search for

725 01:11:50.510 ⇒ 01:11:51.570 Patrick Trainer: Iff.

726 01:11:53.220 ⇒ 01:11:54.030 Uttam Kumaran: No, I

727 01:11:55.520 ⇒ 01:11:56.830 Uttam Kumaran: 100 things.

728 01:12:02.720 ⇒ 01:12:03.980 Patrick Trainer: On tween.

729 01:12:10.690 ⇒ 01:12:12.169 Patrick Trainer: Oh, no, it would.

730 01:12:12.570 ⇒ 01:12:14.239 Patrick Trainer: Total marketing cost.

731 01:12:16.030 ⇒ 01:12:18.209 Patrick Trainer: Oh, I see what you’re doing. Yeah.

732 01:12:22.010 ⇒ 01:12:23.710 Uttam Kumaran: It’s just the cost

733 01:12:24.450 ⇒ 01:12:26.180 Uttam Kumaran: describing

734 01:12:33.240 ⇒ 01:12:35.980 Uttam Kumaran: just clicks. Let’s show some questions.

735 01:12:44.080 ⇒ 01:12:44.780 Uttam Kumaran: The

736 01:12:46.480 ⇒ 01:12:47.790 Uttam Kumaran: all of us. Yeah.

737 01:12:47.790 ⇒ 01:12:48.650 Patrick Trainer: Do d.

738 01:12:57.660 ⇒ 01:12:58.500 Ryan Luke Daque: Matrix.

739 01:13:15.320 ⇒ 01:13:16.330 Uttam Kumaran: Nice.

740 01:13:20.210 ⇒ 01:13:21.500 Patrick Trainer: Fingers crossed.

741 01:13:22.200 ⇒ 01:13:22.990 Ryan Luke Daque: Very good.

742 01:13:23.280 ⇒ 01:13:24.870 Patrick Trainer: Okay, yeah. That looks good.

743 01:13:34.490 ⇒ 01:13:35.940 Patrick Trainer: -Oh, wait.

744 01:13:40.260 ⇒ 01:13:45.589 Patrick Trainer: Okay, all of these. Yeah. E, each individual one, each line is an order.

745 01:13:46.270 ⇒ 01:13:47.619 Ryan Luke Daque: Right, right.

746 01:13:50.060 ⇒ 01:13:52.979 Uttam Kumaran: Then how does that get associated with the marketing cost

747 01:13:55.000 ⇒ 01:13:56.999 Uttam Kumaran: for just joining on a day.

748 01:13:58.760 ⇒ 01:13:59.750 Ryan Luke Daque: Yeah.

749 01:14:03.300 ⇒ 01:14:04.644 Uttam Kumaran: Almost like we should.

750 01:14:12.060 ⇒ 01:14:15.889 Patrick Trainer: Also on the date, the marketing. I see what you’re saying.

751 01:14:20.710 ⇒ 01:14:22.920 Ryan Luke Daque: How did you join it before?

752 01:14:24.670 ⇒ 01:14:25.410 Ryan Luke Daque: Was it.

753 01:14:26.010 ⇒ 01:14:30.329 Uttam Kumaran: Before we’re aggregating everything to the to the day.

754 01:14:41.580 ⇒ 01:14:43.520 Uttam Kumaran: Oh, man.

755 01:14:45.590 ⇒ 01:14:47.180 Uttam Kumaran: I mean, I guess.

756 01:14:49.690 ⇒ 01:14:51.530 Uttam Kumaran: Why can’t we?

757 01:14:55.868 ⇒ 01:14:58.169 Uttam Kumaran: I’m always and just get one route.

758 01:14:59.600 ⇒ 01:15:00.730 Ryan Luke Daque: Aggregate them.

759 01:15:01.560 ⇒ 01:15:04.750 Patrick Trainer: Yeah, you can that I I mean, that would be the

760 01:15:09.160 ⇒ 01:15:12.249 Uttam Kumaran: Let me get all this in. Let me get all this guy on there.

761 01:15:12.730 ⇒ 01:15:14.590 Ryan Luke Daque: It’s in the dashboard. We’re not

762 01:15:14.780 ⇒ 01:15:17.470 Ryan Luke Daque: breaking it down right? So it doesn’t make.

763 01:15:17.470 ⇒ 01:15:19.340 Uttam Kumaran: Beyond day.

764 01:15:19.480 ⇒ 01:15:20.140 Ryan Luke Daque: Yeah.

765 01:15:23.250 ⇒ 01:15:25.329 Ryan Luke Daque: let me just go through the rest room real quick.

766 01:15:48.560 ⇒ 01:15:49.420 Uttam Kumaran: Just sorry

767 01:15:57.310 ⇒ 01:15:58.545 Uttam Kumaran: there.

768 01:16:03.510 ⇒ 01:16:05.359 Uttam Kumaran: multiple cursors.

769 01:16:12.550 ⇒ 01:16:13.740 Uttam Kumaran: But hmm.

770 01:16:15.520 ⇒ 01:16:18.120 Uttam Kumaran: right, this should all work. Right.

771 01:16:35.410 ⇒ 01:16:36.150 Uttam Kumaran: Hang.

772 01:16:50.780 ⇒ 01:16:51.520 Uttam Kumaran: Wow!

773 01:18:13.020 ⇒ 01:18:14.360 Uttam Kumaran: Let’s try this.

774 01:18:45.380 ⇒ 01:18:46.580 Uttam Kumaran: Eee.

775 01:18:52.080 ⇒ 01:18:54.270 Uttam Kumaran: We’re kind of getting multiple.

776 01:19:26.140 ⇒ 01:19:28.530 Uttam Kumaran: very good to go

777 01:19:33.738 ⇒ 01:19:35.291 Uttam Kumaran: there. It is okay.

778 01:19:38.490 ⇒ 01:19:40.150 Uttam Kumaran: Cool. This should work.

779 01:19:40.150 ⇒ 01:19:41.370 Patrick Trainer: Okay. Sweet.

780 01:20:13.770 ⇒ 01:20:14.305 Uttam Kumaran: That’s

781 01:20:16.230 ⇒ 01:20:17.060 Uttam Kumaran: sky

782 01:20:18.940 ⇒ 01:20:20.870 Uttam Kumaran: 4 increases.

783 01:20:38.040 ⇒ 01:20:39.730 Uttam Kumaran: Maybe not, Ryan.

784 01:20:39.800 ⇒ 01:20:41.769 Uttam Kumaran: because it’s a light dash. ROM!

785 01:20:44.660 ⇒ 01:20:45.290 Patrick Trainer: Huh!

786 01:20:49.600 ⇒ 01:20:51.780 Uttam Kumaran: Well, I’m just gonna get rid of it.

787 01:20:54.342 ⇒ 01:20:55.430 Ryan Luke Daque: It’s not working.

788 01:20:57.380 ⇒ 01:21:00.029 Uttam Kumaran: Yeah, I think because I don’t know how you pass bars.

789 01:21:00.160 ⇒ 01:21:01.990 Uttam Kumaran: It may be a different syntax.

790 01:21:02.720 ⇒ 01:21:03.650 Ryan Luke Daque: Yeah.

791 01:21:03.970 ⇒ 01:21:05.810 Ryan Luke Daque: Well, but you cannot.

792 01:21:06.070 ⇒ 01:21:07.790 Ryan Luke Daque: We can add it in the

793 01:21:08.540 ⇒ 01:21:10.590 Ryan Luke Daque: project, Yaml, but

794 01:21:11.490 ⇒ 01:21:13.649 Ryan Luke Daque: just have to remember to really smooth it back.

795 01:21:14.410 ⇒ 01:21:15.300 Uttam Kumaran: Yeah.

796 01:21:17.980 ⇒ 01:21:19.530 Patrick Trainer: Oh, what is this that you’re on.

797 01:21:21.110 ⇒ 01:21:22.229 Uttam Kumaran: You know. Desktop.

798 01:21:23.500 ⇒ 01:21:24.960 Patrick Trainer: Oh!

799 01:21:26.540 ⇒ 01:21:30.350 Uttam Kumaran: Yeah, I I, I learned it. And then I.

800 01:21:31.810 ⇒ 01:21:33.329 Ryan Luke Daque: Usually you will.

801 01:21:33.800 ⇒ 01:21:35.009 Uttam Kumaran: I was like, yeah.

802 01:21:35.180 ⇒ 01:21:37.590 Uttam Kumaran: I know not that in case stuff breaks. But

803 01:21:52.600 ⇒ 01:21:53.270 Uttam Kumaran: hmm.

804 01:21:55.490 ⇒ 01:21:58.229 Patrick Trainer: Okay, let’s hit Tt, mark

805 01:21:58.930 ⇒ 01:21:59.580 Patrick Trainer: all over.

806 01:21:59.580 ⇒ 01:22:03.207 Uttam Kumaran: It’s gonna give us all these metrics. Okay? So.

807 01:22:29.010 ⇒ 01:22:30.030 Patrick Trainer: We need to

808 01:22:31.100 ⇒ 01:22:36.670 Patrick Trainer: rename some of the Dbt stuff. Dbt. Mart, dot devmart. Yeah.

809 01:22:36.670 ⇒ 01:22:37.240 Uttam Kumaran: Yeah.

810 01:22:39.240 ⇒ 01:22:40.349 Ryan Luke Daque: Yeah, like, that’s

811 01:22:41.660 ⇒ 01:22:44.000 Ryan Luke Daque: gonna be one of the tech depths we had.

812 01:22:46.170 ⇒ 01:22:47.110 Patrick Trainer: Yeah.

813 01:23:05.210 ⇒ 01:23:06.440 Uttam Kumaran: Okay, cool

814 01:23:07.570 ⇒ 01:23:11.549 Uttam Kumaran: addition. Now, have all of our stuff in there.

815 01:23:12.680 ⇒ 01:23:14.780 Uttam Kumaran: What we have the metrics

816 01:23:16.100 ⇒ 01:23:19.240 Uttam Kumaran: we have these, and these are all matches.

817 01:23:20.740 ⇒ 01:23:21.860 Uttam Kumaran: braids.

818 01:23:23.040 ⇒ 01:23:23.730 Uttam Kumaran: Nathan.

819 01:23:25.800 ⇒ 01:23:27.620 Uttam Kumaran: is it format Usd.

820 01:23:29.110 ⇒ 01:23:30.860 Patrick Trainer: I believe

821 01:23:32.350 ⇒ 01:23:33.990 Patrick Trainer: somehow.

822 01:23:36.050 ⇒ 01:23:36.980 Uttam Kumaran: Getting along.

823 01:23:37.920 ⇒ 01:23:39.320 Uttam Kumaran: persons.

824 01:23:39.320 ⇒ 01:23:41.880 Patrick Trainer: If you do a command, shift F,

825 01:23:42.050 ⇒ 01:23:45.610 Patrick Trainer: it’ll search through the entire directory.

826 01:23:52.470 ⇒ 01:23:53.830 Patrick Trainer: spell their.

827 01:23:54.175 ⇒ 01:23:54.520 Ryan Luke Daque: Use.

828 01:23:55.230 ⇒ 01:23:56.240 Ryan Luke Daque: Yes. D

829 01:23:59.060 ⇒ 01:24:00.470 Ryan Luke Daque: oh, yeah. Okay.

830 01:24:00.925 ⇒ 01:24:01.380 Uttam Kumaran: There!

831 01:24:02.180 ⇒ 01:24:04.586 Ryan Luke Daque: What was the command? Shift there! Command!

832 01:24:05.320 ⇒ 01:24:06.489 Patrick Trainer: Command! Shift! F.

833 01:24:09.360 ⇒ 01:24:10.850 Ryan Luke Daque: Something new.

834 01:24:10.850 ⇒ 01:24:11.670 Patrick Trainer: Yeah.

835 01:24:13.180 ⇒ 01:24:13.779 Patrick Trainer: I don’t.

836 01:24:13.780 ⇒ 01:24:15.510 Ryan Luke Daque: Don’t know. That’s short. That’s it.

837 01:24:15.510 ⇒ 01:24:17.660 Patrick Trainer: I’m I’m all about.

838 01:24:18.160 ⇒ 01:24:20.240 Ryan Luke Daque: Shortcuts, yeah.

839 01:24:21.100 ⇒ 01:24:28.500 Patrick Trainer: It’s like with with excel or using excel like, I took it as like a personal failure to to touch the mouse.

840 01:24:29.870 ⇒ 01:24:33.528 Ryan Luke Daque: Yeah, I can do that with excel, but not yet.

841 01:24:39.900 ⇒ 01:24:40.789 Ryan Luke Daque: as is.

842 01:24:42.060 ⇒ 01:24:46.195 Ryan Luke Daque: learn to hate, excel. The the longer I’ve been using it, though.

843 01:24:46.830 ⇒ 01:24:49.360 Patrick Trainer: Yeah, yeah, I mean, I really

844 01:24:51.450 ⇒ 01:24:52.155 Patrick Trainer: a

845 01:24:54.500 ⇒ 01:24:55.155 Patrick Trainer: like

846 01:24:57.270 ⇒ 01:25:00.743 Patrick Trainer: sheets. I think sheets, kicks, kicks, ass.

847 01:25:01.240 ⇒ 01:25:01.970 Ryan Luke Daque: Yeah.

848 01:25:07.700 ⇒ 01:25:13.370 Uttam Kumaran: Okay, that’s like running all the checks. I was just gonna look at this real quick

849 01:25:14.180 ⇒ 01:25:16.629 Uttam Kumaran: to put in billing costs.

850 01:25:17.400 ⇒ 01:25:18.520 Ryan Luke Daque: Hmm, okay.

851 01:25:24.760 ⇒ 01:25:27.660 Uttam Kumaran: Cause. What I did here is I also put in markup.

852 01:25:29.880 ⇒ 01:25:35.059 Uttam Kumaran: So we have the discount. So we have the quoted cost, the discount discount rate. The shipping cost

853 01:25:36.290 ⇒ 01:25:38.660 Uttam Kumaran: markup, and then the build cost.

854 01:25:38.800 ⇒ 01:25:43.290 Uttam Kumaran: So this is what they quoted us. This is the discounts. This is the

855 01:25:45.630 ⇒ 01:25:47.190 Uttam Kumaran: oh.

856 01:25:47.400 ⇒ 01:25:48.160 Uttam Kumaran: yeah.

857 01:26:01.530 ⇒ 01:26:03.290 Uttam Kumaran: thank you kill Michael

858 01:26:04.030 ⇒ 01:26:04.910 Uttam Kumaran: Chris Smith

859 01:26:07.750 ⇒ 01:26:08.959 Uttam Kumaran: Center here.

860 01:26:16.150 ⇒ 01:26:17.499 Uttam Kumaran: Hope this is funny.

861 01:26:33.500 ⇒ 01:26:34.959 Uttam Kumaran: Does this seem better?

862 01:26:39.460 ⇒ 01:26:40.320 Uttam Kumaran: Nothing.

863 01:26:40.320 ⇒ 01:26:41.210 Ryan Luke Daque: Excellence

864 01:26:42.220 ⇒ 01:26:43.210 Ryan Luke Daque: be better.

865 01:26:43.930 ⇒ 01:26:45.369 Ryan Luke Daque: the matrix view.

866 01:26:52.480 ⇒ 01:26:53.359 Patrick Trainer: Be right back.

867 01:26:54.010 ⇒ 01:26:54.670 Uttam Kumaran: Pyrrhic.

868 01:27:03.750 ⇒ 01:27:08.709 Ryan Luke Daque: I’m trying to do another update on the work flow for elementary. I’ll just

869 01:27:09.540 ⇒ 01:27:10.710 Ryan Luke Daque: merge this.

870 01:27:12.220 ⇒ 01:27:13.010 Uttam Kumaran: Okay.

871 01:28:02.710 ⇒ 01:28:03.669 Uttam Kumaran: We don’t know.

872 01:28:29.730 ⇒ 01:28:30.450 Ryan Luke Daque: Nerve.

873 01:28:31.040 ⇒ 01:28:32.769 Ryan Luke Daque: the Pr. Still open.

874 01:28:59.590 ⇒ 01:29:00.220 Patrick Trainer: Alright!

875 01:29:22.910 ⇒ 01:29:26.000 Uttam Kumaran: 3 60 discount rates

876 01:29:27.110 ⇒ 01:29:28.740 Uttam Kumaran: sands.

877 01:29:31.900 ⇒ 01:29:36.590 Uttam Kumaran: And the other thing we wanna add to is.

878 01:29:37.220 ⇒ 01:29:38.310 Uttam Kumaran: leave

879 01:29:41.407 ⇒ 01:29:42.570 Uttam Kumaran: do the P.

880 01:29:44.930 ⇒ 01:29:45.950 Uttam Kumaran: Yeah.

881 01:30:13.300 ⇒ 01:30:16.800 Patrick Trainer: Is pool parts just like making money hand over fist.

882 01:30:17.440 ⇒ 01:30:17.920 Uttam Kumaran: Yeah.

883 01:30:18.758 ⇒ 01:30:21.980 Patrick Trainer: Like they’re selling a shit ton of pool parts.

884 01:30:22.660 ⇒ 01:30:24.189 Uttam Kumaran: Oh, yeah, they make a lot of money.

885 01:30:24.290 ⇒ 01:30:24.970 Uttam Kumaran: Okay.

886 01:30:28.500 ⇒ 01:30:29.480 Uttam Kumaran: over there.

887 01:30:30.450 ⇒ 01:30:33.460 Ryan Luke Daque: What this making money had over fist mean.

888 01:30:34.700 ⇒ 01:30:35.766 Patrick Trainer: Oh, like

889 01:30:37.300 ⇒ 01:30:40.905 Patrick Trainer: Oh, I didn’t. I didn’t even think it that that would be like

890 01:30:41.990 ⇒ 01:30:45.065 Patrick Trainer: just a like a Us. Politicalism. It’s a.

891 01:30:45.450 ⇒ 01:30:50.250 Ryan Luke Daque: Yeah, there’s a lot of us things that you do you use like certain?

892 01:30:51.175 ⇒ 01:30:51.520 Ryan Luke Daque: You

893 01:30:51.670 ⇒ 01:30:52.210 Ryan Luke Daque: I don’t.

894 01:30:52.210 ⇒ 01:30:52.879 Uttam Kumaran: I use a lot.

895 01:30:52.880 ⇒ 01:30:53.600 Ryan Luke Daque: Goal.

896 01:30:53.600 ⇒ 01:30:55.519 Uttam Kumaran: I have a lot of jargon that is.

897 01:30:55.760 ⇒ 01:30:56.820 Patrick Trainer: Lot of slang.

898 01:30:57.230 ⇒ 01:30:58.150 Ryan Luke Daque: Yeah, that’s.

899 01:30:59.220 ⇒ 01:31:03.230 Patrick Trainer: Oh, man, that’s interesting it. It. It means to like

900 01:31:04.950 ⇒ 01:31:08.109 Patrick Trainer: like you’re grabbing dollars like

901 01:31:08.210 ⇒ 01:31:09.969 Patrick Trainer: out of the air like

902 01:31:10.690 ⇒ 01:31:12.460 Patrick Trainer: like making lots of money.

903 01:31:16.160 ⇒ 01:31:17.399 Ryan Luke Daque: Yeah. I didn’t know that.

904 01:31:17.400 ⇒ 01:31:18.320 Patrick Trainer: That’s funny.

905 01:31:18.430 ⇒ 01:31:20.380 Patrick Trainer: That’s funny. Yeah, no worries.

906 01:31:21.640 ⇒ 01:31:27.220 Patrick Trainer: I I I actually like, really enjoyed talking to people about like slang. There was a girl that was from

907 01:31:27.300 ⇒ 01:31:29.120 Patrick Trainer: Australia.

908 01:31:29.380 ⇒ 01:31:33.370 Patrick Trainer: and one of the sayings that they say like when

909 01:31:33.980 ⇒ 01:31:36.589 Patrick Trainer: they’re in a room and

910 01:31:36.820 ⇒ 01:31:46.509 Patrick Trainer: like nobody’s kinda doing anything, and it’s like when they should be working or doing something. The saying is, I didn’t come here to fuck spiders

911 01:31:46.670 ⇒ 01:31:47.490 Patrick Trainer: like.

912 01:31:49.910 ⇒ 01:31:50.620 Ryan Luke Daque: It’s.

913 01:31:50.940 ⇒ 01:31:53.169 Patrick Trainer: Said that like they say that all the time.

914 01:32:02.340 ⇒ 01:32:05.189 Uttam Kumaran: I guess the date here is a number.

915 01:32:22.380 ⇒ 01:32:23.970 Uttam Kumaran: Oh, so.

916 01:32:24.700 ⇒ 01:32:27.310 Uttam Kumaran: Patrick, you did 2 character here.

917 01:32:28.600 ⇒ 01:32:30.480 Uttam Kumaran: Should we make this a date?

918 01:32:31.600 ⇒ 01:32:32.140 Uttam Kumaran: Yeah.

919 01:32:32.140 ⇒ 01:32:33.290 Patrick Trainer: That’s that’s cool.

920 01:32:34.210 ⇒ 01:32:34.880 Uttam Kumaran: Back.

921 01:32:37.330 ⇒ 01:32:41.419 Uttam Kumaran: cause I was gonna just test this out for you.

922 01:32:49.150 ⇒ 01:32:50.890 Patrick Trainer: Probably then just do

923 01:32:51.830 ⇒ 01:32:52.609 Patrick Trainer: order, date.

924 01:32:52.610 ⇒ 01:32:53.630 Uttam Kumaran: Get rid of these.

925 01:32:53.920 ⇒ 01:32:55.100 Uttam Kumaran: Well, these, I think.

926 01:32:55.100 ⇒ 01:32:57.060 Patrick Trainer: Oh, yeah, yeah, you need those.

927 01:32:58.370 ⇒ 01:32:58.950 Ryan Luke Daque: In.

928 01:33:13.330 ⇒ 01:33:14.900 Uttam Kumaran: Okay, let’s see.

929 01:33:15.990 ⇒ 01:33:18.019 Uttam Kumaran: it’ll take us some more time.

930 01:33:22.360 ⇒ 01:33:25.349 Uttam Kumaran: Ryan, are we confirmed? There’s only 40 shipments.

931 01:33:26.841 ⇒ 01:33:30.659 Ryan Luke Daque: That that’s based on the Unis file. So should be.

932 01:33:33.760 ⇒ 01:33:35.326 Uttam Kumaran: The and these are all

933 01:33:38.430 ⇒ 01:33:40.549 Uttam Kumaran: what are what is the spot today?

934 01:33:41.620 ⇒ 01:33:44.949 Ryan Luke Daque: The the units. Raw data file should have the

935 01:33:46.720 ⇒ 01:33:52.490 Ryan Luke Daque: but yeah, that’s the shopify order. So item, quantity and sum that I guess.

936 01:33:52.860 ⇒ 01:33:55.340 Uttam Kumaran: And what? How, how did we? How do we get this on.

937 01:33:56.713 ⇒ 01:33:59.779 Ryan Luke Daque: Based on the order number it’s like

938 01:34:00.180 ⇒ 01:34:05.500 Ryan Luke Daque: the Po number on the unit shipment is the order number and shopify order line items.

939 01:34:06.470 ⇒ 01:34:07.410 Uttam Kumaran: Okay.

940 01:34:20.980 ⇒ 01:34:23.619 Uttam Kumaran: A lot of these are out of the canceled.

941 01:34:24.940 ⇒ 01:34:25.890 Ryan Luke Daque: Interesting sleep.

942 01:34:27.570 ⇒ 01:34:28.430 Uttam Kumaran: What does that.

943 01:34:28.925 ⇒ 01:34:29.420 Ryan Luke Daque: Shit.

944 01:34:31.849 ⇒ 01:34:35.439 Uttam Kumaran: So they definitely shipped. But oh, see, they’re all units.

945 01:34:35.440 ⇒ 01:34:36.050 Ryan Luke Daque: Oh, yeah.

946 01:34:36.050 ⇒ 01:34:40.341 Uttam Kumaran: So. Can you wait? Can you? Can you look at all the ones with unice for that week?

947 01:34:40.580 ⇒ 01:34:41.330 Ryan Luke Daque: Same day, and.

948 01:34:41.330 ⇒ 01:34:42.480 Uttam Kumaran: So better, filter.

949 01:34:42.690 ⇒ 01:34:43.569 Ryan Luke Daque: Yeah, that means.

950 01:34:43.570 ⇒ 01:34:45.295 Uttam Kumaran: Oh, well, but this is

951 01:34:47.230 ⇒ 01:34:49.290 Uttam Kumaran: Oh, no, my! It’ll be around about

952 01:34:49.460 ⇒ 01:34:50.180 Uttam Kumaran: like.

953 01:34:51.498 ⇒ 01:34:53.290 Ryan Luke Daque: Cause, that’s cause. We added that.

954 01:34:53.290 ⇒ 01:34:55.550 Uttam Kumaran: This is already coming from our logic. Yeah.

955 01:34:55.970 ⇒ 01:34:56.550 Ryan Luke Daque: Yeah.

956 01:34:59.510 ⇒ 01:35:05.210 Uttam Kumaran: Like, how else can we verify that? All of that units only shipped about 40,

957 01:35:05.690 ⇒ 01:35:09.190 Uttam Kumaran: I mean, let me, I’m just gonna even let me just text, chuck on their side.

958 01:35:09.190 ⇒ 01:35:10.659 Ryan Luke Daque: I think it’s it’s only

959 01:35:11.140 ⇒ 01:35:15.149 Ryan Luke Daque: cause we’re very reliant on whatever the raw data says

960 01:35:15.920 ⇒ 01:35:17.640 Ryan Luke Daque: is the only way we can

961 01:35:17.960 ⇒ 01:35:23.940 Ryan Luke Daque: know whether a shipment is coming from unisys if it exists in the units for all data. So it’s not

962 01:35:24.320 ⇒ 01:35:25.760 Ryan Luke Daque: like there’s no

963 01:35:26.820 ⇒ 01:35:29.599 Ryan Luke Daque: other way we can verify it. I guess.

964 01:35:39.130 ⇒ 01:35:40.780 Uttam Kumaran: Just text the chalk. But

965 01:35:41.500 ⇒ 01:35:42.844 Uttam Kumaran: can you look at

966 01:35:44.800 ⇒ 01:35:47.019 Uttam Kumaran: Can you look at how many

967 01:35:47.760 ⇒ 01:35:50.309 Uttam Kumaran: shipments we had for?

968 01:35:50.980 ⇒ 01:35:52.709 Uttam Kumaran: Let’s see.

969 01:36:08.520 ⇒ 01:36:09.430 Uttam Kumaran: see.

970 01:36:11.160 ⇒ 01:36:11.840 Uttam Kumaran: he.

971 01:36:35.660 ⇒ 01:36:36.450 Uttam Kumaran: yeah.

972 01:36:38.730 ⇒ 01:36:40.639 Uttam Kumaran: here, I’m gonna send you on slack.

973 01:36:51.160 ⇒ 01:36:54.290 Uttam Kumaran: Can you just look at how many of these got shipped

974 01:36:56.410 ⇒ 01:36:57.939 Uttam Kumaran: in that same time period.

975 01:36:58.710 ⇒ 01:37:00.399 Ryan Luke Daque: In shopify you mean.

976 01:37:01.657 ⇒ 01:37:04.230 Uttam Kumaran: Yeah, from shopify. You can’t even try to use it.

977 01:37:06.410 ⇒ 01:37:08.820 Ryan Luke Daque: Check, and that’s those are.

978 01:37:08.850 ⇒ 01:37:10.150 Ryan Luke Daque: He was right

979 01:37:50.460 ⇒ 01:37:51.610 Patrick Trainer: Lock, my computer.

980 01:38:01.150 ⇒ 01:38:01.870 Uttam Kumaran: Yeah.

981 01:38:25.190 ⇒ 01:38:26.390 Uttam Kumaran: multiple, edge.

982 01:38:26.390 ⇒ 01:38:27.270 Patrick Trainer: And

983 01:38:29.770 ⇒ 01:38:32.400 Patrick Trainer: stupid, so let me see, I.

984 01:38:45.122 ⇒ 01:38:47.540 Ryan Luke Daque: For the same date range and

985 01:38:48.020 ⇒ 01:38:49.110 Ryan Luke Daque: ship date.

986 01:38:50.440 ⇒ 01:38:52.550 Ryan Luke Daque: And there’s 46

987 01:38:53.800 ⇒ 01:38:55.210 Ryan Luke Daque: order lines.

988 01:38:57.380 ⇒ 01:39:01.819 Ryan Luke Daque: So it’s looks like it’s the same number and 46.

989 01:39:02.410 ⇒ 01:39:05.059 Ryan Luke Daque: Yep, it’s the same. Number 46.

990 01:39:11.510 ⇒ 01:39:13.280 Ryan Luke Daque: It looks like we should be good.

991 01:39:33.180 ⇒ 01:39:33.695 Ryan Luke Daque: But

992 01:39:34.320 ⇒ 01:39:39.329 Ryan Luke Daque: yeah, it looks like we have the same number with almost like it’s 46 orders

993 01:39:39.630 ⇒ 01:39:40.450 Ryan Luke Daque: shipped.

994 01:39:40.450 ⇒ 01:39:40.895 Uttam Kumaran: Okay.

995 01:39:47.730 ⇒ 01:39:48.910 Uttam Kumaran: okay.

996 01:39:49.260 ⇒ 01:39:52.399 Uttam Kumaran: perfect. Let’s say we were trying to go build

997 01:39:52.830 ⇒ 01:39:56.887 Uttam Kumaran: one of those views where we’re looking at this month over last month.

998 01:39:58.490 ⇒ 01:40:00.709 Uttam Kumaran: So what we would do is

999 01:40:02.570 ⇒ 01:40:04.429 Uttam Kumaran: click on month.

1000 01:40:04.480 ⇒ 01:40:06.659 Uttam Kumaran: Let’s say we wanna look at total.

1001 01:40:07.400 ⇒ 01:40:09.519 Uttam Kumaran: Cost of goods sold.

1002 01:40:10.260 ⇒ 01:40:13.120 Uttam Kumaran: So we have months cost of goods sold.

1003 01:40:34.990 ⇒ 01:40:36.059 Patrick Trainer: Think I’ve just got the

1004 01:40:36.810 ⇒ 01:40:38.780 Patrick Trainer: Dvt work flow figured out.

1005 01:40:39.450 ⇒ 01:40:40.710 Uttam Kumaran: Oh, very nice!

1006 01:40:41.530 ⇒ 01:40:42.940 Uttam Kumaran: So we have months.

1007 01:40:43.010 ⇒ 01:40:44.170 Uttam Kumaran: mass.

1008 01:40:44.730 ⇒ 01:40:47.059 Uttam Kumaran: so if we were trying to look at same

1009 01:40:49.580 ⇒ 01:40:51.919 Uttam Kumaran: same time last month, what would we do

1010 01:41:02.310 ⇒ 01:41:05.020 Uttam Kumaran: his previous month to date.

1011 01:41:05.020 ⇒ 01:41:07.250 Patrick Trainer: Wait! Sorry! Are you talk? Are you talking to me?

1012 01:41:07.630 ⇒ 01:41:08.510 Uttam Kumaran: Yeah.

1013 01:41:08.510 ⇒ 01:41:11.369 Patrick Trainer: Oh, okay, sorry What was the question?

1014 01:41:11.660 ⇒ 01:41:16.930 Uttam Kumaran: So like if we were trying to find the Co. The cogs this month versus the same time last month.

1015 01:41:18.420 ⇒ 01:41:22.180 Patrick Trainer: Right, so you would add into the filters

1016 01:41:28.950 ⇒ 01:41:32.899 Patrick Trainer: the like. The the Boolean flags like is.

1017 01:41:34.970 ⇒ 01:41:37.509 Uttam Kumaran: So we would just say, is previous month to date.

1018 01:41:37.690 ⇒ 01:41:38.310 Patrick Trainer: Right.

1019 01:41:46.660 ⇒ 01:41:48.619 Uttam Kumaran: So this just gives me.

1020 01:41:49.010 ⇒ 01:41:54.429 Patrick Trainer: So that would be the preview. That was is, last month up to

1021 01:41:54.800 ⇒ 01:41:55.830 Patrick Trainer: the second.

1022 01:41:56.180 ⇒ 01:41:58.450 Uttam Kumaran: Oh, so then I would also add this filter.

1023 01:41:58.450 ⇒ 01:41:59.100 Patrick Trainer: Right!

1024 01:42:05.300 ⇒ 01:42:05.850 Ryan Luke Daque: Can’t think.

1025 01:42:05.850 ⇒ 01:42:09.529 Patrick Trainer: So it’s all of the conditions. Match. I think it should be.

1026 01:42:10.320 ⇒ 01:42:11.570 Patrick Trainer: or any.

1027 01:42:14.930 ⇒ 01:42:15.680 Patrick Trainer: Thank you.

1028 01:42:15.680 ⇒ 01:42:16.720 Uttam Kumaran: Yay.

1029 01:42:18.630 ⇒ 01:42:20.500 Uttam Kumaran: does.

1030 01:42:22.000 ⇒ 01:42:22.780 Ryan Luke Daque: Quantity.

1031 01:42:23.000 ⇒ 01:42:25.829 Uttam Kumaran: That’s been massive. Thank God!

1032 01:42:25.980 ⇒ 01:42:26.739 Ryan Luke Daque: Who they saw.

1033 01:42:26.740 ⇒ 01:42:28.670 Uttam Kumaran: I didn’t get. Let’s get this shit out there.

1034 01:42:29.110 ⇒ 01:42:32.179 Ryan Luke Daque: In just like 2 days they sold a million

1035 01:42:32.750 ⇒ 01:42:34.560 Ryan Luke Daque: in sales.

1036 01:42:35.290 ⇒ 01:42:36.220 Uttam Kumaran: 1 million.

1037 01:42:36.410 ⇒ 01:42:38.401 Uttam Kumaran: Well, no, no, no, no

1038 01:42:40.390 ⇒ 01:42:41.320 Uttam Kumaran: way.

1039 01:42:43.930 ⇒ 01:42:45.540 Uttam Kumaran: Course I’m a lot.

1040 01:42:47.390 ⇒ 01:42:48.799 Patrick Trainer: That’s like cost of goods. So.