show recent month data

0 votes
How to display data for recent or latest month in the chart without filter?
Jun 12 in Tableau by Saradhi
26 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 by anonymous
• 28,040 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 in Tableau by Anitha
33 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 in Tableau by Cherukuri
• 28,040 points
32 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 in Tableau by Cherukuri
• 28,040 points
25 views
0 votes
1 answer

Exclude last month from data set

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

answered May 22 in Tableau by Cherukuri
• 28,040 points
20 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,240 points
2,038 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,240 points
89 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 in Tableau by Cherukuri
• 28,040 points
29 views
0 votes
1 answer

Show 0 if value has no data - Tableau

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

answered Apr 24 in Tableau by Cherukuri
• 28,040 points
1,092 views