How to compare sales of today with previous year?

0 votes
How to compare sales of today with previous year?
Apr 5 in Tableau by ayushi
40 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 by Cherukuri
• 31,840 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
1,911 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 in Tableau by Cherukuri
• 31,840 points
22 views
0 votes
3 answers
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,240 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
64 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
29 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
136 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 in Tableau by Cherukuri
• 31,840 points
32 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 in Tableau by Cherukuri
• 31,840 points
29 views