Exclude last month from data set

0 votes

How to always show data by excluding the most recent month?

May 22 in Tableau by Peter
11 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 Peter,

Use a condition as below and statements to perform data

IF MONTH([Order Date])!= MONTH({MAX([Order Date])}) AND YEAR([Order Date])= YEAR({MAX([Order Date])}) THEN "........"
ELSE ......" END

OR

IF DATEDIFF('month',[Order Date], {MAX([Order Date])})>0 THEN "....." ELSE "......." END

Hope it helps!
answered May 22 by Cherukuri
• 15,820 points

Related Questions In Tableau

0 votes
1 answer

How to calculate weekly average from daily data?

You can create these calculated fields: Unique Weeks ...READ MORE

answered Jun 26, 2018 in Tableau by Atul
• 10,220 points
34 views
0 votes
1 answer

Performing automatic read and update data source from a web data connector

Dashboard on Tableau Public can only be ...READ MORE

answered Aug 27, 2018 in Tableau by Atul
• 10,220 points
18 views
0 votes
1 answer

Replacing Data Source from one Server to Another

I did something similar to it For ...READ MORE

answered Sep 19, 2018 in Tableau by Naruto
• 710 points
33 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
• 15,820 points
55 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,220 points
1,171 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,220 points
38 views
+2 votes
1 answer
0 votes
1 answer

last n days transactions data from dataset

Hey,  You can create a calculated column or ...READ MORE

answered May 22 in Tableau by anonymous
• 15,820 points
11 views
0 votes
1 answer

How to set Actions from sheet to Dashboards

Hey, The below Filter can be used to navigate from ...READ MORE

answered Feb 28 in Tableau by Cherukuri
• 15,820 points

edited Feb 28 by Cherukuri 29 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.