As per my understanding you wanted a make provision to show and select two dates.
With the dates you wanted control all the functionalities of the current and other blended data sources.
If I'm right, I would prefer to create two date parameters called Start date (30-sep-18) and End Date (31-dec-22)
E.G. End Date sample parameter
With two parameters you can control all datasources in tableau workbook.
Hope this helps! Plz mark the response as helpful and answered if it solved the problem
Can you try the calculations for above desired results
[Booking amount] / [Dates Difference]
# of nights:
[# of nights] / [Dates Difference]
# of bed nights:
[# of bed nights] / [Dates Difference]
Is it something like this?
join your data to a calendar table using the key 1=1
create a filter and drag to filter, then select true, and right click the filter and select add to context.
Workbook attached for your reference.
Hope this helps
Book2_v10.2.twbx 14.2 KB
This is whate I need to do. But while joining data it is not taking as better mapping.
Please note I am not able to find the workbook. Can you share it on email address?
See, the first problem statement is not in that direct way. It is extracted from different data sources.
The split of dates is not getting right while executing query.
I would like to have more discussion on the same.