Meeting Title: Analyst Team Daily Date: 2025-02-24 Meeting participants: Uttam Kumaran, Jakob Kagel, Bo Yoon, Robert Tseng, Sahana Asokan
WEBVTT
1 00:00:53.120 ⇒ 00:00:54.129 Bo Yoon: Like a pen.
2 00:00:56.570 ⇒ 00:00:57.450 Uttam Kumaran: Hey? What’s up?
3 00:00:58.360 ⇒ 00:01:00.970 Bo Yoon: Okay, how’s it going.
4 00:01:02.040 ⇒ 00:01:05.839 Uttam Kumaran: Good. Yeah. Been chill since the afternoon. How about you.
5 00:01:07.460 ⇒ 00:01:13.509 Bo Yoon: Good good, is it? Only, Jeremy playing thing.
6 00:01:13.680 ⇒ 00:01:16.042 Uttam Kumaran: Maybe it’s just us for now. But
7 00:01:16.820 ⇒ 00:01:19.029 Uttam Kumaran: yeah, how’s it going? Anything I can help with.
8 00:01:20.230 ⇒ 00:01:24.890 Bo Yoon: Yeah, I’m I’m actually struggling with the tableau graph.
9 00:01:25.690 ⇒ 00:01:34.850 Bo Yoon: like the side by side bar part that I that I asked. You guys last Friday, let me.
10 00:01:35.870 ⇒ 00:01:37.429 Uttam Kumaran: Yeah, maybe share it. And we can.
11 00:01:37.430 ⇒ 00:01:38.150 Jakob Kagel: No.
12 00:01:38.640 ⇒ 00:01:39.260 Uttam Kumaran: No.
13 00:01:40.890 ⇒ 00:01:41.736 Bo Yoon: Hey, Jacob?
14 00:01:46.440 ⇒ 00:01:57.080 Bo Yoon: Okay, so the problem here is online.
15 00:01:57.770 ⇒ 00:01:59.410 Uttam Kumaran: Jacob, you do tableau stuff.
16 00:02:00.270 ⇒ 00:02:03.010 Jakob Kagel: Yeah, I may have done a lot of tablet stuff.
17 00:02:03.010 ⇒ 00:02:03.750 Uttam Kumaran: Okay, so.
18 00:02:03.750 ⇒ 00:02:04.160 Jakob Kagel: That’s right.
19 00:02:04.160 ⇒ 00:02:04.690 Uttam Kumaran: About.
20 00:02:05.240 ⇒ 00:02:07.580 Uttam Kumaran: Alright. Then one of us will be able to know how to fix this.
21 00:02:07.580 ⇒ 00:02:08.820 Sahana Asokan: What’s the problem?
22 00:02:08.820 ⇒ 00:02:09.600 Jakob Kagel: Sure.
23 00:02:10.110 ⇒ 00:02:13.520 Uttam Kumaran: I think we’re trying to do stacked bar or side by side bar.
24 00:02:13.520 ⇒ 00:02:19.859 Bo Yoon: No, yeah. It’s gonna be a side by side by side bar chart. And on top of that we’ll need a line graph.
25 00:02:20.240 ⇒ 00:02:25.679 Sahana Asokan: So you want. So there’s 2 fields for bar, and then there’s.
26 00:02:26.240 ⇒ 00:02:28.129 Sahana Asokan: There’s 1 field that’s aligned.
27 00:02:28.990 ⇒ 00:02:31.990 Bo Yoon: Yeah. So let me let me show you the other.
28 00:02:32.380 ⇒ 00:02:41.660 Bo Yoon: So for this one I had to make like calculator fields to to make it show it
29 00:02:41.900 ⇒ 00:02:48.900 Bo Yoon: side by shot, side by side like this, but one of them is showing the average Ltv. And the other one is showing the ancac.
30 00:02:48.900 ⇒ 00:02:49.490 Sahana Asokan: Okay.
31 00:02:50.140 ⇒ 00:02:50.910 Bo Yoon: Yeah.
32 00:02:51.360 ⇒ 00:03:01.070 Bo Yoon: I mean, the side by side by itself. Is not that hard? It’s very simple, but the problem is merging this 2 charts together like let me show you.
33 00:03:01.070 ⇒ 00:03:04.770 Jakob Kagel: All you gotta do. All you gotta do go back is like.
34 00:03:05.390 ⇒ 00:03:12.810 Jakob Kagel: if you bring in. What’s the value you want to bring in as the line. You’re basically saying, you just want to bring in a line right to overlay with this.
35 00:03:14.130 ⇒ 00:03:15.540 Sahana Asokan: No, I think he wants
36 00:03:15.920 ⇒ 00:03:19.760 Sahana Asokan: you. You said you want it stacked right, and then you want a line too.
37 00:03:20.680 ⇒ 00:03:22.640 Bo Yoon: Fact, I already have that.
38 00:03:25.230 ⇒ 00:03:29.560 Bo Yoon: Okay, so so this is the the stack chart that I had. But
39 00:03:29.810 ⇒ 00:03:34.350 Bo Yoon: Robert wanted this side by side instead of the stack.
40 00:03:34.510 ⇒ 00:03:39.129 Sahana Asokan: Okay. So that’s why you have another, the other one, and you want the line, and the other one too.
41 00:03:39.130 ⇒ 00:03:39.870 Bo Yoon: Yeah.
42 00:03:40.080 ⇒ 00:03:41.189 Sahana Asokan: We can go back to the other one.
43 00:03:43.000 ⇒ 00:03:44.029 Bo Yoon: To the other one.
44 00:03:44.260 ⇒ 00:03:44.810 Sahana Asokan: Yeah.
45 00:03:48.850 ⇒ 00:03:59.129 Sahana Asokan: okay, let’s see. So business results. That’s a calculated field. I’m assuming.
46 00:04:00.110 ⇒ 00:04:03.119 Bo Yoon: Yeah, this. Yeah, this is probably the way.
47 00:04:03.120 ⇒ 00:04:08.719 Sahana Asokan: Can you? Can you bring in the other field you wanted like, what was the what’s what’s supposed to be the line.
48 00:04:10.240 ⇒ 00:04:15.480 Bo Yoon: The line is going to be the Ltv. Divided by Ncac. But I.
49 00:04:15.770 ⇒ 00:04:19.930 Sahana Asokan: So I would suggest creating a calculated field for that calculation.
50 00:04:20.179 ⇒ 00:04:20.749 Bo Yoon: And.
51 00:04:20.750 ⇒ 00:04:25.489 Sahana Asokan: You can copy and paste it and then dragging it to the row.
52 00:04:28.380 ⇒ 00:04:30.930 Bo Yoon: Dragging it to the row. Okay, let me.
53 00:04:31.350 ⇒ 00:04:38.439 Sahana Asokan: Like dragging it to the rows column next to average business value. And then we’re gonna click dual access. And I’ll show you how to do that.
54 00:04:38.690 ⇒ 00:04:42.179 Uttam Kumaran: Yeah, maybe Bo, just share your whole screen, because, yeah, it’s.
55 00:04:42.180 ⇒ 00:04:46.625 Bo Yoon: Okay? Let’s try with this one. Okay, the Ncac.
56 00:04:49.540 ⇒ 00:04:51.310 Bo Yoon: Ltv.
57 00:04:52.630 ⇒ 00:04:55.250 Sahana Asokan: So are these guys bar chart.
58 00:04:55.250 ⇒ 00:04:56.700 Uttam Kumaran: The 2 bars. Yeah.
59 00:04:56.700 ⇒ 00:05:00.859 Sahana Asokan: Okay, so be okay. So this is the, this is what we need to do. Right?
60 00:05:01.020 ⇒ 00:05:05.809 Sahana Asokan: We are trying to create 2 different views. Yeah, so this is the bar.
61 00:05:06.050 ⇒ 00:05:14.639 Sahana Asokan: And then, now, we need to create, get in another dimension like, another dimension in there or value. So what we’re going to do is, you know, just keep it like that.
62 00:05:15.300 ⇒ 00:05:16.030 Sahana Asokan: Yeah.
63 00:05:16.170 ⇒ 00:05:21.559 Sahana Asokan: And then get in the calculated like the other field, like, the what’s what’s the 3rd value.
64 00:05:21.560 ⇒ 00:05:23.000 Bo Yoon: That. Yeah, that’s here.
65 00:05:23.400 ⇒ 00:05:23.799 Sahana Asokan: So.
66 00:05:23.800 ⇒ 00:05:26.359 Bo Yoon: If I bring that here to the right.
67 00:05:27.730 ⇒ 00:05:33.529 Sahana Asokan: So, yeah, so can you click on like, when you go to rows.
68 00:05:34.050 ⇒ 00:05:37.120 Sahana Asokan: go to the sum Ltv and Cac thing.
69 00:05:38.050 ⇒ 00:05:38.960 Sahana Asokan: Right click.
70 00:05:40.650 ⇒ 00:05:43.090 Sahana Asokan: And then it’s all it says. Dual access, right?
71 00:05:43.530 ⇒ 00:05:44.170 Bo Yoon: Yeah.
72 00:05:45.186 ⇒ 00:05:47.960 Sahana Asokan: Can you just scroll down to mark type.
73 00:05:48.420 ⇒ 00:05:49.090 Bo Yoon: Well.
74 00:05:49.540 ⇒ 00:05:52.680 Sahana Asokan: Okay. So now go to the left.
75 00:05:54.550 ⇒ 00:05:56.020 Sahana Asokan: And when you see
76 00:05:56.360 ⇒ 00:06:06.060 Sahana Asokan: also another blocker, here is how the month is, but we’ll figure we’ll fix that later. So go to some Ltv. And Cac on your in your marks.
77 00:06:06.900 ⇒ 00:06:10.959 Sahana Asokan: No, no, no! Go up like the mark so like under measure.
78 00:06:12.690 ⇒ 00:06:15.479 Sahana Asokan: So go now, you switch bar to line.
79 00:06:17.770 ⇒ 00:06:34.809 Sahana Asokan: So now this is happening because of the way you’ve aggregated your dates. The dates need to be continuous, right? Because right now it’s a dimension, and you have all those rows, so you need an axis where it’s continuous.
80 00:06:35.640 ⇒ 00:06:36.220 Bo Yoon: Hmm!
81 00:06:36.720 ⇒ 00:06:40.499 Bo Yoon: So so I’ll just have to change this to continuous set.
82 00:06:40.710 ⇒ 00:06:50.389 Sahana Asokan: No. But the reason why it looks like this is because of your X-axis right? So like, for example, go ahead and change it to continuous.
83 00:06:52.580 ⇒ 00:06:55.419 Sahana Asokan: And now you’re gonna have 3 different ones right.
84 00:06:55.870 ⇒ 00:06:57.790 Sahana Asokan: So the the yeah. So you’re not
85 00:06:58.070 ⇒ 00:07:03.079 Sahana Asokan: essentially, I think what’s also happening is just press command. Z,
86 00:07:07.480 ⇒ 00:07:13.550 Sahana Asokan: okay, how are we getting? We don’t really want
87 00:07:15.180 ⇒ 00:07:17.829 Uttam Kumaran: Like, shouldn’t this just be a calculation like, why.
88 00:07:18.700 ⇒ 00:07:21.229 Bo Yoon: Yeah, I mean it. It should be really simple. But.
89 00:07:21.360 ⇒ 00:07:30.580 Uttam Kumaran: No, no meaning like, why, why do this like are we bringing? Is Ltv. And Calc like an actual calculation, or you pre calculating it like
90 00:07:31.420 ⇒ 00:07:31.860 Uttam Kumaran: somewhere?
91 00:07:31.860 ⇒ 00:07:32.590 Uttam Kumaran: Mouse.
92 00:07:32.590 ⇒ 00:07:35.509 Sahana Asokan: Get rid of, measure names from the columns.
93 00:07:35.770 ⇒ 00:07:38.709 Bo Yoon: This is just an average Ltv. Divided by Ankap.
94 00:07:38.710 ⇒ 00:07:39.400 Uttam Kumaran: Okay.
95 00:07:39.960 ⇒ 00:07:42.890 Sahana Asokan: Yeah. Get rid of measure names from the columns.
96 00:07:43.900 ⇒ 00:07:45.460 Bo Yoon: Measure names from the columns.
97 00:07:45.460 ⇒ 00:07:49.280 Sahana Asokan: Yeah, I wanna see what that does. Because that’s also.
98 00:07:50.030 ⇒ 00:07:50.610 Bo Yoon: Oh!
99 00:07:51.170 ⇒ 00:07:52.100 Sahana Asokan: Yup! There you go!
100 00:07:52.100 ⇒ 00:07:53.120 Bo Yoon: Oh, wow!
101 00:07:53.590 ⇒ 00:07:55.780 Uttam Kumaran: But then, okay, how do we do the?
102 00:07:56.500 ⇒ 00:08:02.070 Uttam Kumaran: So maybe in the you have to go to measure values here and then do the bar.
103 00:08:02.250 ⇒ 00:08:03.520 Uttam Kumaran: or like a.
104 00:08:03.520 ⇒ 00:08:04.890 Bo Yoon: Oh, never mind. Yeah, yeah, we.
105 00:08:04.890 ⇒ 00:08:05.669 Uttam Kumaran: Side by side, bar.
106 00:08:07.450 ⇒ 00:08:08.430 Bo Yoon: That sounds.
107 00:08:09.280 ⇒ 00:08:10.049 Uttam Kumaran: No no go back.
108 00:08:10.050 ⇒ 00:08:11.700 Bo Yoon: Oh, my! Gosh, yeah.
109 00:08:12.120 ⇒ 00:08:17.929 Uttam Kumaran: Go to the same process like like click on here or wherever you go to figure out like the actual.
110 00:08:19.970 ⇒ 00:08:22.393 Uttam Kumaran: Oh, where the fuck is like the
111 00:08:23.960 ⇒ 00:08:28.952 Sahana Asokan: Yeah, cause the problem here is if you want that line to be continuous. But then you want
112 00:08:29.440 ⇒ 00:08:34.199 Sahana Asokan: measure names in the X-axis. You’re not going to get a continuous line over time.
113 00:08:39.960 ⇒ 00:08:41.150 Uttam Kumaran: Oh, I see!
114 00:08:41.150 ⇒ 00:08:41.870 Jakob Kagel: Because you can’t.
115 00:08:41.870 ⇒ 00:08:42.419 Uttam Kumaran: You can’t.
116 00:08:42.909 ⇒ 00:08:46.699 Uttam Kumaran: Well, you can’t cut the Ltv. Cac. By the measure name. So that’s why.
117 00:08:47.250 ⇒ 00:08:50.069 Sahana Asokan: Yeah, here you’re get. You’re getting both.
118 00:08:50.300 ⇒ 00:08:59.080 Sahana Asokan: But with the previous view you’re adding, you’re trying to add, measure, name, and the month to your X-axis.
119 00:08:59.080 ⇒ 00:09:04.310 Uttam Kumaran: So you almost need to do the you you almost need to do each by month, all 3,
120 00:09:04.830 ⇒ 00:09:06.529 Uttam Kumaran: and one of them is just a bar.
121 00:09:06.700 ⇒ 00:09:07.430 Sahana Asokan: Think.
122 00:09:07.690 ⇒ 00:09:09.935 Uttam Kumaran: That makes sense like instead of
123 00:09:10.600 ⇒ 00:09:13.350 Uttam Kumaran: Right now, what? What is the orange again?
124 00:09:14.160 ⇒ 00:09:17.160 Bo Yoon: The orange is the average. Ltv.
125 00:09:17.160 ⇒ 00:09:18.380 Uttam Kumaran: And then.
126 00:09:19.020 ⇒ 00:09:20.240 Sahana Asokan: What is the yellow?
127 00:09:20.240 ⇒ 00:09:24.981 Uttam Kumaran: But like, I guess, bring both of those in a separate metrics. The yellow is the ratio.
128 00:09:25.530 ⇒ 00:09:32.450 Uttam Kumaran: but right now you’re like, can we bring in both of these as like individual metrics, and they’re all like
129 00:09:32.870 ⇒ 00:09:35.859 Uttam Kumaran: instead of measures. Bring each of them as metrics
130 00:09:37.610 ⇒ 00:09:39.140 Uttam Kumaran: on the on the road section.
131 00:09:39.140 ⇒ 00:09:40.620 Bo Yoon: Yeah, it’s like.
132 00:09:41.070 ⇒ 00:09:42.499 Uttam Kumaran: Yes, on the rows.
133 00:09:43.580 ⇒ 00:09:44.899 Uttam Kumaran: So bring each.
134 00:09:45.400 ⇒ 00:09:47.849 Uttam Kumaran: Yeah. And then bring in Ltv.
135 00:09:48.520 ⇒ 00:09:49.740 Sahana Asokan: And then you can do.
136 00:09:49.740 ⇒ 00:09:52.760 Uttam Kumaran: And then and then convert that convert the 2 to bar. Yeah.
137 00:09:54.650 ⇒ 00:09:56.370 Bo Yoon: Convert these 2 to bars.
138 00:09:56.370 ⇒ 00:09:56.730 Uttam Kumaran: Yeah.
139 00:09:57.530 ⇒ 00:10:00.019 Sahana Asokan: The problem with this is that you can. Only you only have
140 00:10:00.240 ⇒ 00:10:05.200 Sahana Asokan: to. When you do a dual access. It’ll only combine 2 views, not 3.
141 00:10:06.390 ⇒ 00:10:07.530 Uttam Kumaran: Oh!
142 00:10:08.280 ⇒ 00:10:09.280 Bo Yoon: Yeah.
143 00:10:14.400 ⇒ 00:10:15.930 Uttam Kumaran: Oh, really! 1, 2, 3.
144 00:10:15.930 ⇒ 00:10:16.500 Sahana Asokan: Wow!
145 00:10:16.940 ⇒ 00:10:18.659 Uttam Kumaran: Oh, okay. Cool.
146 00:10:18.660 ⇒ 00:10:20.660 Sahana Asokan: The other idea I have is.
147 00:10:20.660 ⇒ 00:10:21.290 Bo Yoon: Soon.
148 00:10:21.750 ⇒ 00:10:23.799 Sahana Asokan: Get rid of everything in your rows.
149 00:10:24.940 ⇒ 00:10:25.560 Bo Yoon: Okay.
150 00:10:27.320 ⇒ 00:10:30.219 Sahana Asokan: Okay, go to measure names and the filters
151 00:10:31.620 ⇒ 00:10:38.190 Sahana Asokan: select the 3 calc. Select the 3 that you want to go to edit filter.
152 00:10:40.290 ⇒ 00:10:41.349 Bo Yoon: Like 3.
153 00:10:41.350 ⇒ 00:10:47.149 Sahana Asokan: So average Ltv. And Cac. And what the 3rd calculation correct. Go to the left.
154 00:10:48.433 ⇒ 00:10:49.699 Bo Yoon: Scroll down.
155 00:10:50.730 ⇒ 00:10:55.450 Sahana Asokan: Get measure values, drag it into rows.
156 00:11:01.690 ⇒ 00:11:03.579 Sahana Asokan: Where’s the 3rd one?
157 00:11:04.630 ⇒ 00:11:07.329 Sahana Asokan: Oh, it’s so small that it’s not even showing up.
158 00:11:08.600 ⇒ 00:11:13.290 Sahana Asokan: Hmm, okay, wait.
159 00:11:13.520 ⇒ 00:11:16.660 Sahana Asokan: I have one more idea. But then I think after this I don’t know.
160 00:11:17.137 ⇒ 00:11:23.389 Sahana Asokan: Go back to measure names. Just select the 2. I think we did this exercise before, and it didn’t work, though.
161 00:11:23.820 ⇒ 00:11:26.510 Sahana Asokan: No, no, no, in your, in your, in your yeah. There you go.
162 00:11:27.260 ⇒ 00:11:28.359 Bo Yoon: Just the 2. Okay.
163 00:11:28.360 ⇒ 00:11:32.639 Sahana Asokan: Yeah. And then when you go to show me.
164 00:11:32.750 ⇒ 00:11:34.690 Sahana Asokan: And when you do the
165 00:11:35.325 ⇒ 00:11:41.109 Sahana Asokan: axes like that, let’s see what it does like, what is it? I think it’s adding something to the columns. Yeah.
166 00:11:41.790 ⇒ 00:11:43.860 Sahana Asokan: yeah, this is not gonna work like.
167 00:11:45.450 ⇒ 00:11:46.600 Bo Yoon: Yeah.
168 00:11:46.600 ⇒ 00:11:51.019 Sahana Asokan: The way it’s doing this is like the only reason you’re getting side by side is because of the
169 00:11:51.510 ⇒ 00:11:58.169 Sahana Asokan: month because of the the columns. Name in your X-axis, and you’re not going to get a continuous line
170 00:11:58.270 ⇒ 00:12:00.879 Sahana Asokan: because of that, like, there’s no way around that.
171 00:12:01.880 ⇒ 00:12:02.230 Uttam Kumaran: Yeah.
172 00:12:02.726 ⇒ 00:12:07.760 Bo Yoon: I just let let me just try for another hour. I I think I’m
173 00:12:08.900 ⇒ 00:12:10.999 Bo Yoon: I have a few ideas on this.
174 00:12:11.570 ⇒ 00:12:16.289 Uttam Kumaran: But you’re not that that measure is never gonna have the those 2 as dimensions.
175 00:12:16.460 ⇒ 00:12:17.180 Sahana Asokan: Yeah.
176 00:12:17.180 ⇒ 00:12:24.520 Uttam Kumaran: Though, you’re gonna get something that is gonna be null for both of those values. Yeah, I mean.
177 00:12:25.990 ⇒ 00:12:32.990 Uttam Kumaran: why don’t? Why don’t you? Just why don’t you just do line and bar, line and bar, put them one on top, put one on bottom, and call it a day.
178 00:12:33.790 ⇒ 00:12:37.329 Uttam Kumaran: cause that’s what I would do cause. This is a complete waste of time.
179 00:12:38.095 ⇒ 00:12:38.330 Sahana Asokan: Because.
180 00:12:38.330 ⇒ 00:12:40.669 Jakob Kagel: Agree. I mean, I think, having those
181 00:12:41.130 ⇒ 00:12:42.340 Jakob Kagel: I mean, I’m just saying because.
182 00:12:42.340 ⇒ 00:12:49.150 Uttam Kumaran: I don’t. I mean, like, I don’t. I’m I’m not fan for giving up. But I also this is, you’re gonna sit here for. This is gonna yeah, I don’t see a way through.
183 00:12:49.150 ⇒ 00:12:55.620 Jakob Kagel: I I hate the overlaid line, because, like the access is like never synchronized anyway. So it doesn’t like.
184 00:12:55.740 ⇒ 00:13:09.689 Jakob Kagel: you know. I mean, your line is whatever you know, metric. And then it’s like, it’s something completely different. Like, normally, it’s like a percentage or something compared to like your aggregate value, or something in the chart, and it’s like you don’t need to have them on the same chart. Yeah.
185 00:13:09.690 ⇒ 00:13:24.669 Sahana Asokan: You could try a stacked area chart for those initial 2 values, and then do like a dotted line for the 3, rd for the for the ratio. And then they’re basically all. All 3 of them are like lines. So it looks better. That’s an idea. But it’s up to you.
186 00:13:26.030 ⇒ 00:13:26.940 Uttam Kumaran: Yeah.
187 00:13:27.780 ⇒ 00:13:32.449 Bo Yoon: Yeah, I mean, I got a meeting with Robert like in 15 min. So maybe
188 00:13:32.720 ⇒ 00:13:36.110 Bo Yoon: I’ll ask him if he wants to wait.
189 00:13:36.110 ⇒ 00:13:37.099 Uttam Kumaran: Way he’s gonna know.
190 00:13:37.280 ⇒ 00:13:38.460 Sahana Asokan: He’s not gonna know.
191 00:13:38.630 ⇒ 00:13:42.290 Uttam Kumaran: Yeah, you’re talking to. They’re talking to the 3 tableau people at the company.
192 00:13:43.540 ⇒ 00:13:44.440 Uttam Kumaran: That’s it.
193 00:13:45.130 ⇒ 00:13:50.539 Uttam Kumaran: Yeah, I don’t think it’s I. I would say, put the line on one, put the line on the other.
194 00:13:50.950 ⇒ 00:13:51.635 Uttam Kumaran: and
195 00:13:52.500 ⇒ 00:13:54.279 Bo Yoon: So just get a side by side chart.
196 00:13:56.280 ⇒ 00:14:03.360 Sahana Asokan: I think you should just do a 3 way line chart, and then for your ratio, just do a dotted line. So everyone knows it’s like a calculation, like a bench.
197 00:14:03.360 ⇒ 00:14:03.760 Uttam Kumaran: Yeah.
198 00:14:03.760 ⇒ 00:14:04.570 Sahana Asokan: Almost.
199 00:14:05.630 ⇒ 00:14:13.580 Sahana Asokan: and it just looks a little bit more clean because you don’t have those column values for what the column names are.
200 00:14:13.770 ⇒ 00:14:16.949 Uttam Kumaran: But will the line chart be? Will the line be continuous or.
201 00:14:17.170 ⇒ 00:14:36.350 Sahana Asokan: Because what we’re gonna what you can do is just put your measure names into the color in marks. So you’ll basically have 2 lines for those 2 initial calculations over time, and then your 3rd one, which you’ll combine by the dual axes, will be the dotted mark, or like the dashed mark. So then, essentially, you’re just gonna have 3 lines.
202 00:14:36.350 ⇒ 00:14:36.990 Uttam Kumaran: Hmm.
203 00:14:36.990 ⇒ 00:14:45.520 Jakob Kagel: Yeah, you can do that for sure, because it’s like when you drag them in. And you had like the 3 bars, it’s basically the same thing. They’ll just all be lines. And yeah, you can make one dash.
204 00:14:45.760 ⇒ 00:14:46.530 Sahana Asokan: Using that look.
205 00:14:46.530 ⇒ 00:14:47.620 Jakob Kagel: That’s a good idea.
206 00:14:48.030 ⇒ 00:14:48.470 Sahana Asokan: Yes, let’s.
207 00:14:48.470 ⇒ 00:14:51.820 Uttam Kumaran: If it looks yeah. If it looks cleaner, then well, we should just do that.
208 00:14:57.540 ⇒ 00:15:00.220 Bo Yoon: So, so I’m sorry. That will be 2.
209 00:15:01.260 ⇒ 00:15:03.050 Sahana Asokan: Why don’t we?
210 00:15:03.220 ⇒ 00:15:05.459 Sahana Asokan: Yeah, we can just do it together, do you? Wanna just share your.
211 00:15:05.460 ⇒ 00:15:06.759 Bo Yoon: Oh, yeah. Fair.
212 00:15:06.760 ⇒ 00:15:09.270 Sahana Asokan: I’ll just tell you what I mean. It might be confusing.
213 00:15:17.310 ⇒ 00:15:18.040 Sahana Asokan: Okay.
214 00:15:18.310 ⇒ 00:15:31.359 Sahana Asokan: so for this one, we are going to change it to line. So remove measure names 1st from the columns and then just go to marks and change bar to line.
215 00:15:33.220 ⇒ 00:15:39.570 Sahana Asokan: Okay, so this is continuous. Right? So now we just need to get the other one in here. So get Ltv. Over. Ncac.
216 00:15:39.960 ⇒ 00:15:42.389 Sahana Asokan: Put put it to the side of measure values.
217 00:15:44.100 ⇒ 00:15:46.810 Sahana Asokan: We need to make it a dual axis. So right click.
218 00:15:50.110 ⇒ 00:15:52.519 Sahana Asokan: And then it’s not synchronized.
219 00:15:53.410 ⇒ 00:15:56.689 Sahana Asokan: Maybe we should synchronize it because it’s so different.
220 00:15:56.690 ⇒ 00:15:59.280 Bo Yoon: It should be. This would be an average.
221 00:16:02.170 ⇒ 00:16:06.150 Sahana Asokan: We’re sync. Yeah, synchronized axes. Okay, average.
222 00:16:08.570 ⇒ 00:16:12.610 Sahana Asokan: Maybe. Let’s not synchronize it and then go to the left.
223 00:16:13.750 ⇒ 00:16:16.319 Sahana Asokan: And then we’re gonna change the.
224 00:16:17.320 ⇒ 00:16:19.150 Bo Yoon: This one to dots.
225 00:16:19.410 ⇒ 00:16:19.890 Sahana Asokan: No, no.
226 00:16:19.890 ⇒ 00:16:21.010 Bo Yoon: I think it’s.
227 00:16:21.010 ⇒ 00:16:23.610 Sahana Asokan: Stays line. We we need to change them.
228 00:16:23.710 ⇒ 00:16:26.500 Sahana Asokan: Maybe the path go to path.
229 00:16:27.110 ⇒ 00:16:28.929 Sahana Asokan: No, no, no, keep it. Line.
230 00:16:30.240 ⇒ 00:16:31.010 Bo Yoon: The line.
231 00:16:31.330 ⇒ 00:16:31.829 Sahana Asokan: Go to power.
232 00:16:31.830 ⇒ 00:16:32.450 Bo Yoon: Okay.
233 00:16:32.960 ⇒ 00:16:37.389 Sahana Asokan: I’m just trying to change the mark type, that’s all. No, it’s not that.
234 00:16:40.730 ⇒ 00:16:44.980 Sahana Asokan: Hmm, maybe go to the right.
235 00:16:45.300 ⇒ 00:16:49.149 Sahana Asokan: No, no, just get get out of marks and go to the actual line. Graph.
236 00:16:50.050 ⇒ 00:16:55.229 Sahana Asokan: Okay, click, like, go to the red line, which is our newest metric. Right? Click.
237 00:16:57.040 ⇒ 00:16:59.379 Sahana Asokan: And then let’s do mark label.
238 00:17:00.640 ⇒ 00:17:02.660 Sahana Asokan: No, no, maybe mark type.
239 00:17:05.040 ⇒ 00:17:06.920 Sahana Asokan: How do I do? A dotted line.
240 00:17:08.730 ⇒ 00:17:10.630 Uttam Kumaran: I’ve never done a dotted line. I don’t think.
241 00:17:10.630 ⇒ 00:17:11.509 Sahana Asokan: You would draw the line.
242 00:17:11.510 ⇒ 00:17:13.000 Uttam Kumaran: I thought you could do benchmark.
243 00:17:13.680 ⇒ 00:17:14.560 Sahana Asokan: You can do it.
244 00:17:14.560 ⇒ 00:17:16.119 Uttam Kumaran: It’s a it’s 1 value, though.
245 00:17:19.240 ⇒ 00:17:20.139 Sahana Asokan: Let me see.
246 00:17:23.250 ⇒ 00:17:30.129 Uttam Kumaran: Check in like a what about if you go to size or in path.
247 00:17:34.250 ⇒ 00:17:40.939 Sahana Asokan: Oh, format lines. Okay, there’s something called format. Now. We should be able to do.
248 00:17:40.940 ⇒ 00:17:42.460 Uttam Kumaran: Oh, here. Here. Yeah.
249 00:17:43.180 ⇒ 00:17:44.249 Sahana Asokan: Okay, so go.
250 00:17:45.020 ⇒ 00:17:46.830 Sahana Asokan: No, no, no, go to the top.
251 00:17:46.940 ⇒ 00:17:50.930 Sahana Asokan: and it says, format font. Right? You’re going to go to the line, tab all the way.
252 00:17:50.930 ⇒ 00:17:51.700 Bo Yoon: The line.
253 00:17:51.700 ⇒ 00:17:52.350 Sahana Asokan: All the way at the top.
254 00:17:53.610 ⇒ 00:17:58.050 Sahana Asokan: One, and then let’s see what we’re.
255 00:17:58.050 ⇒ 00:17:59.539 Uttam Kumaran: I like these 2.
256 00:18:00.010 ⇒ 00:18:04.390 Sahana Asokan: Yeah, we’re gonna have to just play around and see which one changes as we change.
257 00:18:04.390 ⇒ 00:18:04.920 Uttam Kumaran: Yeah.
258 00:18:05.410 ⇒ 00:18:07.219 Sahana Asokan: So just change everything.
259 00:18:07.220 ⇒ 00:18:12.699 Uttam Kumaran: Try try drop lines or ref lines. Usually it’s like one of the one of them. I don’t. It’s always like one of them.
260 00:18:13.190 ⇒ 00:18:14.470 Sahana Asokan: No, I think it’s gonna be.
261 00:18:14.470 ⇒ 00:18:16.670 Uttam Kumaran: No, no. Now try. Drop. Yeah.
262 00:18:19.140 ⇒ 00:18:20.860 Uttam Kumaran: no, no, it won’t be access.
263 00:18:20.960 ⇒ 00:18:23.849 Uttam Kumaran: Just change this one to like the bigger.
264 00:18:24.830 ⇒ 00:18:27.850 Uttam Kumaran: Okay, never mind. It’s not that it could be.
265 00:18:28.510 ⇒ 00:18:33.029 Uttam Kumaran: Oh, well, maybe it’s a row, isn’t it? Is it? I think it’s in rows. Actually sorry.
266 00:18:33.180 ⇒ 00:18:34.040 Uttam Kumaran: Yeah.
267 00:18:34.400 ⇒ 00:18:35.080 Sahana Asokan: It’s true.
268 00:18:35.080 ⇒ 00:18:39.829 Uttam Kumaran: Actually, maybe not. I don’t know. Usually when I do this, I just change all of them to dash.
269 00:18:39.830 ⇒ 00:18:43.660 Sahana Asokan: Yeah. Same axie’s ticks didn’t work.
270 00:18:45.880 ⇒ 00:18:46.980 Bo Yoon: Axis.
271 00:18:46.980 ⇒ 00:18:49.820 Sahana Asokan: Okay, what is in sheets? What is in sheet?
272 00:18:52.440 ⇒ 00:18:54.290 Sahana Asokan: Can we change all of those
273 00:18:54.680 ⇒ 00:18:57.579 Sahana Asokan: grid lines? Is not it? Rows didn’t work.
274 00:18:59.510 ⇒ 00:19:01.349 Uttam Kumaran: What’s how’s it? Red, though?
275 00:19:01.550 ⇒ 00:19:02.880 Uttam Kumaran: Oh, hold on.
276 00:19:03.474 ⇒ 00:19:09.440 Uttam Kumaran: see! Call check columns, and then also check. Can you look at the fields like? What does it say under there.
277 00:19:09.810 ⇒ 00:19:10.719 Sahana Asokan: Oh, yeah.
278 00:19:10.850 ⇒ 00:19:14.680 Uttam Kumaran: Just just click the one we’re talking about. Yeah, yeah.
279 00:19:14.680 ⇒ 00:19:15.360 Sahana Asokan: Average.
280 00:19:15.610 ⇒ 00:19:16.650 Uttam Kumaran: Average. Yeah.
281 00:19:20.156 ⇒ 00:19:22.770 Uttam Kumaran: Oh, okay, maybe not.
282 00:19:25.450 ⇒ 00:19:26.910 Uttam Kumaran: Paints.
283 00:19:27.850 ⇒ 00:19:28.980 Bo Yoon: Paying I’ll fix.
284 00:19:29.330 ⇒ 00:19:32.380 Sahana Asokan: What’s in what’s in ticks? Is this the color.
285 00:19:33.260 ⇒ 00:19:35.720 Bo Yoon: 6. Yeah, just a college traditional line.
286 00:19:35.720 ⇒ 00:19:36.949 Sahana Asokan: And what’s in pain.
287 00:19:39.540 ⇒ 00:19:40.580 Bo Yoon: And.
288 00:19:42.060 ⇒ 00:19:44.510 Sahana Asokan: And then go back to the top thing
289 00:19:44.830 ⇒ 00:19:49.779 Sahana Asokan: like the line thing. I don’t. Okay is that? No, it’s not.
290 00:19:49.780 ⇒ 00:19:52.400 Uttam Kumaran: I don’t. I think Fields is like another thing.
291 00:19:53.030 ⇒ 00:19:58.630 Sahana Asokan: Why can’t we change it to a line? I don’t hmm!
292 00:19:58.920 ⇒ 00:20:01.579 Uttam Kumaran: Can you go here to like any of these?
293 00:20:02.380 ⇒ 00:20:06.349 Uttam Kumaran: Are any of these like valuable colors, size?
294 00:20:08.810 ⇒ 00:20:13.020 Uttam Kumaran: Just click on, click on all of them, and just see if anything opens up anything valuable.
295 00:20:13.020 ⇒ 00:20:17.440 Jakob Kagel: I think you need to drag them to pat like the lines.
296 00:20:18.500 ⇒ 00:20:19.409 Uttam Kumaran: What do you mean?
297 00:20:19.590 ⇒ 00:20:35.920 Jakob Kagel: It’s like, if you go like, if you drag the value like to path right like or I mean sorry. Drag the dimension onto the path shelf right? And then you can. When you do that, it should give you the option to right click on the line that you want to change, like in the visualization.
298 00:20:37.260 ⇒ 00:20:38.970 Uttam Kumaran: Drag this or from.
299 00:20:38.970 ⇒ 00:20:41.799 Jakob Kagel: Yeah, to path. The dimension. Yeah.
300 00:20:41.800 ⇒ 00:20:43.499 Sahana Asokan: Yeah. Drag them out.
301 00:20:43.500 ⇒ 00:20:44.859 Bo Yoon: This one took to pat.
302 00:20:44.860 ⇒ 00:20:45.420 Sahana Asokan: Yeah, yeah.
303 00:20:45.420 ⇒ 00:20:49.280 Jakob Kagel: No, not not the not the value, like the month, or whatever.
304 00:20:49.280 ⇒ 00:20:51.760 Uttam Kumaran: Yeah, like, like, yeah, this one.
305 00:20:55.260 ⇒ 00:20:56.300 Jakob Kagel: Alright, and then.
306 00:20:56.300 ⇒ 00:21:03.330 Sahana Asokan: You go to the left, though, when you like. You know how you just dragged it right? Yeah, go back to the marks.
307 00:21:04.310 ⇒ 00:21:04.980 Bo Yoon: For the mark.
308 00:21:04.980 ⇒ 00:21:10.179 Jakob Kagel: I think you should. Yeah, sorry. Not month, but measure names probably in there in the path.
309 00:21:11.220 ⇒ 00:21:11.850 Sahana Asokan: Like.
310 00:21:15.500 ⇒ 00:21:17.939 Sahana Asokan: what happens when you click this thing.
311 00:21:22.890 ⇒ 00:21:24.639 Uttam Kumaran: Oh, it’s the same thing.
312 00:21:24.970 ⇒ 00:21:27.940 Sahana Asokan: Still, perhaps no, that’s a good tool tip.
313 00:21:29.070 ⇒ 00:21:30.310 Sahana Asokan: Okay.
314 00:21:30.310 ⇒ 00:21:34.260 Uttam Kumaran: Jacob, what were you saying? So you dragged your month here, and then what do we do?
315 00:21:34.410 ⇒ 00:21:41.679 Jakob Kagel: No, I, I think, try measure names in there. If you drag the measure names into the path, then it should give you the option.
316 00:21:41.680 ⇒ 00:21:44.429 Uttam Kumaran: Oh, literally like into this. Yeah, so.
317 00:21:44.430 ⇒ 00:21:44.910 Jakob Kagel: Yeah.
318 00:21:44.910 ⇒ 00:21:45.450 Uttam Kumaran: By that.
319 00:21:45.820 ⇒ 00:21:56.499 Jakob Kagel: And then it should. Now, okay, see where it says, line right like under there, go up and select line. It should maybe have dash line. No, okay, there’s no dash line there.
320 00:21:58.280 ⇒ 00:21:59.540 Sahana Asokan: I found an article.
321 00:21:59.540 ⇒ 00:22:00.319 Jakob Kagel: Yeah, sure.
322 00:22:00.320 ⇒ 00:22:01.740 Sahana Asokan: Oh, let’s.
323 00:22:01.910 ⇒ 00:22:05.060 Jakob Kagel: That’s weird, though. That’s what I thought it would do.
324 00:22:10.160 ⇒ 00:22:14.970 Jakob Kagel: Right? Click on the line, right click on the line that you want to change in the visualization.
325 00:22:15.840 ⇒ 00:22:16.590 Bo Yoon: This one.
326 00:22:17.020 ⇒ 00:22:19.650 Jakob Kagel: Yeah, and then go to. There should be
327 00:22:20.300 ⇒ 00:22:24.480 Jakob Kagel: drop lines or like a format. Let’s see, no
328 00:22:24.690 ⇒ 00:22:29.279 Jakob Kagel: mark type. Go to mark type one. No. Okay.
329 00:22:29.280 ⇒ 00:22:30.060 Sahana Asokan: Honestly what we.
330 00:22:30.060 ⇒ 00:22:33.139 Jakob Kagel: Format go to format. Sorry. Go to format real quick right here.
331 00:22:33.560 ⇒ 00:22:34.160 Bo Yoon: Okay.
332 00:22:34.160 ⇒ 00:22:39.490 Jakob Kagel: Okay. And now there should be there. No, there’s no one. Huh?
333 00:22:39.880 ⇒ 00:22:40.489 Sahana Asokan: Yeah, whatever.
334 00:22:40.490 ⇒ 00:22:44.940 Jakob Kagel: If you click on the lines like you see, whereas the A at the top left.
335 00:22:45.200 ⇒ 00:22:52.960 Jakob Kagel: if you go all the way over and click on the lines on the right. Okay, now try adjusting like the grid lines.
336 00:22:52.960 ⇒ 00:22:58.379 Uttam Kumaran: But dude, I think all of these are, for like these lines, like, I don’t think you can actually.
337 00:22:58.380 ⇒ 00:22:58.760 Jakob Kagel: Really.
338 00:22:58.760 ⇒ 00:22:59.819 Uttam Kumaran: By this, yeah.
339 00:22:59.820 ⇒ 00:23:02.790 Sahana Asokan: We just want. I think we just did that. It’s not for the actual.
340 00:23:02.790 ⇒ 00:23:10.559 Uttam Kumaran: Yeah, everybody said, you have to insert a a reference line and change it to a dash line which is like
341 00:23:10.920 ⇒ 00:23:13.800 Uttam Kumaran: one reference line. It’s it’s not dynamic.
342 00:23:14.710 ⇒ 00:23:19.289 Sahana Asokan: I send a Youtube video, I think you have to create a calculated field. But I’m not sure.
343 00:23:20.500 ⇒ 00:23:26.100 Uttam Kumaran: Yeah, I think, Bo, just put put a line on the, put a line on each of the bars and just like.
344 00:23:26.340 ⇒ 00:23:27.550 Uttam Kumaran: see if it’ll.
345 00:23:28.040 ⇒ 00:23:29.480 Bo Yoon: See if it’ll catch.
346 00:23:30.680 ⇒ 00:23:34.789 Uttam Kumaran: Like, just like, just have 2. Just have like both bars here.
347 00:23:34.980 ⇒ 00:23:36.540 Bo Yoon: And then here.
348 00:23:36.660 ⇒ 00:23:39.330 Uttam Kumaran: And then just have the line same line on both.
349 00:23:40.440 ⇒ 00:23:45.239 Bo Yoon: Oh, okay, okay, okay, that’s to work. Right?
350 00:23:46.930 ⇒ 00:23:55.769 Uttam Kumaran: Yeah, like, yeah, you would just basically duplicate. You would have the average Ltv metric come in twice.
351 00:23:57.290 ⇒ 00:24:04.519 Uttam Kumaran: or whatever. And I and I. And then you just do dual. You do. Yeah, I think that’s or like you have one dual chart and a next second dual.
352 00:24:05.250 ⇒ 00:24:06.430 Uttam Kumaran: And I don’t know.
353 00:24:07.610 ⇒ 00:24:14.089 Uttam Kumaran: I get like they I get. You want to see that the ratio is going up, but also.
354 00:24:14.960 ⇒ 00:24:21.540 Uttam Kumaran: and you kind of want to look at like what component of the ratio is changing, I would say. A better way of doing that is just to do an area chart
355 00:24:21.710 ⇒ 00:24:23.960 Uttam Kumaran: where it’s filled 100%.
356 00:24:24.510 ⇒ 00:24:26.420 Uttam Kumaran: And you can look at the proportion.
357 00:24:28.700 ⇒ 00:24:30.720 Uttam Kumaran: Right? Isn’t that the better option like.
358 00:24:35.950 ⇒ 00:24:41.910 Sahana Asokan: Well, I know. I think it is possible to do the dash line. You just need to create a calculated field.
359 00:24:41.910 ⇒ 00:24:45.020 Uttam Kumaran: Is it with the nulls? So is that what it is? Okay?
360 00:24:45.280 ⇒ 00:24:49.100 Sahana Asokan: I think so, but I think another option that we could do is probably do
361 00:24:49.620 ⇒ 00:24:51.275 Sahana Asokan: like like you said
362 00:24:52.310 ⇒ 00:25:00.220 Sahana Asokan: maybe create. Just keep the dual line axes and then just create a reference line with the 3rd value and analytics.
363 00:25:00.880 ⇒ 00:25:02.180 Bo Yoon: So so these clusters, yeah.
364 00:25:02.180 ⇒ 00:25:04.440 Uttam Kumaran: Like, I think, yeah, and just change the color.
365 00:25:04.890 ⇒ 00:25:10.820 Uttam Kumaran: make make the line the same color on both change this color and these colors.
366 00:25:10.980 ⇒ 00:25:15.540 Uttam Kumaran: And yeah, just say, like, just let’s get it out the door. Because this is like.
367 00:25:16.140 ⇒ 00:25:21.700 Uttam Kumaran: Yeah, I think this is fine. You you can look up and down and see that this one is bigger than this one. And then
368 00:25:21.860 ⇒ 00:25:23.509 Uttam Kumaran: this line is the same.
369 00:25:25.870 ⇒ 00:25:27.999 Uttam Kumaran: Yeah, that’s probably my.
370 00:25:28.000 ⇒ 00:25:30.560 Robert Tseng: We weren’t able to to get them side by side.
371 00:25:30.800 ⇒ 00:25:31.799 Uttam Kumaran: Yeah, you can’t.
372 00:25:31.800 ⇒ 00:25:36.280 Uttam Kumaran: You can’t do 3 you can’t do 3.
373 00:25:37.020 ⇒ 00:25:42.600 Robert Tseng: Dude. What is wrong with these bi tools in Python? It’s so easy. I don’t understand.
374 00:25:42.910 ⇒ 00:25:43.580 Bo Yoon: Bye.
375 00:25:43.770 ⇒ 00:25:44.230 Sahana Asokan: Yeah.
376 00:25:44.230 ⇒ 00:25:51.129 Sahana Asokan: Yeah. Cause the side by side is creating another dimension. And that’s not letting the line be continuous.
377 00:25:51.560 ⇒ 00:25:54.800 Robert Tseng: Cause. The line has no notion of that dimension.
378 00:25:55.160 ⇒ 00:26:02.159 Robert Tseng: If you, it’s like the 2 bars are on the same y-axis, and the line is on the different axis, right? Because that’s the ratio.
379 00:26:02.160 ⇒ 00:26:12.390 Uttam Kumaran: No, but like the 2 bars, exist because you put them next to each other, which means they’re they’re tagged to one metric name and another metric name.
380 00:26:13.640 ⇒ 00:26:14.390 Robert Tseng: Okay.
381 00:26:15.500 ⇒ 00:26:21.339 Sahana Asokan: We could try the other way. But no, that wouldn’t make it side by side. Never mind.
382 00:26:21.850 ⇒ 00:26:26.697 Uttam Kumaran: But like, see, Sahana, is this like this one? Why isn’t isn’t this
383 00:26:28.180 ⇒ 00:26:31.550 Uttam Kumaran: Is this not the Bo? Is this the one you were doing this one.
384 00:26:32.260 ⇒ 00:26:32.900 Bo Yoon: Do side by side.
385 00:26:34.280 ⇒ 00:26:38.709 Uttam Kumaran: Were you using? You were using this side by side before? Yeah, yeah.
386 00:26:39.140 ⇒ 00:26:40.900 Sahana Asokan: Wait. Can you click that again.
387 00:26:41.840 ⇒ 00:26:45.669 Sahana Asokan: and then go to measure names on the top.
388 00:26:47.210 ⇒ 00:26:48.179 Uttam Kumaran: And get rid of it.
389 00:26:48.730 ⇒ 00:26:51.950 Sahana Asokan: Just get say show header like remove.
390 00:26:54.070 ⇒ 00:26:54.510 Uttam Kumaran: Hmm.
391 00:26:54.510 ⇒ 00:26:57.300 Sahana Asokan: No, it’s still because of it’s it’s the oh, okay.
392 00:26:57.300 ⇒ 00:26:58.279 Uttam Kumaran: Can you delete this.
393 00:26:58.280 ⇒ 00:27:01.660 Sahana Asokan: Actually, can you put that before year and month.
394 00:27:05.000 ⇒ 00:27:05.690 Uttam Kumaran: No.
395 00:27:11.890 ⇒ 00:27:14.810 Sahana Asokan: Okay, never mind. Pivot. Put it back.
396 00:27:17.650 ⇒ 00:27:26.109 Uttam Kumaran: Yeah, this is like the start of my career was like sitting in tablet dude, like making visual trade offs of like what I thought was possible.
397 00:27:26.440 ⇒ 00:27:30.915 Uttam Kumaran: and sitting in the tableau, Forums, being like some obscure person, was like
398 00:27:31.470 ⇒ 00:27:36.179 Uttam Kumaran: dude. I have this calculated field. You should try like it was gonna work. Just try it.
399 00:27:36.530 ⇒ 00:27:43.019 Sahana Asokan: Yeah, it’s the getting it side by side. That’s tricky. You could do it, but you can’t.
400 00:27:43.030 ⇒ 00:27:45.289 Robert Tseng: But this is like a weird
401 00:27:46.110 ⇒ 00:27:51.279 Robert Tseng: wait, I mean, wait. Is this done right? There’s no way. Ncag is 10 k. Right like.
402 00:27:52.630 ⇒ 00:27:55.449 Bo Yoon: Oh, no, yeah. Yeah. I gotta change the average.
403 00:27:57.420 ⇒ 00:27:58.530 Sahana Asokan: Wait. It still says it’s.
404 00:27:58.530 ⇒ 00:27:59.230 Bo Yoon: Oh!
405 00:28:00.160 ⇒ 00:28:03.379 Sahana Asokan: I think it’s because it’s the sum. Perhaps.
406 00:28:04.010 ⇒ 00:28:06.279 Bo Yoon: Yeah. Everything. Everything should figure out right?
407 00:28:06.280 ⇒ 00:28:09.579 Uttam Kumaran: I can’t save you. I can’t save you from that question. But yeah.
408 00:28:11.970 ⇒ 00:28:13.769 Bo Yoon: And I also got a.
409 00:28:13.770 ⇒ 00:28:17.099 Sahana Asokan: Why would it be the average if it’s at the monthly level.
410 00:28:20.330 ⇒ 00:28:20.900 Bo Yoon: Oh!
411 00:28:21.600 ⇒ 00:28:26.539 Sahana Asokan: Like, why would it from like the data model, right? Like, why would it be average.
412 00:28:26.540 ⇒ 00:28:32.619 Robert Tseng: Because it’s it’s it’s stored daily. So then he’s just like averaging out months of a month right.
413 00:28:32.810 ⇒ 00:28:35.120 Sahana Asokan: Yeah. Cause. Then it would just add up, Okay.
414 00:28:35.120 ⇒ 00:28:35.750 Robert Tseng: Yeah.
415 00:28:37.060 ⇒ 00:28:43.150 Robert Tseng: But like, I’m if I’m reading this, and I’m like a Cmo, I’m like, Okay.
416 00:28:43.390 ⇒ 00:28:44.850 Sahana Asokan: Yeah, it’s. It’s not.
417 00:28:45.040 ⇒ 00:28:47.940 Robert Tseng: Ncac volatility. Month over month makes sense.
418 00:28:49.380 ⇒ 00:28:54.180 Robert Tseng: But Ltv, yeah, like steadily decreasing. This. This view makes sense to me.
419 00:28:54.180 ⇒ 00:28:57.769 Uttam Kumaran: Yeah, that’s yeah. That’s what all I was saying was that.
420 00:28:58.016 ⇒ 00:28:58.490 Sahana Asokan: Maybe more.
421 00:28:58.490 ⇒ 00:29:01.849 Uttam Kumaran: Lines the same, though, and change the colors.
422 00:29:02.210 ⇒ 00:29:05.249 Robert Tseng: Yeah, sorry you’re gonna have to. Sorry I already said that once, but.
423 00:29:05.870 ⇒ 00:29:06.560 Uttam Kumaran: Go ahead, son.
424 00:29:06.560 ⇒ 00:29:11.900 Robert Tseng: I mean, but I mean, we’re gonna like I was about to meet with Bo on this on the same topic. So we don’t have to.
425 00:29:11.900 ⇒ 00:29:12.410 Sahana Asokan: Hello!
426 00:29:12.410 ⇒ 00:29:18.360 Robert Tseng: Yeah. So you guys can, if you have anything else to cover, feel free to. But I think there’s like one more.
427 00:29:18.360 ⇒ 00:29:20.069 Sahana Asokan: Add markers, perhaps.
428 00:29:20.070 ⇒ 00:29:20.810 Robert Tseng: Exactly.
429 00:29:21.420 ⇒ 00:29:36.540 Robert Tseng: Or actually, maybe you tell me you’ll need to hear this. But like, okay, so we have this. But this, this view we need. We need like a a moving like metric. So like just like a a number tile, that’s just like the Ltv. Cal.
430 00:29:36.860 ⇒ 00:29:37.750 Robert Tseng: And
431 00:29:38.190 ⇒ 00:29:48.640 Robert Tseng: the leadership obviously wants to make their Ltv. Look better. So they want to use like a 1 year like a 12 month, holding period 3 month average. So like.
432 00:29:49.220 ⇒ 00:29:52.990 Robert Tseng: look at, if what what that means is like.
433 00:29:53.852 ⇒ 00:30:01.160 Robert Tseng: you look 12 months like 10 to 12 months ago, and you take the 3 month average, and that’s the Ltv. They wanted to show.
434 00:30:01.730 ⇒ 00:30:10.279 Uttam Kumaran: You look 12 months ago, and then you take the 3 month average of the Ltv. From from 12 months from the given month. You’re looking at.
435 00:30:10.500 ⇒ 00:30:11.140 Robert Tseng: Yeah.
436 00:30:12.160 ⇒ 00:30:13.790 Uttam Kumaran: Wait, wait, wait! Say sorry.
437 00:30:14.020 ⇒ 00:30:15.960 Uttam Kumaran: You take the average.
438 00:30:16.620 ⇒ 00:30:17.529 Uttam Kumaran: It’s 3.
439 00:30:17.530 ⇒ 00:30:17.980 Robert Tseng: I don’t like.
440 00:30:17.980 ⇒ 00:30:18.380 Uttam Kumaran: Thank you.
441 00:30:18.895 ⇒ 00:30:19.409 Robert Tseng: Yeah.
442 00:30:19.410 ⇒ 00:30:20.599 Uttam Kumaran: From the past.
443 00:30:20.890 ⇒ 00:30:21.430 Uttam Kumaran: Okay.
444 00:30:21.430 ⇒ 00:30:24.239 Robert Tseng: Yeah, well, cause like the thing is we, you know.
445 00:30:24.240 ⇒ 00:30:30.180 Uttam Kumaran: So, yeah, okay, so like, we would. So like, right now, we would take this right.
446 00:30:30.370 ⇒ 00:30:31.600 Robert Tseng: Yeah, exactly.
447 00:30:31.600 ⇒ 00:30:32.340 Uttam Kumaran: Okay.
448 00:30:34.800 ⇒ 00:30:39.340 Sahana Asokan: I don’t think I will say just looking at this. It’s very confusing from like a
449 00:30:40.280 ⇒ 00:30:44.879 Sahana Asokan: not like a behavioral perspective, because, like the green, and the orange is kind of off putting.
450 00:30:45.190 ⇒ 00:30:47.130 Sahana Asokan: I think you need to change that too.
451 00:30:48.220 ⇒ 00:30:50.406 Uttam Kumaran: Oh, in terms of yeah, I would make
452 00:30:50.790 ⇒ 00:30:55.789 Uttam Kumaran: I would make this red. And I would make this green because of the cell TV.
453 00:30:56.990 ⇒ 00:30:57.650 Robert Tseng: Yeah.
454 00:30:58.710 ⇒ 00:31:00.960 Uttam Kumaran: And then, yeah.
455 00:31:01.720 ⇒ 00:31:04.890 Robert Tseng: Yeah, this line, this line.
456 00:31:05.160 ⇒ 00:31:08.010 Uttam Kumaran: Usually, they say, avoid green right for colorblind, so I don’t.
457 00:31:08.660 ⇒ 00:31:10.860 Sahana Asokan: Yeah. And then I think the yellow doesn’t.
458 00:31:11.570 ⇒ 00:31:14.280 Sahana Asokan: I think it would be kind of nice to maybe add.
459 00:31:15.020 ⇒ 00:31:25.939 Sahana Asokan: like the percent change or the value change month over month for the metric, so they can kind of understand how it’s improving, or in this case.
460 00:31:26.210 ⇒ 00:31:31.735 Uttam Kumaran: Yeah, add the like a value up top if it’s possible, or if you can do the
461 00:31:32.320 ⇒ 00:31:33.340 Sahana Asokan: To change.
462 00:31:33.340 ⇒ 00:31:38.019 Sahana Asokan: Yeah, for the. So take the ratio, add it to your label. Maybe.
463 00:31:38.210 ⇒ 00:31:39.020 Uttam Kumaran: Yeah.
464 00:31:39.280 ⇒ 00:31:45.949 Robert Tseng: I just sent a link that this is the link that taught me about chart colors. But you know, if it’s helpful.
465 00:31:45.950 ⇒ 00:31:49.690 Sahana Asokan: Wait that I don’t think that’s the right
466 00:31:52.770 ⇒ 00:31:53.850 Sahana Asokan: one.
467 00:31:57.950 ⇒ 00:31:59.000 Sahana Asokan: Okay, wait.
468 00:31:59.000 ⇒ 00:32:03.050 Bo Yoon: When when do you need this guy to for the lp.
469 00:32:05.000 ⇒ 00:32:11.979 Robert Tseng: This was supposed to be last week. So I did tell Natasha we would ship it like end of day today. Yeah.
470 00:32:13.310 ⇒ 00:32:14.570 Bo Yoon: Left I mean.
471 00:32:17.450 ⇒ 00:32:19.040 Uttam Kumaran: Like what’s left on this.
472 00:32:20.300 ⇒ 00:32:22.800 Robert Tseng: Yeah, I think I think this is this, this will work.
473 00:32:22.800 ⇒ 00:32:27.140 Uttam Kumaran: Just add the labels, change the yellow, and just ship it.
474 00:32:27.450 ⇒ 00:32:29.790 Sahana Asokan: Yeah, just enables. And then.
475 00:32:29.790 ⇒ 00:32:35.680 Robert Tseng: And we just need those that we just need that tile. That’s just like the that’s like the the
476 00:32:36.460 ⇒ 00:32:40.780 Robert Tseng: the 12 month holdout period, 3 month. Average thing that I was talking about.
477 00:32:42.290 ⇒ 00:32:50.779 Sahana Asokan: Yeah, so here, like to it off. Right? Okay, so take your Lpv Ncac value, drag it to Google.
478 00:32:53.640 ⇒ 00:32:59.770 Sahana Asokan: we need to change it to average. Right there we go, and then let’s.
479 00:33:00.220 ⇒ 00:33:01.600 Sahana Asokan: But why is it so high.
480 00:33:01.600 ⇒ 00:33:07.520 Uttam Kumaran: Oh, it’s on the line, so we don’t want it on the line oh.
481 00:33:07.930 ⇒ 00:33:09.010 Sahana Asokan: Oh, God!
482 00:33:09.540 ⇒ 00:33:11.290 Uttam Kumaran: Gonna put it on the bar right? Yeah.
483 00:33:11.570 ⇒ 00:33:13.229 Sahana Asokan: I thought we were doing the ratio. No.
484 00:33:13.950 ⇒ 00:33:16.129 Uttam Kumaran: Oh, yeah, I guess either one. I don’t. Yeah.
485 00:33:16.130 ⇒ 00:33:23.750 Sahana Asokan: Okay? And then right click, format numbers.
486 00:33:25.800 ⇒ 00:33:26.970 Bo Yoon: Numbers.
487 00:33:27.140 ⇒ 00:33:31.550 Sahana Asokan: Right there under alignment.
488 00:33:32.679 ⇒ 00:33:33.549 Sahana Asokan: Default.
489 00:33:35.740 ⇒ 00:33:36.639 Bo Yoon: Sorry, which one.
490 00:33:36.840 ⇒ 00:33:41.269 Sahana Asokan: The one like in the 1st section. So it says, font alignment numbers.
491 00:33:41.890 ⇒ 00:33:43.580 Sahana Asokan: On that numbers.
492 00:33:44.580 ⇒ 00:33:45.660 Bo Yoon: This number. If.
493 00:33:45.900 ⇒ 00:33:47.480 Sahana Asokan: No, no! The one above that.
494 00:33:48.150 ⇒ 00:33:48.640 Sahana Asokan: Yes.
495 00:33:48.640 ⇒ 00:33:49.730 Bo Yoon: Alignment. Okay.
496 00:33:49.730 ⇒ 00:33:52.490 Sahana Asokan: Click numbers. So just click on it. Yeah.
497 00:33:55.260 ⇒ 00:33:58.330 Sahana Asokan: Oh, is there like a pop up showing up
498 00:34:03.450 ⇒ 00:34:04.510 Sahana Asokan: like this?
499 00:34:12.650 ⇒ 00:34:14.159 Sahana Asokan: Is it letting you click anything.
500 00:34:14.940 ⇒ 00:34:17.049 Bo Yoon: Yeah. I mean, we can.
501 00:34:17.050 ⇒ 00:34:25.029 Sahana Asokan: I guess it’s not showing us this full screen. That’s fine. Should be able to change. Yeah, you changed it. Maybe we can do one decimal.
502 00:34:27.590 ⇒ 00:34:28.540 Sahana Asokan: Okay?
503 00:34:28.949 ⇒ 00:34:33.900 Sahana Asokan: And then, yeah, do the same thing for the second one, and then let’s change the yellow to like. Maybe like.
504 00:34:36.679 ⇒ 00:34:38.770 Sahana Asokan: I don’t know not yellow.
505 00:34:54.270 ⇒ 00:34:56.459 Sahana Asokan: And I’m gonna change the color.
506 00:34:57.800 ⇒ 00:34:59.540 Sahana Asokan: Can you click size for me?
507 00:35:01.040 ⇒ 00:35:02.830 Bo Yoon: I, yeah.
508 00:35:02.830 ⇒ 00:35:05.910 Sahana Asokan: Okay, let’s increase the size of the yeah, there you go.
509 00:35:06.230 ⇒ 00:35:09.040 Sahana Asokan: So it just looks a little more
510 00:35:09.340 ⇒ 00:35:11.850 Sahana Asokan: thick. And then, yeah, let’s do the same thing for the top one.
511 00:35:12.020 ⇒ 00:35:16.329 Sahana Asokan: and then let’s change the color, maybe to like.
512 00:35:18.220 ⇒ 00:35:19.140 Sahana Asokan: Hmm.
513 00:35:21.200 ⇒ 00:35:23.870 Uttam Kumaran: Chatgpt said dark blue.
514 00:35:23.870 ⇒ 00:35:25.530 Sahana Asokan: Yeah. Just do the dark blue on the top.
515 00:35:28.680 ⇒ 00:35:30.100 Uttam Kumaran: I’ll send you what it said.
516 00:35:30.440 ⇒ 00:35:32.349 Sahana Asokan: Did it not change? And then, okay.
517 00:35:32.580 ⇒ 00:35:34.960 Sahana Asokan: and the same thing for the one below
518 00:35:35.070 ⇒ 00:35:38.020 Sahana Asokan: maybe decrease the line thickness just a little.
519 00:35:41.230 ⇒ 00:35:42.150 Sahana Asokan: Yeah.
520 00:35:46.260 ⇒ 00:35:52.109 Sahana Asokan: The last thing I want to do is, can you just go to color? Maybe label.
521 00:35:52.240 ⇒ 00:35:53.710 Sahana Asokan: I want to see what’s in there.
522 00:35:55.050 ⇒ 00:35:56.130 Bo Yoon: Label.
523 00:35:56.130 ⇒ 00:36:00.070 Sahana Asokan: Like in the marks card. So like down next to size.
524 00:36:01.060 ⇒ 00:36:03.039 Sahana Asokan: Oh, the the tech.
525 00:36:03.620 ⇒ 00:36:06.829 Sahana Asokan: Okay, I can’t see your screen, so I don’t know. But I.
526 00:36:06.830 ⇒ 00:36:08.219 Bo Yoon: Oh, oh, it doesn’t show.
527 00:36:08.520 ⇒ 00:36:10.949 Sahana Asokan: Yes, I’m not. I’m not able to see Pop Ups.
528 00:36:13.340 ⇒ 00:36:22.299 Sahana Asokan: I was. Gonna say, maybe if we could add like marks the line or something to make it a little distinct, like black dots or something. But I think this is fine. It looks better than before.
529 00:36:24.060 ⇒ 00:36:28.840 Uttam Kumaran: I would get it, I would just get it out, because we can keep formatting it later, as long as it’s good like.
530 00:36:29.720 ⇒ 00:36:35.750 Sahana Asokan: And then just clean up the axes like on the for the average average. Ltv. Just rename that to average Ltv.
531 00:36:35.750 ⇒ 00:36:36.620 Bo Yoon: Oh, yeah.
532 00:36:37.100 ⇒ 00:36:38.190 Sahana Asokan: And then.
533 00:36:40.070 ⇒ 00:36:42.489 Uttam Kumaran: And then I would change the month, I guess.
534 00:36:42.490 ⇒ 00:36:44.909 Sahana Asokan: The months to like short date.
535 00:36:44.910 ⇒ 00:36:47.060 Uttam Kumaran: R. 24, or something like that.
536 00:36:48.250 ⇒ 00:36:50.020 Sahana Asokan: So go go to the top.
537 00:36:51.380 ⇒ 00:36:53.219 Bo Yoon: Oh, you mean the the months.
538 00:36:53.220 ⇒ 00:36:54.009 Sahana Asokan: Yeah, thank, you.
539 00:36:54.010 ⇒ 00:36:54.390 Uttam Kumaran: Ease.
540 00:36:54.390 ⇒ 00:36:55.579 Sahana Asokan: 1224.
541 00:36:56.440 ⇒ 00:36:57.240 Uttam Kumaran: Yeah.
542 00:36:57.980 ⇒ 00:36:58.470 Bo Yoon: Yeah.
543 00:36:58.470 ⇒ 00:37:01.789 Uttam Kumaran: I don’t think I think you’ll have to do that in in here right.
544 00:37:01.790 ⇒ 00:37:03.070 Sahana Asokan: No, you can do it in format.
545 00:37:03.440 ⇒ 00:37:07.670 Sahana Asokan: You can do format, and then the date short type. It’ll just be dash yy
546 00:37:14.100 ⇒ 00:37:18.329 Sahana Asokan: and then format thing is come, it’s on the side.
547 00:37:19.520 ⇒ 00:37:25.830 Sahana Asokan: So you will go to paint header.
548 00:37:29.050 ⇒ 00:37:29.870 Sahana Asokan: Hmm!
549 00:37:32.790 ⇒ 00:37:37.150 Sahana Asokan: It’s not font we go. No, maybe go to the columns.
550 00:37:38.970 ⇒ 00:37:40.420 Sahana Asokan: Click format, there.
551 00:37:42.290 ⇒ 00:37:45.220 Bo Yoon: Yeah, I just clicked this nothing’s changing here.
552 00:37:45.220 ⇒ 00:37:46.819 Sahana Asokan: And then pain.
553 00:37:50.060 ⇒ 00:37:57.079 Sahana Asokan: It should just give you like a way to go to a perhaps like, go through. Let’s go through all the little things.
554 00:37:57.230 ⇒ 00:37:58.130 Sahana Asokan: Okay.
555 00:38:01.300 ⇒ 00:38:04.670 Sahana Asokan: No, no, no, Rose.
556 00:38:16.360 ⇒ 00:38:19.089 Sahana Asokan: what’s in header when you go there like automatic?
557 00:38:20.680 ⇒ 00:38:21.380 Sahana Asokan: Can you scroll.
558 00:38:21.380 ⇒ 00:38:24.669 Bo Yoon: Horizontal direction, vertical and branch.
559 00:38:24.850 ⇒ 00:38:33.159 Sahana Asokan: You know. Yeah, we just need to change the dates. And usually, if you like, go and right, click, it’ll just give you like numbers, and then you can just go and.
560 00:38:34.360 ⇒ 00:38:35.410 Bo Yoon: Yeah, it should.
561 00:38:37.170 ⇒ 00:38:37.690 Sahana Asokan: Oh.
562 00:38:43.050 ⇒ 00:38:44.090 Sahana Asokan: no.
563 00:38:47.630 ⇒ 00:38:48.670 Sahana Asokan: okay. You got it.
564 00:38:49.450 ⇒ 00:38:50.470 Sahana Asokan: And then.
565 00:38:51.330 ⇒ 00:38:54.629 Bo Yoon: It needs to be short month, short year.
566 00:38:58.360 ⇒ 00:38:59.490 Sahana Asokan: Format?
567 00:39:08.495 ⇒ 00:39:13.669 Sahana Asokan: Maybe it’s because it’s a dimension. Can you switch? Make it a make it continuous.
568 00:39:19.620 ⇒ 00:39:21.310 Bo Yoon: Make which one continues.
569 00:39:21.310 ⇒ 00:39:22.160 Sahana Asokan: The date.
570 00:39:23.250 ⇒ 00:39:26.150 Sahana Asokan: Why isn’t it letting us make it continuous?
571 00:39:27.210 ⇒ 00:39:35.450 Sahana Asokan: Okay, go to the just X out of the mark, like the formatting thing like, just show. I want to see all the fields and columns.
572 00:39:35.600 ⇒ 00:39:40.650 Sahana Asokan: Okay, and then go to year, month from like whatever you selected.
573 00:39:40.840 ⇒ 00:39:42.380 Bo Yoon: Which one did you use?
574 00:39:43.470 ⇒ 00:39:45.480 Bo Yoon: Just find someone that always.
575 00:39:45.970 ⇒ 00:39:51.539 Sahana Asokan: Okay, yeah, just change it. And let’s see if that helps us make it continuous.
576 00:39:53.550 ⇒ 00:39:55.669 Sahana Asokan: Okay? And then month.
577 00:39:56.980 ⇒ 00:39:59.509 Sahana Asokan: And then let’s format this.
578 00:40:00.540 ⇒ 00:40:01.300 Sahana Asokan: So go to.
579 00:40:01.300 ⇒ 00:40:03.380 Bo Yoon: So this is better.
580 00:40:03.380 ⇒ 00:40:07.110 Sahana Asokan: Yeah, let’s just try it and see if it comes up. Now, format no.
581 00:40:07.970 ⇒ 00:40:08.404 Bo Yoon: No.
582 00:40:14.760 ⇒ 00:40:16.090 Sahana Asokan: This is so weird.
583 00:40:17.590 ⇒ 00:40:21.169 Sahana Asokan: Pont date. Oh, yeah, dates. There you go dates
584 00:40:22.670 ⇒ 00:40:31.190 Sahana Asokan: and then click on it, and then there should be options, and you can do like a manual, and you should be able to do a short date. So you can just enter.
585 00:40:33.520 ⇒ 00:40:34.310 Sahana Asokan: That’s
586 00:40:38.730 ⇒ 00:40:48.989 Sahana Asokan: like you can play around with the formatting of the dates, and then you can do like abbreviation, and then you can enter Mmyy, and that’ll just give you the like a short, abbreviated version.
587 00:40:53.990 ⇒ 00:40:57.149 Sahana Asokan: can you? You want to send me a screenshot of the pop up.
588 00:40:58.980 ⇒ 00:41:03.940 Robert Tseng: Or both. You just. I feel like it’s because you’re sharing just one window. You’re not sharing your full screen.
589 00:41:04.830 ⇒ 00:41:06.059 Bo Yoon: Okay. Let me.
590 00:41:06.230 ⇒ 00:41:07.230 Sahana Asokan: Yeah. Let’s see.
591 00:41:14.210 ⇒ 00:41:16.969 Robert Tseng: Was this the only thing that you guys went went through in that meeting.
592 00:41:17.160 ⇒ 00:41:17.880 Sahana Asokan: Yeah.
593 00:41:18.310 ⇒ 00:41:19.290 Robert Tseng: Oh, man!
594 00:41:19.780 ⇒ 00:41:20.620 Sahana Asokan: Dates.
595 00:41:20.910 ⇒ 00:41:24.620 Sahana Asokan: Okay, custom. But that did not change anything, did it?
596 00:41:28.880 ⇒ 00:41:31.546 Sahana Asokan: Okay, let’s just try this one more time.
597 00:41:33.450 ⇒ 00:41:37.759 Sahana Asokan: double click, right click on the bottom where we just did it.
598 00:41:38.770 ⇒ 00:41:39.920 Bo Yoon: Format.
599 00:41:43.160 ⇒ 00:41:44.680 Sahana Asokan: Okay, axes.
600 00:41:45.030 ⇒ 00:41:48.430 Sahana Asokan: Maybe it’s not pain in the left.
601 00:41:49.560 ⇒ 00:41:51.160 Sahana Asokan: No, no. So like
602 00:41:52.070 ⇒ 00:41:57.800 Sahana Asokan: in like you are, gonna make all your edits on the left. Yeah, there you go, numbers.
603 00:42:00.260 ⇒ 00:42:02.519 Sahana Asokan: No, it should come up as a date.
604 00:42:06.340 ⇒ 00:42:08.180 Sahana Asokan: Okay. Format here.
605 00:42:11.620 ⇒ 00:42:13.659 Bo Yoon: Wait one second, isn’t it?
606 00:42:15.120 ⇒ 00:42:18.090 Bo Yoon: No cause. It’s abbreviation. That’s the problem.
607 00:42:18.580 ⇒ 00:42:20.080 Sahana Asokan: Yeah. No. Control. Z.
608 00:42:21.020 ⇒ 00:42:22.020 Robert Tseng: Whoa!
609 00:42:23.390 ⇒ 00:42:25.750 Sahana Asokan: So go back to the top to columns.
610 00:42:27.240 ⇒ 00:42:30.860 Sahana Asokan: and then format there, so format above show header.
611 00:42:37.620 ⇒ 00:42:39.290 Sahana Asokan: There do we go.
612 00:42:40.000 ⇒ 00:42:40.810 Bo Yoon: Okay.
613 00:42:41.430 ⇒ 00:42:42.270 Bo Yoon: Yes.
614 00:42:43.080 ⇒ 00:42:47.290 Sahana Asokan: Or you could do Mmm like 4 m’s.
615 00:42:50.480 ⇒ 00:42:53.489 Sahana Asokan: and then just do that. It’s up to you.
616 00:42:54.600 ⇒ 00:42:56.140 Robert Tseng: Yeah, I think that looks fine.
617 00:42:56.540 ⇒ 00:42:57.230 Bo Yoon: Yeah.
618 00:42:57.580 ⇒ 00:43:00.250 Sahana Asokan: Okay, cool. I need to go. But let me know if you need anything.
619 00:43:01.010 ⇒ 00:43:02.439 Robert Tseng: Alright, thanks, Ahana!
620 00:43:04.240 ⇒ 00:43:06.610 Robert Tseng: Alright! But we’ll just stay on for a bit. So
621 00:43:08.750 ⇒ 00:43:13.919 Robert Tseng: yeah, I guess once you have any you wanted to show me like the dashboard. What it looks like now.
622 00:43:15.930 ⇒ 00:43:18.369 Bo Yoon: I’ll have to update it.
623 00:43:18.940 ⇒ 00:43:24.997 Robert Tseng: Okay, you’re gonna update it. Okay? Well, then, the last tile that I mentioned did you? Did you get that
624 00:43:26.240 ⇒ 00:43:30.440 Bo Yoon: Oh, no, I I can. You explain that a little bit more? I I didn’t really get that.
625 00:43:31.830 ⇒ 00:43:36.160 Robert Tseng: Yeah. So okay, so look at this. It’s like a
626 00:43:39.380 ⇒ 00:43:42.670 Robert Tseng: 12 months. Alright, let me let me hold on.
627 00:43:53.010 ⇒ 00:43:54.890 Robert Tseng: Well, hey?
628 00:43:56.470 ⇒ 00:43:58.779 Robert Tseng: The monthly average.
629 00:44:07.360 ⇒ 00:44:12.360 Robert Tseng: Oh, where?
630 00:44:14.490 ⇒ 00:44:15.690 Robert Tseng: Out?
631 00:44:28.130 ⇒ 00:44:33.079 Robert Tseng: So if yeah, if today is like
632 00:44:34.300 ⇒ 00:44:45.949 Robert Tseng: we’re we’re here, it’s saying, you know, 1, 2, 3, 4, 5, 6, 7, 8 until 12, like, look a year back. Take the 3 months from a year ago, and then take the average of that
633 00:44:46.050 ⇒ 00:44:48.570 Robert Tseng: and make that the Ltv. Assumption.
634 00:44:50.840 ⇒ 00:44:56.889 Bo Yoon: So so that would be like a moving average for the 3 months. Starting a year back.
635 00:44:57.430 ⇒ 00:45:03.759 Robert Tseng: Yeah. So we end up having like another tile on the dashboard. That’s just like a number, you know, like.
636 00:45:06.220 ⇒ 00:45:09.370 Robert Tseng: And it’s the calculation is that
637 00:45:10.340 ⇒ 00:45:15.289 Robert Tseng: it’s a placeholder until, like, you know, in the future, once you have like.
638 00:45:15.870 ⇒ 00:45:24.400 Robert Tseng: you know, this is what you’re showing us actuals right? Ideally. What would happen is, you have, like a predicted line as well. That goes something more like this.
639 00:45:26.550 ⇒ 00:45:37.509 Robert Tseng: And then, as each month gets closer, you know, within the next month this point will get a little closer. This point is, gonna get a little closer, they’re all gonna get a bit closer.
640 00:45:38.810 ⇒ 00:45:42.820 Robert Tseng: And so this this predicted line.
641 00:45:45.330 ⇒ 00:45:48.550 Robert Tseng: it stabilizes like if that come becomes
642 00:45:48.680 ⇒ 00:45:53.639 Robert Tseng: what that becomes the main thing to look at. But until we have that.
643 00:45:54.130 ⇒ 00:45:58.020 Robert Tseng: those these 2 lines where we have the actual than the predicted.
644 00:45:58.220 ⇒ 00:46:04.295 Robert Tseng: Mattesh still needs just like a number that he can anchor his assumption to. And
645 00:46:05.190 ⇒ 00:46:09.830 Robert Tseng: that’s why we need to like programmatically come up with one. And
646 00:46:10.550 ⇒ 00:46:16.919 Robert Tseng: Elt’s preferences to use the past. Obviously, because it’s higher. But also.
647 00:46:17.510 ⇒ 00:46:20.199 Robert Tseng: I mean, if you look at this, it shows that.
648 00:46:22.090 ⇒ 00:46:28.080 Robert Tseng: Yeah, I mean over time. Ltv has been dropping. Is that just because at we haven’t
649 00:46:28.726 ⇒ 00:46:31.060 Robert Tseng: like customers are are not.
650 00:46:31.380 ⇒ 00:46:43.910 Robert Tseng: you know. Maybe they’re not done with their lifetime yet, and that’s why it’s been dropping. So if we use something that’s more stable from the past, and that’s that’s that. Maybe that’s a better indication than Ltv.
651 00:46:46.190 ⇒ 00:46:51.830 Bo Yoon: But but if I do that that charge gonna be similar to this one, right, you’ll still be kinda.
652 00:46:52.192 ⇒ 00:46:56.840 Robert Tseng: It’s not a chart, it’s not. I’m not even asking for a chart. I think it’s just a calculation. It’s just a metric.
653 00:46:57.860 ⇒ 00:47:07.029 Bo Yoon: Or just a calculation for okay? So so go go 12 months back and calculate the
654 00:47:08.070 ⇒ 00:47:12.320 Bo Yoon: the 3 months average Ltv.
655 00:47:13.630 ⇒ 00:47:14.020 Robert Tseng: Yeah.
656 00:47:14.020 ⇒ 00:47:16.169 Bo Yoon: Months, and and so on.
657 00:47:17.850 ⇒ 00:47:18.520 Robert Tseng: Yeah.
658 00:47:18.660 ⇒ 00:47:19.600 Bo Yoon: Yeah.
659 00:47:20.570 ⇒ 00:47:23.990 Robert Tseng: So you you still have this chart that’s like you’re gonna
660 00:47:23.990 ⇒ 00:47:34.020 Robert Tseng: be in the dashboard. But you also have a tile. That’s just a number. That’s just the Ltv number, and that number is calculated with this
661 00:47:34.180 ⇒ 00:47:38.180 Robert Tseng: 3 months rolling average with a 1 year holdout period like calculation.
662 00:47:40.530 ⇒ 00:47:48.260 Bo Yoon: So. So, for example, you just need the number of these 3 3 bars together, or.
663 00:47:48.260 ⇒ 00:47:53.649 Robert Tseng: Yeah, I mean, it’s not exactly this, because I don’t think this is exactly a 1 year. Look back that you’re seeing here.
664 00:47:54.080 ⇒ 00:47:55.420 Robert Tseng: But yeah.
665 00:48:05.010 ⇒ 00:48:05.900 Bo Yoon: Period.
666 00:48:08.410 ⇒ 00:48:11.440 Bo Yoon: Still, don’t kind of get it. Why.
667 00:48:18.820 ⇒ 00:48:27.769 Robert Tseng: I’m not. I’m not saying that that’s the solution I want in the future. But it’s just they they need a number right now. And like, that’s that’s the compromise.
668 00:48:27.910 ⇒ 00:48:34.040 Robert Tseng: I I was saying that I think the solution is actually this line that I’ve drift. I’ve drawn here
669 00:48:34.300 ⇒ 00:48:48.949 Robert Tseng: like this is the predicted Ltv curve that we actually need, we need an actual and a predicted. So the predicted line is more stabilized. And then we can actually see how how actual, is like trending towards predicted over time.
670 00:48:49.310 ⇒ 00:49:05.832 Robert Tseng: And ideally, Mattesh would use like this number. But we don’t have this line yet. And so we just need like an Ltv number. And we need an Ltv impact ratio number. That’s like, Cal, yeah, we we need to calculate it for now and
671 00:49:07.730 ⇒ 00:49:09.979 Robert Tseng: they would prefer to use.
672 00:49:10.090 ⇒ 00:49:14.600 Robert Tseng: Oh, I they don’t. Wanna yeah. They wanna exclude.
673 00:49:14.800 ⇒ 00:49:24.199 Robert Tseng: Well, I mean, they just want to look at a year ago, because that seems to be a more stable number than what we see with this like drop off over time.
674 00:49:27.290 ⇒ 00:49:36.360 Bo Yoon: Okay? Then then how can I present that? Do they? They want that number in in the tableau, dashboard, or.
675 00:49:36.630 ⇒ 00:49:40.399 Robert Tseng: Well, so if you go, I I think this this sheet is.
676 00:49:41.040 ⇒ 00:49:45.440 Robert Tseng: A chart in your dashboard. I think you just need 2 more tiles.
677 00:49:46.820 ⇒ 00:49:50.000 Robert Tseng: So you have this number Ltv. Number here.
678 00:49:50.380 ⇒ 00:49:56.720 Robert Tseng: and then you also have maybe this, like Ltv. Ncaa.
679 00:49:58.240 ⇒ 00:49:59.389 Bo Yoon: Oh, just Xbox!
680 00:49:59.390 ⇒ 00:50:01.159 Bo Yoon: Oh, give me one second.
681 00:50:01.400 ⇒ 00:50:05.550 Robert Tseng: Yeah, they’re just like boxes, you know. That’s what I mean by tile
682 00:50:11.990 ⇒ 00:50:21.660 Robert Tseng: and you just put them next to the next to the dashboard. I don’t. I don’t up to you, or if you want to put it on top, or to the side, or whatever. But yeah.
683 00:50:24.440 ⇒ 00:50:26.822 Bo Yoon: But that’s just gonna be one number right
684 00:50:27.560 ⇒ 00:50:29.469 Robert Tseng: Yeah, it’s just gonna be one, number.
685 00:50:34.370 ⇒ 00:50:35.100 Bo Yoon: Okay.
686 00:50:37.650 ⇒ 00:50:44.339 Bo Yoon: 90, hey? I’m I’m sorry, Robert. I I still don’t kinda get it yet. It’s
687 00:50:45.190 ⇒ 00:50:52.000 Bo Yoon: so so this time I thought you wanted like 3 months, the sum of 3 months
688 00:50:53.620 ⇒ 00:51:00.390 Bo Yoon: over time, like a moving average. How how can I put that in a tile here that.
689 00:51:03.650 ⇒ 00:51:05.719 Robert Tseng: Let me see if I can
690 00:51:06.230 ⇒ 00:51:10.930 Robert Tseng: present this in a different way, like
691 00:51:14.870 ⇒ 00:51:16.200 Robert Tseng: paper.
692 00:51:30.830 ⇒ 00:51:32.170 Robert Tseng: Where is
693 00:52:41.790 ⇒ 00:52:49.220 Robert Tseng: yeah. So you you yeah, you you’ve put it on there. And okay, well.
694 00:52:55.130 ⇒ 00:52:56.710 Robert Tseng: let’s see.
695 00:53:31.020 ⇒ 00:53:33.090 Robert Tseng: Okay, so
696 00:53:42.210 ⇒ 00:53:44.599 Robert Tseng: yeah, so you have your table here.
697 00:53:46.070 ⇒ 00:53:51.770 Robert Tseng: And then you have your charts, like, yeah, I kind of like what you’re showing here already.
698 00:53:54.530 ⇒ 00:54:04.880 Robert Tseng: I need a few. I need a couple of tiles. I don’t know if you want to put them here, or if you want to put them to the side, maybe to the side, makes more sense, you could kind of shrink it a bit.
699 00:54:05.210 ⇒ 00:54:10.959 Robert Tseng: But yeah, I mean, this is like an Ltv number. It’s just a single number.
700 00:54:11.490 ⇒ 00:54:14.580 Robert Tseng: And then this is Ltv over. Ncac.
701 00:54:21.100 ⇒ 00:54:29.610 Robert Tseng: yeah, so, and then the way that this is calculated is, it’s you’re taking like the 3 month
702 00:54:30.770 ⇒ 00:54:36.409 Robert Tseng: average of like 12 months ago.
703 00:54:37.650 ⇒ 00:54:40.069 Bo Yoon: 3 months average of about 12 months ago. Okay.
704 00:54:40.070 ⇒ 00:54:47.699 Robert Tseng: Yeah. So that’s what I mean by holdout period. So you you’re doing your 3 month average. But you’re not starting from today. You’re starting from like 12 months ago.
705 00:54:48.910 ⇒ 00:54:53.510 Bo Yoon: Okay. So so you’ll basically just be the the the average of these 3.
706 00:54:53.510 ⇒ 00:54:56.399 Robert Tseng: Yeah, it’ll just be the average of those 3. Yeah.
707 00:54:56.400 ⇒ 00:55:00.080 Bo Yoon: Those 3. And these 3 on on 2 different tiles. Okay.
708 00:55:00.390 ⇒ 00:55:00.840 Robert Tseng: Yeah.
709 00:55:00.840 ⇒ 00:55:05.089 Bo Yoon: Yeah, yeah, that won’t be yeah. That’ll be easy to do.
710 00:55:06.870 ⇒ 00:55:07.880 Bo Yoon: And
711 00:55:12.990 ⇒ 00:55:16.760 Bo Yoon: yeah, okay, I’ll I’ll add that to this here
712 00:55:17.360 ⇒ 00:55:26.450 Bo Yoon: I guess I’ll just. I can just put it here or or somewhere in between. But do you think this graph is okay for now? Or
713 00:55:27.550 ⇒ 00:55:31.629 Bo Yoon: I mean, I I can spend a little a little bit more time on this.
714 00:55:31.860 ⇒ 00:55:34.629 Bo Yoon: to to get it like a side by side.
715 00:55:36.470 ⇒ 00:55:40.716 Robert Tseng: I think if we can’t get the side by side, it’s fine.
716 00:55:41.650 ⇒ 00:55:48.990 Robert Tseng: I do think that having 2 lines is unnecessary. It’s like it the line? Yeah.
717 00:55:49.870 ⇒ 00:55:51.420 Robert Tseng: So.
718 00:55:51.550 ⇒ 00:55:53.359 Bo Yoon: Or maybe just get rid of one of them.
719 00:56:04.000 ⇒ 00:56:09.950 Robert Tseng: Yeah, I don’t know. I guess you have. You have 2 of the same measures. So yeah, if you remove one of them, then maybe that makes more sense.
720 00:56:11.620 ⇒ 00:56:12.909 Bo Yoon: Okay, got it?
721 00:56:15.870 ⇒ 00:56:19.550 Robert Tseng: I just like can’t believe that we cannot put them side by side. It’s just like.
722 00:56:20.210 ⇒ 00:56:30.220 Robert Tseng: honestly, I would rather do this. I would rather do 2 2 bar charts, and then a line chart like rather than to impose it. And you know, like, maybe that’s just the better way to do it.
723 00:56:30.700 ⇒ 00:56:33.030 Bo Yoon: Oh, yeah, just just 3 different charts.
724 00:56:33.030 ⇒ 00:56:33.770 Robert Tseng: Yeah.
725 00:56:34.200 ⇒ 00:56:35.519 Bo Yoon: Okay, sure,
726 00:56:37.670 ⇒ 00:56:44.549 Robert Tseng: If we can’t, if we can’t do the side by side, all in one, all in one chart, we might as well just split them up.
727 00:56:45.370 ⇒ 00:56:47.750 Bo Yoon: Hmm, okay, I got it.
728 00:56:48.310 ⇒ 00:56:48.810 Robert Tseng: Yeah.
729 00:56:54.940 ⇒ 00:56:55.490 Bo Yoon: Or.
730 00:57:00.100 ⇒ 00:57:00.600 Robert Tseng: Okay.
731 00:57:10.330 ⇒ 00:57:11.670 Robert Tseng: does that make sense.
732 00:57:12.000 ⇒ 00:57:14.469 Bo Yoon: Yeah, yeah, sure. Let me get this done.
733 00:57:18.200 ⇒ 00:57:19.050 Robert Tseng: Okay.
734 00:57:19.340 ⇒ 00:57:22.670 Bo Yoon: Can I just deploy it on the on the same account, or did I deploy?
735 00:57:24.100 ⇒ 00:57:25.510 Bo Yoon: Is there a.
736 00:57:25.660 ⇒ 00:57:30.670 Robert Tseng: Yeah, it should be the same account. Is there like a public view, or something like.
737 00:57:31.940 ⇒ 00:57:38.359 Bo Yoon: Public view. Yeah, there, there is a public view. But I don’t think they’ll want that because of privacy issues.
738 00:57:39.230 ⇒ 00:57:46.590 Bo Yoon: That’s so. If they want to to see the chart I mean the dashboard.
739 00:57:46.790 ⇒ 00:57:53.149 Bo Yoon: We will have to invite them to their I even
740 00:57:53.560 ⇒ 00:58:00.980 Bo Yoon: is that is that okay? Like they, they’ll still have to make an account, but I don’t think that’s really that difficult to do for them.
741 00:58:01.610 ⇒ 00:58:15.970 Robert Tseng: I already made it already. I I think I already converted it to paid, and we have 2 creator seats and 2 viewer seats. So I’ll just add the viewer seats. But yeah, if you can add that, and I want to deploy it and get it to metash. So.
742 00:58:16.830 ⇒ 00:58:21.189 Bo Yoon: Okay, yeah, let me deploy it on the same account. Then I’ll I’ll send you the link for that.
743 00:58:21.190 ⇒ 00:58:21.810 Robert Tseng: Okay.
744 00:58:22.040 ⇒ 00:58:23.050 Robert Tseng: Thank you.
745 00:58:23.340 ⇒ 00:58:25.000 Bo Yoon: Alright. Yeah, thank you.
746 00:58:25.450 ⇒ 00:58:27.089 Robert Tseng: Cool, alright! See ya.
747 00:58:27.090 ⇒ 00:58:28.700 Bo Yoon: Yeah, talk to you soon.