Looker Studioで日付フィルターの開始日・終了日をスコアカード表示する方法

こんにちは、中村です。

皆さんはLooker Studioの日付フィルターで開始日・終了日の値をスコアカードとして表示したいと思ったことは、ありませんか？

期間グラフで両端の値にカーソルを合わせれば見られるけど、できればぱっと見で把握できるようにしたいと思った方は少なくないはずです。

そこで今回は、Looker Studioで日付フィルターの開始日、終了日の値をスコアカードで表示する方法について解説していきます。

準備

csvファイルのデータ


index,date,total_members,new_members,active_members,inactive_members,cancelled_members
0,2025-06-01,5017,112,1181,726,95
1,2025-06-02,5092,144,1925,360,69
2,2025-06-03,5161,126,1703,299,57
3,2025-06-04,5191,117,730,112,87
4,2025-06-05,5283,190,1624,276,98
5,2025-06-06,5308,72,1210,537,47
6,2025-06-07,5349,60,1148,286,19
7,2025-06-08,5478,147,871,162,18
8,2025-06-09,5481,90,745,420,87
9,2025-06-10,5577,151,1002,144,55
10,2025-06-11,5688,161,1135,622,50
11,2025-06-12,5785,194,862,397,97
12,2025-06-13,5830,114,1255,516,69
13,2025-06-14,5929,167,1877,523,68
14,2025-06-15,5972,53,1025,278,10
15,2025-06-16,6126,195,1777,737,41
16,2025-06-17,6218,169,1947,359,77
17,2025-06-18,6279,83,1112,717,22
18,2025-06-19,6346,123,1051,350,56
19,2025-06-20,6400,77,1817,136,23
20,2025-06-21,6380,63,1417,401,83
21,2025-06-22,6484,165,976,691,61
22,2025-06-23,6590,140,1084,371,34
23,2025-06-24,6622,91,1987,343,59
24,2025-06-25,6759,174,1537,271,37
25,2025-06-26,6794,92,630,376,57
26,2025-06-27,6824,129,909,762,99
27,2025-06-28,6937,177,1208,516,64
28,2025-06-29,7017,151,1153,233,71
29,2025-06-30,7060,92,855,273,49
30,2025-07-01,7126,102,1762,433,36
31,2025-07-02,7203,145,1834,324,68
32,2025-07-03,7289,123,1135,680,37
33,2025-07-04,7351,119,1088,342,57
34,2025-07-05,7433,135,1207,570,53
35,2025-07-06,7473,102,1969,170,62
36,2025-07-07,7554,142,1064,523,61
37,2025-07-08,7723,195,1969,387,26
38,2025-07-09,7762,105,1208,177,66
39,2025-07-10,7850,112,1178,549,24
40,2025-07-11,7852,90,920,327,88
41,2025-07-12,7921,129,1757,459,60
42,2025-07-13,8003,100,735,700,18
43,2025-07-14,8078,122,683,744,47
44,2025-07-15,8209,168,1996,494,37
45,2025-07-16,8222,65,1948,578,52
46,2025-07-17,8246,75,1704,299,51
47,2025-07-18,8340,153,577,238,59
48,2025-07-19,8388,71,1297,608,23
49,2025-07-20,8432,68,1931,368,24
50,2025-07-21,8572,187,1713,142,47
51,2025-07-22,8640,111,905,788,43
52,2025-07-23,8650,86,1135,750,76
53,2025-07-24,8728,148,749,395,70
54,2025-07-25,8715,66,1839,632,79
55,2025-07-26,8726,65,1175,224,54
56,2025-07-27,8816,136,611,664,46
57,2025-07-28,8819,72,1497,303,69
58,2025-07-29,8869,142,1736,782,92
59,2025-07-30,8852,78,1361,126,95
60,2025-07-31,8898,137,1420,622,91
61,2025-08-01,9012,165,636,566,51
62,2025-08-02,9076,88,1473,559,24
63,2025-08-03,9103,109,1116,522,82
64,2025-08-04,9211,144,1762,518,36
65,2025-08-05,9290,160,1008,791,81
66,2025-08-06,9365,114,1878,586,39
67,2025-08-07,9484,171,868,580,52
68,2025-08-08,9591,190,578,701,83
69,2025-08-09,9684,135,781,298,42
70,2025-08-10,9796,155,1740,567,43
71,2025-08-11,9802,105,1623,735,99
72,2025-08-12,9825,89,1935,784,66
73,2025-08-13,9944,176,1685,346,57
74,2025-08-14,9979,62,766,258,27
75,2025-08-15,10021,78,712,532,36
76,2025-08-16,10148,149,1586,301,22
77,2025-08-17,10302,199,927,428,45
78,2025-08-18,10403,125,674,661,24
79,2025-08-19,10453,144,1315,128,94
80,2025-08-20,10518,85,1536,141,20
81,2025-08-21,10646,181,1949,618,53
82,2025-08-22,10732,176,712,375,90
83,2025-08-23,10738,63,1845,127,57
84,2025-08-24,10813,138,1698,574,63
85,2025-08-25,10945,185,1747,793,53
86,2025-08-26,10918,56,688,485,83
87,2025-08-27,11007,176,1237,294,87
88,2025-08-28,10991,61,1250,748,77
89,2025-08-29,11091,146,1120,788,46
90,2025-08-30,11201,129,1944,379,19
91,2025-08-31,11362,192,1614,604,31
92,2025-09-01,11341,58,1918,160,79
93,2025-09-02,11355,90,1330,556,76
94,2025-09-03,11402,125,1841,397,78
95,2025-09-04,11427,123,1499,248,98
96,2025-09-05,11582,189,946,427,34
97,2025-09-06,11624,78,1351,147,36
98,2025-09-07,11707,121,1691,641,38
99,2025-09-08,11757,79,1092,113,29

今回はLooker Studioのデータソースはcsvファイルにします。