I would like some formulae to analzye data as follows:
Last Month Vs This Month
Last Quarter Vs This Quarter
Last 6 Month Vs this 6 Month
Last Year Vs this Year
Total Last Year Vs this year
My raw data has the following fields
First write formulas for last month this month and last year this year and whatever you require....
in below link you have options that how to write a formula. for example i am writing one for finding last month sales.
IF DATEADD('month',-1,TODAY()) THEN
Calculated Field: Last Month Only
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...