Forum Discussion
Post PatronCalendar for 2 tables
I have a report that I have created a calendar for. See the relationship view in the image.
It is nicely fitlering my invoices over time. but I can not get it to control the billable Time table. If I try to relate the "Date" it will not make the relationship active. I plotted a chart of billable and invoiced over time and my billable shows as a total for the job across the duration of that project, and not as a plot against time
Any suggestions how to make this relationship work?
Hi Pmorg73 ,
As the third - party blog, ‘Both’ setting should be the issue here.Please change the relationship between the tables from both to single and create the relationship between date and Billable to check again.
3 Replies
- Pmorg7301_calendar = CALENDAR(DATE(2015,04,01),today())I used this to make the calendar
v-frfei-msftCommunity Support
Hi Pmorg73 ,
As the third - party blog, ‘Both’ setting should be the issue here.Please change the relationship between the tables from both to single and create the relationship between date and Billable to check again.
- Pmorg73
thanks. I think this has me going in the right direction. I have not quite figured out relationships yet
