折れ線グラフで表示できる「グループ/色」の項目は、デフォルトでアルファベットに並んでいるかと思います。これを売り上げの高い順で並べることは可能でしょうか？
現在、以下のような拠点のごとの売上を折れ線グラフを作っていますが、「グループ/色」の項目数が多く、最大表示可能数の50を超えています。それ自体は特に問題でなく、売上のTop50さえ表示されていれば問題ない、かつTop50から外れた拠点が見たい場合はユーザーがフィルターの指定して表示できるようにしておけば良いと考えています。
しかし、デフォルトのアルファベット順を変更する方法が見つかりませんでした。折れ線グラフの「グループ/色」の項目を売上順に並べて表示させることは可能でしょうか？
ご質問いただきありがとうございます。
データセットおよびビジュアル作成時のフィールドの設定に関して、もう少し詳しくお聞かせいただいても良いでしょうか？
です。
また、添付いただいたビジュアルから、一部のデータは縦軸方向に変動がみられますが、それ以外のデータに関しましては、横軸にほぼほぼ張り付いているように見受けられます。
これにより、一部のデータを集約して、例えば 「TOP5 + その他」のような表示方法を選択することは可能でしょうか？
お返事いただき、ありがとうございます。また、情報が欠けており、失礼いたしました。
少しややこしくて大変恐縮なのですが、以下のような設定になっております。（すみません、少し修正したら、当初のグラフの見え方と若干変わってしまいました）
sales以外は計算フィールドで作成したカラムを置いて、パラメータでグラフの粒度を変更できるようにしております。それぞれ以下のような計算フィールドを作成しております。
datetype_num
ifelse(
${datetype} = 'Weekly', ifelse(weeknum({creation_date}) = 53, 1, weeknum({creation_date})),
${datetype} = 'Monthly', extract('MM', {creation_date}),
null
)
datetype_year
ifelse(
${datetype} = 'Weekly', extract('YYYY', addDateTime(6, 'DD', truncDate('WK', {creation_date}))),
${datetype} = 'Monthly', extract('YYYY', {creation_date}),
null
)
location_type
ifelse(
${locationtype} = 'Region', {region},
${locationtype} = 'Country', {country},
${locationtype} = 'Site', {site},
null
)
「TOP5 + その他」のような表示方法を選択することは避けたいです。なぜなら拠点数が膨大なので、その他に集約すると逆にその他だけが目立ってしまうようになる可能性が高いからです。
できれば表示数は最大の50個まで、かつその50個は売上のTop50の拠点で表示できたら嬉しいです。
追加情報ありがとうございました。
ドキュメント等を含めて確認をしてみましたが、直接凡例に表示される文字列の順番をソートする方法はなさそうです。
上記ドキュメントにも、
ビジュアルの凡例は、表示/非表示を切り替えられます。凡例のタイトルと位置はフォーマットできます。凡例のタイトルと項目のフォント設定をカスタマイズすることもできます。
の記載があります。
したがって、凡例に該当するもの（今回であれば、location_typeという計算フィールド）の文字列がシステム側でソートされて返却されたものが表示されることになってしまいます。
これに関しましては、salesの合計値を使って各location_typeにランクを設定してみると、表示制限が可能です。
明記されていないパラメータや計算フィールドは、ご記載いただきましたものを流用しております。
入力データ
今回は、2023/01/01 ~ 2023/02/28 と 2024/01/01 ~ 2024/02/29 のサンプルデータを生成しております。
creation_date,region,country,site,sales,weeknum
2023/01/01,C,AA,AAA,938,1
2023/01/02,H,FF,FFF,492,1
2023/01/03,H,HH,JJJ,850,1
2023/01/04,J,II,FFF,750,1
2023/01/05,F,II,CCC,518,1
2023/01/06,C,GG,FFF,312,1
2023/01/07,G,AA,EEE,973,1
2023/01/08,A,JJ,DDD,992,2
2023/01/09,I,DD,GGG,835,2
2023/01/10,F,EE,CCC,862,2
2023/01/11,I,DD,DDD,118,2
2023/01/12,G,II,EEE,911,2
2023/01/13,G,HH,FFF,452,2
2023/01/14,J,DD,JJJ,362,2
2023/01/15,G,AA,GGG,132,3
2023/01/16,J,CC,GGG,555,3
2023/01/17,A,FF,GGG,998,3
2023/01/18,J,HH,BBB,551,3
2023/01/19,D,GG,JJJ,710,3
2023/01/20,J,FF,DDD,537,3
2023/01/21,C,DD,EEE,924,3
2023/01/22,I,GG,GGG,716,4
2023/01/23,D,JJ,EEE,125,4
2023/01/24,D,AA,GGG,560,4
2023/01/25,J,DD,JJJ,208,4
2023/01/26,F,JJ,BBB,447,4
2023/01/27,F,II,JJJ,630,4
2023/01/28,C,HH,BBB,460,4
2023/01/29,A,BB,HHH,613,5
2023/01/30,G,DD,FFF,388,5
2023/01/31,J,JJ,EEE,635,5
2023/02/01,J,AA,CCC,974,5
2023/02/02,G,FF,GGG,169,5
2023/02/03,A,CC,FFF,698,5
2023/02/04,H,EE,CCC,586,5
2023/02/05,E,BB,JJJ,360,6
2023/02/06,E,EE,BBB,443,6
2023/02/07,D,II,CCC,959,6
2023/02/08,G,CC,GGG,602,6
2023/02/09,H,DD,III,600,6
2023/02/10,F,GG,AAA,110,6
2023/02/11,C,JJ,JJJ,703,6
2023/02/12,F,GG,III,784,7
2023/02/13,B,HH,DDD,186,7
2023/02/14,D,BB,AAA,891,7
2023/02/15,J,GG,FFF,216,7
2023/02/16,D,II,AAA,461,7
2023/02/17,E,AA,HHH,376,7
2023/02/18,F,GG,HHH,717,7
2023/02/19,G,BB,FFF,510,8
2023/02/20,A,CC,CCC,164,8
2023/02/21,G,JJ,AAA,354,8
2023/02/22,G,FF,DDD,834,8
2023/02/23,H,AA,FFF,645,8
2023/02/24,J,CC,GGG,571,8
2023/02/25,J,AA,GGG,904,8
2023/02/26,D,GG,AAA,513,9
2023/02/27,F,BB,JJJ,839,9
2023/02/28,B,JJ,BBB,808,9
2023/01/01,C,II,EEE,426,1
2023/01/02,G,EE,AAA,315,1
2023/01/03,C,EE,GGG,339,1
2023/01/04,I,AA,GGG,975,1
2023/01/05,I,GG,CCC,394,1
2023/01/06,D,AA,FFF,852,1
2023/01/07,A,BB,FFF,741,1
2023/01/08,B,JJ,FFF,581,2
2023/01/09,H,GG,DDD,899,2
2023/01/10,C,GG,DDD,410,2
2023/01/11,E,EE,GGG,618,2
2023/01/12,J,GG,JJJ,302,2
2023/01/13,E,DD,DDD,743,2
2023/01/14,F,JJ,BBB,668,2
2023/01/15,G,EE,DDD,579,3
2023/01/16,D,II,FFF,113,3
2023/01/17,I,FF,EEE,228,3
2023/01/18,C,GG,CCC,529,3
2023/01/19,E,CC,FFF,618,3
2023/01/20,F,DD,GGG,230,3
2023/01/21,I,JJ,HHH,165,3
2023/01/22,A,JJ,DDD,709,4
2023/01/23,I,GG,GGG,257,4
2023/01/24,H,AA,DDD,986,4
2023/01/25,F,AA,FFF,863,4
2023/01/26,G,BB,CCC,658,4
2023/01/27,J,HH,EEE,563,4
2023/01/28,E,FF,GGG,441,4
2023/01/29,C,CC,EEE,635,5
2023/01/30,B,CC,FFF,236,5
2023/01/31,J,AA,FFF,108,5
2023/02/01,F,EE,CCC,539,5
2023/02/02,I,FF,AAA,943,5
2023/02/03,A,DD,JJJ,202,5
2023/02/04,E,GG,CCC,417,5
2023/02/05,H,DD,AAA,698,6
2023/02/06,H,HH,CCC,946,6
2023/02/07,E,DD,JJJ,524,6
2023/02/08,E,HH,CCC,450,6
2023/02/09,E,HH,BBB,224,6
2023/02/10,I,FF,HHH,196,6
2023/02/11,B,II,III,722,6
2023/02/12,B,EE,EEE,575,7
2023/02/13,D,AA,BBB,864,7
2023/02/14,C,FF,EEE,287,7
2023/02/15,C,GG,EEE,324,7
2023/02/16,H,II,DDD,483,7
2023/02/17,J,EE,FFF,475,7
2023/02/18,F,FF,EEE,967,7
2023/02/19,F,FF,HHH,740,8
2023/02/20,C,JJ,FFF,822,8
2023/02/21,A,EE,JJJ,383,8
2023/02/22,C,BB,EEE,188,8
2023/02/23,A,EE,EEE,108,8
2023/02/24,A,BB,JJJ,925,8
2023/02/25,A,HH,BBB,807,8
2023/02/26,I,BB,AAA,692,9
2023/02/27,F,AA,AAA,387,9
2023/02/28,H,GG,HHH,191,9
2024/01/01,C,HH,JJJ,799,1
2024/01/02,I,II,EEE,254,1
2024/01/03,D,EE,FFF,284,1
2024/01/04,H,BB,III,489,1
2024/01/05,B,GG,GGG,210,1
2024/01/06,J,II,HHH,733,1
2024/01/07,J,CC,JJJ,758,2
2024/01/08,I,FF,III,743,2
2024/01/09,H,AA,DDD,590,2
2024/01/10,D,BB,BBB,243,2
2024/01/11,D,FF,AAA,960,2
2024/01/12,B,BB,AAA,947,2
2024/01/13,G,CC,DDD,381,2
2024/01/14,H,AA,FFF,941,3
2024/01/15,E,GG,JJJ,646,3
2024/01/16,E,II,EEE,129,3
2024/01/17,B,CC,EEE,773,3
2024/01/18,C,HH,HHH,360,3
2024/01/19,B,JJ,FFF,438,3
2024/01/20,B,CC,III,623,3
2024/01/21,E,JJ,DDD,187,4
2024/01/22,E,HH,DDD,682,4
2024/01/23,B,BB,DDD,436,4
2024/01/24,E,FF,FFF,630,4
2024/01/25,G,GG,HHH,916,4
2024/01/26,A,CC,EEE,141,4
2024/01/27,D,DD,GGG,170,4
2024/01/28,E,AA,CCC,597,5
2024/01/29,C,HH,JJJ,207,5
2024/01/30,I,EE,DDD,925,5
2024/01/31,J,BB,GGG,279,5
2024/02/01,B,CC,DDD,466,5
2024/02/02,G,II,CCC,970,5
2024/02/03,E,CC,HHH,722,5
2024/02/04,F,DD,EEE,596,6
2024/02/05,J,EE,DDD,369,6
2024/02/06,J,AA,III,796,6
2024/02/07,G,JJ,JJJ,133,6
2024/02/08,I,BB,BBB,715,6
2024/02/09,D,BB,BBB,445,6
2024/02/10,C,JJ,CCC,322,6
2024/02/11,G,JJ,BBB,156,7
2024/02/12,G,II,AAA,885,7
2024/02/13,B,HH,FFF,469,7
2024/02/14,H,GG,HHH,969,7
2024/02/15,I,HH,III,981,7
2024/02/16,D,JJ,DDD,167,7
2024/02/17,C,AA,HHH,853,7
2024/02/18,J,FF,CCC,765,8
2024/02/19,C,CC,FFF,321,8
2024/02/20,B,AA,HHH,797,8
2024/02/21,I,DD,BBB,740,8
2024/02/22,I,FF,EEE,729,8
2024/02/23,H,CC,HHH,396,8
2024/02/24,D,HH,HHH,876,8
2024/02/25,A,GG,JJJ,206,9
2024/02/26,E,AA,III,472,9
2024/02/27,C,II,DDD,907,9
2024/02/28,D,BB,JJJ,700,9
2024/02/29,F,CC,FFF,432,9
2024/01/01,G,FF,III,992,1
2024/01/02,I,EE,CCC,581,1
2024/01/03,A,HH,EEE,578,1
2024/01/04,J,GG,EEE,288,1
2024/01/05,J,II,DDD,415,1
2024/01/06,A,JJ,III,462,1
2024/01/07,E,HH,EEE,939,2
2024/01/08,I,GG,AAA,102,2
2024/01/09,G,EE,EEE,885,2
2024/01/10,D,GG,JJJ,774,2
2024/01/11,B,HH,CCC,185,2
2024/01/12,B,HH,CCC,467,2
2024/01/13,A,HH,AAA,951,2
2024/01/14,A,II,GGG,726,3
2024/01/15,F,FF,BBB,312,3
2024/01/16,A,CC,FFF,227,3
2024/01/17,D,HH,CCC,297,3
2024/01/18,A,AA,FFF,825,3
2024/01/19,H,GG,CCC,569,3
2024/01/20,G,DD,JJJ,527,3
2024/01/21,H,FF,JJJ,121,4
2024/01/22,B,DD,FFF,469,4
2024/01/23,A,CC,HHH,516,4
2024/01/24,E,EE,III,173,4
2024/01/25,H,JJ,AAA,346,4
2024/01/26,J,HH,AAA,975,4
2024/01/27,D,HH,DDD,734,4
2024/01/28,H,BB,EEE,527,5
2024/01/29,D,EE,GGG,647,5
2024/01/30,I,JJ,FFF,476,5
2024/01/31,C,BB,BBB,435,5
2024/02/01,D,JJ,DDD,592,5
2024/02/02,A,CC,BBB,944,5
2024/02/03,B,CC,GGG,109,5
2024/02/04,G,AA,HHH,469,6
2024/02/05,H,HH,EEE,616,6
2024/02/06,B,HH,EEE,701,6
2024/02/07,F,DD,GGG,714,6
2024/02/08,B,II,GGG,911,6
2024/02/09,G,BB,BBB,939,6
2024/02/10,G,AA,BBB,695,6
2024/02/11,D,HH,HHH,929,7
2024/02/12,D,HH,HHH,774,7
2024/02/13,H,EE,FFF,306,7
2024/02/14,I,EE,HHH,835,7
2024/02/15,I,GG,BBB,698,7
2024/02/16,A,II,GGG,242,7
2024/02/17,H,BB,CCC,697,7
2024/02/18,G,CC,III,840,8
2024/02/19,J,BB,JJJ,431,8
2024/02/20,G,II,EEE,551,8
2024/02/21,I,DD,HHH,796,8
2024/02/22,A,HH,DDD,278,8
2024/02/23,I,GG,HHH,370,8
2024/02/24,E,BB,CCC,747,8
2024/02/25,B,FF,EEE,603,9
2024/02/26,B,II,III,550,9
2024/02/27,B,FF,GGG,727,9
2024/02/28,H,BB,AAA,520,9
2024/02/29,A,AA,FFF,293,9
2023/01/01,I,BB,GGG,230,1
2023/01/02,C,GG,EEE,963,1
2023/01/03,H,II,GGG,111,1
2023/01/04,C,JJ,DDD,449,1
2023/01/05,J,DD,GGG,487,1
2023/01/06,F,DD,AAA,603,1
2023/01/07,H,FF,GGG,647,1
2023/01/08,E,HH,GGG,541,2
2023/01/09,B,JJ,FFF,788,2
2023/01/10,F,HH,GGG,542,2
2023/01/11,H,GG,EEE,841,2
2023/01/12,J,HH,HHH,261,2
2023/01/13,E,DD,CCC,284,2
2023/01/14,J,AA,CCC,889,2
2023/01/15,H,HH,GGG,724,3
2023/01/16,A,FF,EEE,955,3
2023/01/17,I,AA,AAA,327,3
2023/01/18,I,EE,JJJ,867,3
2023/01/19,E,JJ,BBB,481,3
2023/01/20,J,DD,GGG,679,3
2023/01/21,C,II,CCC,460,3
2023/01/22,A,GG,CCC,513,4
2023/01/23,J,GG,BBB,609,4
2023/01/24,A,HH,HHH,753,4
2023/01/25,E,EE,III,278,4
2023/01/26,C,DD,III,276,4
2023/01/27,E,EE,AAA,900,4
2023/01/28,H,JJ,III,300,4
2023/01/29,H,JJ,FFF,977,5
2023/01/30,H,II,HHH,389,5
2023/01/31,D,FF,JJJ,707,5
2023/02/01,F,HH,FFF,774,5
2023/02/02,A,DD,BBB,126,5
2023/02/03,A,II,GGG,860,5
2023/02/04,F,BB,EEE,752,5
2023/02/05,I,AA,III,425,6
2023/02/06,D,HH,HHH,688,6
2023/02/07,D,EE,AAA,967,6
2023/02/08,E,EE,BBB,968,6
2023/02/09,J,BB,JJJ,969,6
2023/02/10,G,CC,GGG,407,6
2023/02/11,I,EE,HHH,857,6
2023/02/12,A,BB,BBB,839,7
2023/02/13,F,CC,JJJ,107,7
2023/02/14,H,BB,CCC,237,7
2023/02/15,D,HH,III,117,7
2023/02/16,B,GG,HHH,508,7
2023/02/17,J,CC,HHH,567,7
2023/02/18,D,CC,DDD,349,7
2023/02/19,C,CC,JJJ,738,8
2023/02/20,J,BB,CCC,138,8
2023/02/21,F,CC,FFF,234,8
2023/02/22,F,HH,FFF,863,8
2023/02/23,G,CC,GGG,956,8
2023/02/24,J,JJ,FFF,719,8
2023/02/25,J,II,CCC,146,8
2023/02/26,I,GG,GGG,918,9
2023/02/27,E,CC,EEE,579,9
2023/02/28,B,CC,DDD,183,9
2023/01/01,D,DD,FFF,999,1
2023/01/02,G,FF,III,617,1
2023/01/03,E,HH,GGG,296,1
2023/01/04,C,AA,FFF,405,1
2023/01/05,D,FF,EEE,511,1
2023/01/06,F,DD,CCC,279,1
2023/01/07,I,AA,AAA,673,1
2023/01/08,E,JJ,III,954,2
2023/01/09,F,FF,CCC,275,2
2023/01/10,A,BB,CCC,257,2
2023/01/11,A,GG,JJJ,506,2
2023/01/12,F,DD,AAA,701,2
2023/01/13,F,CC,CCC,201,2
2023/01/14,F,II,EEE,440,2
2023/01/15,B,DD,GGG,150,3
2023/01/16,E,GG,BBB,361,3
2023/01/17,I,BB,FFF,265,3
2023/01/18,B,GG,BBB,108,3
2023/01/19,B,BB,AAA,961,3
2023/01/20,C,II,III,633,3
2023/01/21,A,AA,DDD,465,3
2023/01/22,J,BB,BBB,900,4
2023/01/23,J,JJ,III,382,4
2023/01/24,A,DD,DDD,238,4
2023/01/25,C,JJ,CCC,632,4
2023/01/26,J,FF,BBB,384,4
2023/01/27,G,DD,AAA,668,4
2023/01/28,F,II,JJJ,833,4
2023/01/29,I,FF,EEE,770,5
2023/01/30,B,JJ,BBB,623,5
2023/01/31,C,AA,III,143,5
2023/02/01,J,BB,EEE,648,5
2023/02/02,J,BB,CCC,309,5
2023/02/03,J,CC,FFF,433,5
2023/02/04,G,DD,DDD,345,5
2023/02/05,F,JJ,GGG,761,6
2023/02/06,B,AA,BBB,287,6
2023/02/07,A,JJ,HHH,914,6
2023/02/08,I,EE,HHH,103,6
2023/02/09,A,CC,JJJ,825,6
2023/02/10,A,JJ,JJJ,478,6
2023/02/11,B,JJ,DDD,372,6
2023/02/12,F,AA,JJJ,593,7
2023/02/13,E,CC,CCC,361,7
2023/02/14,E,JJ,JJJ,925,7
2023/02/15,B,FF,BBB,485,7
2023/02/16,C,JJ,CCC,906,7
2023/02/17,B,AA,III,970,7
2023/02/18,E,HH,FFF,287,7
2023/02/19,H,FF,FFF,388,8
2023/02/20,I,JJ,FFF,320,8
2023/02/21,H,CC,JJJ,989,8
2023/02/22,I,FF,JJJ,336,8
2023/02/23,G,DD,DDD,473,8
2023/02/24,A,EE,BBB,264,8
2023/02/25,D,JJ,CCC,178,8
2023/02/26,I,FF,EEE,120,9
2023/02/27,C,BB,BBB,487,9
2023/02/28,C,GG,DDD,297,9
2024/01/01,A,CC,AAA,974,1
2024/01/02,F,AA,FFF,925,1
2024/01/03,I,GG,JJJ,559,1
2024/01/04,F,II,JJJ,738,1
2024/01/05,E,BB,FFF,308,1
2024/01/06,B,EE,BBB,614,1
2024/01/07,I,CC,CCC,700,2
2024/01/08,H,II,AAA,485,2
2024/01/09,A,AA,GGG,626,2
2024/01/10,C,AA,III,548,2
2024/01/11,J,HH,CCC,389,2
2024/01/12,E,BB,DDD,251,2
2024/01/13,E,FF,JJJ,792,2
2024/01/14,C,HH,HHH,634,3
2024/01/15,D,JJ,JJJ,193,3
2024/01/16,G,BB,GGG,711,3
2024/01/17,A,FF,III,944,3
2024/01/18,H,EE,JJJ,484,3
2024/01/19,C,FF,CCC,515,3
2024/01/20,H,DD,HHH,261,3
2024/01/21,C,EE,EEE,340,4
2024/01/22,J,EE,EEE,810,4
2024/01/23,D,FF,BBB,619,4
2024/01/24,A,CC,DDD,871,4
2024/01/25,I,HH,EEE,619,4
2024/01/26,E,HH,EEE,154,4
2024/01/27,A,GG,EEE,541,4
2024/01/28,B,II,BBB,312,5
2024/01/29,H,JJ,AAA,759,5
2024/01/30,C,GG,FFF,684,5
2024/01/31,H,JJ,FFF,779,5
2024/02/01,F,GG,HHH,571,5
2024/02/02,I,EE,JJJ,893,5
2024/02/03,J,JJ,DDD,465,5
2024/02/04,F,JJ,GGG,962,6
2024/02/05,B,JJ,DDD,544,6
2024/02/06,C,CC,DDD,856,6
2024/02/07,D,BB,BBB,604,6
2024/02/08,I,CC,HHH,925,6
2024/02/09,C,AA,EEE,737,6
2024/02/10,I,DD,III,785,6
2024/02/11,I,HH,BBB,957,7
2024/02/12,J,JJ,BBB,830,7
2024/02/13,A,BB,AAA,144,7
2024/02/14,G,II,AAA,221,7
2024/02/15,F,II,GGG,617,7
2024/02/16,J,DD,III,618,7
2024/02/17,E,II,JJJ,706,7
2024/02/18,A,EE,BBB,996,8
2024/02/19,B,II,JJJ,907,8
2024/02/20,J,CC,JJJ,861,8
2024/02/21,I,DD,DDD,163,8
2024/02/22,G,AA,JJJ,377,8
2024/02/23,B,JJ,AAA,225,8
2024/02/24,D,GG,AAA,106,8
2024/02/25,H,GG,FFF,404,9
2024/02/26,A,HH,BBB,591,9
2024/02/27,B,AA,GGG,680,9
2024/02/28,C,BB,BBB,437,9
2024/02/29,A,GG,GGG,890,9
2024/01/01,G,DD,GGG,268,1
2024/01/02,F,II,DDD,633,1
2024/01/03,C,EE,III,270,1
2024/01/04,G,EE,CCC,170,1
2024/01/05,J,GG,HHH,710,1
2024/01/06,C,GG,HHH,916,1
2024/01/07,E,AA,CCC,441,2
2024/01/08,F,HH,JJJ,682,2
2024/01/09,F,FF,GGG,981,2
2024/01/10,D,CC,FFF,965,2
2024/01/11,B,II,III,661,2
2024/01/12,J,GG,EEE,222,2
2024/01/13,E,II,DDD,462,2
2024/01/14,D,BB,III,242,3
2024/01/15,E,FF,JJJ,553,3
2024/01/16,A,JJ,DDD,418,3
2024/01/17,D,EE,GGG,411,3
2024/01/18,A,JJ,FFF,363,3
2024/01/19,C,EE,III,504,3
2024/01/20,I,EE,GGG,407,3
2024/01/21,H,HH,JJJ,832,4
2024/01/22,F,HH,III,249,4
2024/01/23,B,DD,III,878,4
2024/01/24,D,AA,GGG,198,4
2024/01/25,I,JJ,FFF,209,4
2024/01/26,J,AA,DDD,767,4
2024/01/27,H,II,EEE,405,4
2024/01/28,F,FF,DDD,971,5
2024/01/29,B,GG,BBB,175,5
2024/01/30,I,HH,FFF,229,5
2024/01/31,F,JJ,DDD,394,5
2024/02/01,C,HH,AAA,647,5
2024/02/02,C,II,DDD,679,5
2024/02/03,H,CC,JJJ,691,5
2024/02/04,A,EE,BBB,803,6
2024/02/05,E,GG,AAA,666,6
2024/02/06,I,DD,HHH,710,6
2024/02/07,F,BB,AAA,310,6
2024/02/08,F,DD,AAA,648,6
2024/02/09,F,DD,BBB,680,6
2024/02/10,J,EE,GGG,975,6
2024/02/11,D,GG,FFF,972,7
2024/02/12,C,JJ,AAA,208,7
2024/02/13,F,BB,AAA,700,7
2024/02/14,B,BB,JJJ,848,7
2024/02/15,C,EE,III,623,7
2024/02/16,H,HH,EEE,943,7
2024/02/17,B,AA,HHH,912,7
2024/02/18,E,BB,DDD,983,8
2024/02/19,E,GG,HHH,993,8
2024/02/20,J,HH,DDD,334,8
2024/02/21,A,JJ,AAA,318,8
2024/02/22,J,DD,JJJ,645,8
2024/02/23,I,JJ,AAA,712,8
2024/02/24,I,BB,GGG,498,8
2024/02/25,F,DD,HHH,143,9
2024/02/26,H,HH,JJJ,818,9
2024/02/27,B,DD,EEE,999,9
2024/02/28,B,JJ,III,459,9
2024/02/29,I,JJ,AAA,296,9
2023/01/01,G,HH,FFF,948,1
2023/01/02,D,JJ,CCC,154,1
2023/01/03,H,GG,III,860,1
2023/01/04,J,EE,AAA,835,1
2023/01/05,D,CC,CCC,825,1
2023/01/06,D,II,FFF,452,1
2023/01/07,C,II,AAA,698,1
2023/01/08,E,EE,AAA,937,2
2023/01/09,B,FF,DDD,220,2
2023/01/10,I,EE,EEE,798,2
2023/01/11,B,GG,DDD,208,2
2023/01/12,J,CC,BBB,848,2
2023/01/13,H,HH,HHH,960,2
2023/01/14,C,AA,BBB,975,2
2023/01/15,F,BB,EEE,355,3
2023/01/16,B,HH,CCC,482,3
2023/01/17,F,AA,BBB,786,3
2023/01/18,H,DD,FFF,537,3
2023/01/19,G,GG,CCC,998,3
2023/01/20,D,DD,GGG,425,3
2023/01/21,I,BB,FFF,231,3
2023/01/22,C,CC,GGG,476,4
2023/01/23,I,GG,GGG,278,4
2023/01/24,B,CC,BBB,295,4
2023/01/25,J,II,BBB,804,4
2023/01/26,C,CC,AAA,419,4
2023/01/27,A,FF,DDD,852,4
2023/01/28,A,JJ,AAA,576,4
2023/01/29,D,EE,AAA,534,5
2023/01/30,D,AA,III,253,5
2023/01/31,B,AA,BBB,159,5
2023/02/01,G,GG,JJJ,715,5
2023/02/02,I,FF,JJJ,151,5
2023/02/03,B,HH,JJJ,425,5
2023/02/04,J,DD,JJJ,328,5
2023/02/05,C,II,GGG,962,6
2023/02/06,J,JJ,JJJ,186,6
2023/02/07,F,HH,HHH,611,6
2023/02/08,D,EE,JJJ,178,6
2023/02/09,H,II,BBB,605,6
2023/02/10,H,EE,CCC,999,6
2023/02/11,H,CC,III,815,6
2023/02/12,F,DD,EEE,584,7
2023/02/13,I,II,BBB,216,7
2023/02/14,A,HH,AAA,492,7
2023/02/15,B,HH,BBB,466,7
2023/02/16,A,FF,FFF,194,7
2023/02/17,D,BB,DDD,206,7
2023/02/18,H,HH,AAA,451,7
2023/02/19,D,HH,CCC,578,8
2023/02/20,I,AA,AAA,361,8
2023/02/21,H,CC,AAA,104,8
2023/02/22,H,JJ,HHH,893,8
2023/02/23,F,BB,JJJ,602,8
2023/02/24,F,GG,AAA,204,8
2023/02/25,E,HH,HHH,922,8
2023/02/26,A,AA,EEE,893,9
2023/02/27,D,AA,FFF,871,9
2023/02/28,J,II,BBB,459,9
2023/01/01,H,DD,HHH,982,1
2023/01/02,D,EE,BBB,117,1
2023/01/03,A,CC,EEE,319,1
2023/01/04,C,DD,GGG,192,1
2023/01/05,A,GG,GGG,343,1
2023/01/06,H,HH,AAA,618,1
2023/01/07,B,AA,CCC,102,1
2023/01/08,F,FF,III,622,2
2023/01/09,B,CC,GGG,147,2
2023/01/10,F,II,AAA,822,2
2023/01/11,G,II,III,264,2
2023/01/12,B,CC,III,733,2
2023/01/13,A,HH,GGG,486,2
2023/01/14,C,GG,III,158,2
2023/01/15,I,AA,CCC,970,3
2023/01/16,E,DD,III,212,3
2023/01/17,J,CC,CCC,365,3
2023/01/18,G,GG,III,501,3
2023/01/19,I,CC,JJJ,821,3
2023/01/20,G,CC,III,703,3
2023/01/21,B,II,HHH,900,3
2023/01/22,B,JJ,EEE,888,4
2023/01/23,J,HH,BBB,906,4
2023/01/24,E,EE,III,806,4
2023/01/25,I,JJ,AAA,154,4
2023/01/26,D,GG,GGG,392,4
2023/01/27,I,GG,EEE,955,4
2023/01/28,H,GG,GGG,860,4
2023/01/29,E,II,GGG,578,5
2023/01/30,F,GG,DDD,823,5
2023/01/31,G,HH,EEE,836,5
2023/02/01,E,EE,FFF,573,5
2023/02/02,D,DD,DDD,398,5
2023/02/03,B,AA,CCC,310,5
2023/02/04,I,EE,GGG,274,5
2023/02/05,H,HH,HHH,467,6
2023/02/06,C,FF,EEE,632,6
2023/02/07,D,JJ,III,628,6
2023/02/08,H,EE,AAA,390,6
2023/02/09,C,AA,GGG,250,6
2023/02/10,G,AA,CCC,567,6
2023/02/11,D,GG,DDD,884,6
2023/02/12,D,JJ,HHH,750,7
2023/02/13,H,JJ,AAA,506,7
2023/02/14,E,BB,JJJ,674,7
2023/02/15,D,HH,CCC,437,7
2023/02/16,I,CC,III,175,7
2023/02/17,A,GG,JJJ,576,7
2023/02/18,B,BB,EEE,801,7
2023/02/19,D,AA,GGG,765,8
2023/02/20,J,CC,BBB,386,8
2023/02/21,D,JJ,JJJ,441,8
2023/02/22,B,II,AAA,301,8
2023/02/23,G,GG,GGG,173,8
2023/02/24,J,EE,HHH,124,8
2023/02/25,C,BB,EEE,240,8
2023/02/26,C,AA,EEE,701,9
2023/02/27,E,CC,HHH,551,9
2023/02/28,D,AA,JJJ,398,9
2024/01/01,E,CC,DDD,877,1
2024/01/02,D,FF,GGG,237,1
2024/01/03,I,EE,EEE,531,1
2024/01/04,D,BB,CCC,244,1
2024/01/05,G,DD,GGG,169,1
2024/01/06,J,HH,CCC,139,1
2024/01/07,A,DD,BBB,801,2
2024/01/08,F,FF,HHH,524,2
2024/01/09,B,FF,DDD,650,2
2024/01/10,F,JJ,GGG,779,2
2024/01/11,J,FF,JJJ,513,2
2024/01/12,D,AA,EEE,584,2
2024/01/13,D,CC,BBB,759,2
2024/01/14,I,II,FFF,688,3
2024/01/15,I,JJ,CCC,710,3
2024/01/16,G,BB,DDD,601,3
2024/01/17,F,BB,FFF,314,3
2024/01/18,F,JJ,DDD,418,3
2024/01/19,J,GG,FFF,170,3
2024/01/20,A,BB,CCC,990,3
2024/01/21,E,BB,HHH,555,4
2024/01/22,F,JJ,HHH,817,4
2024/01/23,I,EE,FFF,524,4
2024/01/24,D,FF,DDD,652,4
2024/01/25,G,AA,CCC,645,4
2024/01/26,D,AA,JJJ,260,4
2024/01/27,J,FF,JJJ,770,4
2024/01/28,I,DD,III,290,5
2024/01/29,C,FF,BBB,647,5
2024/01/30,G,CC,DDD,849,5
2024/01/31,C,CC,BBB,767,5
2024/02/01,J,II,GGG,594,5
2024/02/02,J,GG,AAA,764,5
2024/02/03,J,CC,CCC,525,5
2024/02/04,E,DD,FFF,392,6
2024/02/05,I,BB,AAA,908,6
2024/02/06,E,FF,HHH,297,6
2024/02/07,D,II,EEE,457,6
2024/02/08,G,CC,CCC,235,6
2024/02/09,J,AA,GGG,100,6
2024/02/10,C,FF,EEE,824,6
2024/02/11,A,GG,DDD,188,7
2024/02/12,E,BB,BBB,322,7
2024/02/13,E,BB,AAA,785,7
2024/02/14,D,GG,GGG,608,7
2024/02/15,J,DD,DDD,977,7
2024/02/16,F,DD,EEE,735,7
2024/02/17,E,EE,JJJ,785,7
2024/02/18,B,CC,DDD,372,8
2024/02/19,I,FF,AAA,336,8
2024/02/20,A,HH,EEE,349,8
2024/02/21,H,BB,EEE,630,8
2024/02/22,D,II,GGG,859,8
2024/02/23,J,II,BBB,361,8
2024/02/24,H,GG,CCC,127,8
2024/02/25,J,AA,FFF,628,9
2024/02/26,A,JJ,CCC,570,9
2024/02/27,F,II,BBB,698,9
2024/02/28,H,DD,AAA,292,9
2024/02/29,G,HH,HHH,983,9
2024/01/01,C,DD,HHH,844,1
2024/01/02,J,BB,FFF,365,1
2024/01/03,B,HH,III,732,1
2024/01/04,B,FF,CCC,131,1
2024/01/05,A,FF,GGG,501,1
2024/01/06,A,II,HHH,369,1
2024/01/07,J,EE,III,304,2
2024/01/08,B,HH,JJJ,476,2
2024/01/09,I,JJ,EEE,693,2
2024/01/10,J,CC,HHH,542,2
2024/01/11,H,FF,EEE,604,2
2024/01/12,I,DD,GGG,227,2
2024/01/13,J,CC,AAA,463,2
2024/01/14,I,II,GGG,985,3
2024/01/15,H,FF,BBB,245,3
2024/01/16,J,CC,JJJ,959,3
2024/01/17,D,DD,CCC,470,3
2024/01/18,A,GG,BBB,596,3
2024/01/19,A,GG,BBB,596,3
2024/01/20,D,EE,BBB,584,3
2024/01/21,F,JJ,FFF,447,4
2024/01/22,F,JJ,EEE,608,4
2024/01/23,E,II,HHH,184,4
2024/01/24,I,DD,GGG,398,4
2024/01/25,E,EE,EEE,387,4
2024/01/26,E,AA,III,775,4
2024/01/27,B,CC,GGG,268,4
2024/01/28,I,DD,AAA,683,5
2024/01/29,H,DD,DDD,934,5
2024/01/30,J,DD,BBB,931,5
2024/01/31,H,EE,GGG,753,5
2024/02/01,C,DD,BBB,310,5
2024/02/02,F,CC,CCC,718,5
2024/02/03,G,BB,JJJ,933,5
2024/02/04,B,DD,GGG,433,6
2024/02/05,J,AA,FFF,827,6
2024/02/06,B,BB,EEE,647,6
2024/02/07,F,GG,III,285,6
2024/02/08,F,CC,EEE,175,6
2024/02/09,A,CC,JJJ,798,6
2024/02/10,E,GG,JJJ,641,6
2024/02/11,E,AA,AAA,634,7
2024/02/12,D,HH,EEE,986,7
2024/02/13,I,CC,III,801,7
2024/02/14,C,II,DDD,669,7
2024/02/15,C,CC,CCC,557,7
2024/02/16,I,FF,DDD,159,7
2024/02/17,G,DD,AAA,414,7
2024/02/18,H,BB,GGG,142,8
2024/02/19,G,AA,EEE,321,8
2024/02/20,G,EE,DDD,709,8
2024/02/21,A,HH,JJJ,682,8
2024/02/22,E,AA,JJJ,602,8
2024/02/23,E,BB,BBB,920,8
2024/02/24,H,II,FFF,245,8
2024/02/25,C,BB,BBB,223,9
2024/02/26,C,CC,AAA,476,9
2024/02/27,F,BB,AAA,961,9
2024/02/28,C,BB,BBB,778,9
2024/02/29,I,FF,JJJ,966,9
2023/01/01,A,HH,JJJ,401,1
2023/01/02,F,II,DDD,663,1
2023/01/03,B,GG,JJJ,973,1
2023/01/04,I,AA,AAA,457,1
2023/01/05,F,CC,III,860,1
2023/01/06,E,HH,AAA,260,1
2023/01/07,A,AA,JJJ,938,1
2023/01/08,F,BB,III,991,2
2023/01/09,B,BB,BBB,897,2
2023/01/10,D,HH,BBB,169,2
2023/01/11,I,CC,JJJ,246,2
2023/01/12,H,CC,CCC,836,2
2023/01/13,I,II,HHH,440,2
2023/01/14,B,BB,GGG,362,2
2023/01/15,F,HH,JJJ,278,3
2023/01/16,I,BB,DDD,103,3
2023/01/17,B,JJ,BBB,210,3
2023/01/18,C,CC,FFF,637,3
2023/01/19,A,FF,III,102,3
2023/01/20,E,AA,DDD,542,3
2023/01/21,H,II,HHH,275,3
2023/01/22,A,JJ,BBB,766,4
2023/01/23,F,DD,AAA,491,4
2023/01/24,D,BB,DDD,891,4
2023/01/25,F,EE,BBB,839,4
2023/01/26,A,JJ,CCC,115,4
2023/01/27,C,GG,FFF,316,4
2023/01/28,F,II,FFF,191,4
2023/01/29,I,JJ,FFF,802,5
2023/01/30,J,II,GGG,727,5
2023/01/31,E,EE,FFF,792,5
2023/02/01,H,II,FFF,737,5
2023/02/02,J,DD,GGG,312,5
2023/02/03,D,II,BBB,916,5
2023/02/04,B,GG,CCC,952,5
2023/02/05,G,EE,HHH,327,6
2023/02/06,I,JJ,III,425,6
2023/02/07,A,CC,FFF,511,6
2023/02/08,I,GG,BBB,554,6
2023/02/09,J,FF,DDD,824,6
2023/02/10,E,BB,AAA,741,6
2023/02/11,J,GG,JJJ,784,6
2023/02/12,B,AA,DDD,360,7
2023/02/13,H,GG,GGG,366,7
2023/02/14,E,GG,CCC,287,7
2023/02/15,C,II,BBB,718,7
2023/02/16,I,EE,JJJ,598,7
2023/02/17,E,FF,GGG,405,7
2023/02/18,D,AA,HHH,277,7
2023/02/19,G,AA,BBB,874,8
2023/02/20,F,FF,AAA,808,8
2023/02/21,H,GG,III,669,8
2023/02/22,C,II,AAA,697,8
2023/02/23,F,FF,CCC,749,8
2023/02/24,F,DD,DDD,994,8
2023/02/25,I,EE,GGG,431,8
2023/02/26,A,FF,GGG,450,9
2023/02/27,C,FF,HHH,219,9
2023/02/28,A,BB,JJJ,880,9
2023/01/01,E,CC,BBB,441,1
2023/01/02,G,II,DDD,370,1
2023/01/03,A,JJ,AAA,555,1
2023/01/04,J,HH,GGG,233,1
2023/01/05,J,GG,AAA,202,1
2023/01/06,G,II,BBB,501,1
2023/01/07,B,AA,CCC,347,1
2023/01/08,B,HH,III,982,2
2023/01/09,F,HH,DDD,897,2
2023/01/10,A,CC,FFF,647,2
2023/01/11,D,EE,AAA,197,2
2023/01/12,F,BB,FFF,555,2
2023/01/13,H,FF,AAA,979,2
2023/01/14,B,HH,HHH,433,2
2023/01/15,D,EE,BBB,820,3
2023/01/16,J,DD,EEE,899,3
2023/01/17,C,BB,HHH,385,3
2023/01/18,J,GG,FFF,450,3
2023/01/19,E,HH,DDD,873,3
2023/01/20,H,DD,EEE,335,3
2023/01/21,H,BB,DDD,272,3
2023/01/22,F,JJ,GGG,755,4
2023/01/23,J,EE,FFF,299,4
2023/01/24,F,CC,GGG,894,4
2023/01/25,C,II,HHH,106,4
2023/01/26,G,HH,AAA,646,4
2023/01/27,D,JJ,HHH,965,4
2023/01/28,H,HH,JJJ,282,4
2023/01/29,F,AA,DDD,239,5
2023/01/30,H,CC,EEE,279,5
2023/01/31,D,JJ,JJJ,794,5
2023/02/01,I,GG,AAA,646,5
2023/02/02,F,BB,BBB,282,5
2023/02/03,D,EE,HHH,732,5
2023/02/04,H,CC,JJJ,854,5
2023/02/05,D,II,FFF,872,6
2023/02/06,E,FF,BBB,527,6
2023/02/07,D,GG,DDD,393,6
2023/02/08,E,II,CCC,816,6
2023/02/09,D,II,GGG,468,6
2023/02/10,C,GG,GGG,112,6
2023/02/11,G,JJ,DDD,683,6
2023/02/12,C,JJ,HHH,371,7
2023/02/13,B,FF,HHH,387,7
2023/02/14,C,BB,AAA,424,7
2023/02/15,C,GG,CCC,542,7
2023/02/16,J,DD,AAA,238,7
2023/02/17,C,FF,CCC,817,7
2023/02/18,A,BB,CCC,971,7
2023/02/19,J,BB,BBB,536,8
2023/02/20,D,EE,CCC,993,8
2023/02/21,I,II,FFF,750,8
2023/02/22,A,GG,CCC,461,8
2023/02/23,F,CC,FFF,589,8
2023/02/24,F,JJ,FFF,923,8
2023/02/25,E,FF,CCC,705,8
2023/02/26,H,DD,III,853,9
2023/02/27,E,FF,CCC,912,9
2023/02/28,H,II,EEE,836,9
2024/01/01,J,DD,CCC,473,1
2024/01/02,D,FF,GGG,840,1
2024/01/03,C,HH,GGG,765,1
2024/01/04,I,II,BBB,746,1
2024/01/05,D,DD,CCC,255,1
2024/01/06,C,AA,III,577,1
2024/01/07,F,CC,JJJ,806,2
2024/01/08,C,AA,FFF,147,2
2024/01/09,I,JJ,FFF,860,2
2024/01/10,I,HH,BBB,445,2
2024/01/11,C,JJ,AAA,889,2
2024/01/12,H,FF,JJJ,646,2
2024/01/13,C,JJ,GGG,310,2
2024/01/14,G,HH,GGG,658,3
2024/01/15,J,HH,CCC,497,3
2024/01/16,J,HH,III,571,3
2024/01/17,G,GG,III,560,3
2024/01/18,F,BB,AAA,467,3
2024/01/19,I,CC,EEE,452,3
2024/01/20,G,II,EEE,596,3
2024/01/21,D,II,HHH,759,4
2024/01/22,C,BB,CCC,433,4
2024/01/23,D,CC,AAA,206,4
2024/01/24,F,CC,HHH,135,4
2024/01/25,I,JJ,AAA,871,4
2024/01/26,C,EE,III,137,4
2024/01/27,E,FF,AAA,352,4
2024/01/28,J,HH,EEE,720,5
2024/01/29,D,DD,III,409,5
2024/01/30,E,BB,DDD,532,5
2024/01/31,G,GG,III,161,5
2024/02/01,A,FF,AAA,316,5
2024/02/02,E,BB,GGG,105,5
2024/02/03,I,EE,DDD,682,5
2024/02/04,I,BB,GGG,784,6
2024/02/05,J,HH,DDD,993,6
2024/02/06,G,EE,HHH,350,6
2024/02/07,E,II,DDD,812,6
2024/02/08,A,FF,GGG,352,6
2024/02/09,G,CC,DDD,626,6
2024/02/10,B,EE,HHH,669,6
2024/02/11,J,EE,DDD,992,7
2024/02/12,C,FF,GGG,712,7
2024/02/13,B,FF,JJJ,249,7
2024/02/14,E,BB,FFF,403,7
2024/02/15,C,HH,BBB,738,7
2024/02/16,F,JJ,BBB,923,7
2024/02/17,D,II,AAA,990,7
2024/02/18,C,CC,JJJ,142,8
2024/02/19,C,EE,EEE,472,8
2024/02/20,F,EE,BBB,202,8
2024/02/21,B,FF,DDD,479,8
2024/02/22,D,AA,EEE,365,8
2024/02/23,D,DD,GGG,752,8
2024/02/24,H,GG,AAA,650,8
2024/02/25,F,HH,III,908,9
2024/02/26,I,HH,JJJ,645,9
2024/02/27,E,CC,FFF,233,9
2024/02/28,H,II,CCC,773,9
2024/02/29,H,DD,III,810,9
2024/01/01,F,JJ,GGG,965,1
2024/01/02,G,FF,EEE,914,1
2024/01/03,H,HH,FFF,363,1
2024/01/04,C,DD,FFF,851,1
2024/01/05,C,HH,BBB,764,1
2024/01/06,A,BB,EEE,205,1
2024/01/07,F,EE,BBB,245,2
2024/01/08,F,AA,GGG,915,2
2024/01/09,H,GG,JJJ,813,2
2024/01/10,F,GG,GGG,132,2
2024/01/11,D,EE,GGG,317,2
2024/01/12,H,JJ,EEE,521,2
2024/01/13,A,HH,EEE,591,2
2024/01/14,A,DD,GGG,911,3
2024/01/15,F,BB,CCC,889,3
2024/01/16,A,JJ,FFF,778,3
2024/01/17,G,II,DDD,390,3
2024/01/18,C,BB,GGG,511,3
2024/01/19,E,JJ,JJJ,685,3
2024/01/20,A,AA,FFF,812,3
2024/01/21,C,DD,JJJ,460,4
2024/01/22,D,BB,EEE,660,4
2024/01/23,G,EE,III,687,4
2024/01/24,B,CC,GGG,159,4
2024/01/25,G,AA,EEE,449,4
2024/01/26,I,JJ,CCC,172,4
2024/01/27,F,HH,JJJ,396,4
2024/01/28,J,FF,HHH,543,5
2024/01/29,C,FF,GGG,918,5
2024/01/30,H,II,CCC,268,5
2024/01/31,A,JJ,JJJ,759,5
2024/02/01,H,II,JJJ,619,5
2024/02/02,B,HH,FFF,758,5
2024/02/03,I,DD,DDD,833,5
2024/02/04,A,II,JJJ,951,6
2024/02/05,D,AA,FFF,511,6
2024/02/06,E,BB,III,175,6
2024/02/07,F,DD,HHH,988,6
2024/02/08,F,EE,III,252,6
2024/02/09,F,HH,JJJ,774,6
2024/02/10,D,JJ,JJJ,392,6
2024/02/11,D,JJ,AAA,354,7
2024/02/12,G,II,DDD,705,7
2024/02/13,C,HH,EEE,537,7
2024/02/14,I,II,BBB,614,7
2024/02/15,J,BB,CCC,294,7
2024/02/16,I,II,JJJ,653,7
2024/02/17,A,FF,EEE,377,7
2024/02/18,F,FF,III,202,8
2024/02/19,A,GG,AAA,481,8
2024/02/20,A,GG,HHH,230,8
2024/02/21,A,CC,HHH,380,8
2024/02/22,B,GG,DDD,175,8
2024/02/23,G,JJ,FFF,718,8
2024/02/24,F,EE,BBB,988,8
2024/02/25,E,II,EEE,668,9
2024/02/26,J,EE,CCC,121,9
2024/02/27,H,FF,HHH,457,9
2024/02/28,H,GG,HHH,493,9
2024/02/29,E,FF,CCC,407,9
2023/01/01,D,AA,JJJ,997,1
2023/01/02,B,FF,CCC,447,1
2023/01/03,H,HH,HHH,769,1
2023/01/04,A,DD,GGG,968,1
2023/01/05,D,JJ,GGG,745,1
2023/01/06,C,HH,EEE,538,1
2023/01/07,B,HH,III,810,1
2023/01/08,C,JJ,III,804,2
2023/01/09,F,AA,HHH,165,2
2023/01/10,B,CC,III,326,2
2023/01/11,I,EE,AAA,897,2
2023/01/12,I,EE,DDD,568,2
2023/01/13,B,JJ,EEE,187,2
2023/01/14,F,EE,EEE,491,2
2023/01/15,C,JJ,III,242,3
2023/01/16,D,JJ,FFF,262,3
2023/01/17,D,GG,HHH,969,3
2023/01/18,H,GG,EEE,174,3
2023/01/19,C,HH,JJJ,784,3
2023/01/20,A,EE,HHH,656,3
2023/01/21,G,II,HHH,151,3
2023/01/22,J,CC,EEE,150,4
2023/01/23,J,GG,CCC,701,4
2023/01/24,F,CC,JJJ,793,4
2023/01/25,A,EE,AAA,768,4
2023/01/26,G,AA,III,519,4
2023/01/27,A,BB,AAA,737,4
2023/01/28,I,CC,AAA,147,4
2023/01/29,D,JJ,AAA,631,5
2023/01/30,C,BB,GGG,689,5
2023/01/31,F,II,CCC,608,5
2023/02/01,I,CC,GGG,192,5
2023/02/02,C,CC,BBB,111,5
2023/02/03,A,AA,EEE,888,5
2023/02/04,E,II,DDD,914,5
2023/02/05,I,BB,JJJ,677,6
2023/02/06,E,CC,DDD,754,6
2023/02/07,E,CC,BBB,348,6
2023/02/08,E,GG,HHH,448,6
2023/02/09,D,GG,BBB,483,6
2023/02/10,I,II,EEE,857,6
2023/02/11,D,JJ,DDD,488,6
2023/02/12,D,CC,GGG,927,7
2023/02/13,E,JJ,GGG,664,7
2023/02/14,G,AA,DDD,702,7
2023/02/15,B,FF,DDD,784,7
2023/02/16,G,CC,GGG,508,7
2023/02/17,G,DD,JJJ,972,7
2023/02/18,F,HH,HHH,472,7
2023/02/19,I,HH,AAA,536,8
2023/02/20,G,HH,CCC,704,8
2023/02/21,H,BB,III,961,8
2023/02/22,A,HH,EEE,730,8
2023/02/23,A,JJ,EEE,603,8
2023/02/24,F,JJ,BBB,309,8
2023/02/25,B,AA,AAA,329,8
2023/02/26,C,EE,EEE,322,9
2023/02/27,A,BB,EEE,114,9
2023/02/28,B,BB,GGG,360,9
2023/01/01,B,HH,GGG,769,1
2023/01/02,E,JJ,GGG,869,1
2023/01/03,F,FF,BBB,914,1
2023/01/04,A,EE,CCC,656,1
2023/01/05,D,HH,FFF,448,1
2023/01/06,E,II,EEE,497,1
2023/01/07,I,HH,EEE,524,1
2023/01/08,I,AA,DDD,475,2
2023/01/09,C,JJ,CCC,971,2
2023/01/10,H,AA,GGG,991,2
2023/01/11,B,FF,HHH,751,2
2023/01/12,F,AA,CCC,133,2
2023/01/13,B,BB,III,822,2
2023/01/14,I,FF,GGG,701,2
2023/01/15,C,II,GGG,146,3
2023/01/16,F,AA,DDD,446,3
2023/01/17,F,HH,DDD,139,3
2023/01/18,I,CC,GGG,909,3
2023/01/19,D,EE,CCC,591,3
2023/01/20,C,DD,CCC,842,3
2023/01/21,F,JJ,JJJ,680,3
2023/01/22,I,GG,EEE,664,4
2023/01/23,D,AA,BBB,954,4
2023/01/24,B,GG,EEE,655,4
2023/01/25,E,JJ,HHH,129,4
2023/01/26,H,JJ,AAA,414,4
2023/01/27,C,BB,BBB,918,4
2023/01/28,E,II,FFF,362,4
2023/01/29,F,AA,FFF,451,5
2023/01/30,E,JJ,GGG,541,5
2023/01/31,E,GG,AAA,992,5
2023/02/01,G,JJ,GGG,994,5
2023/02/02,G,HH,JJJ,531,5
2023/02/03,H,EE,III,307,5
2023/02/04,I,BB,III,174,5
2023/02/05,F,CC,III,114,6
2023/02/06,E,AA,GGG,449,6
2023/02/07,B,II,JJJ,452,6
2023/02/08,I,JJ,III,243,6
2023/02/09,B,GG,FFF,862,6
2023/02/10,D,GG,EEE,134,6
2023/02/11,J,DD,EEE,891,6
2023/02/12,H,AA,FFF,257,7
2023/02/13,H,JJ,AAA,135,7
2023/02/14,G,DD,CCC,927,7
2023/02/15,D,HH,BBB,573,7
2023/02/16,A,EE,FFF,468,7
2023/02/17,C,CC,JJJ,820,7
2023/02/18,B,HH,DDD,383,7
2023/02/19,F,BB,DDD,635,8
2023/02/20,I,DD,AAA,138,8
2023/02/21,G,GG,HHH,461,8
2023/02/22,D,AA,DDD,684,8
2023/02/23,H,HH,EEE,372,8
2023/02/24,H,EE,BBB,809,8
2023/02/25,G,II,EEE,104,8
2023/02/26,C,GG,FFF,258,9
2023/02/27,J,FF,JJJ,227,9
2023/02/28,F,AA,BBB,928,9
2024/01/01,E,DD,III,202,1
2024/01/02,I,EE,III,929,1
2024/01/03,G,JJ,JJJ,419,1
2024/01/04,I,II,EEE,916,1
2024/01/05,H,GG,EEE,923,1
2024/01/06,I,II,GGG,689,1
2024/01/07,C,JJ,III,837,2
2024/01/08,E,II,BBB,635,2
2024/01/09,B,DD,FFF,229,2
2024/01/10,J,CC,GGG,623,2
2024/01/11,D,HH,AAA,129,2
2024/01/12,H,EE,BBB,492,2
2024/01/13,G,CC,EEE,233,2
2024/01/14,G,GG,III,282,3
2024/01/15,A,FF,HHH,595,3
2024/01/16,I,II,DDD,476,3
2024/01/17,B,HH,DDD,127,3
2024/01/18,C,HH,AAA,604,3
2024/01/19,D,GG,HHH,498,3
2024/01/20,G,BB,JJJ,979,3
2024/01/21,J,HH,AAA,574,4
2024/01/22,J,GG,BBB,308,4
2024/01/23,D,II,FFF,469,4
2024/01/24,A,II,JJJ,487,4
2024/01/25,G,CC,GGG,535,4
2024/01/26,F,II,III,630,4
2024/01/27,B,JJ,BBB,286,4
2024/01/28,E,HH,DDD,767,5
2024/01/29,I,FF,CCC,746,5
2024/01/30,I,EE,FFF,382,5
2024/01/31,F,EE,EEE,164,5
2024/02/01,G,CC,GGG,387,5
2024/02/02,B,EE,JJJ,824,5
2024/02/03,E,FF,CCC,846,5
2024/02/04,B,BB,DDD,273,6
2024/02/05,G,AA,GGG,532,6
2024/02/06,B,AA,HHH,185,6
2024/02/07,B,GG,CCC,531,6
2024/02/08,C,CC,CCC,300,6
2024/02/09,G,GG,HHH,116,6
2024/02/10,G,AA,JJJ,464,6
2024/02/11,C,II,CCC,833,7
2024/02/12,I,FF,BBB,869,7
2024/02/13,D,HH,EEE,370,7
2024/02/14,D,HH,GGG,708,7
2024/02/15,A,FF,CCC,576,7
2024/02/16,B,JJ,EEE,166,7
2024/02/17,G,II,HHH,560,7
2024/02/18,E,AA,GGG,634,8
2024/02/19,D,BB,HHH,900,8
2024/02/20,J,JJ,CCC,526,8
2024/02/21,F,DD,BBB,566,8
2024/02/22,C,CC,EEE,579,8
2024/02/23,F,CC,FFF,851,8
2024/02/24,A,AA,AAA,815,8
2024/02/25,H,JJ,FFF,303,9
2024/02/26,C,CC,GGG,570,9
2024/02/27,I,EE,GGG,619,9
2024/02/28,A,BB,GGG,581,9
2024/02/29,E,II,BBB,501,9
2024/01/01,H,CC,JJJ,948,1
2024/01/02,G,HH,JJJ,716,1
2024/01/03,J,CC,CCC,610,1
2024/01/04,I,EE,BBB,703,1
2024/01/05,H,FF,JJJ,140,1
2024/01/06,D,FF,AAA,752,1
2024/01/07,G,DD,JJJ,337,2
2024/01/08,D,DD,HHH,532,2
2024/01/09,I,FF,EEE,109,2
2024/01/10,B,EE,III,747,2
2024/01/11,A,FF,CCC,762,2
2024/01/12,G,CC,DDD,393,2
2024/01/13,H,FF,EEE,887,2
2024/01/14,C,GG,BBB,638,3
2024/01/15,B,II,GGG,727,3
2024/01/16,G,EE,JJJ,248,3
2024/01/17,A,HH,EEE,783,3
2024/01/18,G,AA,AAA,632,3
2024/01/19,H,FF,III,879,3
2024/01/20,E,AA,DDD,281,3
2024/01/21,E,FF,AAA,928,4
2024/01/22,E,GG,GGG,737,4
2024/01/23,J,HH,III,573,4
2024/01/24,E,GG,III,422,4
2024/01/25,B,CC,BBB,822,4
2024/01/26,B,II,III,345,4
2024/01/27,B,BB,FFF,844,4
2024/01/28,E,CC,III,411,5
2024/01/29,G,BB,HHH,161,5
2024/01/30,G,FF,CCC,240,5
2024/01/31,B,EE,CCC,346,5
2024/02/01,H,GG,HHH,613,5
2024/02/02,D,EE,HHH,380,5
2024/02/03,G,EE,III,408,5
2024/02/04,A,AA,CCC,387,6
2024/02/05,A,BB,EEE,751,6
2024/02/06,I,DD,BBB,158,6
2024/02/07,A,II,DDD,141,6
2024/02/08,D,II,CCC,824,6
2024/02/09,A,EE,BBB,378,6
2024/02/10,C,DD,DDD,650,6
2024/02/11,C,EE,BBB,628,7
2024/02/12,H,AA,DDD,209,7
2024/02/13,E,II,EEE,137,7
2024/02/14,A,EE,FFF,989,7
2024/02/15,F,HH,JJJ,260,7
2024/02/16,D,FF,EEE,497,7
2024/02/17,H,CC,BBB,872,7
2024/02/18,G,II,GGG,290,8
2024/02/19,B,II,FFF,501,8
2024/02/20,E,II,EEE,693,8
2024/02/21,F,GG,CCC,618,8
2024/02/22,B,CC,BBB,539,8
2024/02/23,G,DD,AAA,148,8
2024/02/24,J,FF,HHH,526,8
2024/02/25,G,DD,GGG,445,9
2024/02/26,E,II,HHH,212,9
2024/02/27,I,CC,III,346,9
2024/02/28,B,AA,EEE,338,9
2024/02/29,F,AA,DDD,222,9
2023/01/01,A,BB,AAA,971,1
2023/01/02,D,CC,III,330,1
2023/01/03,G,JJ,JJJ,138,1
2023/01/04,J,AA,DDD,398,1
2023/01/05,J,EE,JJJ,182,1
2023/01/06,H,HH,BBB,445,1
2023/01/07,B,GG,III,109,1
2023/01/08,E,AA,III,184,2
2023/01/09,E,CC,HHH,299,2
2023/01/10,A,DD,GGG,391,2
2023/01/11,H,DD,AAA,954,2
2023/01/12,C,JJ,FFF,714,2
2023/01/13,B,CC,GGG,214,2
2023/01/14,A,AA,GGG,325,2
2023/01/15,E,AA,EEE,686,3
2023/01/16,I,FF,DDD,866,3
2023/01/17,G,EE,III,930,3
2023/01/18,G,JJ,III,453,3
2023/01/19,G,FF,JJJ,425,3
2023/01/20,J,JJ,CCC,900,3
2023/01/21,G,HH,BBB,879,3
2023/01/22,F,HH,CCC,614,4
2023/01/23,H,II,HHH,777,4
2023/01/24,A,EE,III,217,4
2023/01/25,F,HH,CCC,892,4
2023/01/26,C,CC,HHH,661,4
2023/01/27,E,JJ,III,466,4
2023/01/28,I,DD,FFF,516,4
2023/01/29,F,HH,AAA,839,5
2023/01/30,A,EE,FFF,179,5
2023/01/31,C,CC,HHH,385,5
2023/02/01,H,GG,EEE,614,5
2023/02/02,H,AA,EEE,406,5
2023/02/03,I,II,BBB,249,5
2023/02/04,A,II,BBB,652,5
2023/02/05,J,FF,III,970,6
2023/02/06,D,CC,GGG,499,6
2023/02/07,B,FF,FFF,809,6
2023/02/08,F,DD,GGG,135,6
2023/02/09,H,EE,GGG,978,6
2023/02/10,D,BB,AAA,217,6
2023/02/11,G,EE,AAA,350,6
2023/02/12,G,HH,FFF,221,7
2023/02/13,G,CC,GGG,102,7
2023/02/14,E,HH,HHH,276,7
2023/02/15,J,GG,III,120,7
2023/02/16,C,GG,GGG,820,7
2023/02/17,D,EE,CCC,987,7
2023/02/18,G,HH,GGG,829,7
2023/02/19,G,AA,III,360,8
2023/02/20,A,II,HHH,913,8
2023/02/21,F,FF,JJJ,747,8
2023/02/22,H,GG,GGG,970,8
2023/02/23,A,HH,AAA,874,8
2023/02/24,F,DD,CCC,308,8
2023/02/25,D,GG,DDD,894,8
2023/02/26,D,CC,EEE,593,9
2023/02/27,F,AA,CCC,712,9
2023/02/28,C,JJ,JJJ,361,9
2023/01/01,E,EE,DDD,157,1
2023/01/02,A,DD,EEE,483,1
2023/01/03,F,AA,JJJ,777,1
2023/01/04,I,II,JJJ,240,1
2023/01/05,I,FF,AAA,270,1
2023/01/06,C,BB,AAA,891,1
2023/01/07,A,HH,BBB,905,1
2023/01/08,J,JJ,BBB,490,2
2023/01/09,A,FF,FFF,370,2
2023/01/10,I,CC,GGG,456,2
2023/01/11,C,AA,GGG,447,2
2023/01/12,G,AA,JJJ,189,2
2023/01/13,J,HH,CCC,107,2
2023/01/14,C,FF,JJJ,945,2
2023/01/15,G,DD,JJJ,618,3
2023/01/16,F,AA,FFF,123,3
2023/01/17,G,CC,III,485,3
2023/01/18,H,II,GGG,614,3
2023/01/19,G,FF,HHH,749,3
2023/01/20,C,JJ,AAA,905,3
2023/01/21,A,JJ,BBB,907,3
2023/01/22,B,CC,BBB,435,4
2023/01/23,A,GG,EEE,628,4
2023/01/24,J,FF,DDD,851,4
2023/01/25,E,DD,DDD,639,4
2023/01/26,I,FF,FFF,722,4
2023/01/27,F,FF,III,321,4
2023/01/28,I,BB,HHH,939,4
2023/01/29,D,DD,III,926,5
2023/01/30,B,GG,AAA,420,5
2023/01/31,F,GG,HHH,193,5
2023/02/01,F,EE,DDD,483,5
2023/02/02,F,BB,JJJ,802,5
2023/02/03,E,II,JJJ,275,5
2023/02/04,D,GG,CCC,889,5
2023/02/05,D,EE,HHH,298,6
2023/02/06,B,FF,GGG,844,6
2023/02/07,C,DD,GGG,449,6
2023/02/08,D,BB,III,373,6
2023/02/09,H,AA,FFF,954,6
2023/02/10,F,JJ,BBB,120,6
2023/02/11,J,CC,JJJ,539,6
2023/02/12,I,BB,FFF,221,7
2023/02/13,I,AA,FFF,702,7
2023/02/14,C,EE,CCC,350,7
2023/02/15,G,CC,EEE,339,7
2023/02/16,C,CC,HHH,466,7
2023/02/17,A,HH,III,441,7
2023/02/18,C,JJ,FFF,581,7
2023/02/19,C,JJ,AAA,841,8
2023/02/20,G,JJ,HHH,775,8
2023/02/21,G,AA,EEE,159,8
2023/02/22,A,HH,DDD,152,8
2023/02/23,C,HH,III,802,8
2023/02/24,D,DD,BBB,162,8
2023/02/25,I,FF,CCC,475,8
2023/02/26,E,CC,DDD,780,9
2023/02/27,J,GG,CCC,757,9
2023/02/28,B,CC,CCC,427,9
2024/01/01,E,HH,JJJ,361,1
2024/01/02,D,GG,DDD,531,1
2024/01/03,B,EE,JJJ,995,1
2024/01/04,J,AA,JJJ,315,1
2024/01/05,I,GG,AAA,232,1
2024/01/06,H,HH,DDD,645,1
2024/01/07,A,CC,GGG,990,2
2024/01/08,G,EE,EEE,797,2
2024/01/09,C,BB,HHH,999,2
2024/01/10,D,AA,CCC,971,2
2024/01/11,B,AA,CCC,481,2
2024/01/12,F,II,AAA,151,2
2024/01/13,E,CC,GGG,700,2
2024/01/14,J,GG,BBB,706,3
2024/01/15,D,FF,AAA,120,3
2024/01/16,H,JJ,DDD,637,3
2024/01/17,H,DD,AAA,503,3
2024/01/18,E,FF,HHH,468,3
2024/01/19,F,GG,CCC,306,3
2024/01/20,G,GG,GGG,895,3
2024/01/21,G,JJ,FFF,150,4
2024/01/22,F,FF,JJJ,363,4
2024/01/23,F,GG,DDD,523,4
2024/01/24,H,GG,AAA,242,4
2024/01/25,D,JJ,AAA,134,4
2024/01/26,F,DD,BBB,569,4
2024/01/27,C,JJ,III,490,4
2024/01/28,E,JJ,HHH,104,5
2024/01/29,E,BB,CCC,403,5
2024/01/30,E,DD,EEE,566,5
2024/01/31,B,GG,AAA,561,5
2024/02/01,C,EE,EEE,909,5
2024/02/02,F,CC,JJJ,449,5
2024/02/03,C,CC,CCC,252,5
2024/02/04,B,AA,GGG,570,6
2024/02/05,I,HH,EEE,931,6
2024/02/06,H,BB,AAA,200,6
2024/02/07,A,GG,AAA,937,6
2024/02/08,G,II,DDD,482,6
2024/02/09,G,DD,AAA,964,6
2024/02/10,A,DD,CCC,823,6
2024/02/11,B,BB,EEE,524,7
2024/02/12,H,HH,AAA,502,7
2024/02/13,F,DD,HHH,881,7
2024/02/14,A,HH,FFF,536,7
2024/02/15,J,AA,CCC,715,7
2024/02/16,J,CC,EEE,100,7
2024/02/17,D,FF,BBB,356,7
2024/02/18,F,II,HHH,372,8
2024/02/19,G,HH,AAA,504,8
2024/02/20,I,DD,GGG,993,8
2024/02/21,J,JJ,AAA,784,8
2024/02/22,F,JJ,III,297,8
2024/02/23,I,FF,JJJ,323,8
2024/02/24,E,GG,DDD,645,8
2024/02/25,B,GG,III,260,9
2024/02/26,C,II,BBB,717,9
2024/02/27,I,II,EEE,822,9
2024/02/28,G,CC,AAA,503,9
2024/02/29,E,EE,III,305,9
2024/01/01,B,FF,DDD,364,1
2024/01/02,E,CC,CCC,170,1
2024/01/03,I,DD,FFF,659,1
2024/01/04,C,JJ,III,254,1
2024/01/05,F,HH,AAA,609,1
2024/01/06,C,AA,EEE,761,1
2024/01/07,A,BB,III,969,2
2024/01/08,I,EE,EEE,607,2
2024/01/09,J,JJ,JJJ,142,2
2024/01/10,D,AA,CCC,266,2
2024/01/11,G,II,AAA,874,2
2024/01/12,H,CC,GGG,982,2
2024/01/13,J,GG,JJJ,568,2
2024/01/14,D,EE,EEE,613,3
2024/01/15,G,HH,EEE,641,3
2024/01/16,I,JJ,DDD,474,3
2024/01/17,A,DD,BBB,365,3
2024/01/18,J,HH,AAA,711,3
2024/01/19,B,HH,DDD,677,3
2024/01/20,A,CC,BBB,710,3
2024/01/21,B,FF,HHH,357,4
2024/01/22,A,AA,EEE,204,4
2024/01/23,G,EE,DDD,459,4
2024/01/24,H,HH,GGG,648,4
2024/01/25,I,CC,JJJ,436,4
2024/01/26,D,DD,GGG,576,4
2024/01/27,D,FF,BBB,456,4
2024/01/28,I,AA,EEE,941,5
2024/01/29,G,AA,DDD,199,5
2024/01/30,E,GG,FFF,246,5
2024/01/31,B,CC,EEE,273,5
2024/02/01,G,EE,CCC,424,5
2024/02/02,E,FF,EEE,838,5
2024/02/03,I,EE,JJJ,896,5
2024/02/04,D,HH,CCC,288,6
2024/02/05,D,FF,AAA,985,6
2024/02/06,B,AA,FFF,250,6
2024/02/07,D,HH,AAA,259,6
2024/02/08,D,CC,CCC,506,6
2024/02/09,D,II,EEE,675,6
2024/02/10,F,GG,BBB,804,6
2024/02/11,F,EE,BBB,196,7
2024/02/12,A,FF,EEE,479,7
2024/02/13,F,II,III,200,7
2024/02/14,E,II,AAA,654,7
2024/02/15,E,CC,CCC,836,7
2024/02/16,F,JJ,FFF,927,7
2024/02/17,D,EE,BBB,570,7
2024/02/18,H,EE,BBB,727,8
2024/02/19,F,JJ,GGG,529,8
2024/02/20,B,DD,JJJ,254,8
2024/02/21,C,BB,AAA,418,8
2024/02/22,E,DD,EEE,849,8
2024/02/23,H,HH,CCC,752,8
2024/02/24,F,EE,CCC,203,8
2024/02/25,C,GG,JJJ,238,9
2024/02/26,I,FF,CCC,916,9
2024/02/27,C,CC,BBB,473,9
2024/02/28,B,FF,III,313,9
2024/02/29,F,FF,GGG,233,9
計算フィールド
sum_sales
sum(sales, [{datetype_year}, {location_type}])
rank_sum_sales
rank([max({sum_sales}) DESC], [{datetype_year}, {datetype_num}])
計算フィールドの結果確認テーブル
フィルターの設定
rank_sum_salesにフィルターを設定します。
赤枠の部分の値を変更することで上位XX位の表示が可能になります。
大きな数字を設定すれば全件が表示されます。
ビジュアルの結果
全件表示（フィルターなし、もしくはフィルターの最大値に10を設定した場合）
当該期間のSalesの合計のTop5（フィルターの最大値に5を設定した場合）
（注意）たまたま凡例の文字列の並びが変わっていますが、意図してやっているわけではありません。
表示される順番は別として、ご提案いただいた表示制限する方法で私のやりたかったことが実現できました。ありがとうございます！
