Working with two set of dates

[Matthieu]

Hello 🙂

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) ).

Would a master calendar be any help here?

Thank you!

Matthieu

[andoryuu]

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.

[Kashyap_R]

Hi

Please Find the file in the attachment.

Hope this helps 

Thanks