3 Replies Latest reply on Aug 14, 2017 6:38 PM by Zhouyi Zhang

New vs Retuning Customer? Group by number of records?

Hi Ya'll, I need help!

I would like to view by movie title and know the % of new vs returning customers/users

A - The % of new vs returning user Ids

B - ....

C - ....

I think I may have to duplicate my data source and use it as a denominator, but currently stuck and would love some help. THANKS.

Here is my data

I can count by movie title

I can also group by discrete number of records and color on User ID

• 1. Re: New vs Retuning Customer? Group by number of records?

Hi, Benjamin

Is this the outcome you are after?

Hope this could help

ZZ

• 2. Re: New vs Retuning Customer? Group by number of records?

Wow Zhouyi,

This is exactly what I needed! Thanks you!!

I have two follow up questions

Question 1

As it turns out the alphabetic order of movie titles is not the order I'd like to use when calculating new/repeat users.  I show my solution below, but thought you may have a less archaic way of doing the same thing.

Lets say for example that I wanted to use this order

B % new/returning

C % new/returning

A % new/returning

My solution was to create a new column in my data titled "order" that I then used instead of movie title.

NEW ORDER COLUMN

ORDER COLUMN USED IN CALC

SOLUTION IN DIFFERENT ORDER

Question 2

This calc is kinda like a loop? [Order] <> { FIXED [User ID]:MIN([Order])}

Stating that if the rows order is not equal to the minimum order of that userID then title that record repeating?

I understand you logic and for some reason I'm having trouble knowing how to think broadly about LOD calcs and their applications. They seem critical, do you have any advice on how to know when to implement them?

Bonus Point Question 3!

Who are you?

Do you work for Tableau?

Can I compensate you for your help?

Many thanks,

Ben

• 3. Re: New vs Retuning Customer? Group by number of records?

Hi, Ben

To your 1st question, adding order is brilliant,  another way I could think of is to use date, e.g. movie on shelf date.

2nd question, it is not a loop, Tableau has the feature of LOD, which to my understanding is something similar to "over partition by" in SQL query so that you could calculate the aggregation value in row level.

here are two links you may interest in

Overview: Level of Detail Expressions

3rd question, this is a Tableau company provided community, a lot of people like me are volunteer to help, because initially I got help from other people the same as you.

ZZ