Reply
Highlighted
Frequent Visitor
Posts: 5
Registered: ‎08-18-2016
Accepted Solution

Client Journey – Compare the client’s performance with number of registrations over the time broken

[ Edited ]

Requirement: Client Journey – Compare the client’s performance with number of registrations over the time broken down by WEEK1, WEEK2, WEEK3,…..etc.

 

Important Note: This comparison need to be done with same period of client with another client. (Comparison example: Week1 – FFor Client1 – From 6th Aug’16 To 12th Aug’16 vs. Week1 – For Client2 – From 3rd Feb 16 To 10th Feb 16)

 

Expected:
CLient1-Week1-CustomerCount-9
Client2-Week1-CustomerCount-3

 

Client CustomerName RegistrationDate
Client1 J.V.Rizzi 6-Aug-16
Client1 NickOtto 7-Aug-16
Client1 AllanS.Roth 8-Aug-16
Client1 LauraAlix 8-Aug-16
Client1 ElizabethDexheimer 9-Aug-16
Client1 RonGoldstein 10-Aug-16
Client1 DavidVoreacos 10-Aug-16
Client1 JenA.Miller 10-Aug-16
Client1 SulemanDin 12-Aug-16
Client2 RaeShanahan 3-Feb-16
Client2 ElliotM.Kass 4-Feb-16
Client2 MarkDupont 8-Feb-16


Accepted Solutions
Community Support Team
Posts: 5,652
Registered: ‎09-21-2016

Re: Client Journey – Compare the client’s performance with number of registrations over the time bro

Hi @mahantesh1988,

 

Create a calculated column:

WeekNo =
"Week"
    & INT (
        DATEDIFF (
            CALCULATE (
                MIN ( 'Client Table'[RegistrationDate] ),
                ALLEXCEPT ( 'Client Table', 'Client Table'[Client] )
            ),
            'Client Table'[RegistrationDate],
            DAY
        )
            / 7
    )
        + 1

2.PNG

 

Use a table visual to host data.

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 5,652
Registered: ‎09-21-2016

Re: Client Journey – Compare the client’s performance with number of registrations over the time bro

Hi @mahantesh1988,

 

Create a calculated column:

WeekNo =
"Week"
    & INT (
        DATEDIFF (
            CALCULATE (
                MIN ( 'Client Table'[RegistrationDate] ),
                ALLEXCEPT ( 'Client Table', 'Client Table'[Client] )
            ),
            'Client Table'[RegistrationDate],
            DAY
        )
            / 7
    )
        + 1

2.PNG

 

Use a table visual to host data.

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 5
Registered: ‎08-18-2016

Re: Client Journey – Compare the client’s performance with number of registrations over the time bro

Thank You so much. It looks fine