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
 • 678 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
 • 33,030 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 • 15,337 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 17, 2019 in Tableau by Cherukuri
 • 33,030 points • 613 views
+1 vote
4 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
 • 2,965 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,891 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 • 863 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
 • 469 views
0 votes
1 answer

How to return the value on which the condition is met for the first time?

It looks like you are trying to ...READ MORE

answered Aug 14, 2018 in Tableau by Naruto
 • 710 points • 1,179 views
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 • 2,053 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
 • 33,030 points • 770 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 • 843 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
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.