Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following data:
locations | ticket_number | ticket_age |
irvine | 101 | 1 |
irvine | 102 | 2 |
utah | 103 | 5 |
utah | 104 | 1 |
I'm trying to create a pivot table like this:
locations | ticket_age <2 | ticket_age > 4 |
Irvine | 1 | 0 |
Utah | 1 | 1 |
My dimension is locations, however, I can't seem to do a conditional expression correctly to get me the counts I needed.
I tried If(ticket_age < 2, count(ticket_number)) which doesn't work.
Any suggestions?
put the count on the outside:
count(If(ticket_age < 2, ticket_number) )
put the count on the outside:
count(If(ticket_age < 2, ticket_number) )
That's what I needed. Thanks!