| T O P I C R E V I E W |
| a_h |
Posted - 06/25/2026 : 04:19:38 AM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2025 (64-bit) SR1
Operating System: Win11
The frequency count feature is one of my most regularly used features and I find it superuseful.
However, I recently used frequency count (mark column -> right click -> frequency count) where the x-column is set to date.
It generates the expected statistical frequency information, however, the generated date bins are off by two days.
For example, the frequency count statistics show that a certain event happened 28-times on the day June, 2 (class starts at June 2 12:00 and goes to June 3 12:00).
Looking into the actual data (that is the basis for the frequency count) this is not correct as the day where this event happened 28-times is actually June 1 at 06:47 which is the May 31 class (that begins on May 31 12:00 and ends on June 1 12:00).
Please advise how I can fix this, thanks!! |
| 6 L A T E S T R E P L I E S (Newest First) |
| a_h |
Posted - 06/29/2026 : 02:59:15 AM
Hi,
many thanks for looking into this!!
Thank you also very much for your work-around - it helps a bit to mitigate the issue, but plotting is consequently painful (as it's no longer a real date but treated as text).
Thanks, Hannes
EDIT: found a solution also for that, so all good now - thank you! |
| NadeeshaSupport |
Posted - 06/25/2026 : 10:21:32 AM
https://my.originlab.com/ftp/forum_and_kbase/Images/date%20freq%20bug2.ogwu |
| NadeeshaSupport |
Posted - 06/25/2026 : 10:19:58 AM
Hi,
This seems to be a bug.
For now, I've extracted the date portion from the column and reproduced the correct frequency bins.
Please see attached.
These are the steps for reproducing:
1. Right click and select Properties
2. Select Date under Options -> Format
3. Select Custom Display under Display and enter dd.MM.yyyy HH':'mm':'ss'.'###
4. Click OK
5. Enter =int(col(A)) under the F(x)= designation in column B
6. Right click and select Properties
7. Select Date under Options -> Format
8. Select Custom Display under Display and enter dd.MM.yyyy
Thanks,
Nadeesha |
| YimingChen |
Posted - 06/25/2026 : 09:51:23 AM
Hi,
This seems like a bug, I have reported the issue (ref: ORG-33834) to fix it. Thank you.
Yiming |
| a_h |
Posted - 06/25/2026 : 04:27:15 AM
another image of the frequency count results
 |
| a_h |
Posted - 06/25/2026 : 04:24:51 AM
Frequency count result:
Actual data showing the event to occur 28-times on June 1 which would belong to the May 31 class:
 |
