Forum Discussion

aridavid's avatar
aridavid
Frequent Visitor
5 years ago
Solved

Counting items from two date columns in one single timeline

Hello,

 

I'm trying to plot a table where I can observe on a timeline (months), how many items are between two given dates (start & end) from a table. The problem I'm having is that these two dates are rperesented in two different columns and I can't find a good way of relating them to a Calendar table in order to get what I want. Example:

 

TableX

 UserProject StartDate EndDate 
 A Project1  10/5/2021  12/7/2021
A  Project2 4/21/2021  7/28/2021
B  Project3 5/23/2021  9/13/2021
B  Project4 7/18/2021  11/6/2021
B  Project5 11/7/2021  11/18/2021
C  Project6 8/16/2021  12/28/2021
C  Project711/13/2021  12/4/2021

 

From TableX I'd like to tell on a given month, how many projects would the person have assigned, and observe it by month. Liek this:

 

Result

UserTotal ProjectsJanFebMarAprMayJunJulAugSeptOctNovDec
A2000111100111
B3000011222120
C2000000011122

 

Would this be even possible?

 

Thanks a lot.

2 Replies