Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeD1
Partner - Contributor II
Partner - Contributor II

Null date in join table

Hi, I have two table

Table1:

Date,

Agent,

hours.

Table2: 

Date

Agent,

worklog.

The first table contains the hours that must be worked by the agent per day.

The second one contains the hours effectively worked every day.

I have some null values in the second table (when the agent does not record the worked time).

I need to create a graph with the two hours compared.

I've tried with some master calendar without success and also with a bridge table but I'm not able to do it.

Thanks in advance community.

 

0 Replies