Trend Report is not showing True/False when a Group by Aggregation is done on Reference type field referring to Boolean values.

Steps to Reproduce

  • create a table that has assigned to field that is a reference to table user
  • create 2 records from this table that one of them has assigned to field populated and the 2nd one is empty
  • create a trend report and group it by assigned (active from sys_user table user dot walking).
  • run the report

    The trend report is displayed correctly

    The trend report is displaying only records with empty assigned to reference


use a different type of visualization or upgrade to a version where fix is available

Related Problem: PRB1330401

Seen In

There is no data to report.

Intended Fix Version

New York

Fixed In

Madrid Patch 3

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-30 23:42:27