Skip to Content
0
Dec 27, 2022 at 07:56 AM

SUM IN WEBI

15 Views Last edit Dec 27, 2022 at 08:00 AM 2 rev

Hey Guys,

I am useing WEBI and I am having problem:

I want to sum up the number of responses according to the date the message was sent, and not according to the date the customer replied.

I have two metrics: Move_To_channel_DT (the date the customer was sent the message) and response_date (the date the customer responded).

For example, if customer A was sent a message on 12/12 and the customer replied to it on 15/15, I would like to consider it as a response to 12/12.

image.png


This is The final table:

image.png

Thanks,

Attachments

image.png (15.0 kB)
image.png (10.5 kB)