Hello, rather basic question I guess: 1. I have e...
# questions
b
Hello, rather basic question I guess: 1. I have events 2. Via lookup table each event name has some number attached to event. For example: open-profile - 2, close-profile - 1, open-checkout - 10 3. Now I want to sum all numbers for all events that occurred for a user during the day Example: User John • Event A - 10 • Event B - 5 • Event A (one more time, as it occurred twice during the day for John) - 10 • TOTAL that I want to get: 25 User Amy • Event A - 10 • Event C - 7 • Event C - 7 • Event D - 2 • TOTAL that I want to get: 26 So, what I figured out so far is on the screenshot below. But .. well ... for Select Aggregation there is maximum, minimum, average and distinct ... none of which I guess gives me the needed sum. Any suggestions please?