Show first order for a customer

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

Related Questions In Tableau

0 votes
1 answer

combine two data sets in tableau so that I can show a forecast for the next 3 months

I believe the best approach is to ...READ MORE

answered Apr 5, 2022 in Tableau by Vaani
• 7,060 points
692 views
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, 2022 in Tableau by Neha
• 9,060 points
1,817 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 ffdfd
• 5,550 points
1,285 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
771 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,240 points
1,299 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
1,427 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
2,507 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,030 points
620 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,030 points
711 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP