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
118 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
• 33,010 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
106 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
• 33,010 points
127 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
• 33,010 points
466 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
• 33,010 points
256 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,230 points
7,449 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,230 points
658 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
• 33,010 points
163 views
+1 vote
4 answers

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
• 33,010 points
66,402 views