I have an issue with Tableau doing a running total of active members. I am attaching a sample workbook with sample data. My question is about data padding and figuring out how can it be done in tableau, without creating extra rows when pulling in the data. I am trying to introduce a calendar table to my original data. I have a Data table with id,start date,end date (lets assume they all start at first of every month and end of a month). I want to introduce a date table so i have a start date table and end date table (I know i could have joined just using one table that has start date column and end date column, but then i run into the problem creating a single row for each id for each month its active. Which create a lot of rows, as i am dealing with a large database).
My question now is, I want to join the data table with a start table like data.startdate = startdate and same with end date. But when i do this I only seem to get either the start date or end date, but not exactly when are active between both dates.
If you have more questions regarding this please let me know. I know this might sound confusing, but since i am dealing with large dataset its hard to use a method like joining a separate calendar all together because like i mentioned it creates many more rows. Like going from 20 million records to 120 million records. So finally to make it simple, I want to know how to introduce a calendar table into my data without creating additional rows and I need to show exactly when they are active between. Thanks.
Edit: Sorry everyone forgot to post the result i was getting and what i was expecting. Updated my workbook. Anyhelp would be appreciated.