-
1. Re: I need to calculate the date difference between the Date dimension(only one date field)using a calculated field based on the choice of dates by the user i.e Date field i a filter shown . For example user may select 6/21/2016 to 6/25/2016.
Marc MOUSSA Oct 29, 2016 1:56 PM (in response to sumanth b r)Can you give a more detailed description with a tableau workbook or screenshots may be ?
Both of dates selected by the user are in the datasource ?
-
2. Re: I need to calculate the date difference between the Date dimension(only one date field)using a calculated field based on the choice of dates by the user i.e Date field i a filter shown . For example user may select 6/21/2016 to 6/25/2016.
sumanth b r Oct 31, 2016 2:38 PM (in response to Marc MOUSSA)Based on the date selector selection, I should be able to calculate the difference in dates
-
3. Re: I need to calculate the date difference between the Date dimension(only one date field)using a calculated field based on the choice of dates by the user i.e Date field i a filter shown . For example user may select 6/21/2016 to 6/25/2016.
Marc MOUSSA Oct 31, 2016 3:58 PM (in response to sumanth b r)Can you provide a sample workbook ?
-
4. Re: I need to calculate the date difference between the Date dimension(only one date field)using a calculated field based on the choice of dates by the user i.e Date field i a filter shown . For example user may select 6/21/2016 to 6/25/2016.
sumanth b r Oct 31, 2016 5:26 PM (in response to Marc MOUSSA)Here is my date selector. According to the user selection I need to
calculate the difference in days.
Let me know if you need any more details .
Sumanth
On Mon, Oct 31, 2016 at 3:59 PM, Marc MOUSSA <tableaucommunity@tableau.com>
-
image.png 5.2 KB
-
-
5. Re: I need to calculate the date difference between the Date dimension(only one date field)using a calculated field based on the choice of dates by the user i.e Date field i a filter shown . For example user may select 6/21/2016 to 6/25/2016.
Marc MOUSSA Nov 1, 2016 12:47 AM (in response to sumanth b r)First you need to add your date field to the context on the filter shelf.
Then you use the following formula :
DATEDIFF('day', { MIN([Date d'expédition]) }, { MAX([Date d'expédition]) })
-
6. Re: I need to calculate the date difference between the Date dimension(only one date field)using a calculated field based on the choice of dates by the user i.e Date field i a filter shown . For example user may select 6/21/2016 to 6/25/2016.
sumanth b r Nov 1, 2016 10:34 AM (in response to Marc MOUSSA)Thanks for your reply but I want the days difference based on the user
selection and also to exclude weekends. This formula calculates the
difference between my start date and present day.
Sumanth
On Tue, Nov 1, 2016 at 12:48 AM, Marc MOUSSA <tableaucommunity@tableau.com>
-
7. Re: I need to calculate the date difference between the Date dimension(only one date field)using a calculated field based on the choice of dates by the user i.e Date field i a filter shown . For example user may select 6/21/2016 to 6/25/2016.
Dibyendu Sharma Mondal Jan 19, 2017 12:04 AM (in response to sumanth b r)1 of 1 people found this helpfulYou have to create a Date Parameter to allow user to select a start or end date (it could be also one date selection) and then do the calculation on this date with the date in the data set
Below is the link to help you.
Creating a Filter for Start and End Dates Using Parameters | Tableau Software