topic Re: BMIUtilisationMonthly ... history has only EoM figures in Product Forum

BMIUtilisationMonthly ... history has only EoM figures

Walter.Koller — Mon, 17 Jun 2024 08:57:30 GMT

Hello,

I wanted to use the statistics table BMIUtilisationMonthly to get historic figures for the past years. When querying the table I noticed only the December is available for previous months and all months for the current year. The list of year & months look like:

2024-06, 2024-05, 2024-04, 2024-03, 2024-02, 2024-01, 2023-12, 2022-12, 2021-12, 2020-12, ...

I was hoping those December values will at least show the total sum of the year but no, 2023-12 values are less than monthly values in 2024 and cannot be a total sum.

Either I completely miss something, I don't get the purpose of previous year's value or there seem to be a bug of either keeping old data or cleaning the table of old data.

Or is this some weird situation that just happened in our environment after being used for a couple of years and after some upgrades?!

Clarification is much appreciated, thanks

Re: BMIUtilisationMonthly ... history has only EoM figures

steven.boggs — Wed, 10 Jul 2024 13:49:08 GMT

Hi Walter,

We've seen in the past where utilization data is not available in analytics tables because the setting to begin collecting them was not enabled before a certain time.

Utilization data will only be collected and displayed in your Analytics tables if you have enabled the Collect utilization and productivity statistics check box under System Settings > System > Reporting:

It could be the case that either this option was not enabled until December of last year, and/or you're using the default value of 6 months for "Keep...monthly statistics", which would remove any utilization data older than 6 months at a regular interval.

Re: BMIUtilisationMonthly ... history has only EoM figures

Walter.Koller — Wed, 24 Jul 2024 11:13:44 GMT

Hello @steven.boggs

Thanks for your reply. I just came back from vacation and could not get back to you sooner.

Statistics collection is enabled in our environments. You brought up a good point of monthly statistics being deleted after 6 months. This somehow explains the numbers I saw for Decembers, which seems to be just lower than usual.

However, I can see figures for each month of December for past years although everything older than six months should be deleted

I think four of our environments have several December figures for previous years. Most of our environments seem to delete values > 6 months correctly though.

I will consider this behavior as caused by the age of the environment, which was initially created in v6.4

Thanks again