Notifications

40 views

Description

When a Column type, Time Series report has a Condition using the "Keywords" field and is configured to display the columns by date, the months will not display in the correct order.

Steps to Reproduce

1. Navigate to Report > View / Run

2. Create New

3. Configure the report as follows:
- Table: Task
- Type: Time Series > Column
- Group by: None
- Trend By: Opened
- Per: Month
- Aggregation: Count

4. In the Conditions builder add any condition with the "Keywords" field. For example, applying any of the following to an OOB instance will display the issue (not specific to just these conditions, any condition containing "Keywords"):

"Keywords are email"
"Keywords are application"
"Keywords are change"

Notice some of the months displayed in the X axis do not appear in the correct order from the furthest calendar date to the closest.

Workaround

This is expected behavior in the current releases, "Sort by keywords" is not supported. Using the keywords feature for reporting is not a recommended practice.


Related Problem: PRB1333367

Seen In

SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - NIST CSF - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITOM - Discovery and Service Mapping - 201908
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Security Incident Response UI Patch - London 2019 Q2 v.6.2.3
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - VR - Rapid7 - London 2019 Q2 v.6.2.1
SR - VR - Vulnerability Response - New York 2019 Q3

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-12-02 12:05:00
Published:2019-08-20