Return last day of each moth in the calendar

0 votes
I have multiple records that shows for each month. For e.g. October is showing 15 records and February is showing 12 records. I only want the last record of each month i.e the last record.
Apr 20, 2018 in Tableau by DragonLord999
• 8,380 points
26 views

1 answer to this question.

0 votes

Try this way:

Place the order date in the same date format and change the property to 'discrete'

Now extract the year and month in separate calculated fields and drag to detail.

Year:

year(Date) 

Month:

Month(date)

Now create one more calculated field and use this:

WINDOW_MAX(MAX([Order Date]),FIRST(),LAST())
answered Apr 20, 2018 by QueenBee
• 1,810 points

Related Questions In Tableau

0 votes
1 answer

In Tableau, How to sum the last 7 days of the value?

It can be achieved easily by creating ...READ MORE

answered Mar 12 in Tableau by Cherukuri
• 28,040 points
639 views
0 votes
1 answer

How to show % of the total to each bar in bar graph?

Hi Manu, It is a simple procedure, Follow ...READ MORE

answered Apr 22 in Tableau by Cherukuri
• 28,040 points
48 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
158 views
0 votes
1 answer

How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

answered Apr 11, 2018 in Tableau by xyz
• 1,550 points
734 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,034 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

Divide count of Table 1 by count of Table 2 on the same time interval

Use a custom SQL to create a ...READ MORE

answered Apr 11, 2018 in Tableau by QueenBee
• 1,810 points
25 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
697 views