I am attempting to build a report in DE 1.0 to show the vacant visits, by any given week in a year. I have run into an issue where I cannot find a field that counts by visit filled status. To get around this, I have built a report in the visit cube using the below axes, measures and filters.
- X-Axis: Visit Start Week
- Measures: Visit Count
- Filters: Visit start year (current), Cancel Code (not cancelled) and Employee Department Name (excluding all departments)
Am I correct that this setup is only showing vacant visits (and any employees that do not have a department listed)? My company has not transitioned to DE 2.0, so I am currently unable to use that platform to build this report.
Please sign in to leave a comment.