Last answered:

24 Aug 2022

Posted on:

23 Aug 2022


Using different query and not using active column

Hi there,
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?

1 answers ( 0 marked as helpful)
Posted on:

24 Aug 2022


Hi Syed!
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.

Submit an answer