Show first order for a customer

0 votes
How to show first-order sales for each customer?
May 7, 2019 in Tableau by Nithin
148 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, 2019 by Cherukuri
• 33,010 points

Related Questions In Tableau

0 votes
1 answer
0 votes
1 answer

Tableau - how to show a legend for a stacked bar chart?

I'm afraid I'm going to get marked ...READ MORE

answered Apr 5 in Tableau by Neha
• 8,560 points
97 views
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 sdfg
• 5,550 points
584 views
0 votes
1 answer
0 votes
1 answer

How to create a filter based on date range?

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

answered Aug 8, 2018 in Tableau by Nitish
• 630 points
420 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 10, 2018 in Tableau by Atul
• 10,230 points
892 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 15, 2018 in Tableau by AwesomeSauce
• 860 points
849 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
1,387 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, 2019 in Tableau by Cherukuri
• 33,010 points
205 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, 2019 in Tableau by Cherukuri
• 33,010 points
342 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP