-
Calculate Number of Employees Over Time (using employee hire & termination dates)
I have an employee data set with dates the employees were hired and then for some of them, when they were terminated- still unsure what to put in termination date column for employees that are still active. I'd like to create a visualization that shows the number of active employees over time or at any given time. I tried…
-
Line Chart- Missing Values Show Gap Instead of 0; Bonus: how to deal with many lines
I'm creating a line chart to show employee terminations over time. In some instances, there is no data/terminations for a given period of time. The chart is showing gaps when there is no data present. I'd like it to plot 0 for those years instead of a gap. I thought selecting 'hide empty values' would do the trick, but I…
-
Multi-value column card to Compare Turnover
My intent is to create a multi-value column card to compare turnover data from the current year to the previous year. Ideally, I'd have it compare the year to date terminations/turnover to the previous year's at the same point in time. I'd like to display the total number of terminations for this year and either a %…
-
Using Sort to Show Before and After?
I have a chart in my dashboard and I want to do a before & after by sorting by one variable and then sorting by a different variable. Can I do this all in the same chart in my dashboard, or do I have to create another chart that is sorted by the different variable?
-
Assigning Students to Various Organizations
I have a student data set and an organization dataset. In the student data set, the students are ranked by a "matching score". In the organization data set, there is a list of organizations that need to fill 'x' number of vacancies (the vacancies vary by organization). The organizations are also ranked by a priority. The…
