-
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.
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.
Based on the date selector selection, I should be able to calculate the difference in dates
-
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.
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>
-
-
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.
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.
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.
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
