How to compare sales of today with previous year?

0 votes
How to compare sales of today with previous year?
Apr 5, 2019 in Tableau by ayushi
46 views

1 answer to this question.

0 votes
Create a calculative field as,

IF YEAR(TODAY())=YEAR([DATE_FIELD]+1 AND DAY(TODAY())=DAY([DATE_FIELD]) AND MONTH(TODAY())=MONTH([DATE_FIELD]) THEN [DATE_FIELD] ELSE "0" END

Drop the created field into sheet and now use this field to filter out data and show visuals.

Hope this helps you.
answered Apr 5, 2019 by Cherukuri
• 32,420 points

Related Questions In Tableau

0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
2,404 views
0 votes
1 answer

How to get distinct customers this year wrt previous year?

Follow the below steps: 1. Create calculated fields ...READ MORE

answered May 16, 2019 in Tableau by Cherukuri
• 32,420 points
33 views
+1 vote
3 answers

How to Update my Start and End dates parameter or Filter with Today and Last 5 Days Date Automatically ??

Create a calculated field and set its ...READ MORE

answered Jul 31, 2019 in Tableau by anonymous
216 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,250 points
2,661 views
0 votes
1 answer

How to determine average per event by year?

Hi Roshan, Create a new calculated field (use ...READ MORE

answered Sep 25, 2018 in Tableau by Machdata
• 340 points
82 views
0 votes
0 answers

Calculating count average from averages

I've a calculated field in Tableau which ...READ MORE

May 28, 2018 in Tableau by Mahima Choudhary
32 views
0 votes
1 answer
0 votes
1 answer

How to Split a Measure in Tableau?

Have you tried using an IF statement: IF ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
215 views
0 votes
1 answer

How to find first n months profit/sales for a given year

Hi Sindhu, You can use Calculated field to ...READ MORE

answered Mar 8, 2019 in Tableau by Cherukuri
• 32,420 points
46 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
• 32,420 points
39 views