How to get only the last n months action of all my records

0 votes

How to get only the last n months action of all my records?

Mar 8, 2019 in Tableau by Nithin
456 views

1 answer to this question.

0 votes

Hi Nithin,

You can use Calculated field to group those under last n months and then display using filter or color shelf.

1. First create a calculated field, 

2. Add year in the filter shelf to view only that years details.

 

3.Create N value as a parameter.

4. Now enter N value and add the created calculated field in color shelf to view details. (below shown for N = 1, 3)

Hope this helps you.

answered Mar 8, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

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
2,833 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 9, 2018 in Tableau by ffdfd
• 5,550 points
4,405 views
0 votes
1 answer

How to show a chart with only a part of the dimension/measure value.

Hi Nithin, Follow below steps: 1. Create a calculative ...READ MORE

answered Apr 2, 2019 in Tableau by Cherukuri
• 33,030 points
485 views
0 votes
1 answer

Need to take window average of last 3 months for my sales

Hi Ayushi, Create a calculated field to calculate ...READ MORE

answered Apr 22, 2019 in Tableau by Cherukuri
• 33,030 points
491 views
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,277 views
0 votes
1 answer

How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

answered Apr 10, 2018 in Tableau by ffdfd
• 5,550 points
901 views
0 votes
1 answer

Creating a calculated field with LOD expression

Go ahead and try the following three ...READ MORE

answered Apr 20, 2018 in Tableau by ffdfd
• 5,550 points
890 views
0 votes
2 answers

Calculation issue: Distinct sum in Tableau

I feel the easiest way is to ...READ MORE

answered Aug 26, 2020 in Tableau by Dhiraj Kumar Sahu
9,101 views
0 votes
1 answer

How to get past N months date from data source?

Hi, this is a one solution to your ...READ MORE

answered Mar 1, 2019 in Tableau by Cherukuri
• 33,030 points
546 views
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, 2019 in Tableau by Cherukuri
• 33,030 points
16,604 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