5 Replies Latest reply on Apr 17, 2017 10:56 AM by Jim Dehner

# Amount per day using dynamic start and end date

I have a start date and an end date along with the total amount for the duration. I would like to add filters to the dashboard allowing me to filter the range but still see all the companies within that duration. For example, company ABC has an amount of \$200K with a start date of 1/3/2017 and an end date of 1/7/2017. If I filter the start date for the entire dashboard to 1/4/2017, I want the graph and table to adjust to continue to display ABC with the amount of \$150K

• ###### 1. Re: Amount per day using dynamic start and end date

If you had separate rows by date for ABC such that \$50,000 was on 1/3 and the rest was on later dates, you could filter out the 1/3 row and still sum up the remaining rows.

Otherwise, how do you determine that \$50,000 should be excluded from the \$200,000 total for ABC?  Just divide \$200,000 by [Number of Days]?  If so, you can do that in a calc, but I wonder how reliable that is.  (Note that there are actually FIVE days, not 4, if you count the days from Start to END.)

• ###### 2. Re: Amount per day using dynamic start and end date

Disregard the the actual day length for now as I can +1 to my number of days calc.

Imagine I cannot change the actual back end data. Is there anything I can do within Tableau displaying the amount per day without entirely filtering out ABC company.

• ###### 3. Re: Amount per day using dynamic start and end date

Attached is an example of playing with the difference between the parameter and the start date.  See [Amount Adjusted] calc that I added to TEXT.

1 of 1 people found this helpful
• ###### 4. Re: Amount per day using dynamic start and end date

Good Morning

Please see the attached - I think this does what you want -

Let me know it it helps

Jim

1 of 1 people found this helpful
• ###### 5. Re: Amount per day using dynamic start and end date

Thanks