Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • 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.

  • Icey's avatar
    Icey
    Community Support

    Hi Anonymous ,

     

    Any details?

     

     

    Best Regards,

    Icey