Grouping with Date and time feild

[sarin1]

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. 

[Amit_Shinde]

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