Rounding Time Unit based on Custom date slice

Hi ,

I would like to know if there are any provision to consolidate the date for the specific date slice to use in the dimensions . For Eg 5 days or 3 days custom grouping etc .

I require the functionality similar to ROUND_WEEK() to group date but i should be able to group based on the custom logic of 5 days or 3 days etc for the date range .

Thanks ,
Praveen

Hi Praveen,

unfortunately there is no such feature available yet, but you can build a workaround in PQL.
To do so, try the following logic (e.g. for intervals of 5 days):
ADD_DAYS(
ROUND_MONTH(“ACTIVITIES”.“EVENTTIME”),
CASE
WHEN DAY(“ACTIVITIES”.“EVENTTIME”) >= 25
THEN 25
WHEN DAY(“ACTIVITIES”.“EVENTTIME”) >= 20
THEN 20
WHEN DAY(“ACTIVITIES”.“EVENTTIME”) >= 15
THEN 15
WHEN DAY(“ACTIVITIES”.“EVENTTIME”) >= 10
THEN 10
WHEN DAY(“ACTIVITIES”.“EVENTTIME”) >= 5
THEN 5
ELSE 1 END
)

Best regards,
Data Science Service Desk