Calculate employee occurrences (absent, late, etc) from REHIRE date
Hey all. Wondering if anyone would be able to assist with this.
We have a card (simple bar chart) where we show employee occurrences, e.g. absent, late, early out, etc based on a dataset that pulls together a couple different tables, assigning point values to these occurrences for a sum total (absence = 1 point | late <=10 minutes = .25 | late >10 minutes = .50 | etc).
We report on this for the last 12 months, and we're having an issue with individuals who have been rehired where a gap in employment exists within the rolling 12 month period, so it's still counting occurrences. Realistically, we wouldn't see a rehire with a gap in employment of less than 30 days, so that would be the benchmark to determine gaps.
What we want to do is make is so that all occurrences, even though they're within the last 12 months, are excluded if they were PRIOR to their rehire date, basically only counting occurrences from that date forward, not the full 12 months as we would for anyone who's worked the entire reporting period.
1) should this be done in the dataflow, or at the card level?
2) how would we go about doing this?
Please let me know what other information might be needed to assist. Thanks in advance!
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board