First-Time Buyers in Analytics?

Hi,

This formula doesn't seem to do anything -

What am I doing wrong? 

Hi Phillip,

The IF statement by itself only works when evaluated per constituent (grouped by Constituent ID). To use it at a Season level requires doing the constituent level evaluation within the formula via Multi-Pass Aggregation. So you will need to implement the second formula from my previous post...

COUNT ( [Constituent ID] ,
  IF (
    MIN( DDIFF ( [Days in Performance Date] , [Days in First Performance Date] ) ) = 0
    , MAX ( [Constituent ID] )
    , NULL
    )
)

Cheers.

Hi Chris.

I'm receiving an error 'function IF does not accept 2 parameters'

Also, I can't seem to find [Days in Performance Date]

If I select performance date, then change from years to days it changes to [Days in Date].

Hi Phillip,

The formula in your screenshot is missing this line:

    , MAX ( [Constituent ID] )

[Days in Date] is correct if it is the [Date] field from the [PERFORMANCE DATE] dimension. I renamed it [Days in Performance Date] to try an clarify which [Days in Date] I was using, but I confused matters. That to say, you have that right.

Cheers.

Hi Chris, the formula was correct... you can't expand the window to show the whole query.

It turns out that TX_ANALYTICS_DIVISION_ELEMENTS hadn't been configured correctly and was showing all data as 1900. We've now corrected this and my first timer data is correct.

Thanks,

Phillip 

Hi again,

Is there an easy way to see percentage of new bookers?

I've tried this:

But get this:

It looks like maybe this is just an order-of-operations issue? Move the final ")" to before the division "/".  

That's worked!

Thanks Chris

Hello Phillip, 

What did you have to change in the TX_ANALYTICS_DIVISION_ELEMENTS table? I think I could be experiencing the same issue.

Thanks! 

Hello Phillip, 

What did you have to change in the TX_ANALYTICS_DIVISION_ELEMENTS table? I think I could be experiencing the same issue.

Thanks!