Issue
Description
In the Istanbul version, reports contain the 'Created' field in 'Stack by' when that field is added in the 'Additional group by'. But in the London version and higher, it is behaving differently. Even though the 'Created' field in 'Additional group by' is added, it does not appear in the 'Stack by' list.
Steps To Reproduce
Observation in Istanbul:
- Go to create Reports
- Give the Table name 'Incident'
- Type - Bar
- Group by - Category
- Additional Group by - Priority and created
- Aggregation - count
- select stacked
Based on the above observation, we can see that the in Istanbul release, 'Stacked by' has 'Created' as an option when 'Created' is added to 'Additional group by'.
Observation in London and higher:
- Go to create Reports
- Give the Table name 'Incident'
- Type - Bar
- Group by - Category
- Additional Group by - Priority and created
- Aggregation - count
- select stacked
Based on the above observation, we can see that the in London release, 'Stacked by' doesn't have 'Created' as an option even when 'Created' is added to 'Additional group by'.
In the versions London and higher, the available 'Stack by' fields is limited to catalog variables, reference fields, lists, and boolean values. Date/time, integer, long, string, list, and text fields cannot be used as stacked fields. Hence the 'Created' field does not appear in 'Stacked by' in the London version, whereas it appears in 'Stacked by' in the Istanbul version.
Affected Versions
London and higher versions
Additional Information
In Istanbul, all fields are supported in 'Stacked by'.
In London and higher versions, only catalog variables, reference fields, lists, and boolean values can be used in 'Stacked by'. Date/time, integer, long, string, list, and text fields cannot be used as 'Stacked by' fields.
