Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a data set like below:
Customer, Start Date, End Date
A, Jan 1, Mar 15
B, Jan 1, Feb 10
C, Feb 2, Mar 2
Now I need to draw a monthly bar chart to show how many customers are with us each month (in this example, Jan 2, Feb 3, Mar 2). In the script, I have a master calendar (Date, Month, Year). Can I use the master calendar and the data set to draw such a bar chart?
Thanks in advance!
You would need to create an intermediate table using Interval match.