Using different query and not using active column
Can we use different query for instance we do the group by in query in order to show number of male manager in each year in each department similar for the female as well. will it work in tableau?
Thanks for reaching out.
We need an active column in order to see who is active and who is not. We use the GROUP BY clause for the calendar year. So, it is possible that there is another solution. We need a cartesian product between the managers and the years and this result have to be joined with the t_departments and t_employees tables.
Hope this helps.