When viewing an exported report from CAPC in unscaled csv, the date format seems inconsistent.
An example below:
09/12/2020 17:00 0.481407
09/12/2020 18:00 0.472109
09/12/2020 19:00 0.472195
09/12/2020 20:00 0.473063
09/12/2020 21:00 0.473435
09/12/2020 22:00 0.499793
09/12/2020 23:00 0.485768
9/13/20 0:00 0.476173
9/13/20 1:00 0.474971
9/13/20 2:00 0.371966
9/13/20 3:00 0.472035
9/13/20 4:00 0.510429
9/13/20 5:00 0.469157
9/13/20 6:00 0.472527
9/13/20 7:00 0.475987
9/13/20 8:00 0.476372
9/13/20 9:00 0.473769
Release : 3.7
Component : IM Reporting / Admin / Configuration
Cell formatting was inconsistent in the rendering tool used, in this case excel.
Open the raw CSV file in a text editor like notepad++ and verify that CAPC is exporting the data in a consistent format.
Adjust or switch the tools you are opening the file with.
Original issue 32266321