Data visualizations not reflecting numbers from spreedsheet view
Content
Hi All,
We are creating very symple chart - Joiners and Leavers in last 12 months. I am aware this is very quick one, Hire Headcount, Termination Headcount in Measure Section and then Time/Month or Event Effective Start Date (YYYY/MM) in section grouped by.
Background: However our customers wants to report to report Terminations based on Termination Date which is -1 day from Effective Start date of Events/Termination Headcount. Impact by this approach, in cases in peak season, when there are mass terminations (termination date = last day of the month) these terminations are reported as terminations of following month, which per customer's reporting standards is not accurate and could lead to some legal penalties.