I have huge payroll data with weekly date (meaning consecutive Thursdays). I need to use that for daily analysis.
So for example when I am creating a chart (where dimension is Date and expression is “count( disctinct PersonelNumber)” ) I want to have a workforce shown for each day, not only for Thursdays. In payroll I have field “Date from” and “Date to” but I do not know how to use it.
What would be the best approach to such issue? Any help would be appreciated.