Go to Analysis > Create Calculated Field. Subtracting five months from todays date yields some day in October, 2016. To add 45 days to an existing date I can create a calculated field. Environment Tableau Desktop Answer The following example is based on the Superstore sample data source. Tableau calculated field with a simple DATEADD formula. And what I want to do is to calculate a time 45 days in the future where we would expect a reply. In the scenario that I have envisioned here in the workbook, I'm assuming that clients have contacted my hotel about hosting a conference and we have a proposal required date that I've already filled in. I am using this calculation: DATEDIFF day, Order Date, Ship Date) You can easily recreate this with the sample data set (superstore) that ships with tableau. Let's say that you want to add 45 days to a date. datediff(daycase start date,case enddate) getting results but nor correct i need to include where case id 1 then count days in between case start date. I am not sure exactly what your data looks like, but you could calculate the difference in days between two dates by using the datediff function. My sample file is the AddDates workbook, and you can find it in the chapter four folder of your exercise files collection. I'll show you several ways to perform those tasks. ![]() Calculating long strings of dates by hand can be cumbersome, so Tableau allows you to make the calculation easier by creating a formula to add a set interval or increment to a date. In some cases, events can happen every eight or 10 days, or a client might have 45 days to respond to a proposal. ![]() To create a calculated field, click on Analysis Create Calculated. Many events happen at regular intervals, such as every week, month, or year. Tableau and under Connect To a File, click Text File.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |