How to get distinct customers this year wrt previous year?

0 votes
How to get distinct customers this year with respect to previous year? I'm using global superstore data set.
May 16 in Tableau by anonymous
17 views

1 answer to this question.

0 votes
Follow the below steps:

1. Create calculated fields to a group of n depending on years.

2. Create a parameter for selecting the current year.

3. Now create another calculated field to check current year vs previous year as if the order date is equal to the current year -1 then the customer is an existing customer else a new customer.

IF YEAR([Order Date]) = YEAR([Current Date])-1 THEN "EXISTING CUST"
ELSE [Customer ID]
END

Hope it helps you.
answered May 16 by Cherukuri
• 25,700 points

Related Questions In Tableau

0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
137 views
0 votes
1 answer

How to get Tableau results in python?

Well even I was looking for the ...READ MORE

answered Apr 9, 2018 in Tableau by Atul
• 5,530 points
66 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
4,309 views
0 votes
1 answer

How to change months for a calendar year

Hey, you can try this & Change ...READ MORE

answered Apr 20, 2018 in Tableau by QueenBee
• 1,810 points
20 views
0 votes
1 answer

How to determine average per event by year?

Hi Roshan, Create a new calculated field (use ...READ MORE

answered Sep 25, 2018 in Tableau by Machdata
• 340 points
54 views
0 votes
0 answers

Calculating count average from averages

I've a calculated field in Tableau which ...READ MORE

May 28, 2018 in Tableau by Mahima Choudhary
23 views
0 votes
1 answer
0 votes
1 answer

How to Split a Measure in Tableau?

Have you tried using an IF statement: IF ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
91 views
0 votes
1 answer

How to compare sales of today with previous year?

Create a calculative field as, IF YEAR(TODAY())=YEAR([DATE_FIELD]+1 AND ...READ MORE

answered Apr 5 in Tableau by Cherukuri
• 25,700 points
36 views
0 votes
1 answer

How to get past N months date from data source?

Hi, this is a one solution to your ...READ MORE

answered Mar 1 in Tableau by Cherukuri
• 25,700 points
66 views