Grouping with Date and time feild | Community
Skip to main content
October 11, 2023
Question

Grouping with Date and time feild

  • October 11, 2023
  • 1 reply
  • 693 views

 

I have a data in which creation date and processed data count available. Creation date is update with same date but different time. Processed count is updated based on time.

I required like one date with sum of all  processed count and Success count.

please help on this. 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Level 3
October 19, 2023

Hi Sarin,

Assuming you are asking this query for Adobe Campaign Classic platform. you can group by the data based on creation date to get the one row for one day with processed and success count. Below are the steps you can follow.

1. Apply the toDate() function on creation date to remove the timestamp from date in output columns and check the group checkbox(Group=Yes)

2. Use aggregate function count() to get the count for processed and success count

3. In Advance Parameters, check the option 'Disable automatic adding of the primary keys of the targeting dimension'  

Below is a screenshot for reference. Hope this helpful.

 

Regards,

Amit