Hi,
I have 4 Person P1,P2,P3 and P4
P1 is active from date 1-3,5-7
P2 is active from date 2-7
P3 is active from date 1-2,4-5
P4 is active from date 1--
(P4 is active from 1 to current date)
I want to show count of person active in each date
Example:
P1 - 1,2,3,5,7
P2 - 2,3,4,5,6,7
P3 - 1,2,4,5
P4 - 1,2,3,4,5,6,7
In chart use date as dimension and expression is Count(person)
Result i want is this
1 is 3(P1,P3,P4),
2 is 4(P1,P2,P3,P4)
3 is 3(P1,P2,P4)
Please help me to find out the solution.
Thanks
