To create a calculated field, right-click in any blank space in the left navigation of the authoring interface and choose “Create Calculated Field…”.
The formula is: DATEDIFF(‘day’,[Minimum Date],[Maximum Date]) 1 This is more of a half-step, but we’ll need a calculated field that tells Tableau which date comparison we are using.
This parameter will have a data type of “String” and will list out our options of “Prior Period” and “Prior Year”.
This key step counts the number of days between your start date and end date so that Tableau can eventually create an apples to apples date comparison range with the same number of days.
If it’s the date range immediately preceding the selection, Tableau will use the Days in Range calculation from the last step; if we’re comparing the selected date range to last year, we will use 365 (the number of days in a year).
This tutorial will show you how to compare a selected date range to either the date range immediately preceding the selection or the same date range one year ago.Create a parameter with a data type of “Date” and give it a name that represents the start date.Here is how my “Minimum Date” parameter looks after setting it up and setting the date to “9/1/2016”.The When Harry Met Sally star's new condo set her back .3 million and will see her become the neighbour of a whole host of A-list celebrities, including Ryan Reynolds and Blake Lively, Justin Timberlake and Jessica Biel, Jennifer Lawrence, Harry Styles and Lewis Hamilton.Meg's former apartment is the ninth home the mother-of-two has renovated and has been described as a designer dream, even featuring in Architectural Digest.