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?

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. Best, Tsvetelin

Follow this topic

Syed Muhammad Mudassir

Last answered:

24 Aug 2022

Posted on:

23 Aug 2022

Using different query and not using active column

in SQL + Tableau / Chart 2: Visualizing the Solution in Tableau

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

24 Aug 2022

Using different query and not using active column

Submit an answer

related questions