show recent month data

0 votes
How to display data for recent or latest month in the chart without filter?
Jun 12, 2019 in Tableau by Saradhi
41 views

1 answer to this question.

0 votes
Create a calculated column as below,

IF MONTH([Date]) = MONTH({MAX([Date])}) THEN [Date] END

Place year in filter shelf for the year else use YEAR([ Date]) = YEAR({MAX([Date])}) to fetch for latest year.

Drop the created column in the chart and place the other fields to see only the data for the last or recent month.
answered Jun 12, 2019 by anonymous
• 32,440 points

Related Questions In Tableau

0 votes
1 answer

Show data for next n days

Hi, Follow below steps: 1. Make a parameter to take ...READ MORE

answered Apr 5, 2019 in Tableau by Anitha
47 views
0 votes
1 answer

Show data from 2 different sheets in one sheet.

Hi Anitha, Follow the below steps: 1. Create both ...READ MORE

answered Apr 25, 2019 in Tableau by Cherukuri
• 32,440 points
52 views
0 votes
1 answer

Show color bar even when no data in bar chart

Hi Latha, Follow the below steps: 1. Create the ...READ MORE

answered May 9, 2019 in Tableau by Cherukuri
• 32,440 points
62 views
0 votes
1 answer

Exclude last month from data set

Hi Peter, Use a condition as below and ...READ MORE

answered May 22, 2019 in Tableau by Cherukuri
• 32,440 points
33 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,250 points
3,197 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,250 points
177 views
+2 votes
1 answer
0 votes
1 answer

How to show data between few points/dates (measure) ?

Hi Akhil, You can show data values or ...READ MORE

answered Apr 24, 2019 in Tableau by Cherukuri
• 32,440 points
51 views
+1 vote
1 answer

Show 0 if value has no data - Tableau

Hi Abhay, To replace null or empty values ...READ MORE

answered Apr 24, 2019 in Tableau by Cherukuri
• 32,440 points
6,867 views