Hi,
I'm building a diagram from personell data.
After a lot of trying and after four or five resident loads, I have a table with one record per employee with the holiday_budget he had at year's start, the nr of days he's taken and the nr. of days he has planned - and a nr. of days he has neither taken nor planned.
=> Out of this last figure (days not taken nor planned), I want to build my diagram.
My dilemma is this:
- I can see by using the system_fields that my final table has 483 records - that's 483 employees who had a holiday_budget <> 0 at year's start.
- I use the interval_match function to group these into categories
- The upper limit of every category is my dimension (x-axis) for the diagram
- On the y-axis (formula) I display the nr. of employees within that category.
<=> Even though I know I have enough categories (I have one or two on either side which don't appear, so I guess that means there is no data in those),
the total count is wrong: Instead of 483 (as are in the underlying table), in the categories I only have a total of 373.
I am totally puzzled by this. Can anybody explain to me what might be the reason I'm missing out on 110 employees?
Thanks a lot!
Best regards,
DataNibbler
