most recent purchase dates of a customer in tableau

0 votes

Most recent purchase dates of a customer in tableau.

Apr 22 in Tableau by smitha
26 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hi Smitha,

Follow below steps:

1. Create a calculated field like below. (find max(date) then compare with dates for each customer

      IF [Order Date]={ FIXED [Customer ID] : MAX([Order Date]) } THEN [Order ID]
      ELSE "NO"
      END

2. Now add the created field to filter ans unselect "NO".

3. Now the last or recent purchased order will be shown.

Hope this helps you.
answered Apr 22 by CHERUKURI
• 12,780 points

Related Questions In Tableau

0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,470 points
64 views
0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,170 points
1,337 views
0 votes
1 answer

Counting number of elements in a comma seperated column in Tableau

If you have access to the database, ...READ MORE

answered Jun 19, 2018 in Tableau by xyz
• 1,550 points
79 views
0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
554 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,170 points
898 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,170 points
35 views
+2 votes
1 answer
0 votes
1 answer

Is it possible to do a % of Table with an attribute in Tableau?

Hi Nithin, yes it is possible to ...READ MORE

answered Mar 12 in Tableau by CHERUKURI
• 12,780 points
8 views
0 votes
2 answers

How can I add text in the centre of a Donut Chart ?

Hi, You can read this for creating a donut ...READ MORE

answered Apr 4 in Tableau by CHERUKURI
• 12,780 points
285 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.