Logo
Resources
Documentation Portal Ideas Portal Guardsix Academy License Portal
Resources
Documentation Portal Ideas Portal Guardsix Academy License Portal Use Case Navigator
Sign in
  1. Guardsix Servicedesk
  2. Products Hub
  3. Known Issues

Aggregation functions return 0 when a wildcard or IN condition is used on a field

Avatar Kripa Thapa
November 18, 2026 10:07
Follow
Reference ID
LP-78980
Date Published November 18, 2026
Affected Products Guardsix SIEM
Affected Versions 7.10.0, 7.11.0, 7.11.1
Status
Under Development
Fix Version 7.10.1 and 7.11.2
Description

A wildcard or IN condition placed inside an aggregation function in a chart or timechart returns 0 for the affected count, even when matching logs exist. For example:

  • | chart count(norm_id=*) 

  • | timechart count(norm_id=*) 

  • | chart count(norm_id in ['SIEM', 'WCL']) 

If your deployment is affected by this issue, you may see the following:

  • The count returns 0 for every group, even when matching logs exist.

  • Percentages or ratios calculated from these counts are incorrect.

  • In the same query, a plain count() returns the expected value, while the conditional count returns 0.

This behaviour also affects alerts, dashboard widgets, and reports built on these query patterns. 

Workaround

Move the condition into the base search, before the first pipe (|):

  • norm_id=* | chart count() 

  • norm_id=* | timechart count() 

  • norm_id in ['SIEM', 'WCL'] | chart count() 

Apply the same change to any alerts, dashboard widgets or reports that use affected queries. If you have any questions or require assistance, create a support ticket.

Comments

Article is closed for comments.

Related articles

  • Alert rules may stop triggering when dashboards or alerts use timechart with long intervals
  • Label conditions inside aggregation functions or the search command fail to match or return incorrect counts
  • Root CA Update Plugin / Patch
Was this article helpful? 0 out of 0 found this helpful
Privacy policy    EULA    Terms of service   
Copyright © , Guardsix. All rights reserved.

Note: We use cookies that are essential for the smooth functioning of our website.