-
1. Re: Counting entries and exits per dimension over time
swaroop.gantela Jul 22, 2016 6:45 AM (in response to david.huffer)David,
Welcome to the Forums.I think your desired goal can benefit from the ideas on this excellent link:
CROSS JOIN with Tableau's join dialog
(kettan, this shows up on my browser as a highly visited site. Thank you again for it.)
If this all works well with your setup, you can add a Key column of all 1s to your data worksheet,
and then the make a new sheet of the same Key column and then a column of all the possible dates.
This creates the combination of all possible dates, but it can be filtered using:
[Date]>=[Start Date]
AND [Date]<=[Discharge Date]
From here, I returned the Start IDs and The DC IDs:
IF [Date]=[Start Date] THEN [ID] END
Similarly
IF [Date]=[Discharge Date] THEN [ID] END
You can also CountD these:
COUNTD(IF [Date]=[Start Date] THEN [ID] END)
Then you do a Running Total on the Delta:
[CountStart] - [CountDCs]
This Delta calculation should be amenable for graphing.
There are some nulls, I wasn't sure you needed them padded to zeros.
-
211500delta.twbx 41.1 KB
-
2. Re: Counting entries and exits per dimension over time
david.huffer Jul 28, 2016 10:44 AM (in response to swaroop.gantela)Thank you so much. Your response was incredibly enlightening.