I would like to create an OLAP table which counts cases with/ without specific activities.
In this case, I’d like to count cases which through both “Confirm Reservation” and “Sell Ticket”.
I’d like to get the result like this.
Confirm Reservation (Booking Number) : 1
Confirm Reservation (QR Code) : 2
Else : 2
*D-004 is treated as “Else” because D-004 passed though only “Confirm Reservation”
The name of activity is different from my raw data, so please don’t use wildcard like "Confirm Reservation"
If I could, I’d like to show the result as pie chart.
Thank you for your support.