1 of 1 people found this helpful
Proposed is a generic attempt at your question,
though it may need adjustment in practice if your dataset is large
or if your dataset type doesn't allow for such methods.
The idea is to join your data with a running column of dates
to be used as the x-axis for your histogram.
Then you can compare your Creation and Final dates to
the LookupDate to see if it meets the criteria for the Waiting List.
This method is generally described here:
An example of a similar implementation of this in Tableau Prep is shown here:
In your example, I made a new sheet of a single column dates.
I joined this to the data with a calculated field of 1.
This joins every date to every data row.
I filtered the data down using:
[Look Up Date]>=[Creation Date]
[Look Up Date]<=[Final Date]
Then the criteria to count for the waiting list became:
IF ([Look Up Date]>=[Creation Date] AND [Look Up Date]<[Final Date])
THEN 1 ELSE 0 END
Please see the workbook v10.3 and datasource attached in the Forum Thread.
The dashboard has the histogram on top and then a gantt sheet with a parameter
to check the values.
Further in depth discussion of this method, performance considerations, and alternatives
can be found here:
Sorry for the late answer, I spent several days trying your solution.
This solution works indeed, I can have my orders waiting list at the end.
- It's not really effective for big database like mine. Indeed, It multiplies each line by the number of date you want to compare, in my case it's really huge
- You have to join your data with a custom range of date Look up. (not really the best solution in my case : the database can't be modified by myself or I will need an extra excel file with the look up dates).
I would rather be interested in a solution 100% inner tableau with calculated fields / parameter / filters, and no works on the database or joining of tables.
Anyway that helped and I know I can do this way in last resort.
Thank you !