cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MarcoG2000 Frequent Visitor
Frequent Visitor

synthetic result for each customer on each day

Hi, I have a simple table with three columns.

Each line is an event that concerns a customer in a day. For each customer, multiple events can occur in one day with the same or different results.

 

he problem is this: Create a new table that has to be assigned only one synthetic result for each customer on each day. The synthetic result must have this order of priority. If there is an A or B then "Very Good", if there is no A or B, but there exists C or D then "Good", otherwise "Bud". I enclose the excerpt of the initial table and the desired one.

 

Thank you very much for helping.

Table.JPGsynthetic.JPG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: synthetic result for each customer on each day

Hi @MarcoG2000,

 

You could create a calculated table with the formula below to get your expected output.

 

Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Date],
    'Table'[IDCustomer],
    "out_come", IF (
        OR ( MIN ( 'Table'[OUTCOME] ) = "A", MIN ( 'Table'[OUTCOME] ) = "B" ),
        "Very Good",
        IF (
            OR ( MIN ( 'Table'[OUTCOME] ) = "C", MIN ( 'Table'[OUTCOME] ) = "D" ),
            "Good",
            "Bud"
        )
    )
)

Then you will get the output below.

 

Capture.PNG

 

Best Regards,

Cherry

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

Re: synthetic result for each customer on each day

Hi @MarcoG2000,

 

You could create a calculated table with the formula below to get your expected output.

 

Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Date],
    'Table'[IDCustomer],
    "out_come", IF (
        OR ( MIN ( 'Table'[OUTCOME] ) = "A", MIN ( 'Table'[OUTCOME] ) = "B" ),
        "Very Good",
        IF (
            OR ( MIN ( 'Table'[OUTCOME] ) = "C", MIN ( 'Table'[OUTCOME] ) = "D" ),
            "Good",
            "Bud"
        )
    )
)

Then you will get the output below.

 

Capture.PNG

 

Best Regards,

Cherry

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