I'm having trouble figuring out how merging two set of dates.
My inputs are:
activities | Status | Opening Date | Closing Date | Category
Status can be either = Closed or = In progress
I would like my chart to show how many activities are closed and opened per month (or per week).
If I set my dimension to be Month(Opening date), it will show me the correct amount of activities created per month; but the figures for the closed one will be wrong (it will show the quantity of activities closed during month(opening date) ).
What you need is set analysis in your measure to ignore the selection of the opening date. Let's say the field you are counting is called ActivityCount. Your measure to count the closed date quantities would be: Sum({$<[Opening Date]=>}ActivityCount) Your measure to count the open date quantities would be: Sum({$<[Closing Date]=>}ActivityCount)
This set analysis will prevent selections from the other date from affecting your activity count.
