Not sure, if i got your question.
Do you want to show the weeks cumulative # Persons and # Calls. - Then remove the Date range filter..
If you are applying date range filter , then it will show only weeks coming in that date range.
thank you for you response.
I would like to show # Persons and # Calls. Like on this screenshot:
The problem is, if I apply the date range filter, tableau shows me only the items beginning from the week I applied in the filter. Tableau doesn't counts items before.
I'm filtering on the period: Nov and Dec in 2016. Tableau ignores all items I had gather before (Jan - Oct) and beginns to count from Nov. I would like that tableau counts all items I gathered before Nov.
Do you have any ideas what was my mistake?
Tableau ignores all earlier months, because date range filter is applied and it will only show values occurring within date range.
If you dont use date range filter, then it will show all the earlier values as well.
I know that. Thank you!
But I also know that it is wark to count all items. I have a mistake in my formula. The formula should be adjusted. Do you have any ideas?
What you're trying to get is a little bit complicated,
because of mixing the two things:
1) To show RUNNING calculation results "filtered" by [Activity Date],
you're rightfully using the Table Calculation Filter based on LOOKUP().
The fine point here is Computing this filter calc along Cell.
When filtering on both sheets you have to use Parameters (rightfully so).
Any other "regular" filter by [Activity Date] would break the RUNNING Table Calc.
2) To calculate RUNNING Counts of DISTINCT [IDs] along [Activity Date]
you would like to count only the first occurrence of each [IDs] value along Date
using FIXED LOD expression, and then the result would be (running) summed up nicely.
Please find the attached with modifications (all on Dashboard 7).
Hope it could he of help.