Forum Discussion
Anonymous
4 years agoNot applicable
Total Availability
Hi,
I have a three tables.
table 1
Date table
table 2
employee ID
table 3
crossjoin table 1 & 2 (creates single row for each employee per day)
I want to create a measure that can be used in a calendar visual which shows a count of all employees. each day (labour availability)
Any ideas?
2 Replies
- MFelixSuper User
Hi Anonymous ,
How do you know if the employee is available in that specific day? you refere that you do a cross join so I assume there is also some dates columns on the users table?
Can you please share some sample data.
- IceyCommunity Support
Hi Anonymous ,
Any details?
Best Regards,
Icey