Not enough info in your problem statement to give you an answer.
Can you create a sample data file in excel and build a sample workbook on that?
In the attached I made a table calc that gives you the running sum day by day. I placed it on the "open each day" sheet.
Table calcs can give us looks at past data this way.
On your second tab I changed things. I added a parameter that lets the user select what day to look at. See calc [running sum up to selected day].
Notice that I had to include the Date Created dimension on the sheet. Tableau needs to know what days to add, and what each day's value is. And therefore you get multiple copies of the same total, one for each day on the sheet.
Go to version (2). Here I added another calc called INDEX, and told tableau just to display the first of the multiple values. This gives you the viz you need. Your user can select whatever day to examine this way.
Going back to the very first sheet, I could have instead made a filter like this:
If ATTR(Date Created) = [Display Date] then 1 else 0 END
And then if I put that on the filter shelf and selected for value = 1, it would only show the one date, with the proper running_sum value for that date.
So there are lots of ways to get what you need. Please ping back if you have questions about what I did in there.
Book2_v10.4.twbx 41.6 KB
When i am doing a running_sum it works fine , but as soon as the status changes to close, the data is impacting again?
You will have to add a column to your data (or a separate row!) that lets you see when closure happened.
Looking back, I see you were asking about a snapshot, and now I see why. But tableau doesn't write anything out. It only tells you about what data has come in. So Tableau won't save for you what the data looked like yesterday or last week.
Therefore you will need to have something in the data to tell you when closure occurred. With that, you won't be filtering on Status="Open", but rather you will filter for part numbers where the closure happened after the selected [Display Date].