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
560 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,030 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
465 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,030 points
625 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,030 points
1,418 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,030 points
923 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
9,784 views
+2 votes
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
1,542 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,030 points
773 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,030 points
123,347 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP