AnsweredAssumed Answered

How Do You Restrict a Selector to Active Items in Dataview

Question asked by mheurlin on May 10, 2019

I am working to convert labor analysis report from Excel to Board.  In excel the report uses slicers which display only the employees with hours worked in the currently selected branch.  I have the data in Board, however the selectors list all of the employees, not just the ones that currently make up the data in the data view.  I am working in Board v10.5 web, and I tried using the 'Show only active members' option on the selector, however it doesn't restrict the employees shown to only the ones in the current data view.  Our employees work at multiple branches at times so I can't have an employee branch relationship.  Any suggestions for how I might achieve this?

 

Outcomes