Performance - Average Values Over Time --- Repository Dashboard -- missing values

[funooni]

Did you check DOCS to make sure there is no workaround? https://sqlwatch.io/docs/

Yes

Describe the bug The table "Performance - Average Values Over Time" does not show values for the columns:

Blocked, Batch Requests , Transactions, Connections, Logins/Sec

To Reproduce Steps to reproduce the behavior:

1. Go to repository Dashboard, Expand the "Performance - Average Values Over Time"
2. The values for above mentioned columns will not be there

Expected behavior The columns must have values

Screenshots

Windows Server (please complete the following information):

• OS Version: Windows 2016 R2

SQL Server (please complete the following information):

• SQL Version: [e.g. SQL Server 2016 SP1]
• SQL Edition: [e.g. Enterprise]

SQL Server Management Studio (SSMS -> about -> copy info): Microsoft SQL Server Management Studio 13.0.16106.4 Microsoft Analysis Services Client Tools 13.0.1700.441 Microsoft Data Access Components (MDAC) 10.0.17763.1 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.11.17763.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 6.3.17763

SQLWATCH version (from DACPAC or from sysinstances)

• 4.2.0.28234

Additional context The table gets data from the below query SELECT --repository_dashboard_table 'Batch Requests/sec' = avg(case when counter_name = 'Batch Requests/sec' then [cntr_value_calculated] else null end) ,'Readahead pages/sec' = avg(case when counter_name = 'Readahead pages/sec' then [cntr_value_calculated] else null end) ,'Transactions/sec' = max(case when counter_name = 'Transactions/sec' then [cntr_value_calculated] else null end) ,'Processes blocked' = avg(case when counter_name = 'Processes blocked' then [cntr_value_calculated] else null end) ,'User Connections' = avg(case when counter_name = 'User Connections' then [cntr_value_calculated] else null end) ,'Logins/sec' = avg(case when counter_name = 'Logins/sec' then cntr_value_calculated else null end) ,pc.sql_instance FROM [dbo].[vw_sqlwatch_report_fact_perf_os_performance_counters] pc WHERE [aggregation_interval_minutes] = 1 AND $__timeFilter(snapshot_time) AND counter_name IN ('Batch Requests/sec','Readahead pages/sec','Transactions/sec','Processes blocked','CPU usage %','User Connections','Logins/sec') GROUP BY pc.sql_instance

If i remove the condition "[aggregation_interval_minutes] = 1" in the where condition then i see the data.

Please check whether this is a fix or I need to check something else.

Many thanks Zee