looker

[Emmap]

Hi

I have data :

Tickets - with values of 1 and 2

Supporters Age

I want to do a sum based on the ticket the and the supporter age

For example

If Ticket is 1 and age is less than 20 then multiply by 0.5

and of ticket is 1 and age is between 21-25 then multiply by 0.6

and so on in 5 yr increments up to 100 and then the same for the 2 tickets with different multipliers.

I have tried various things and can not find a solution. 

I am fairly new to looker so any advice on a solution or where to look would be greatly appreciated. 

Regards

[Joseph_Seddik]

Where do you want to show this sum and how you want to display it? Please post screenshots of what you've done so far and where you are stuck so you could get better help. 

Basically, you'll need to add a new calculated field with the right formula. The formula and whether you'd need to add a filter to your data source can vary according to the way you'd display this sum.