Show first order for a customer

0 votes
How to show first-order sales for each customer?
May 7 in Tableau by Nithin
18 views

1 answer to this question.

0 votes
Hi Nithin,

Use the calculative field as below,

IF[Order Date]={ MIN([Order Date]) } THEN [Sales]
END

This would fetch you the order for each customer.

Now drop customer in the sheet and above created field and order-date field.

Hope it helps you.
answered May 7 by Cherukuri
• 32,260 points

Related Questions In Tableau

0 votes
1 answer

How can I add a row number for a specific field?

Hi @Noob, You can use RANK_DENSE function: "The function returns the ...READ MORE

answered Apr 17, 2018 in Tableau by Atul
• 5,530 points
43 views
0 votes
1 answer
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
28 views
0 votes
1 answer

What are the important question for a Tableau Interview?

Here is a link to the blog ...READ MORE

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

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 7, 2018 in Tableau by Nitish
• 630 points
68 views
0 votes
1 answer

How can I convert week into Date(mm/dd/yyyy)?

Right click on your date field, you'll ...READ MORE

answered Aug 9, 2018 in Tableau by Atul
• 10,240 points
200 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

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

How to merge Year ,Month and date in Order Date in Tableau?

Hi, you can simply drag the Order ...READ MORE

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

How to find first n months profit/sales for a given year

Hi Sindhu, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 32,260 points
34 views
0 votes
1 answer

How to show outliers for a given set of points.

Hi Anshuli, Follow below steps: 1. Create a line ...READ MORE

answered Apr 17 in Tableau by Cherukuri
• 32,260 points
66 views