Allow date-time data types to work with filter operators | Community
Skip to main content
Level 5
October 20, 2023
New

Allow date-time data types to work with filter operators

  • October 20, 2023
  • 1 reply
  • 481 views

Description

In Customer Journey Analytics, dimensions can be configured to use a date-time schema data type. For example, a dimension showing when a product was added to wishlist could use this data type. Despite dates being akin to numbers, they cannot be used with greater than and less than operators in fitlers. The recommendation is to allow for this type of functionality.

 

Why is this feature important to you

Allowing the use of operators on dimensions that use a date-time data type would be useful for filter creation.

 

For example, let's say that a user wanted to see a list of customer IDs that added a product to a wishlist between September 20, 2023, and October 20, 2023. A dimension exists that captures the date that a product was added to a wishlist (Dimension 1), and the dimension's values are in date-time format. If filter operators worked with date-time dimensions, the user could build a filter with logic similar to "greater than or equal to Dimension 1 = Sep 20, 2023, and less than or equal to Dimension 1 = Oct 20, 2023". Currently, the user would have to list out 31 different dimension values to cover each of the dates from Sep 20, 2023, and Oct 20, 2023.

 

How would you like the feature to work

Treat dimension values with a date-time data type as numbers, which will allow greater than, less than, etc. operators to be used.

 

Current Behaviour

Dimensions with date-time data types do not currently work with operators.

1 reply

January 13, 2025

Hi,

 

Same problem here. For my client, it is important to segment costumer by date of suscription, and as @brentrad said, it is impossible to use date dimension to filter based on grater/less than operator.

 

regards