昨年のYear to Date (YTD) をKPIのVisualで表示したい

[higuyuta]

今年の数値と昨年の数値を比較できるようなKPIを作成しています。

当初は以下を参考にifelse(dateDiff({creation_date}, now(),"YYYY") = 1 AND {creation_date} <= addDateTime(-1,"YYYY",now()), quantity, 0)の計算フィールドで昨年のYTDの数値を表示させていました。ただ、これだと{creation_date}にフィルターは適用させることができません。

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…

例えばフィルターで{creation_date}の終了日を2025年8月31日とセットした際には、昨年のYTDも2024年1月1日から2024年8月31日までの数値になるようにしたいですが、どのように計算フィールドを書けば良いでしょうか？

＜現状＞

Quantity CY: ifelse(dateDiff({creation_date},now(),"YYYY") = 0 and {creation_date}<=now(), quantity, 0)

Quantity LY: ifelse(dateDiff({creation_date}, now(),"YYYY") = 1 AND {creation_date} <= addDateTime(-1,"YYYY",now()), quantity, 0)

[oyachiya]

@higuyuta

ご質問いただきありがとうございます。

パラメータとコントロールを使ってみてはいかがでしょうか？

この場合、計算フィールドにそれほど手をいれることなく、やりたいことが実現できると思います。

何かございましたら、遠慮なくご質問ください。

---

入力データ

creation_date,quantity
2023/01/01,4763
2023/01/02,7244
2023/01/03,5044
2023/01/04,1504
2023/01/05,5133
2023/01/06,1858
2023/01/07,9966
2023/01/08,8513
2023/01/09,8983
2023/01/10,689
2023/01/11,4374
2023/01/12,5110
2023/01/13,2672
2023/01/14,3796
2023/01/15,5725
2023/01/16,7806
2023/01/17,2083
2023/01/18,6196
2023/01/19,4700
2023/01/20,6079
2023/01/21,7410
2023/01/22,7532
2023/01/23,6109
2023/01/24,3816
2023/01/25,4536
2023/01/26,1885
2023/01/27,3758
2023/01/28,7198
2023/01/29,2158
2023/01/30,7152
2023/01/31,9722
2023/02/01,4375
2023/02/02,9170
2023/02/03,1692
2023/02/04,2908
2023/02/05,1457
2023/02/06,1973
2023/02/07,7249
2023/02/08,407
2023/02/09,7508
2023/02/10,6128
2023/02/11,7651
2023/02/12,3091
2023/02/13,7611
2023/02/14,5738
2023/02/15,5720
2023/02/16,2906
2023/02/17,2560
2023/02/18,772
2023/02/19,7876
2023/02/20,8003
2023/02/21,4152
2023/02/22,8748
2023/02/23,9465
2023/02/24,8858
2023/02/25,8968
2023/02/26,7965
2023/02/27,2653
2023/02/28,6364
2023/03/01,9573
2023/03/02,6741
2023/03/03,2932
2023/03/04,797
2023/03/05,5431
2023/03/06,1264
2023/03/07,9930
2023/03/08,2476
2023/03/09,8308
2023/03/10,3319
2023/03/11,8361
2023/03/12,2870
2023/03/13,2558
2023/03/14,3714
2023/03/15,954
2023/03/16,1101
2023/03/17,3103
2023/03/18,2279
2023/03/19,1861
2023/03/20,2937
2023/03/21,4248
2023/03/22,6587
2023/03/23,3111
2023/03/24,6416
2023/03/25,1162
2023/03/26,3083
2023/03/27,2461
2023/03/28,2171
2023/03/29,2335
2023/03/30,5741
2023/03/31,1209
2023/04/01,2197
2023/04/02,6902
2023/04/03,1258
2023/04/04,8636
2023/04/05,1413
2023/04/06,1049
2023/04/07,9549
2023/04/08,3478
2023/04/09,9548
2023/04/10,7937
2023/04/11,8494
2023/04/12,7400
2023/04/13,3069
2023/04/14,9826
2023/04/15,8601
2023/04/16,966
2023/04/17,4592
2023/04/18,6262
2023/04/19,5561
2023/04/20,2203
2023/04/21,694
2023/04/22,9774
2023/04/23,5297
2023/04/24,7486
2023/04/25,832
2023/04/26,2278
2023/04/27,9313
2023/04/28,5570
2023/04/29,1195
2023/04/30,9147
2023/05/01,3199
2023/05/02,7108
2023/05/03,5800
2023/05/04,415
2023/05/05,5827
2023/05/06,318
2023/05/07,8930
2023/05/08,6562
2023/05/09,7874
2023/05/10,6494
2023/05/11,466
2023/05/12,4520
2023/05/13,4084
2023/05/14,6949
2023/05/15,1488
2023/05/16,6694
2023/05/17,2562
2023/05/18,7254
2023/05/19,5553
2023/05/20,3190
2023/05/21,958
2023/05/22,1832
2023/05/23,3124
2023/05/24,2908
2023/05/25,805
2023/05/26,6532
2023/05/27,8593
2023/05/28,4124
2023/05/29,798
2023/05/30,2821
2023/05/31,916
2023/06/01,2678
2023/06/02,1440
2023/06/03,1577
2023/06/04,7104
2023/06/05,8268
2023/06/06,3816
2023/06/07,6027
2023/06/08,2121
2023/06/09,8132
2023/06/10,3088
2023/06/11,8834
2023/06/12,8267
2023/06/13,2562
2023/06/14,3656
2023/06/15,6463
2023/06/16,3964
2023/06/17,3543
2023/06/18,1892
2023/06/19,542
2023/06/20,4730
2023/06/21,1954
2023/06/22,915
2023/06/23,1753
2023/06/24,1847
2023/06/25,1736
2023/06/26,4843
2023/06/27,6682
2023/06/28,9330
2023/06/29,2288
2023/06/30,4174
2023/07/01,4506
2023/07/02,526
2023/07/03,8614
2023/07/04,6607
2023/07/05,3262
2023/07/06,606
2023/07/07,7372
2023/07/08,5000
2023/07/09,7231
2023/07/10,1027
2023/07/11,4353
2023/07/12,9766
2023/07/13,6350
2023/07/14,580
2023/07/15,1906
2023/07/16,7587
2023/07/17,7743
2023/07/18,3970
2023/07/19,4301
2023/07/20,7365
2023/07/21,3317
2023/07/22,7184
2023/07/23,6369
2023/07/24,6624
2023/07/25,9567
2023/07/26,8618
2023/07/27,7010
2023/07/28,5026
2023/07/29,606
2023/07/30,9732
2023/07/31,3525
2023/08/01,9511
2023/08/02,393
2023/08/03,7802
2023/08/04,7095
2023/08/05,2092
2023/08/06,563
2023/08/07,3775
2023/08/08,8610
2023/08/09,9677
2023/08/10,3121
2023/08/11,4311
2023/08/12,4506
2023/08/13,2639
2023/08/14,8147
2023/08/15,4640
2023/08/16,5471
2023/08/17,3262
2023/08/18,474
2023/08/19,5882
2023/08/20,2926
2023/08/21,5967
2023/08/22,7082
2023/08/23,834
2023/08/24,4199
2023/08/25,6817
2023/08/26,5290
2023/08/27,3825
2023/08/28,962
2023/08/29,5077
2023/08/30,267
2023/08/31,8206
2023/09/01,7123
2023/09/02,3332
2023/09/03,2747
2023/09/04,5328
2023/09/05,5469
2023/09/06,4462
2023/09/07,1934
2023/09/08,4269
2023/09/09,982
2023/09/10,892
2023/09/11,8879
2023/09/12,226
2023/09/13,389
2023/09/14,8770
2023/09/15,7647
2023/09/16,3349
2023/09/17,8538
2023/09/18,6393
2023/09/19,3492
2023/09/20,7745
2023/09/21,1420
2023/09/22,162
2023/09/23,8056
2023/09/24,6075
2023/09/25,9571
2023/09/26,1646
2023/09/27,4976
2023/09/28,8683
2023/09/29,4185
2023/09/30,4221
2023/10/01,6612
2023/10/02,7156
2023/10/03,9170
2023/10/04,5702
2023/10/05,9336
2023/10/06,7220
2023/10/07,2025
2023/10/08,4187
2023/10/09,2937
2023/10/10,1578
2023/10/11,6839
2023/10/12,7899
2023/10/13,9714
2023/10/14,7207
2023/10/15,401
2023/10/16,5973
2023/10/17,4783
2023/10/18,397
2023/10/19,5255
2023/10/20,9221
2023/10/21,6665
2023/10/22,7289
2023/10/23,1754
2023/10/24,5044
2023/10/25,7110
2023/10/26,8336
2023/10/27,218
2023/10/28,675
2023/10/29,5903
2023/10/30,685
2023/10/31,9369
2023/11/01,6335
2023/11/02,6697
2023/11/03,4685
2023/11/04,2304
2023/11/05,1452
2023/11/06,1165
2023/11/07,4787
2023/11/08,4384
2023/11/09,8260
2023/11/10,4458
2023/11/11,3632
2023/11/12,3993
2023/11/13,9985
2023/11/14,6475
2023/11/15,7626
2023/11/16,1682
2023/11/17,9636
2023/11/18,9923
2023/11/19,6589
2023/11/20,3637
2023/11/21,5122
2023/11/22,3906
2023/11/23,4765
2023/11/24,8647
2023/11/25,8406
2023/11/26,5183
2023/11/27,3349
2023/11/28,3453
2023/11/29,1871
2023/11/30,1879
2023/12/01,7337
2023/12/02,5125
2023/12/03,8504
2023/12/04,2300
2023/12/05,2522
2023/12/06,4751
2023/12/07,1728
2023/12/08,7872
2023/12/09,2553
2023/12/10,6272
2023/12/11,129
2023/12/12,6027
2023/12/13,757
2023/12/14,2356
2023/12/15,9737
2023/12/16,1584
2023/12/17,5725
2023/12/18,2486
2023/12/19,1966
2023/12/20,3457
2023/12/21,5924
2023/12/22,8831
2023/12/23,7437
2023/12/24,3780
2023/12/25,7216
2023/12/26,3329
2023/12/27,4629
2023/12/28,2387
2023/12/29,8921
2023/12/30,8027
2023/12/31,4530
2024/01/01,9463
2024/01/02,957
2024/01/03,4859
2024/01/04,1032
2024/01/05,974
2024/01/06,7199
2024/01/07,967
2024/01/08,1886
2024/01/09,6017
2024/01/10,9924
2024/01/11,1477
2024/01/12,1315
2024/01/13,4954
2024/01/14,5916
2024/01/15,5238
2024/01/16,7066
2024/01/17,8815
2024/01/18,9763
2024/01/19,2855
2024/01/20,9556
2024/01/21,3895
2024/01/22,8950
2024/01/23,7517
2024/01/24,1829
2024/01/25,8341
2024/01/26,1771
2024/01/27,8359
2024/01/28,9252
2024/01/29,9559
2024/01/30,7723
2024/01/31,1067
2024/02/01,9495
2024/02/02,948
2024/02/03,3877
2024/02/04,7942
2024/02/05,4661
2024/02/06,6407
2024/02/07,8897
2024/02/08,6793
2024/02/09,6832
2024/02/10,6504
2024/02/11,9315
2024/02/12,6035
2024/02/13,7283
2024/02/14,925
2024/02/15,4309
2024/02/16,8111
2024/02/17,2871
2024/02/18,1328
2024/02/19,8717
2024/02/20,1605
2024/02/21,9874
2024/02/22,3691
2024/02/23,987
2024/02/24,4651
2024/02/25,3509
2024/02/26,656
2024/02/27,1027
2024/02/28,103
2024/02/29,3102
2024/03/01,1939
2024/03/02,1345
2024/03/03,7481
2024/03/04,665
2024/03/05,5994
2024/03/06,8749
2024/03/07,5616
2024/03/08,3329
2024/03/09,6716
2024/03/10,3309
2024/03/11,8031
2024/03/12,1338
2024/03/13,6070
2024/03/14,2275
2024/03/15,8759
2024/03/16,6398
2024/03/17,7750
2024/03/18,1583
2024/03/19,620
2024/03/20,9899
2024/03/21,7955
2024/03/22,2686
2024/03/23,7873
2024/03/24,8937
2024/03/25,226
2024/03/26,3748
2024/03/27,7889
2024/03/28,1251
2024/03/29,2238
2024/03/30,6123
2024/03/31,6450
2024/04/01,2404
2024/04/02,4861
2024/04/03,6581
2024/04/04,1596
2024/04/05,2220
2024/04/06,1619
2024/04/07,4740
2024/04/08,8971
2024/04/09,8440
2024/04/10,2480
2024/04/11,5361
2024/04/12,1780
2024/04/13,9340
2024/04/14,2737
2024/04/15,8398
2024/04/16,5789
2024/04/17,2455
2024/04/18,9378
2024/04/19,5427
2024/04/20,3401
2024/04/21,9837
2024/04/22,4746
2024/04/23,1101
2024/04/24,9784
2024/04/25,530
2024/04/26,850
2024/04/27,489
2024/04/28,7706
2024/04/29,2993
2024/04/30,4227
2024/05/01,2540
2024/05/02,3024
2024/05/03,5268
2024/05/04,2079
2024/05/05,6355
2024/05/06,3703
2024/05/07,1998
2024/05/08,1348
2024/05/09,5008
2024/05/10,6767
2024/05/11,648
2024/05/12,3910
2024/05/13,3849
2024/05/14,6812
2024/05/15,8674
2024/05/16,4462
2024/05/17,2570
2024/05/18,2884
2024/05/19,8901
2024/05/20,356
2024/05/21,6690
2024/05/22,8574
2024/05/23,1023
2024/05/24,5463
2024/05/25,9699
2024/05/26,8934
2024/05/27,8301
2024/05/28,5690
2024/05/29,6274
2024/05/30,4057
2024/05/31,4970
2024/06/01,4178
2024/06/02,6189
2024/06/03,7048
2024/06/04,3947
2024/06/05,2326
2024/06/06,4032
2024/06/07,4164
2024/06/08,1700
2024/06/09,7759
2024/06/10,2274
2024/06/11,1572
2024/06/12,3032
2024/06/13,7673
2024/06/14,8150
2024/06/15,2172
2024/06/16,1073
2024/06/17,9499
2024/06/18,4165
2024/06/19,4810
2024/06/20,4150
2024/06/21,9585
2024/06/22,3504
2024/06/23,5962
2024/06/24,5657
2024/06/25,3293
2024/06/26,1254
2024/06/27,2545
2024/06/28,5880
2024/06/29,1285
2024/06/30,6947
2024/07/01,4556
2024/07/02,5379
2024/07/03,5042
2024/07/04,3278
2024/07/05,1544
2024/07/06,6767
2024/07/07,4039
2024/07/08,5258
2024/07/09,1920
2024/07/10,9246
2024/07/11,7009
2024/07/12,7606
2024/07/13,3395
2024/07/14,2784
2024/07/15,4841
2024/07/16,8274
2024/07/17,1458
2024/07/18,4494
2024/07/19,5639
2024/07/20,4390
2024/07/21,5017
2024/07/22,2169
2024/07/23,9072
2024/07/24,964
2024/07/25,850
2024/07/26,3941
2024/07/27,7750
2024/07/28,9181
2024/07/29,7020
2024/07/30,2778
2024/07/31,9717
2024/08/01,5265
2024/08/02,1609
2024/08/03,6481
2024/08/04,6639
2024/08/05,4236
2024/08/06,5210
2024/08/07,9102
2024/08/08,8608
2024/08/09,9848
2024/08/10,2172
2024/08/11,6623
2024/08/12,6502
2024/08/13,9351
2024/08/14,8670
2024/08/15,7695
2024/08/16,1168
2024/08/17,8400
2024/08/18,5375
2024/08/19,9126
2024/08/20,5836
2024/08/21,2966
2024/08/22,5694
2024/08/23,5894
2024/08/24,6968
2024/08/25,6269
2024/08/26,8942
2024/08/27,7437
2024/08/28,9063
2024/08/29,3313
2024/08/30,6814
2024/08/31,3200
2024/09/01,5638
2024/09/02,1953
2024/09/03,1535
2024/09/04,6148
2024/09/05,6184
2024/09/06,6419
2024/09/07,295
2024/09/08,2265
2024/09/09,2470
2024/09/10,4492
2024/09/11,4251
2024/09/12,3237
2024/09/13,2536
2024/09/14,3587
2024/09/15,6792
2024/09/16,7138
2024/09/17,6337
2024/09/18,8969
2024/09/19,7757
2024/09/20,4065
2024/09/21,8027
2024/09/22,9233
2024/09/23,3681
2024/09/24,6297
2024/09/25,2181
2024/09/26,3744
2024/09/27,1127
2024/09/28,2204
2024/09/29,3356
2024/09/30,1556
2024/10/01,1983
2024/10/02,7402
2024/10/03,4278
2024/10/04,3447
2024/10/05,3520
2024/10/06,1458
2024/10/07,5632
2024/10/08,1667
2024/10/09,7782
2024/10/10,5383
2024/10/11,5154
2024/10/12,1017
2024/10/13,7096
2024/10/14,8173
2024/10/15,3501
2024/10/16,3588
2024/10/17,6667
2024/10/18,9837
2024/10/19,360
2024/10/20,2054
2024/10/21,3506
2024/10/22,6007
2024/10/23,3184
2024/10/24,5781
2024/10/25,1482
2024/10/26,7640
2024/10/27,5281
2024/10/28,2129
2024/10/29,8799
2024/10/30,144
2024/10/31,3917
2024/11/01,8461
2024/11/02,2080
2024/11/03,7557
2024/11/04,3430
2024/11/05,4329
2024/11/06,5228
2024/11/07,9906
2024/11/08,200
2024/11/09,3857
2024/11/10,4079
2024/11/11,3897
2024/11/12,2764
2024/11/13,8710
2024/11/14,3304
2024/11/15,3902
2024/11/16,1605
2024/11/17,4701
2024/11/18,1657
2024/11/19,937
2024/11/20,4514
2024/11/21,5510
2024/11/22,1274
2024/11/23,2203
2024/11/24,5051
2024/11/25,4518
2024/11/26,3949
2024/11/27,9211
2024/11/28,1002
2024/11/29,7136
2024/11/30,8519
2024/12/01,4609
2024/12/02,9566
2024/12/03,335
2024/12/04,2316
2024/12/05,498
2024/12/06,791
2024/12/07,800
2024/12/08,7722
2024/12/09,1807
2024/12/10,6105
2024/12/11,3890
2024/12/12,7289
2024/12/13,6838
2024/12/14,9255
2024/12/15,1519
2024/12/16,5266
2024/12/17,1745
2024/12/18,8574
2024/12/19,2936
2024/12/20,9374
2024/12/21,6354
2024/12/22,810
2024/12/23,7576
2024/12/24,5784
2024/12/25,8467
2024/12/26,772
2024/12/27,4746
2024/12/28,3948
2024/12/29,1885
2024/12/30,9020
2024/12/31,3380
2025/01/01,3835
2025/01/02,5392
2025/01/03,9060
2025/01/04,2902
2025/01/05,8987
2025/01/06,5226
2025/01/07,4549
2025/01/08,8852
2025/01/09,5071
2025/01/10,8322
2025/01/11,660
2025/01/12,4526
2025/01/13,4811
2025/01/14,2719
2025/01/15,7958
2025/01/16,4093
2025/01/17,582
2025/01/18,7642
2025/01/19,189
2025/01/20,1845
2025/01/21,2940
2025/01/22,5053
2025/01/23,786
2025/01/24,4340
2025/01/25,9095
2025/01/26,7602
2025/01/27,2313
2025/01/28,7547
2025/01/29,7093
2025/01/30,7123
2025/01/31,8266
2025/02/01,9340
2025/02/02,2744
2025/02/03,7656
2025/02/04,9302
2025/02/05,8458
2025/02/06,8209
2025/02/07,1844
2025/02/08,3318
2025/02/09,2477
2025/02/10,2175
2025/02/11,9080
2025/02/12,5182
2025/02/13,6312
2025/02/14,9902
2025/02/15,6362
2025/02/16,6941
2025/02/17,8208
2025/02/18,9844
2025/02/19,9621
2025/02/20,4105
2025/02/21,9679
2025/02/22,734
2025/02/23,2302
2025/02/24,4931
2025/02/25,3240
2025/02/26,4146
2025/02/27,6979
2025/02/28,882
2025/03/01,5703
2025/03/02,4642
2025/03/03,5024
2025/03/04,9159
2025/03/05,6842
2025/03/06,3153
2025/03/07,7458
2025/03/08,4878
2025/03/09,4423
2025/03/10,789
2025/03/11,6554
2025/03/12,4743
2025/03/13,6983
2025/03/14,4864
2025/03/15,8925
2025/03/16,8272
2025/03/17,676
2025/03/18,7659
2025/03/19,649
2025/03/20,6101
2025/03/21,7973
2025/03/22,3947
2025/03/23,7124
2025/03/24,7753
2025/03/25,7289
2025/03/26,9873
2025/03/27,5738
2025/03/28,3993
2025/03/29,6799
2025/03/30,5928
2025/03/31,4173
2025/04/01,8145
2025/04/02,8176
2025/04/03,4071
2025/04/04,6920
2025/04/05,486
2025/04/06,249
2025/04/07,3229
2025/04/08,6189
2025/04/09,5591
2025/04/10,4180
2025/04/11,7410
2025/04/12,7470
2025/04/13,8735
2025/04/14,4254
2025/04/15,4803
2025/04/16,6294
2025/04/17,4320
2025/04/18,3254
2025/04/19,5503
2025/04/20,3278
2025/04/21,6924
2025/04/22,3589
2025/04/23,5074
2025/04/24,5368
2025/04/25,548
2025/04/26,1329
2025/04/27,1280
2025/04/28,990
2025/04/29,6224
2025/04/30,9241
2025/05/01,3393
2025/05/02,1654
2025/05/03,2621
2025/05/04,5651
2025/05/05,8691
2025/05/06,6291
2025/05/07,3489
2025/05/08,5953
2025/05/09,3980
2025/05/10,3006
2025/05/11,4668
2025/05/12,4039
2025/05/13,9614
2025/05/14,1391
2025/05/15,8269
2025/05/16,6647
2025/05/17,6112
2025/05/18,6202
2025/05/19,989
2025/05/20,2401
2025/05/21,5203
2025/05/22,9628
2025/05/23,5685
2025/05/24,4361
2025/05/25,7903
2025/05/26,567
2025/05/27,2217
2025/05/28,3966
2025/05/29,2695
2025/05/30,4095
2025/05/31,6710
2025/06/01,9130
2025/06/02,2249
2025/06/03,8540
2025/06/04,6325
2025/06/05,4936
2025/06/06,783
2025/06/07,9239
2025/06/08,6621
2025/06/09,6332
2025/06/10,256
2025/06/11,6822
2025/06/12,9773
2025/06/13,7563
2025/06/14,3995
2025/06/15,3674
2025/06/16,8981
2025/06/17,6549
2025/06/18,1126
2025/06/19,5678
2025/06/20,7439
2025/06/21,7656
2025/06/22,8484
2025/06/23,1310
2025/06/24,1711
2025/06/25,1145
2025/06/26,5794
2025/06/27,5669
2025/06/28,5058
2025/06/29,9448
2025/06/30,8993
2025/07/01,6259
2025/07/02,7946
2025/07/03,4685
2025/07/04,9520
2025/07/05,284
2025/07/06,5734
2025/07/07,7638
2025/07/08,1615
2025/07/09,3640
2025/07/10,2542
2025/07/11,4039
2025/07/12,8892
2025/07/13,2764
2025/07/14,6823
2025/07/15,2105
2025/07/16,5053
2025/07/17,9966
2025/07/18,5733
2025/07/19,8135
2025/07/20,5561
2025/07/21,4352
2025/07/22,3938
2025/07/23,5143
2025/07/24,2230
2025/07/25,8983
2025/07/26,452
2025/07/27,3246
2025/07/28,7215
2025/07/29,1356
2025/07/30,5612
2025/07/31,7043
2025/08/01,4484
2025/08/02,9203
2025/08/03,6219
2025/08/04,3007
2025/08/05,260
2025/08/06,875
2025/08/07,5913
2025/08/08,3912
2025/08/09,8909
2025/08/10,6159
2025/08/11,5954
2025/08/12,7822
2025/08/13,9156
2025/08/14,6330
2025/08/15,5048
2025/08/16,1038
2025/08/17,5432
2025/08/18,5135
2025/08/19,7109
2025/08/20,6971
2025/08/21,5534
2025/08/22,9312
2025/08/23,1978
2025/08/24,3571
2025/08/25,8838
2025/08/26,6294
2025/08/27,7188
2025/08/28,9178
2025/08/29,8894
2025/08/30,6572
2025/08/31,2420

パラメータ

コントロール

計算フィールド

Quantity CV

ifelse(dateDiff({creation_date},${lastdate},"YYYY") = 0 and {creation_date}<=${lastdate}, quantity, 0)

Quantity LV

ifelse(dateDiff({creation_date}, ${lastdate},"YYYY") = 1 AND {creation_date} <= addDateTime(-1,"YYYY",${lastdate}), quantity, 0)

表示結果

検算結果

Quantity CV

Quantity LV

[higuyuta]

パラメータを使えばよかったのですね、無事できました。ありがとうございました！