I’m got a problem where my “Inline” views are showing conflicting data. The picture shows (1) item for the Active Field Service, but the inline shows 3 items. My data also shows only one. Here’s what I have
- Slice of my Field Service Data (Active Field Service) where I’ve filtered from 1 day looking forward ([DaysToEvent] >= -1) -Days to event being a virtual column using today() vs my end date. This works, only return one row of test data, which is right, see picture.
- Virtual Column Reference Row (Employees Active Field Service) For Employees Spreadsheet (REF_ROWS(“Active Field Service”, “EmployeeID”)) - where I go through the above slice and filter out this employees field service items.
- My Employees Detail Display then displays the column (Employees Active Field Service) above, hopefully showing 1. The forward (date) looking slice, with that employees field service items only. There should be one result (as verified by the slice data pic) but the inline display is correctly showing that one result as a total, but then displaying multiple lines of data.
See Slice Data (1 item)
See Inline (1 item calc, but 3 displayed)
I’ve been fighting with this a bit and am really frustrated. Anyone ever see this where the numbers and inline items simply don’t match up?