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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
